Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Roundcube connection failed after upgrading webmail and roundcube jails #221

Closed
needafix opened this issue May 5, 2017 · 7 comments
Closed

Comments

@needafix
Copy link

needafix commented May 5, 2017

After running provision webmail and provision roundcube, roundcube is unable to connect to db.

DB Error in /usr/local/www/roundcube/program/lib/Roundcube/rcube_db.php (173): SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'roundcube' (using password: YES)
DB Error: SQLSTATE[HY000] [1045] Access denied for user 'roundcube'@'roundcube' (using password: YES)
DATABASE ERROR: CONNECTION FAILED!

Tried using our config.inc.php in /jails/roundcube/usr/local/www/roundcube/config which did not work either.
Tried changing password for roundcube in mysql, that did not work either.

Using qmailadmin has no issues for any user.
Thanks for any help,

@Infern1
Copy link
Collaborator

Infern1 commented May 5, 2017

probably mysql is unable resolve roundcube host
Check ping roundcube on the mysql jail

@needafix
Copy link
Author

needafix commented May 5, 2017

I assume you meant to jailmanage mysql if so, cannot ping period.

root@mysql:~ # ping roundcube
ping: socket: Operation not permitted

Can ping roundcube on the mt6 server itself just not in any jail

root@mailserver:~ # ping roundcube
PING roundcube (172.16.15.33): 56 data bytes
64 bytes from 172.16.15.33: icmp_seq=0 ttl=64 time=0.041 ms

@msimerson
Copy link
Owner

ICMP is blocked in jails by default. A better and more thorough test is to use the mysql client in the roundcube jail to connect to mysql in it's jail.

@needafix
Copy link
Author

needafix commented May 5, 2017

root@mailserver # jailmanage mysql
root@mysql:~ # mysql -u roundcube roundcubemail -p
Enter password:
ERROR 1045 (28000): Access denied for user 'roundcube'@'localhost' (using password: YES)

Password used is from /jails/roundcube/usr/local/www/roundcube/config/config.inc.php

root@mailserver:~ # jailmanage roundcube
root@roundcube:~ # pkg info mysql
pkg: No package(s) matching mysql
If there is a mysql client in roundcube jail, cannot access it. Perhaps you can say how to access it?
Thanks

@needafix
Copy link
Author

needafix commented May 7, 2017

Tried to # provision roundcube
stops at:
*** preserving /jails/stage//usr/local/www/roundcube/config/config.inc.php ***

cp: 34826ZFS_JAIL_MNT/roundcube.last//usr/local/www/roundcube/config/config.inc.php: No such file or directory

@needafix
Copy link
Author

needafix commented May 9, 2017

Is there a any fix for provision roundcube?

@needafix
Copy link
Author

needafix commented May 11, 2017

Infern1 you were 100% correct.
Mysql db had roundcube as roundcube@172.16.15.10. But now roundcube jail has IP of 172.16.15.33

I don't know why msimerson could not simply write something to the effect of:
jexec mysql mysql
use mysql;
rename user roundcube@172.16.15.10 to roundcube@172.16.15.33;
exit
Thing is msimerson builds this pretty well all inclusive mail system which is designed for people without his skill set. 6 days pass by and no one could get to roundcube!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants