[isf-wifidog] problem with the installation of wifidog-auth server
christian gattermair
christian.gattermair at mci.edu
Jeu 22 Sep 08:49:22 EDT 2005
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
More information about the WiFiDog
mailing list