Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: edlentz on November 19, 2005, 03:06:40 PM

Title: MySql outside the "Box"
Post by: edlentz on November 19, 2005, 03:06:40 PM

I can use PHPMyAdmin from within an Ibay on the SME box, but I can't get to Mysql with ODBC connector, or MySql Administrator from the network.  Is there a permission I need to change in SME?  I have created users in Mysql to allow this.
Thanks

Title: MySql outside the "Box"
Post by: Henk on November 19, 2005, 05:53:35 PM

I found this in the release notes of SME 6.0:


The mysql database daemon is configured by default to accept only
local connections (i.e. it is not accessible via the network).
This is a security precaution. We only use mysql for webmail
preferences, and only require access from localhost.

If you wish to enable local network access, you can do so via:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

Title: MySql outside the "Box"
Post by: edlentz on November 20, 2005, 01:34:45 AM

Thanks for the reply Henk.  I looked in the areas you suggested but didn't find what you referred to.  I did install version 7.0beta  Would that make a difference?

Title: MySql outside the "Box"
Post by: juncool on November 21, 2005, 01:38:14 AM

Quote

I can use PHPMyAdmin from within an Ibay on the SME box, but I can't get to Mysql with ODBC connector, or MySql Administrator from the network. Is there a permission I need to change in SME? I have created users in Mysql to allow this.

Quote

If you wish to enable local network access, you can do so via:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

after i have executed the above commands and granted privileges on a mysql user (e.g. grant all on somedb.* to someuser@192.168.1.2 identified by 'somepasswd' with grant option), i have successfully connected to mysql through odbc connector, assuming that your sme box has the ip address 192.168.1.1 and the pc you're using is 192.168.1.2, you can also connect using mysql administrator however mysql server 4.0 or higher is preferred to use. hope this would help.

- juncool

 8-)

Title: MySql outside the "Box"
Post by: edlentz on November 21, 2005, 05:24:23 AM

DOH!!  Such a newbie I just didn't see what you were showing me!  Thanks for your help.