[rt-users] Moved Database, now cannot create sessions

[Jacob Helwig]

It should actually be the web server process that is trying to write to
the directory, not MySQL, if you're using Apache::Session::File.  Have
you changed the WebSessionClass in your RT_SiteConfig.pm?  It should be
trying to save to the MySQL DB, and not /usr/local/rt3/var/session_data,
unless you have changed it.

# $WebSessionClass is the class you wish to use for managing Sessions.
# It defaults to use your SQL database, but if you are using MySQL 3.x
and
# plans to use non-ascii Queue names, uncomment and add this line to
# RT_SiteConfig.pm will prevent session corruption.

# Set($WebSessionClass , 'Apache::Session::File');

If the Set line is still commented out, or not defined in your
RT_SiteConfig.pm, you might want to check the permissions on your
sessions table, and make sure the structure is correct on it.

-- 
Jacob Helwig
PC Technician
Busch's Help Desk
Desk: x35221
Direct: 734-214-8221

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Mathew
Snyder
Sent: Thursday, October 04, 2007 9:05 AM
To: Mathew Snyder
Cc: RT Users
Subject: Re: [rt-users] Moved Database, now cannot create sessions

I'm guessing the problem here is that MySQL is trying to write the
session data
to this directory.  However, with the database now on another server it
clearly
doesn't have access to it.  Is this correct?

Keep up with me and what I'm up to: http://theillien.blogspot.com


Mathew Snyder wrote:
> I'm moving my devel database to a second server and separating it from
the
> server RT actually runs on.  However, after doing so and updating the
> RT_SiteConfig.pm I get the following:
> 
> error:   	RT couldn't store your session.
> This may mean that that the directory
'/usr/local/rt3/var/session_data' isn't
> writable or a database table is missing or corrupt.
> 
> context:  	
> ...  	
> 86:  	};
> 87:  	undef $cookies{$cookiename};
> 88:  	}
> 89:  	else {
> 90:  	die loc("RT couldn't store your session.") . "\n"
> 91:  	. loc(
> 92:  	"This may mean that that the directory '[_1]' isn't writable or
a database
> table is missing or corrupt.",
> 93:  	$RT::MasonSessionDir
> 94:  	)
> ...  	
> code stack:  	/usr/local/rt3/local/html/Elements/SetupSessionCookie:90
> /usr/local/rt3/share/html/autohandler:120
> 
> I've verified the permissions and ownership for the directory.  What
else might
> I need to look at?
> 
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com