[isf-wifidog] problem with the installation of wifidog-auth server
Proulx François
fproulx at edito.qc.ca
Jeu 22 Sep 10:27:46 EDT 2005
This error should not occur, it is most probably created when running
SQL update from schema 25 to 26. Schema 26 creates the networks
table, but it assumes you had some data before. In your case, it's a
fresh install so you should have started with the initial schema 28
or 29 and all the tables would be there for a fresh start....
So it's not normal that you get the initial schema 13.
It uses the initial_schema SQL file, but I just checked and it was at
schema 28, so you should not have started at 13....
Can you drop the database and start the install process again ? You
said you downloaded the latest CVS version from Sourceforge.net ?
By looking here, you'll see that we passed version 28, more than two
weeks ago....
http://cvs.sourceforge.net/viewcvs.py/wifidog/wifidog-auth/sql/
wifidog-postgres-initial-data.sql?rev=1.18&view=auto
Can you check what's in your local /sql/wifidog-postgres-initial-
data.sql ?
On 22-Sep-2005, at 8:49 , christian gattermair wrote:
> hi!
>
> i use a fresh system and the files from today cvs.
>
> the installation wizzard brings me correct to:
>
> Database connection
>
> * Postgresql database connection : Success
>
>
>
> then i get:
>
> Database initialisation
>
> On localhost, Database wifidog exists and is at schema version 13. The
> required schema version is 29
>
> Please upgrade the database
>
>
> i click upgrade and get the following error message:
>
>
>
> Database schema upgrade
> Trying to update the database schema.
> Preparing SQL statements to update schema to version 14
> Preparing SQL statements to update schema to version 15
> Preparing SQL statements to update schema to version 16
> Preparing SQL statements to update schema to version 17
> Preparing SQL statements to update schema to version 18
> Preparing SQL statements to update schema to version 19
> Preparing SQL statements to update schema to version 20
> Preparing SQL statements to update schema to version 21
> Preparing SQL statements to update schema to version 22
> Preparing SQL statements to update schema to version 23
> Preparing SQL statements to update schema to version 24
> Preparing SQL statements to update schema to version 25
> Preparing SQL statements to update schema to version 26
> Preparing SQL statements to update schema to version 27
> Preparing SQL statements to update schema to version 28
> Preparing SQL statements to update schema to version 29
>
> ExecuterSqlUpdate(): DEBUG: requête:
>
> BEGIN;
>
>
> UPDATE schema_info SET value='14' WHERE tag='schema_version';
> CREATE TABLE pictures ( pictures_id text NOT NULL PRIMARY KEY
> REFERENCES files
> ON DELETE CASCADE ON UPDATE CASCADE, width int4, height int4);
>
>
> UPDATE schema_info SET value='15' WHERE tag='schema_version';
> ALTER TABLE files ADD COLUMN data_blob oid;
> ALTER TABLE files ADD COLUMN
> local_binary_size int8;
> ALTER TABLE files DROP COLUMN
> binary_data;
>
>
> UPDATE schema_info SET value='16' WHERE tag='schema_version';
> ALTER TABLE flickr_photostream ADD COLUMN requests_cache text;
> ALTER TABLE flickr_photostream ADD COLUMN cache_update_timestamp
> timestamp;
>
>
> UPDATE schema_info SET value='17' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN max_monthly_incoming int8;
> ALTER TABLE nodes ADD COLUMN max_monthly_outgoing int8;
> ALTER TABLE nodes ADD COLUMN quota_reset_day_of_month int4;
>
>
> UPDATE schema_info SET value='18' WHERE tag='schema_version';
> ALTER TABLE content ADD COLUMN long_description text REFERENCES
> content ON
> DELETE RESTRICT ON UPDATE CASCADE;
>
>
> UPDATE schema_info SET value='19' WHERE tag='schema_version';
> CREATE TABLE iframes (iframes_id text NOT NULL PRIMARY KEY
> REFERENCES content
> ON DELETE CASCADE ON UPDATE CASCADE,url text,width int4,height int4);
>
>
> UPDATE schema_info SET value='20' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN latitude NUMERIC(16, 6);
> ALTER TABLE nodes ADD COLUMN longitude NUMERIC(16, 6);
>
>
> UPDATE schema_info SET value='21' WHERE tag='schema_version';
> CREATE TABLE content_rss_aggregator
> (
> content_id text NOT NULL PRIMARY KEY REFERENCES content ON UPDATE
> CASCADE ON
> DELETE CASCADE,
> number_of_display_items integer NOT NULL DEFAULT 10,
> algorithm_strength real NOT NULL DEFAULT 0.75,
> max_item_age interval DEFAULT NULL
> );
> CREATE TABLE content_rss_aggregator_feeds
> ( content_id text NOT NULL REFERENCES content_rss_aggregator ON
> UPDATE CASCADE
> ON DELETE CASCADE,
> url text,
> bias real NOT NULL DEFAULT 1,
> default_publication_interval int DEFAULT NULL,
> PRIMARY KEY(content_id, url)
> );
> ALTER TABLE content_has_owners ALTER COLUMN is_author SET DEFAULT 'f';
>
> ALTER TABLE nodes DROP COLUMN rss_url;
>
> DELETE FROM content WHERE content_type='HotspotRss';
>
>
> UPDATE schema_info SET value='22' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN civic_number text;
> ALTER TABLE nodes ADD COLUMN street_name text;
> UPDATE nodes SET street_name = street_address;
> ALTER TABLE nodes DROP COLUMN street_address;
> ALTER TABLE nodes ADD COLUMN city text;
> ALTER TABLE nodes ADD COLUMN province text;
> ALTER TABLE nodes ADD COLUMN country text;
> ALTER TABLE nodes ADD COLUMN postal_code text;
>
>
> UPDATE schema_info SET value='23' WHERE tag='schema_version';
> CREATE TABLE node_tech_officers (
> node_id VARCHAR(32) REFERENCES nodes (node_id),
> user_id VARCHAR(45) REFERENCES users (user_id),
> PRIMARY KEY (node_id, user_id)
> );
>
>
> UPDATE schema_info SET value='24' WHERE tag='schema_version';
> ALTER TABLE content_rss_aggregator_feeds ADD COLUMN title text;
>
>
> UPDATE schema_info SET value='25' WHERE tag='schema_version';
> CREATE TABLE node_stakeholders (
> node_id VARCHAR(32) REFERENCES nodes (node_id),
> user_id VARCHAR(45) REFERENCES users (user_id),
> is_owner BOOLEAN NOT NULL DEFAULT FALSE,
> is_tech_officer BOOLEAN NOT NULL DEFAULT FALSE,
> PRIMARY KEY (node_id, user_id)
> );
> INSERT INTO node_stakeholders (node_id, user_id) SELECT node_id,
> user_id FROM
> node_owners UNION SELECT node_id, user_id FROM node_tech_officers;
> UPDATE node_stakeholders SET is_owner = true FROM node_owners WHERE
> node_stakeholders.node_id = node_owners.node_id AND
> node_stakeholders.user_id
> = node_owners.user_id;
> UPDATE node_stakeholders SET is_tech_officer = true FROM
> node_tech_officers
> WHERE node_stakeholders.node_id = node_tech_officers.node_id AND
> node_stakeholders.user_id = node_tech_officers.user_id;DROP TABLE
> node_owners;
> DROP TABLE node_tech_officers;
>
>
> UPDATE schema_info SET value='26' WHERE tag='schema_version';
> CREATE TABLE networks (
> network_id text NOT NULL PRIMARY KEY,
> network_authenticator_class text NOT NULL CHECK
> (network_authenticator_class<>''),
> network_authenticator_params text,
> is_default_network boolean NOT NULL DEFAULT FALSE,
> name text NOT NULL DEFAULT 'Unnamed network' CHECK (name<>''),
> creation_date date NOT NULL DEFAULT now(),
> homepage_url text,
> tech_support_email text,
> validation_grace_time interval NOT NULL DEFAULT '1200 seconds',
> validation_email_from_address text NOT NULL CHECK
> (validation_email_from_address<>'') DEFAULT
> 'validation at wifidognetwork',
> allow_multiple_login BOOLEAN NOT NULL DEFAULT FALSE,
> allow_splash_only_nodes BOOLEAN NOT NULL DEFAULT FALSE,
> allow_custom_portal_redirect BOOLEAN NOT NULL DEFAULT FALSE
> );
> INSERT INTO networks (network_id, network_authenticator_class,
> network_authenticator_params) SELECT account_origin,
> COALESCE('AuthenticatorLocalUser') as network_authenticator_class,
> '\'' ||
> account_origin || '\'' FROM users GROUP BY (account_origin) ORDER BY
> min(reg_date);
> UPDATE networks SET is_default_network=TRUE WHERE network_id=(SELECT
> account_origin FROM users GROUP BY (account_origin) ORDER BY min
> (reg_date)
> LIMIT 1);
> ALTER TABLE users ADD CONSTRAINT account_origin_fkey FOREIGN KEY
> (account_origin) REFERENCES networks (network_id) ON UPDATE CASCADE
> ON DELETE
> RESTRICT;
> ALTER TABLE nodes ADD COLUMN network_id text;
> UPDATE nodes SET network_id=(SELECT account_origin FROM users GROUP BY
> (account_origin) ORDER BY min(reg_date) LIMIT 1);
> ALTER TABLE nodes ALTER COLUMN network_id SET NOT NULL;
> ALTER TABLE nodes ADD CONSTRAINT network_id_fkey FOREIGN KEY
> (network_id)
> REFERENCES networks ON UPDATE CASCADE ON DELETE RESTRICT;
> ALTER TABLE network_has_content ADD CONSTRAINT network_id_fkey
> FOREIGN KEY
> (network_id) REFERENCES networks ON UPDATE CASCADE ON DELETE CASCADE;
> CREATE TABLE network_stakeholders (
> network_id text REFERENCES networks,
> user_id VARCHAR(45) REFERENCES users,
> is_admin BOOLEAN NOT NULL DEFAULT FALSE,
> is_stat_viewer BOOLEAN NOT NULL DEFAULT FALSE,
> PRIMARY KEY (network_id, user_id)
> );
>
>
> UPDATE schema_info SET value='27' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN last_paged timestamp;
>
>
> UPDATE schema_info SET value='28' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN is_splash_only_node boolean;
> ALTER TABLE nodes ALTER COLUMN is_splash_only_node SET DEFAULT FALSE;
> ALTER TABLE nodes ADD COLUMN custom_portal_redirect_url text;
>
>
> UPDATE schema_info SET value='29' WHERE tag='schema_version';
> ALTER TABLE flickr_photostream ADD COLUMN api_shared_secret text;
>
> COMMIT;
>
>
> Warning: pg_query() [function.pg-query]: Query failed: FEHLER: Spalte
> »network_id« enthält NULL-Werte
> in /var/www/wifidog/classes/AbstractDbPostgres.php on line 287
>
> Warning: pg_affected_rows(): supplied argument is not a valid
> PostgreSQL
> result resource in /var/www/wifidog/classes/AbstractDbPostgres.php
> on line
> 305
>
> rangées affectées par la requête SQL
> Temps écoulé: 0.135004043579 seconde(s)
>
> ExecuterSqlResUnique(): ERREUR: Lors de l'exécution de la requête
> SQL:
>
> BEGIN;
>
>
> UPDATE schema_info SET value='14' WHERE tag='schema_version';
> CREATE TABLE pictures ( pictures_id text NOT NULL PRIMARY KEY
> REFERENCES files
> ON DELETE CASCADE ON UPDATE CASCADE, width int4, height int4);
>
>
> UPDATE schema_info SET value='15' WHERE tag='schema_version';
> ALTER TABLE files ADD COLUMN data_blob oid;
> ALTER TABLE files ADD COLUMN
> local_binary_size int8;
> ALTER TABLE files DROP COLUMN
> binary_data;
>
>
> UPDATE schema_info SET value='16' WHERE tag='schema_version';
> ALTER TABLE flickr_photostream ADD COLUMN requests_cache text;
> ALTER TABLE flickr_photostream ADD COLUMN cache_update_timestamp
> timestamp;
>
>
> UPDATE schema_info SET value='17' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN max_monthly_incoming int8;
> ALTER TABLE nodes ADD COLUMN max_monthly_outgoing int8;
> ALTER TABLE nodes ADD COLUMN quota_reset_day_of_month int4;
>
>
> UPDATE schema_info SET value='18' WHERE tag='schema_version';
> ALTER TABLE content ADD COLUMN long_description text REFERENCES
> content ON
> DELETE RESTRICT ON UPDATE CASCADE;
>
>
> UPDATE schema_info SET value='19' WHERE tag='schema_version';
> CREATE TABLE iframes (iframes_id text NOT NULL PRIMARY KEY
> REFERENCES content
> ON DELETE CASCADE ON UPDATE CASCADE,url text,width int4,height int4);
>
>
> UPDATE schema_info SET value='20' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN latitude NUMERIC(16, 6);
> ALTER TABLE nodes ADD COLUMN longitude NUMERIC(16, 6);
>
>
> UPDATE schema_info SET value='21' WHERE tag='schema_version';
> CREATE TABLE content_rss_aggregator
> (
> content_id text NOT NULL PRIMARY KEY REFERENCES content ON UPDATE
> CASCADE ON
> DELETE CASCADE,
> number_of_display_items integer NOT NULL DEFAULT 10,
> algorithm_strength real NOT NULL DEFAULT 0.75,
> max_item_age interval DEFAULT NULL
> );
> CREATE TABLE content_rss_aggregator_feeds
> ( content_id text NOT NULL REFERENCES content_rss_aggregator ON
> UPDATE CASCADE
> ON DELETE CASCADE,
> url text,
> bias real NOT NULL DEFAULT 1,
> default_publication_interval int DEFAULT NULL,
> PRIMARY KEY(content_id, url)
> );
> ALTER TABLE content_has_owners ALTER COLUMN is_author SET DEFAULT 'f';
>
> ALTER TABLE nodes DROP COLUMN rss_url;
>
> DELETE FROM content WHERE content_type='HotspotRss';
>
>
> UPDATE schema_info SET value='22' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN civic_number text;
> ALTER TABLE nodes ADD COLUMN street_name text;
> UPDATE nodes SET street_name = street_address;
> ALTER TABLE nodes DROP COLUMN street_address;
> ALTER TABLE nodes ADD COLUMN city text;
> ALTER TABLE nodes ADD COLUMN province text;
> ALTER TABLE nodes ADD COLUMN country text;
> ALTER TABLE nodes ADD COLUMN postal_code text;
>
>
> UPDATE schema_info SET value='23' WHERE tag='schema_version';
> CREATE TABLE node_tech_officers (
> node_id VARCHAR(32) REFERENCES nodes (node_id),
> user_id VARCHAR(45) REFERENCES users (user_id),
> PRIMARY KEY (node_id, user_id)
> );
>
>
> UPDATE schema_info SET value='24' WHERE tag='schema_version';
> ALTER TABLE content_rss_aggregator_feeds ADD COLUMN title text;
>
>
> UPDATE schema_info SET value='25' WHERE tag='schema_version';
> CREATE TABLE node_stakeholders (
> node_id VARCHAR(32) REFERENCES nodes (node_id),
> user_id VARCHAR(45) REFERENCES users (user_id),
> is_owner BOOLEAN NOT NULL DEFAULT FALSE,
> is_tech_officer BOOLEAN NOT NULL DEFAULT FALSE,
> PRIMARY KEY (node_id, user_id)
> );
> INSERT INTO node_stakeholders (node_id, user_id) SELECT node_id,
> user_id FROM
> node_owners UNION SELECT node_id, user_id FROM node_tech_officers;
> UPDATE node_stakeholders SET is_owner = true FROM node_owners WHERE
> node_stakeholders.node_id = node_owners.node_id AND
> node_stakeholders.user_id
> = node_owners.user_id;
> UPDATE node_stakeholders SET is_tech_officer = true FROM
> node_tech_officers
> WHERE node_stakeholders.node_id = node_tech_officers.node_id AND
> node_stakeholders.user_id = node_tech_officers.user_id;DROP TABLE
> node_owners;
> DROP TABLE node_tech_officers;
>
>
> UPDATE schema_info SET value='26' WHERE tag='schema_version';
> CREATE TABLE networks (
> network_id text NOT NULL PRIMARY KEY,
> network_authenticator_class text NOT NULL CHECK
> (network_authenticator_class<>''),
> network_authenticator_params text,
> is_default_network boolean NOT NULL DEFAULT FALSE,
> name text NOT NULL DEFAULT 'Unnamed network' CHECK (name<>''),
> creation_date date NOT NULL DEFAULT now(),
> homepage_url text,
> tech_support_email text,
> validation_grace_time interval NOT NULL DEFAULT '1200 seconds',
> validation_email_from_address text NOT NULL CHECK
> (validation_email_from_address<>'') DEFAULT
> 'validation at wifidognetwork',
> allow_multiple_login BOOLEAN NOT NULL DEFAULT FALSE,
> allow_splash_only_nodes BOOLEAN NOT NULL DEFAULT FALSE,
> allow_custom_portal_redirect BOOLEAN NOT NULL DEFAULT FALSE
> );
> INSERT INTO networks (network_id, network_authenticator_class,
> network_authenticator_params) SELECT account_origin,
> COALESCE('AuthenticatorLocalUser') as network_authenticator_class,
> '\'' ||
> account_origin || '\'' FROM users GROUP BY (account_origin) ORDER BY
> min(reg_date);
> UPDATE networks SET is_default_network=TRUE WHERE network_id=(SELECT
> account_origin FROM users GROUP BY (account_origin) ORDER BY min
> (reg_date)
> LIMIT 1);
> ALTER TABLE users ADD CONSTRAINT account_origin_fkey FOREIGN KEY
> (account_origin) REFERENCES networks (network_id) ON UPDATE CASCADE
> ON DELETE
> RESTRICT;
> ALTER TABLE nodes ADD COLUMN network_id text;
> UPDATE nodes SET network_id=(SELECT account_origin FROM users GROUP BY
> (account_origin) ORDER BY min(reg_date) LIMIT 1);
> ALTER TABLE nodes ALTER COLUMN network_id SET NOT NULL;
> ALTER TABLE nodes ADD CONSTRAINT network_id_fkey FOREIGN KEY
> (network_id)
> REFERENCES networks ON UPDATE CASCADE ON DELETE RESTRICT;
> ALTER TABLE network_has_content ADD CONSTRAINT network_id_fkey
> FOREIGN KEY
> (network_id) REFERENCES networks ON UPDATE CASCADE ON DELETE CASCADE;
> CREATE TABLE network_stakeholders (
> network_id text REFERENCES networks,
> user_id VARCHAR(45) REFERENCES users,
> is_admin BOOLEAN NOT NULL DEFAULT FALSE,
> is_stat_viewer BOOLEAN NOT NULL DEFAULT FALSE,
> PRIMARY KEY (network_id, user_id)
> );
>
>
> UPDATE schema_info SET value='27' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN last_paged timestamp;
>
>
> UPDATE schema_info SET value='28' WHERE tag='schema_version';
> ALTER TABLE nodes ADD COLUMN is_splash_only_node boolean;
> ALTER TABLE nodes ALTER COLUMN is_splash_only_node SET DEFAULT FALSE;
> ALTER TABLE nodes ADD COLUMN custom_portal_redirect_url text;
>
>
> UPDATE schema_info SET value='29' WHERE tag='schema_version';
> ALTER TABLE flickr_photostream ADD COLUMN api_shared_secret text;
>
> COMMIT;
>
> L'erreur est:
> FEHLER: Spalte »network_id« enthält NULL-Werte
>
> Back - Next
>
>
> thx 4 any help or tip
>
> christian
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>
More information about the WiFiDog
mailing list