[ic] moving sessions to mysql - no luck
DB
DB at M-and-D.com
Sat Jan 19 11:26:58 EST 2008
> Do you have query logging enabled in MySQL, and can you see even a
> connection attempt being made?
>
> Does the sessions table exist in MySQL? Can you connect with a simple Perl
> program using the DSN, user, and pass you supplied?
>
> In interchange.cfg, is DEBUG set and DataTrace enabled, and debug logging
> going somewhere? Anything showing up there?
>
> You could try deleting your file-based session directory entirely as well,
> and it should throw a 500 error if it's trying to write there but can't,
> indicating it's not using database sessions.
>
> Jon
The table does exist in the store's database. The store runs ok so the
DSN, user and pass should be ok. I renamed the session/ folder to
session_off/
I added these lines to my catalog.cfg:
Variable MYSQL_SESSIONS_YES 1
Variable SESSION_USER myuser
Variable SESSION_PASS mypass
Variable SESSION_DSN dbi:mysql:mycatalog
ifdef MYSQL_SESSIONS_YES
Message Enabling MySQL-based sessions...
SessionType DBI
Database sessions sessions.txt __SESSION_DSN__
Database sessions USER __SESSION_USER__
Database sessions PASS __SESSION_PASS__
Database sessions KEY code
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 ''"
Database sessions COLUMN_DEF "last_accessed=TIMESTAMP(14)"
SessionDB session
Message ...Done
endif
ifndef MYSQL_SESSIONS_YES
Message MySQL-based sessions not enabled.
endif
but when I try to restart IC, it hangs after displaying the "Enabling
MySQL-based sessions..." message. I see no errors in the IC logs nor
much of interest when I try 'top'. Maybe I'm not waiting long enough,
but nothing appears to be happening. Doing a Ctrl-C, setting
MYSQL_SESSIONS_YES to zero and again restarting IC brings the store back.
It seems odd that no errors get logged and I'm not sure how to proceed ?
More information about the interchange-users
mailing list