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. :)
>
--
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
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users
