Re: Apache::Session::MySQL, light/heavy proxy, wedging

[Jonathan Vanasco <suppressed>]

On Jan 30, 2007, at 4:47 PM, Todd Finney wrote:

> I have two servers running in the light/heavy configuration as  
> outlined in the guide.   Both servers are 1.3.34.  On the  
> lightweight server, my proxy section looks like this:

first off, you should be running 2.0.x by now

try this:

>     my %session;
	eval {
> 	    tie %session, 'Apache::Session::MySQL', $cookie, {
> 	        DataSource => 'dbi:mysql:boygenius', #these arguments are
> 	        UserName   => 'nobody',         #required when using
> 	        Password   => 'XXXXXXXXX',           #MySQL.pm
> 	        LockDataSource => 'dbi:mysql:boygenius',
> 	        LockUserName   => 'nobody',
> 	        LockPassword   => 'XXXXXXXXX'
> 	        };
	};
	if ( $@ ) {
		print STDERR "\n ERROR TIE -> $@ ";
	}

> I'm not even going to attempt to guess what's going on here, but I  
> could really use a smack with the clue brick.

my gut feeling is that you're having an error that deals with valid /  
invalid / new session ids.  but it could really be anything - maybe  
you're having connectivity issues with apache::session (timing out ?  
are you using apache::dbi ? etc )

just as an example, in my session class i do:

	is there a cookie ?  if so, is the session id in a valid format  .   
if so, is it a valid session.
	no session id ?  then i need a session new.  can i crete a new  
session ?  yes ? awesome.  no ? log an error and do something for  
unsupported sessions ( ie , send a notifier to the daemon that will  
email me if it gets more  than 10 of those in an hour and regardless-  
redirect the user to a "system error" page )

anyways, you shouldn't be writing new code for 1.3.x  unless you're  
stuck supporting a legacy app.

// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - - - - -
| SyndiClick.com
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - - - - -
|      FindMeOn.com - The cure for Multiple Web Personality Disorder
|      Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - - - - -
|      RoadSound.com - Tools For Bands, Stuff For Fans
|      Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - - - - -