I am unable to get phpDivinglog2.2 to work with a remote mysql server.
I have mysql and phpDivinglog successfully running on my localhost (Fedora 11 server). I copied the phpDivinglog installation to another server on my internal network. I edited the config.inc.php file and replaced the database_server with my (remote) mysql server. When I attempt to access the web page, I get:
MDB2 Error: connect failed
I have opened port 3306 through my firewall. When I run mysqladmin from my remote host using the same credentials as the config.inc.php, everything seems to work. It sees my remote mysql server, tells me the version number, the remote host name, the fact that it is accessible via TCP/IP, the port number, etc. I can also telnet remotely to this host, port 3306 and mysql answers with its version number. I see nothing in the mysql.log file aside from daemon starts and stops.
So first, should this work? And if so, any suggestions on getting it working?
Any assistance is greatly appreciated!
phpDivinglog2.2 with remote mysql server
Re: phpDivinglog2.2 with remote mysql server
Wil test this myself, so never used it!
Re: phpDivinglog2.2 with remote mysql server
tested this today and works perfect:
So from my webserver to my home linux box
when I enter wrong password then it gives me MDB2 cannot connect.
The database divelog is not on my webserver. So I am sure it connects to my home machine
So from my webserver to my home linux box
Code: Select all
$_config['database_server'] = "robhome.lensen.nu";
$_config['database_db'] = "divelog";
$_config['database_username'] = "inferno";
$_config['database_password'] = "x";
The database divelog is not on my webserver. So I am sure it connects to my home machine