phpDivinglog2.2 with remote mysql server

3rd party extensions (phpDivingLog, dive computer downloader,...)
Post Reply
zeroGsa
Posts: 12
Joined: Fri Apr 23, 2010 13:25
Location: FL, USA
Contact:

phpDivinglog2.2 with remote mysql server

Post by zeroGsa »

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!

Inferno
Posts: 252
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog2.2 with remote mysql server

Post by Inferno »

Wil test this myself, so never used it!

Inferno
Posts: 252
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: phpDivinglog2.2 with remote mysql server

Post by Inferno »

tested this today and works perfect:

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";
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

Post Reply