[Catalyst] Session::Store::DBIC and session table (postgres)

[Alejandro Imass]

On Wed, Nov 14, 2012 at 7:45 AM, Fernan Aguero <fernan.aguero at gmail.com>wro=
te:

> Hi,
>
> I'm having this issue with my catalyst app where the session table is
> not fully qualified in the generated SQL statement:
>

[...]


> The sessions table lives in my PostgreSQL database in a separate
> schema 'webapp'.
>
> So I would expect the statement to be:
> DELETE FROM webapp.sessions WHERE ( id =3D ? )
>
> I also have the table name fully qualified in the corresponding DBIC
> schema class (GUS/Webapp/Sessions.pm):
>
>
[...]

DBIC works well with schemas.

The first obvious question is permissions. Have you tried manually
connecting as the app user using pgsql and then selecting the table using
the fq name?

Pg requires grants on an object by object basis not like MySQL where you
can do something like grant all on *.db. You have to grant one by one to
the Catalyst DB user to the objects in the particular schema, unless of
course the user is the owner of the schema and in that case you don't even
need to fq the object names.

Also, if you are creating your Result classes with loader have you tried
"{loader_options=3D>{db_schema=3D>'foo'}}

Best,

-- =

Alejandro Imass
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20121114/498c8=
511/attachment.htm