Changeset 223

Timestamp:

09/01/04 16:20:56 (9 years ago)

Author:

benoitg

Message:

2004-08-31 Benoit Gr�goire <bock@…>

• sql/: Update the postgres schemas and add scripts to ease maintaining it.
• sql/sync_sql_for_cvs.sh: Should you modify the schema in your db, run this script to the chances will be available in the cvs schemas and initial data.
• sql/dump_initial_data_postgres.sh: This does the actual dump of the data in a runnable form. Note that this needs to be edited manually if you add a new table requiring initial data.
• INSTALL: Update for postgres. Somebody please test this.

Location:

trunk/wifidog-auth

Files:

• ChangeLog (modified) (1 diff)
• INSTALL (modified) (1 diff)
• dump_db_postgres (deleted)
• sql (added)
• sql/dump_initial_data_postgres.sh (added)
• sql/dump_schema_postgres.sh (added)
• sql/sync_sql_for_cvs.sh (added)
• sql/wifidog-postgres-initial-data.sql (added)
• sql/wifidog-postgres-schema.sql (added)
• wifidog-postgres-schema.sql (deleted)

trunk/wifidog-auth/ChangeLog

@@ -1 +1 @@
 # $Header$
+2004-08-31 Benoit Gr�goire  <bock@step.polymtl.ca>
+        * sql/: Update the postgres schemas and add scripts to ease maintaining it.
+        * sql/sync_sql_for_cvs.sh: Should you modify the schema in your db, run this script to the chances will be available in the cvs schemas and initial data.
+        * sql/dump_initial_data_postgres.sh: This does the actual dump of the data in a runnable form.  Note that this needs to be edited manually if you add a new table requiring initial data.
+        * INSTALL:  Update for postgres.  Somebody please test this.
+
 2004-08-31 Benoit Gr�goire  <bock@step.polymtl.ca>
         * wifidog/ping/index.php: Implement logging of which hotspot sent the heartbeat, from which ip and when.

trunk/wifidog-auth/INSTALL

@@ -4 +4 @@
 php's php-xml extention installed. (Required if RSS support is on)
 php compiled with gettext support (Will be autodetected if unavailable, but you will loose internationalization)
+PostgreSql (mysql code alse exists, but is looking for a maintainer)
 
-Install:
+Install files:
 
 -Uncompress the tarball on your web server.
--Put the content of the libs directory in the smarty tarball in lib/smarty/
--Put the content of the magpierss-0.xx directory in the magpierss tarball in lib/magpie.  If you do not wish to install RSS support, you must set define('RSS_SUPPORT', false) in config.php.
+-Copy the content of the libs directory of the smarty tarball in lib/smarty/
+-Copy the content of the magpierss-0.xx directory of the magpierss tarball in lib/magpie.  If you do not wish to install RSS support, you must set define('RSS_SUPPORT', false) in config.php.
 
 -local_content/cache/, and everything in tmp/smarty must be at least writable by your web server.  Run "sh permissions.sh" to set them 777
--Import wifidog.schema to create your database.
+
+Database:
+-Create the user wifidog (both in postgres and on your system).
+-Import the schema:
+        psql -d template1 -U wifidog -W -f sql/wifidog-postgres-schema.sql
+-Import initial data:
+        psql -d template1 -U wifidog -W -f sql/wifidog-postgres-initial-data.sql
+
+Configure the system:   
 -Edit wifidog/config.php to suit your environment.
--Enjoy.
+
+Enjoy!