Menu

#5 errors trying to setup

open
nobody
None
5
2002-11-24
2002-11-24
Anonymous
No

I've installed UserLogin as a perl module and I'm now
trying to get the sql portion installed. Here's my
command and output:

*******************************************************************
banks ~/UserLogin-0.6.2/sql> ./setup-postgres.pl --host
10.0.0.15 --username mason --password mason mason_sessions
Dropping ul_PARAMETER ...
DBD::Pg::st execute failed: ERROR: table
"ul_parameter" does not exist at ./setup-postgres.pl
line 113.
Dropping ul_SESSION_VAR ...
DBD::Pg::st execute failed: ERROR: table
"ul_session_var" does not exist at ./setup-postgres.pl
line 113.
Dropping ul_SESSION ...
DBD::Pg::st execute failed: ERROR: table "ul_session"
does not exist at ./setup-postgres.pl line 113.
Dropping ul_USER_ATTRIBUTE ...
DBD::Pg::st execute failed: ERROR: table
"ul_user_attribute" does not exist at
./setup-postgres.pl line 113.
Dropping ul_ATTRIBUTE (seq:
ul_attribute_attribute_id_seq) ...
DBD::Pg::st execute failed: ERROR: sequence
"ul_attribute_attribute_id_seq" does not exist at
./setup-postgres.pl line 109.
DBD::Pg::st execute failed: ERROR: table
"ul_attribute" does not exist at ./setup-postgres.pl
line 113.
Dropping ul_USER (seq: ul_user_user_id_seq) ...
DBD::Pg::st execute failed: ERROR: sequence
"ul_user_user_id_seq" does not exist at
./setup-postgres.pl line 109.
DBD::Pg::st execute failed: ERROR: table "ul_user"
does not exist at ./setup-postgres.pl line 113.
Dropping ul_GROUP (seq: ul_group_group_id_seq) ...
DBD::Pg::st execute failed: ERROR: sequence
"ul_group_group_id_seq" does not exist at
./setup-postgres.pl line 109.
DBD::Pg::st execute failed: ERROR: table "ul_group"
does not exist at ./setup-postgres.pl line 113.
Executing psql -h 10.0.0.15 -U mason -f
create_schema_postgres.sql.new mason_sessions ...
DBD::Pg::st execute failed: ERROR: Relation
"ul_attribute" does not exist at
/usr/lib/perl5/site_perl/5.6.1/Tie/HashRef/DBICache.pm
line 37.
DBD::Pg::st execute failed: ERROR: Relation
"ul_attribute" does not exist at
/usr/lib/perl5/site_perl/5.6.1/Tie/HashRef/DBICache.pm
line 37.
Database handle destroyed without explicit disconnect.
Segmentation fault (core dumped)
*******************************************************************

I've tried running the create_schema_postgres.sql
locally on the database server first, but the setup
script first drops the tables anyways so that didn't
really help.

What am I missing?

Thanks,
Tim

Discussion


Log in to post a comment.