[Userlogin-users] UserLogin

[Brian A. <bri...@se...>]

Okay I followed your blatant plug from the mason list to use UserLogin.

The install docs say to do this.

cd sql
setup-postgres.pl


I am running
Postgres 7.1.3
Perl 5.6.1

Solaris 8

I created a db called userdata (didn't really know what to call it).

and ran setup-postgres.pl userdata and this is what I got.

Dropping ul_PARAMETER ...
ERROR:  table "ul_parameter" does not exist
DBD::Pg::st execute failed: ERROR:  table "ul_parameter" does not exist 
at ./setup-postgres.pl line 113.
Dropping ul_SESSION_VAR ...
ERROR:  table "ul_session_var" does not exist
DBD::Pg::st execute failed: ERROR:  table "ul_session_var" does not 
exist at ./setup-postgres.pl line 113.
Dropping ul_SESSION ...
ERROR:  table "ul_session" does not exist
DBD::Pg::st execute failed: ERROR:  table "ul_session" does not exist at 
./setup-postgres.pl line 113.
Dropping ul_USER_ATTRIBUTE ...
ERROR:  table "ul_user_attribute" does not exist
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) ...
ERROR:  sequence "ul_attribute_attribute_id_seq" does not exist
DBD::Pg::st execute failed: ERROR:  sequence 
"ul_attribute_attribute_id_seq" does not exist at ./setup-postgres.pl 
line 109.
ERROR:  table "ul_attribute" does not exist
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) ...
ERROR:  sequence "ul_user_user_id_seq" does not exist
DBD::Pg::st execute failed: ERROR:  sequence "ul_user_user_id_seq" does 
not exist at ./setup-postgres.pl line 109.
ERROR:  table "ul_user" does not exist
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) ...
ERROR:  sequence "ul_group_group_id_seq" does not exist
DBD::Pg::st execute failed: ERROR:  sequence "ul_group_group_id_seq" 
does not exist at ./setup-postgres.pl line 109.
ERROR:  table "ul_group" does not exist
DBD::Pg::st execute failed: ERROR:  table "ul_group" does not exist at 
./setup-postgres.pl line 113.
Executing psql -f create_schema_postgres.sql.new userdata ...
ERROR:  Relation 'ul_attribute' does not exist
DBD::Pg::st execute failed: ERROR:  Relation 'ul_attribute' does not 
exist at /usr/local/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/local/lib/perl5/site_perl/5.6.1/Tie/HashRef/DBICache.pm 
line 37.
Database handle destroyed without explicit disconnect.
pq_recvbuf: unexpected EOF on client connection
Segmentation Fault


I am pretty sure that isn't correct.  :)

All I want to do is to be able to track from 4 to 5 variables throughout 
a users session. I am not even sure if I need a user login to do this or 
not.

Any advice on what I am doing wrong?



-- 
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
If nautical nonsense be something you wish,
then drop on the deck and flop like a fish.