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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
