Hi Thanks Michael for the info. Do you know how is the performance of the DBItore vs. FileStore? Thanks Edgardo Michael Kahn <[EMAIL PROTECTED]> wrote: > I had problems with this too. I actually had to change the code in > Apache::Session::DBIStore to work properly with the postgres driver. For some > reason the driver doesn't appear to be properly escaping byte sequences, and so > the session data which is packed up by Storable is causing the error. > > As a quick fix, I added "use MIME::Base64 qw(encode_base64 decode_base64);" to > the top of the file, and then base64 encode and decode the session data before > writing to the database and reading from it. That seemed to fix the > problem. I'll email you the updated source if you'd like. > > This fix is a pretty big hack, and I don't know what the performance effect > is, but it wasn't for production code, it was for a demo. > > Michael Kahn > Ottawa, Ontario, Canada > > On Tue, 24 Jun 2036, you wrote: > > Hi > > > > I've used Embeded Perl for a while, and now I'm trying to use the session > > funcionality. I tried to use postgresql as a database server, but I had no > > luck. My apache configuration file looks like: > > > > PerlSetEnv EMBPERL_SESSION_CLASSES "DBIStore SysVSemaphoreLocker" > > PerlSetEnv EMBPERL_SESSION_ARGS "DataSource=dbi:Pg:dbname=session > > UserName=xxx" > > > > When I try to acces a page I get the following error: > > The server encountered an internal error or misconfiguration and was unable to > > complete your request. > > > > Please contact the server administrator, [EMAIL PROTECTED] and > > inform them of the time the error occurred, and anything > > you might have done that may have caused the error. > > > > [27900]ERR: 24: Line 15: Error in Perl code: DBD::Pg::st execute failed: > > ERROR: parser: parse error at or near "" > > > > Apache/1.3.12 (Unix) mod_perl/1.22 HTML::Embperl 1.3b2 [Fri May 19 18:43:57 > > 2000] > > > > HTTP/1.1 500 Internal Server Error Date: Fri, 19 May 2000 21:43:57 GMT Server: > > Apache/1.3.12 (Unix) mod_perl/1.22 > > Connection: close Content-Type: text/html; charset=iso-8859-1 > > > > Internal Server Error > > > > How could I fix it? > > > > Then, I tried to use FileStore, and it worked fine. However, it stores the > > sessions files in the /tmp directory. How could I change the location of the > > sessions file in the httpd.conf file? > > > > Any help to solve this problems will be very appreciated > > > > Thanks in advance > > > > Edgardo Szulsztein > > [EMAIL PROTECTED] > > > > ____________________________________________________________________ > > Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] ____________________________________________________________________ Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
