Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: grosbedos on August 05, 2005, 09:13:25 PM

Title: remote mysqld
Post by: grosbedos on August 05, 2005, 09:13:25 PM

hi,

i'have a sme server. Another pc on my network has a web server and that pc must 'talk' with the mysql server of my sme.

(:p i'm french...lol)

i've read on the forum :

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


Ok, i have do that..but it didn't work for me.

in my /etc/my.cnf .. i haven't "skip-networking"..but it didn't work..

i must tell you that i use mysql 4.0 (install by the update script of contribs..)

it's the only log usefull (/var/log/mysqld.log) :
"""Warning: Asked for 196608 thread stack, but got 126976"""

when i want to connect to the mysql server the error return is :
Host 'post.domain.com' is not allowed to connect to this MySQL Server

if you have an idea...i'm open ^^

thanks

Title: remote mysqld
Post by: letouriste on August 06, 2005, 09:44:58 AM

Hello;


Try with PHPMyAdmin to check he config ;)

Title: remote mysqld
Post by: grosbedos on August 08, 2005, 02:06:56 PM

thanks for the tips,
with the good privileges it's work great  :-D