Hi all,
Recently I upgraded roundcube on CentOS 6 via epel to ver. 0.9.5-1.el6. When I did, I started getting database connection errors. I guessed that my password (containing spaces and special characters). I changed the owner of the (postgresql) database and set the new user's password to be much simpler (pure string of letters), but that didn't fix the problem either.
When I try to connect from the server with roundcube to the database server, I connect just fine.
==== psql -h db.alteeve.ca -U alteeve_rc roundcubemail Password for user foo: psql (8.4.18) Type "help" for help.
When I try to connect from roundcube, I get the error:
==== DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database! Please contact your server-administrator. ====
I have debug set to 1 and this is what I see in /var/log/roundcubemail/errors:
==== [17-Dec-2013 17:10:51 -0500]: DB Error: [7] ERROR: permission denied for relation session (SQL Query: SELECT vars, ip, changed FROM session WHERE sess_id = 'q9fnmb7o8j8c5cuu5v2o94ji72') in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 416 (GET /m/) [17-Dec-2013 17:10:51 -0500]: DB Error: [7] ERROR: permission denied for relation session (GET /m/) [17-Dec-2013 17:10:51 -0500]: DB Error: [7] ERROR: permission denied for relation session (SQL Query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('q9fnmb7o8j8c5cuu5v2o94ji72', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '111.222.33.44', '2013-12-17 17:10:51', '2013-12-17 17:10:51')) in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 416 (GET /m/) ====
I'm stumped and would love some help/advice. :)
Answering my own email...
I found that; "grant select on session to public;" got the login prompt to work, but nothing else. So I dumped the DB to flat file, replaced the old user db username with the new db username and reloaded the DB. This got it working.
digimer
On 17/12/13 17:24, Digimer wrote:
Hi all,
Recently I upgraded roundcube on CentOS 6 via epel to ver. 0.9.5-1.el6. When I did, I started getting database connection errors. I guessed that my password (containing spaces and special characters). I changed the owner of the (postgresql) database and set the new user's password to be much simpler (pure string of letters), but that didn't fix the problem either.
When I try to connect from the server with roundcube to the database server, I connect just fine.
==== psql -h db.alteeve.ca -U alteeve_rc roundcubemail Password for user foo: psql (8.4.18) Type "help" for help.
roundcubemail=>
When I try to connect from roundcube, I get the error:
==== DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database! Please contact your server-administrator. ====
I have debug set to 1 and this is what I see in /var/log/roundcubemail/errors:
==== [17-Dec-2013 17:10:51 -0500]: DB Error: [7] ERROR: permission denied for relation session (SQL Query: SELECT vars, ip, changed FROM session WHERE sess_id = 'q9fnmb7o8j8c5cuu5v2o94ji72') in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 416 (GET /m/) [17-Dec-2013 17:10:51 -0500]: DB Error: [7] ERROR: permission denied for relation session (GET /m/) [17-Dec-2013 17:10:51 -0500]: DB Error: [7] ERROR: permission denied for relation session (SQL Query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('q9fnmb7o8j8c5cuu5v2o94ji72', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '111.222.33.44', '2013-12-17 17:10:51', '2013-12-17 17:10:51')) in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 416 (GET /m/) ====
I'm stumped and would love some help/advice. :)