Mailing-List: contact embperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Date: Wed, 25 Sep 2002 08:51:12 +1000
Message-ID: <87d6r3rogv.wl@gus.inodes.org>
From: Angus Lees <gus@inodes.org>
To: "Kaare Rasmussen" <kar@kakidata.dk>
Cc: embperl@perl.apache.org
Subject: Re: Session support
In-Reply-To: <20020924074429.15938.qmail@post.webline.dk>
References: <87sn08at45.wl@lambast.inside.urnet.com.au>
	<009401c2639b$ffaf3b70$0b0c0b0a@gr.ecos.de>
	<20020924073511.15822.qmail@post.webline.dk>
	<20020924074429.15938.qmail@post.webline.dk>
Mail-Followup-To: embperl@perl.apache.org
User-Agent: Wanderlust/2.9.14 (Unchained Melody) XEmacs/21.4 (Honest
 Recruiter)
MIME-Version: 1.0 (generated by SEMI 1.14.3 - "Ushinoya")
Content-Type: text/plain; charset=US-ASCII

At Tue, 24 Sep 2002 07:44:29 GMT, Kaare Rasmussen wrote:
> I'm trying to set up session support for Embperl. 
> I'd like to use Postgres, so my application can scale better. But it seems 
> that it uses semaphores for locking, and that the semaphores is placed on 
> Apache's side. Wouldn't this prevent me from using two or more Apache 
> servers from runing the same application with one database server? 

yes it would, if you were using something other than postgres for
storage.

you should use the "Null" locker for postgres, since the postgres
store does its own locking (using postgres transactions).

> But my current question is that I get a strange error. After fighting off 
> semaphore and other problems, I'm stuck with this: 
> 
> [2811]ERR: 24: Error in Perl code: DBD::Pg::st execute failed: ERROR: 
> Unterminated quoted string at 
> /usr/lib/perl5/site_perl/5.6.1/Apache/Session/Store/DBI.pm line 42. 
> Line 42 in DBI.pm is an execute of an insert into the sessions table. Can 
> anyone help me or offer any hints? 

set the DBI_TRACE environment variable to /tmp/dbi.log (or something),
then start apache.  all DBI calls should now log several lines to that
log file.

in there somewhere will be the actual SQL statement being used, which
should give some clues as to whats going wrong.

-- 
 - Gus

---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org