Topic: MySql - Remote access

[pete]

We are not using SME as a security device and currently have no need to restrict access to mysql, we are simply trying to pilot a replica of our win2k environment.

We need to be able to provide access to mysql so we can use things like SQLyog.

I have tried running the following 3 commands as found in the forum archives,

service mysqld stop
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
service mysqld start

 but the problem appears to be that the server is not listening on the 3306 tcp port (we have tpools to test this, and no response on this port. We are using SME 6.0 final

Could some one please explain what i need to do to allow access to thios port, even if i allow only the 2 local subnets?

EDIT: PS i have allowed all the subnets in the remote access server panel.

[Anonymous]

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

This is the fix but I have had to run the commands twice for some reason for it to work

In your post you didn't expand the template

[pete]

Thanks i tried exactly that and still no dice - i tried to connect remotely using root/pass contained in /root/.myconf

[Boris]

install phpmyadmin and check your accounts setup.
by default root is allowed to connect from localhost and IP of the server only. Don't mess with this, but create separate account for yourself@192.168% or whatever your local network is for daily use.

[pete]

I have added a user that has access from any host, but still dont work.

Should the username format in mymmyadmin be "username" in the user field and the "10.0%" in the hosts field? or all in the username field like "username@10.0%" ?

do i need to write the username as "username@10.0%" when trying to connect from my remote machine on 10.0.0.3 ? or just "username"?

Below is the monty account i created and the existing horde one, using "horde" with no pass gets me connected, using "monty" doesnt?

Edit  Delete  Grants  %  horde  No  No Privileges  
Edit  Delete  Grants  10.0.%  monty  No  Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter

[pete]

Chnage the user monty to have any host access and it works, will practise the restrictions later

thanks for the tips.

[pabs]

Hi all,

I’m also trying to connect to mySQL using SQLyog, will these techniques work on my SME 5.6?

Thanks

[Anonymous]

Seems to - the 2 things i hadnt done right are both listed above
1. Set mysql to listen to other hosts - i have nping whihc can ping tcp ports and tell ya if they are open, once opened...
2....all i had to was set the user account up correctly in phpmyadmin, its not secure at all my way, but it gives me access, which is all i wanted to migrate some DBs using SQLyog from a mysql win2k machine.

[pabs]

I’ve confirmed that 3306 is now open using LANguard port scanner, and I have a user set up with all privileges, host %.  But when I try to connect with SQLyog it gives an error “Error No. 2013 Lost connection to MySQL server during query”

Any ideas?

[Anonymous]

I think that means you didnt save the details on the connection dialog?

[pabs]

That doesn’t seem to be the problem (I wish that fixed it ).

I’ve set up the remote network via the server-manager like this:
Network = 192.168.1.1 Subnet mask= 255.255.255.0

192.168.1.1 is the local address of the SME

Could this be the problem?(I really don’t know how I  should set remote network)

[Boris]

I’ve confirmed that 3306 is now open using LANguard port scanner, and I have a user set up with all privileges, host %.  But when I try to connect with SQLyog it gives an error “Error No. 2013 Lost connection to MySQL server during query”

Any ideas?

for version 5.6 you need to update glibc and glibc-common from the latest version for RH 7.3
This fix was discussed before.

[pabs]

I upgraded my glibc and glibc-common and SQLyog connects with no problems.  Also, I tried using a SSH tunnel setup in PuTTY to access the DB with SQLyog from a remote site and it worked great (no need to setup a remote network anymore).  

Thanks everyone for the help.

[greavesg]

I've just upgraded to e-smith 6 final UD and tried all of the tips in listed, to get mysql to work on the network work. I've even edit the my.cnf file "live" to comment out the skip-network, and restarted mysqld!
I'm pulling my hair out now. help!

[Anonymous]

Your desperate? yet you provide no details on exactly what problem your having?

Post your details, include any log messages you can find....