Mailing List Archive: Embperl Session ID problem with %udat and postgres

Hi,

my configuration looks like:

Suse Linux 6.3
Apache_1.3.12
Apache-Session-1.04
mod_perl-1.22
HTML-embperl-1_3b3
postgres-6.5.3
DBD-Pg-0.93

On an EPL-Site I post data into %udat, when I try to acess the data on
another EPL-Site I get the error-message:

Error in Perl code: DBD::Pg::st execute failed: ERROR: Cannont insert a
duplicate key into a unique index

The database field "Session_id" has a unique index. If I remove the
index from that field, EmbPerl puts for each %udat call an entry into
the database with equal session_ids.

It looks like there is never an update to the db_entry, but always
an insert.

The cookie is set and received sucessfully (says the logfile).

Can anybody help me?!

Florian Dorrer

I don't have tried Apache::Session and Postgres. I forward your message to
the mod_perl list, where Apache::Session is supported

Gerald

> -----Original Message-----
> From: embperl-return-515-richter=ecos.de@perl.apache.org
> [mailto:embperl-return-515-richter=ecos.de@perl.apache.org]On Behalf Of
> Florian Dorrer
> Sent: Thursday, June 01, 2000 5:37 PM
> To: embperl@perl.apache.org
> Subject: Embperl Session ID problem with %udat and postgres
>
>
> Hi,
>
> my configuration looks like:
>
> Suse Linux 6.3
> Apache_1.3.12
> Apache-Session-1.04
> mod_perl-1.22
> HTML-embperl-1_3b3
> postgres-6.5.3
> DBD-Pg-0.93
>
> On an EPL-Site I post data into %udat, when I try to acess the data on
> another EPL-Site I get the error-message:
>
> Error in Perl code: DBD::Pg::st execute failed: ERROR: Cannont insert a
> duplicate key into a unique index
>
> The database field "Session_id" has a unique index. If I remove the
> index from that field, EmbPerl puts for each %udat call an entry into
> the database with equal session_ids.
>
> It looks like there is never an update to the db_entry, but always
> an insert.
>
> The cookie is set and received sucessfully (says the logfile).
>
> Can anybody help me?!
>
>
> Florian Dorrer
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
> For additional commands, e-mail: embperl-help@perl.apache.org
>
>

-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting

Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: richter@ecos.de Voice: +49 6133 925151
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------