[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ic] moving sessions to mysql - no luck


Can any suggest something I should check?

Yes, use the SessionDB directive, not SessionDatabase.

Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/

Ok - so these lines go into catalog.cfg correct?

SessionType DBI
SessionDB sessions
Variable SESSION_USER myusername
Variable SESSION_PASS mypassword
Variable SESSION_DSN dbi:mysql:mycatalog:localhost

Also, do these lines go into catalog.cfg, or into a new file .../dbconf/mysql/sessions.sql ?

Database  sessions  sessions.txt  __SESSION_DSN__
Database  sessions  USER          __SESSION_USER__
Database  sessions  PASS          __SESSION_PASS__
Database  sessions  COLUMN_DEF    "code=VARCHAR(64) NOT NULL PRIMARY KEY"
Database  sessions  COLUMN_DEF    "session=TEXT"
Database  sessions  COLUMN_DEF    "sessionlock=VARCHAR(64) DEFAULT ''
NOT NULL"
Database  sessions  COLUMN_DEF    "last_accessed=TIMESTAMP(14)"

I think I'm still missing something :(

DB
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.