Mountain Lion, Postgres, "value to long" on login

[carlmuck]

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.

[alec]

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.

[carlmuck]

Ahh, running the update script fixed it, as a new install I expected the latest version of the schema.

carl.