Yes, thanks for that Ajit. I had actually created a 'sessions' database in
earlier attempts, but not a table as well (The distribution readme is fairly
unhelpful). After digging around, I found the following in
Apache::Session::Store::MySQL:
To use this module, you will need at least these columns in a table
called 'sessions':
id char(32) # or however long your session IDs are.
a_session text
To create this schema, you can execute this command using the mysql
program:
CREATE TABLE sessions (
id char(32) not null primary key,
a_session text
);
If you use some other command, ensure that there is a unique index
on the
table's id column.
Thanks again,
Rog
-----Original Message-----
From: Ajit Deshpande [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 9 August 2000 09:52 AM
To: Stuckey, Roger; '[EMAIL PROTECTED]'
Subject: Re: Make test fails for Apache::Session
On Wed, Aug 09, 2000 at 08:51:08AM +1000, Stuckey, Roger wrote:
>
> I can't seem to get Apache::Session installed on our SGI-Irix box. The
MySQL
> test fails when trying to create a new database, as shown by the build
> output below. Does anyone know what I am doing (or not doing) wrong? I
have
> the distinct feeling that it's something very simple :)
>
> Running:
> Apache 1.3.6
> mod_perl-1.21
> MySQL 3.22.20a
>From "perldoc Apache::Session::DBI :
To use this module, you will need these columns in a table
called 'sessions':
id char(16)
length int(11)
a_session text
Where the a_session column needs to be able to handle
arbitrarily long binary data.
Your error message suggests that you do have not created the sessions
table.
Ajit
