[Devel] r150 - trunk

[thomas at lolut.utbm.info]

Author: thomas
Date: 2006-02-05 15:00:17 +0100 (Sun, 05 Feb 2006)
New Revision: 150

Modified:
   trunk/INSTALL
Log:

Mise ?\195?\160 jour du fichier INSTALL:
 - suppression des espaces en fin de ligne
 - ajout d'une entr?\195?\169e expliquant comment remplir la table des LUGs



Modified: trunk/INSTALL
===================================================================
--- trunk/INSTALL	2006-02-05 13:59:31 UTC (rev 149)
+++ trunk/INSTALL	2006-02-05 14:00:17 UTC (rev 150)
@@ -17,7 +17,7 @@
 
 mysql> CREATE DATABASE agendadulibre;
 
-mysql> GRANT ALL PRIVILEGES ON agendadulibre.* TO 'agendadulibre'@'localhost' 
+mysql> GRANT ALL PRIVILEGES ON agendadulibre.* TO 'agendadulibre'@'localhost'
        IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
 
 mysql> quit
@@ -46,9 +46,9 @@
 
 $ cd ~/public_html/agenda/
 
-$ mysql -h localhost -u agendadulibre -p agendadulibre < schema.sql 
+$ mysql -h localhost -u agendadulibre -p agendadulibre < schema.sql
 
-$ cp bd-private.inc.php.template bd-private.inc.php          
+$ cp bd-private.inc.php.template bd-private.inc.php
 
  (edit it with needed host, base name, password, etc. I used:
 /** Where the database is hosted */
@@ -80,7 +80,7 @@
 
 mysql> select(md5('tonpassword'));
 
-mysql> insert into users (login, password, email) 
+mysql> insert into users (login, password, email)
        values ('dmentre', 'a6dd9955af3de4f06b992821dcae3f13', 'david at localhost');
 
 mysql> quit
@@ -91,4 +91,15 @@
 
  (enter previous login and password)
 
+9) Add the list of LUGs (optional)
 
+The list of LUGs in the Agenda du Libre is generated using a script
+available at
+http://www.agendadulibre.org/svn/scripts/extract-gulls.py. This script
+parses the LUG list of AFUL (at http://www.aful.org/gul/liste) and
+generates SQL queries to insert them in a SQL database.
+
+$ svn co http://www.agendadulibre.org/svn/scripts/extract-gulls.py
+$ chmod +x extract-gulls.py
+$ ./extract-gulls.py > lugs.sql
+$ mysql -h localhost -u agendadulibre -p agendadulibre < lugs.sql