On Wed, Nov 14, 2012 at 5:56 PM, Francisco Obispo <fobi...@isc.org> wrote:

> Use:
> $c->model('GUS::WebappSession') as the name.

And where would I put this?

I'm not dealing myself with the session data. I'm relying and delegating
all this to Session, Session::Store::DBIC, and Session::State::Cookie

That's why I'm saying that somewhere within these modules, they are failing
at getting 'GUS::WebappSession'. They seem to be using a hardwired
'sessions' table ...

> or in the config:
> <Plugin::Session>
>   dbic_class GUS::WebappSession
>   id_field id
>   storage_field session_data
>   expires_field expires
>   need_commit 0
>   expires 3600
>   verify_address 1
> </Plugin::Session>

My config is simpler, but still identical to what you propose:

[fernan@optima] cat tcsnp_local.yml
  schema_class: GUS
    - dbi:Pg:dbname=tcsnp
    - fernan
    - //PASS//
    - AutoCommit: 1

  dbic_class: GUS::WebappSession
  cookie_name: tcsnp_cookie
  cookie_expires: 0

This is clearly not the issue.  All other SQL statements are being
generated correctly, e.g. using DBIC_TRACE=1

[info] tcsnp powered by Catalyst 5.90018
HTTP::Server::PSGI: Accepting connections at http://0:3006/
SELECT me.id, me.session_data, me.expires FROM webapp.sessions me WHERE (
me.id = ? ): 'session:eff3bb1616f1ee3341477c4d1056c51c7ed826a6'
[info] *** Request 1 (0.167/s) [14993] [Wed Nov 14 18:22:13 2012] ***
[debug] Path is "genes"
[debug] "GET" request for "genes" from ""
[debug] Rendering template "genes/search.tt"
[debug] Applying HTML page layout wrappers to genes/search.tt
[debug] Found sessionid "eff3bb1616f1ee3341477c4d1056c51c7ed826a6" in cookie
[debug] Response Code: 200; Content-Type: text/html; charset=utf-8;
Content-Length: 25221
[info] Request took 0.331861s (3.013/s)

Here you can see that the table is fully qualified with the schema name as

It is only at the DELETE statements that this is failing.

List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/

Reply via email to