Re: [Userlogin-users] UserLogin

[John K. <jk...@in...>]

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