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. :)
--
Digimer
Papers and Projects: https://alteeve.ca/w/
What if the cure for cancer is trapped in the mind of a person without
access to education?
_______________________________________________
Roundcube Users mailing list
[email protected]
http://lists.roundcube.net/mailman/listinfo/users
