Hi all
I have followed the installation how to of RoundCube as posted at http://www.hmailserver.com/forum/viewtopic.php?t=5591 however I seem to have a continuing problem with MySQL connectivity.
When browsing to the RoundCube webmail homepage I get the familiar:-
SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4)
which I am aware means that the RoundCube installation is not talking to the MySQL database. I have checked and rechecked the entry within the db.inc.php file and the string of 'mysql://
:@localhost:3307/' is all correct.
I am using SQLyog to manage the MySQL installation and I can see the Roundcube database is setup and when going into 'Manage Permissions for Users' I can see that the roundcube user has 'SELECT,INSERT,UPDATE,DELETE' permissions on that database but the user as specified in the db.inc.php file refuses to collect.
The strange thing is that we have had this working yesterday and then we migrated the server from private IP (R&D) to public IP (testing) and the whole thing fell over. I have rebuilt the server (Windows 2003) and applied the mailserver app (hMailServer) and the installation of RoundCube fully as per the how to instructions above but seem to run into this problem.
Any help is appreciated
Have you tried specifying the IP Address in 'mysql://
:@localhost:3307/' rather than just using localhost all the time. Is your server still using a public or private address, did you build the server with a public IP address or private, is it possible something else is using the address you are trying to use? Any errors in any logfiles for mysql or hmail?
I have mine setup on OS X server and I use the fqdn rather than localhost I found that worked a lot better. Not had any trouble with it either.
Hi there,
I have tried specifying IP address and FQDN but no joy. I have created a new user with both the IP and FQDN and used those particular account details but again no joy.
When we initially built the first server it was on a private IP address as assigned by our lab DHCP server and the build worked fine but we then took that server from the lab and put it onto the R&D network with a static public IP and it failed. We were confident that we could rebuild the server on the R&D platform and on the public IP but we are now getting stonewalled when we try and access the webmail homepage with the application not being able to access the MySQL server
Regards
Ian
Where does the mysql database live.
ie.. on the webserver, on a server in your private network, on another server in your dmz
From where are you trying to access RC.
ie from the internet, from the webserver itself, from your private network
I wonder if the problem is related more to using a public ip address than anything else. It could be a problem with how your traffic is routed. Are you trying to run the webclient on the web server itself. or are you accessing it from a pc on your private network. have you tried using a private ip address? if that works sounds more like your problem is with where your traffic is going than the install.. why not connect it to the web and try accessing it that way?