Re: [Userlogin-users] UserLogin
Status: Beta
Brought to you by:
johnkeiser
From: John K. <jk...@in...> - 2001-09-07 20:24:12
|
On 07 Sep 2001 11:28:46 -0800, Brian Avis wrote: > 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? > Well, first, I think I might have steered you wrong, if you are not going to have users at all, or store information about each user ... Apache::Session might actually be better for you if all you care about is anonymous sessions, though you're going to have to write the cookie-dropping logic yourself. (Not terribly hard.) Plus, if you use Apache::Session, you should be able to easily convert to UserLogin later if you decide to add users. (Both systems use hashes to store / retrieve data.) As to the errors you're getting, don't worry, it looks like you're set up fine :) The removing tables thing is happening because the script doesn't check to see if tables exist before removing them yet. I'll have to fix that sometime or at least put a note in the install guide. The db handle destroyed error is troubling, I'll look into it. It's almost like we're not calling $sys->finished; at the end of the script. --John |