Koozali.org: home of the SME Server

SME 7.0pre4 MySQL No Connect

bssued

SME 7.0pre4 MySQL No Connect
« 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

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: SME 7.0pre4 MySQL No Connect
« Reply #1 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.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

bssued

Re: SME 7.0pre4 MySQL No Connect
« Reply #2 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.

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: SME 7.0pre4 MySQL No Connect
« Reply #3 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

dswillia

SME 7.0pre4 MySQL No Connect
« Reply #4 on: March 26, 2006, 05:26:54 AM »
Ok, so how would I open the port for local traffic (internal)

Regards

Offline raem

  • *
  • 3,972
  • +4/-0
SME 7.0pre4 MySQL No Connect
« Reply #5 on: March 26, 2006, 11:44:25 AM »
dswillia

See the link Charlie provided
...