Thread: [Userlogin-users] UserLogin
Status: Beta
Brought to you by:
johnkeiser
From: Brian A. <bri...@se...> - 2001-09-07 19:28:45
|
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. |
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 |
From: John K. <jk...@in...> - 2001-09-07 21:57:11
|
Incidentally, UserLogin *will* work for what you want to do, it just might be overkill :) --John 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? > > > > -- > 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. > > > > _______________________________________________ > userlogin-users mailing list > use...@li... > https://lists.sourceforge.net/lists/listinfo/userlogin-users -- http://www.johnkeiser.com http://www.wrighthaven.com - Technology and Philanthropy |