Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: steidley on July 21, 2005, 07:12:16 PM

Title: MySQL Server Access
Post by: steidley on July 21, 2005, 07:12:16 PM

I've been trying to acces my MySQL server by ODBC, Rekall and other apps but I keep getting a refused connection. I tried to find out which port, I was assuming the default of 3306. But telneting to 3306 on all of my servers gets me a refused connection. What am I missing? Is it on a different port?

Title: MySQL Server Access
Post by: psykoben on July 21, 2005, 10:01:54 PM

You need to modify your configuration to connect from a lan client because mysql is set to serve on localhost only by default on sme server.
To do this you must connect in a rootshell on the sme server and enter this 3 command lines

Code: [Select]

[root@sme root]# /sbin/e-smith/db configuration setprop mysqld LocalNetworkingOnly no

[root@sme root]# /sbin/e-smith/expand-template /etc/my.cnf

[root@sme root]# /sbin/service mysqld restart

and all may work fine :-D

Title: MySQL Server Access
Post by: steidley on July 22, 2005, 02:29:18 AM

That fixed it! Thank you!