Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: bssued on March 25, 2006, 11:57:25 AM

Title: SME 7.0pre4 MySQL No Connect
Post by: bssued on March 25, 2006, 11:57:25 AM

Hallo, sorry, my English is not so perfect an Im new in this server.
I have installed SME 7.0pre4, all work perfect, but not mysql.
I have a MySQL-Database with users and rights created. I would like to connect to mysql Server with Port 3006 to this Database, but it dont work.
Error: mysql Server is not reachable.
phpmyadmin works fine, but no connect to the mysql server.

The SME Server works in only "Server Mode ", mysql Portforwarding in my Router from Port 3306 to the IP of the SME Server.

Please, I need help.

Thanks

Bodo Franz

Title: Re: SME 7.0pre4 MySQL No Connect
Post by: cactus on March 25, 2006, 02:28:12 PM

Quote from: "bssued"

Hallo, sorry, my English is not so perfect an Im new in this server.
I have installed SME 7.0pre4, all work perfect, but not mysql.
I have a MySQL-Database with users and rights created. I would like to connect to mysql Server with Port 3006 to this Database, but it dont work.
Error: mysql Server is not reachable.
phpmyadmin works fine, but no connect to the mysql server.

The SME Server works in only "Server Mode ", mysql Portforwarding in my Router from Port 3306 to the IP of the SME Server.

Please, I need help.

Thanks

Bodo Franz

You are using two port numbers 3006 and 3306. The latter is the default on, is the first one perhaps a typo?

Is the mysql server running on your system configured to use a different port number than the default port or didn't you change the port setting?

If you did not change the port mysql is listening to it should be port 3306.

Title: Re: SME 7.0pre4 MySQL No Connect
Post by: bssued on March 25, 2006, 04:45:54 PM

Quote from: "cactus"

Quote from: "bssued"

Hallo, sorry, my English is not so perfect an Im new in this server.
I have installed SME 7.0pre4, all work perfect, but not mysql.
I have a MySQL-Database with users and rights created. I would like to connect to mysql Server with Port 3006 to this Database, but it dont work.
Error: mysql Server is not reachable.
phpmyadmin works fine, but no connect to the mysql server.

The SME Server works in only "Server Mode ", mysql Portforwarding in my Router from Port 3306 to the IP of the SME Server.

Sorry, this was an mistake. Nothing is changed, default port is 3306 !!

Please, I need help.

Thanks

Bodo Franz

You are using two port numbers 3006 and 3306. The latter is the default on, is the first one perhaps a typo?

Is the mysql server running on your system configured to use a different port number than the default port or didn't you change the port setting?

If you did not change the port mysql is listening to it should be port 3306.

Title: Re: SME 7.0pre4 MySQL No Connect
Post by: CharlieBrady on March 25, 2006, 05:01:08 PM

Quote from: "cactus"

Is the mysql server running on your system configured to use a different port number than the default port or didn't you change the port setting?

The mysql server is not listening to any port. It is configured for local host access only, and therefore listens only to a unix domain socket, not a TCP socket.

http://forums.contribs.org/index.php?topic=30945.0

Title: SME 7.0pre4 MySQL No Connect
Post by: dswillia on March 26, 2006, 05:26:54 AM

Ok, so how would I open the port for local traffic (internal)

Regards

Title: SME 7.0pre4 MySQL No Connect
Post by: raem on March 26, 2006, 11:44:25 AM

dswillia

See the link Charlie provided