I've installed both 0.7.2 and 0.8-RC, both produce the same errors below is from 2 login attempts on 0.7.2:
Postgres.log entries:
2012-08-04 12:27:07 EDT LOG: connection authorized: user=roundcube database=roundcubemail
2012-08-04 12:27:07 EDT ERROR: value too long for type character varying(40)
2012-08-04 12:27:07 EDT STATEMENT: EXECUTE mdb2_statement_pgsql_28fdd64f92f5d960ac40d856e2dd3440b888c17d2 ('jie0cbbv36q0of
uauvub7i9gvlllve9p05ekkcmb68l2d7cmpcvdgafvaee5cft3s9lg3e2cldvmgc50dndt7sv3igvqad1h628d3l0', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1Oi
Jlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '<IP-ADDR>')
2012-08-04 12:27:12 EDT LOG: connection received: host=127.0.0.1 port=54747
2012-08-04 12:27:12 EDT LOG: connection authorized: user=roundcube database=roundcubemail
2012-08-04 12:27:12 EDT ERROR: value too long for type character varying(40)
2012-08-04 12:27:12 EDT STATEMENT: EXECUTE mdb2_statement_pgsql_59c343b5e2fa929ca79b353ffb0f8bcd75024c6cc ('dpekoo41vntesb
ehnp1nvstrisoit835mu2g365rmlk9add4891l2il7jlqbucg612ebm74v4n4nscs9tgdt6t0qvcvjfvqf627rv11', 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7aW1hcF9uYW1lc3BhY2V8YTo0OntzOjg6InBlcnNvbmFsIjthOjE6e2k6MDthOjI6e2k6MDtzOjA6IiI7aToxO3M6MToiLiI7fX1zOjU6Im90aGVyIjtOO3M6Njoic2hhcmVkIjtOO3M6NjoicHJlZml4IjtzOjA6IiI7fWltYXBfZGVsaW1pdGVyfHM6MToiLiI7dXNlcl9pZHxzOjE6IjMiO3VzZXJuYW1lfHM6MzoiY2ZtIjtpbWFwX2hvc3R8czo5OiJsb2NhbGhvc3QiO2ltYXBfcG9ydHxpOjE0MztpbWFwX3NzbHxOO3Bhc3N3b3JkfHM6MjQ6ImFmdll2VlgxdVUrQlhhRllhK3JRRHc9PSI7bG9naW5fdGltZXxpOjEzNDQwOTc2MzI7dGltZXpvbmV8ZDotNTtkc3RfYWN0aXZlfGk6MTs=', '<IP-ADDR>')
roundcube/logs/error output:
[04-Aug-2012 12:27:07 -0400]: DB Error: MDB2 Error: invalid Query: _doQuery: [Error message: Could not execute statement] [
Last executed query: EXECUTE mdb2_statement_pgsql_28fdd64f92f5d960ac40d856e2dd3440b888c17d2 ('jie0cbbv36q0ofuauvub7i9gvlllv
e9p05ekkcmb68l2d7cmpcvdgafvaee5cft3s9lg3e2cldvmgc50dndt7sv3igvqad1h628d3l0', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza
3xzOjU6ImxvZ2luIjs=', '74.107.127.173')] [Native message: ERROR: value too long for type character varying(40)] in /Libra
ry/Server/Web/Data/Sites/Default/webmail/program/include/rcube_mdb2.php on line 719 (GET /Webmail/)
[04-Aug-2012 16:27:12 UTC] MDB2 Error: invalid (-8): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_pgsql_59c343b5e2fa929ca79b353ffb0f8bcd75024c6cc ('dpekoo41vntesbehnp1nvstrisoi
t835mu2g365rmlk9add4891l2il7jlqbucg612ebm74v4n4nscs9tgdt6t0qvcvjfvqf627rv11', 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7aW1hcF9uYW1lc3Bh
Y2V8YTo0OntzOjg6InBlcnNvbmFsIjthOjE6e2k6MDthOjI6e2k6MDtzOjA6IiI7aToxO3M6MToiLiI7fX1zOjU6Im90aGVyIjtOO3M6Njoic2hhcmVkIjtOO3M
6NjoicHJlZml4IjtzOjA6IiI7fWltYXBfZGVsaW1pdGVyfHM6MToiLiI7dXNlcl9pZHxzOjE6IjMiO3VzZXJuYW1lfHM6MzoiY2ZtIjtpbWFwX2hvc3R8czo5Oi
Jsb2NhbGhvc3QiO2ltYXBfcG9ydHxpOjE0MztpbWFwX3NzbHxOO3Bhc3N3b3JkfHM6MjQ6ImFmdll2VlgxdVUrQlhhRllhK3JRRHc9PSI7bG9naW5fdGltZXxpOjEzNDQwOTc2MzI7dGltZXpvbmV8ZDotNTtkc3RfYWN0aXZlfGk6MTs=', '<IP-ADDR>')]
[Native message: ERROR: value too long for type character varying(40)]
[04-Aug-2012 12:27:12 -0400]: DB Error: MDB2 Error: invalid Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_pgsql_59c343b5e2fa929ca79b353ffb0f8bcd75024c6cc ('dpekoo41vntesbehnp1nvstrisoit835mu2g365rmlk9add4891l2il7jlqbucg612ebm74v4n4nscs9tgdt6t0qvcvjfvqf627rv11', 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7aW1hcF9uYW1lc3BhY2V8YTo0OntzOjg6InBlcnNvbmFsIjthOjE6e2k6MDthOjI6e2k6MDtzOjA6IiI7aToxO3M6MToiLiI7fX1zOjU6Im90aGVyIjtOO3M6Njoic2hhcmVkIjtOO3M6NjoicHJlZml4IjtzOjA6IiI7fWltYXBfZGVsaW1pdGVyfHM6MToiLiI7dXNlcl9pZHxzOjE6IjMiO3VzZXJuYW1 in /Library/Server/Web/Data/Sites/Default/webmail/program/include/rcube_mdb2.php on line 719 (POST /Webmail/?_task=login&_action=login)
[04-Aug-2012 16:27:12 UTC] MDB2 Error: invalid (-8): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_pgsql_29bf8b1a6d3f6f9c911a41bf0d0649fecabf521c1 ('dpekoo41vntesbehnp1nvstrisoit835mu2g365rmlk9add4891l2il7jlqbucg612ebm74v4n4nscs9tgdt6t0qvcvjfvqf627rv11', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '<IP-ADDR>')]
[Native message: ERROR: value too long for type character varying(40)]
Result is failed login with "Your session is invalid or expired." message.
I can't find any varchar(40) values in the SQL, so I'm not sure who's throwing the error.
I installed MySQL and roundcube works fine with that, but I'd prefer to use Postgres since its running to support the Mountain Lion server anyways.
Please, check Roundcube database structure. In 0.7 the length of sess_id column has been changed to 128 and now there's no column with 40 character length. So, something's wrong with the structure.
Ahh, running the update script fixed it, as a new install I expected the latest version of the schema.
carl.