help please!!!!

[TiamaT]

hello, can anyone know what this error means?
the installation of Roundcube was ok, connection to db is ok, test message ok, but when i try to access via web, this error appears:
SERVICE CURRENTLY NOT AVAILABLE!
Error No. [0x01F4]


in the roundcube log file i see this error:

[09-Mar-2009 12:25:47 +0200] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_179fc0516c122dbc2eabb7a2ad7856d9b5264769f FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1146]
[Native message: Table 'casan.session' doesn't exist]
 in C:\wwwroot\PHPWebAdmin\roundcube\program\include\rcube_mdb2.php on line 255 (GET /roundcube/index.php)

the mail server is hMail and the database is MySql.
everything works greate except the webmail
sorry for my english....
thanks!

[kopros]

Hi

(my english isn't very great too...)

I had the same error.

I solved the problem with this command :

mysql -u root -p roundcubemail < roundcube/SQL/mysql.initial.sql
Your root sql password


Now I access to the homepage of roundcube, but I can't loggin a user.
When I try, I type the user name, the system's password of this user, and whenever there's an authentication error.
I don't know why.

A log file extract :
[10-Mar-2009 18:11:08 +0100] IMAP Error: Authentication for user@mydomain.com failed (LOGIN): "a001 No Login failed." (POST /roundcubemail/?_task=&_action=login)


EDIT : I understood why the authentications failed, there's no user on database.
How can I create a user with the web interface ?

Thanks for answers

[TiamaT]

if i run the mysql -u root -p roundcubemail < roundcube/SQL/mysql.initial.sql command i have the following error in MySQL Query Browser


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u root -p roundcubemail < roundcube/SQL/mysql.initial.sql' at line 1

[JohnDoh]

`mysql -u root -p roundcubemail < roundcube/SQL/mysql.initial.sql` should be run on the command line, not in MySQL Query Browser. In Query Browser, one you have connected to the database, you can do File > Open Script and run the SQL that way.

[TiamaT]

it's ok, but now i have another error

[18-Mar-2009 18:12:11 +0200] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_1ceaf80e546346e7b739755d8c4b0885fe8380468 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1054]
[Native message: Unknown column 'vars' in 'field list']
 in C:\wwwroot\PHPWebAdmin\roundcube\program\include\rcube_mdb2.php on line 255 (GET /roundcube/index.php)
[18-Mar-2009 18:12:11] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_147012dcc822931867c06b43c725cf29986aef962 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1054]
[Native message: Unknown column 'vars' in 'field list']


[18-Mar-2009 18:12:11 +0200] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_147012dcc822931867c06b43c725cf29986aef962 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed\n     FROM session\n     WHERE  sess_id=?']
[Native code: 1054]
[Native message: Unknown column 'vars' in 'field list']
 in C:\wwwroot\PHPWebAdmin\roundcube\program\include\rcube_mdb2.php on line 255 (GET /roundcube/index.php)

the data base name is casan ....if that help.
thanks