Topic: MySql - Remote access

[Anonymous]

Okay. I've upgraded from version e-smith 5.6 to version 6. MySQL was visable to local network so web software like ezpublisher (which uses MySQL) was able to connect using users I created under e-smith v5.6.
Since the upgrade, none of my web software which requires MySQL works, I get various errors from each installed product from "your database cannot be connected" to the "FATAL DATABASE ERROR: database cannot be reached". mysqlcc times out.

I'll seek out the error logs and upload them later.

From what I understand here in this forum the skip-network param in the my.cnf needs to be commented out or set to no. Isn't that what the lines below try to do?
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/rc7.d/S90mysqld restart

I did the above and when I checked the my.cnf file there was no change ie it still had the skip-network param, and yes I've rebooted.
Should i also do /sbin/e-smith/signal-event upgrade?

[Anonymous]

Hello

I posted the required commands on how to open access to mysql it is the second post with the 3 command lines

then I add a user at the console using the user add info I found at mysql docs site giving myself access from my computer ip address and mysqlcc works fine you can also install the phpmyadmin contrib and it also works fine by going to

https://yourserver.com/phpmyadmin or
https://###.###.###.###/phpmyadmin your ip number you have given the sme server

mysql adding users

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Adding_users

[BrunoGarin]

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!

Have you try this:
Add in your etc/my.cnf under [mysqld]
set-variable   = thread_stack=256K

before to put your hair out

[Boris]

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!

Did you do:
service mysqld stop
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
service mysqld start
?

[TrevorB]

Also note that connections to MySQL behave differently if you are running sme in server-gateway or server-only mode.

In server-gateway any normal user should be able to connect to your databases, in server-only mode you need to create a mysql user with rights on the database.

More info on your setup will help.....

Trevor B

[greavesg]

Here comes the info

Like v5.6 this mode is server-gateway. I have phpmyadmin installed as well as web mail and it all works fine. I have two network cards, the machine is an old PII running @ 300Mhz with 512Mb ram.
I'm registered with dyndns.org... any other info? feel free to ask...
Is there suppose to be a change in the my.cmf after issuing those commands mentioned by guest? When I look at the file nothing changes.

[greavesg]

Okay, seem like I've found the problem. I created a user called mysql with which I was trying to login to the db. When I altered the name to something else bada-bing I'm in. Thanx for your support.
Now all I need is is some superglue..... and  

[Guest]

Is there a way of restricting user access to certain websites within SME Server 5.6?

[Pajmon]

I have tried to do PHPFileExchange on SME 6.0 from
http://www.seattleserver.com/projects.htm site.

I think I configure this exchange corectly but i have an error when I try to connect with SQLSERVER remotly from other machine:
"Unable to connect to xxx.xxx.xxx.xxx Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)"
When I try to conect to this server from MySQLFront i can't either.
Can enyone tried this before. SME is SERVER-ONLY-MODE. I don't change anything in configuration.
I add sql user and configure him to be able to remote access->'user'@'%'. If I do wrong???
Any ideas???I am newbie with mysql so be patient:)
Thx for any reply and sorry for not my best language.

[mike_mattos]

I just wated a day trying to get MySQL to work on the network, gave up, UPGRADED to 4.0 and seem to have fixed the problems!  

Follow the instructions , there is one bug,

rpm -e --nodeps mysql

seems to be needed!

APart from that, great