jo wrote:
Christoph Zwerschke wrote:
Am 15.02.2011 16:56, schrieb jo:
The servers are different, they are installed in different cities.
The file session-???? is saved in the /tmp/ directory
Maybe there is a cron job or something on your server forecefully trying
to clean up your /tmp/ directory or there is some process filling the
temp filesystem from time to time.
Try using a dedicated directory outside of /tmp for the session files.
Is it possible to use PostgreSQL as session storage? Where can I learn
more about it?
http://www.cherrypy.org/chrome/common/2.2/docs/book/chunk/ch03.html#backends
-- Christoph
I'm using PostgreSQL to store my session data, seems it works fine. :-)
I'm trying to implement it on Oracle with a monkeypatch, because in
some context I don't have pg installed.
I have a problem of data type, because Oracle hasn't TEXT type, seems
the equivalent is CLOB
infact SQLAlchemy creates the table like this:
name | data_type | nullable | data_default | data_length
--------------- + ------------ + -------- + ------------ + -----------
ID | NVARCHAR2 | N | NULL | 80
DATA | CLOB | Y | NULL | 4000
EXPIRATION_TIME | TIMESTAMP(6) | Y | NULL | 11
but pickle doesn't like it...
...data *=* pickle*.*loads*(*pickled_data*)*|
*TypeError: ('loads() argument 1 must be string, not cx_Oracle.LOB',
<bound method Root.index of <sicer.BASE.controller.Root object at
0x8231f10>>)*
any idea how to solve this?
thank you.
j
I solved using pickle.loads(str(pickled_data))
If it interest to someone to have this monkeypatch I can send it to him.
I want to say thanks to everybody who helped me to solve this problem. :-)
j
--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en.
