Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: lagraula on February 24, 2004, 10:10:32 PM

Title: sme 6.0u / php .... + mysql
Post by: lagraula on February 24, 2004, 10:10:32 PM

hello !
I installed a sme server+gateway with a dyndns connection.
I try to develop a dynamic web site with php and ... myusql.
With php : no problem ; but with mysql : I've got the message : "Access denied for user"

I made some corrections with sme :
-> error messages in apache are available
-> php is allowed "outside localnetworkingonly !"
-> a specific user in mysql have been created !

And it doesn't work !!!!

:-((((

Title: sme 6.0u / php .... + mysql
Post by: mrjhb3 on February 25, 2004, 07:27:18 AM

Is this what you are looking to do:  

MySQL accepts only local connections

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/esmith/config setprop mysqld LocalNetworkingOnly no
/sbin/esmith/expandtemplate /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

I think the above is a typo, it should read something like if you wish to enable public access..  Here is the link I got this from.
http://no.longer.valid/phpwiki/index.php/SME%20Server%20Announce%20v6.0

JB

Title: I tried that still cannot connect from another machine
Post by: hemps on February 27, 2004, 02:57:44 AM

I did all that you said, there were some typo's in you instructions. I restarted mysql tried to connect from another machine ---> no go.

Title: Access denied for root@computer.domain.com
Post by: hemps on February 27, 2004, 03:03:10 AM

This is the error