Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: davidebellei on August 19, 2004, 12:05:41 AM

Title: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)
Post by: davidebellei on August 19, 2004, 12:05:41 AM

Hi
I have this problem installing oscommerce.
During installation it give this error
"can't connect to mysql (111)"
Reading previous posts, I found that I need to grant access to mysql from local netword, doing the following:

/sbin/e-smith/db configuration setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/sbin/service mysqld restart
Even after a complete restart of the server, I can't access mysql and always have errore "can't connect to mysql on '192.168.1.12' (111).

I'm running sme server 6 at 192.168.1.12
I'm trying to access the server from win2000 at 192.168.1.83 on local network

Can anyone help me?

Thank you!

Title: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)
Post by: Boris on August 19, 2004, 12:41:07 AM

In addition to allowing network access to mysql you need to create mysql-user@192.168.1.83 with appropriate permissions to database

Title: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)
Post by: davidebellei on August 19, 2004, 10:22:37 PM

Still not working...
Thank you for your advice.
I'm not sure I'm on the right way...

I manually created (phisically on mitel) database ecommerce and created sqluser@192.168.1.83 as following:

grant alter, select, insert, update, delete, index, create, drop on on ecommerce.* to sqluser@192.168.1.83 identified by 'password';

The error is the same "Can't connect to MySQL server on '192.168.1.12' (111)"

I also tried from dos prompt:

telnet 192.168.1.12 3306

but...able to connect to host.
Maybe something wrong on  enabling access to mysql on network? I did exactly the commands as in my previous post...

Can you help me? Thank you so much !
Davide

Title: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)
Post by: davidebellei on August 19, 2004, 10:37:49 PM

Wait wait!
I retyped commands to enable mysql over network. Now it works....
Ops, maybe I mistyperd it....

Now i'm having trouble with chmod.
How can i chmod a file via ftp to 706 or 777 as admin, if it says I have not the rights to do it?
550 permission denied?

Title: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)
Post by: Boris on August 20, 2004, 09:45:44 AM

you can not chmod via ftp as this feature disabled. Use ssh instead.

Title: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)
Post by: davidebellei on August 24, 2004, 01:48:53 PM

Thank you Boris, unfortunately I don't know how to do this......  :-?

Title: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)
Post by: Boris on August 24, 2004, 07:25:17 PM

Welcome, unfortunately I don't have time or will to teach you the basics. You have to do some reading on your own.
Try WinSCP3 instead of FTP. It will let you change permissions and transfer files if you have rights on the server.

Title: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)
Post by: davidebellei on August 25, 2004, 02:04:59 AM

Thank you very much.
You gave me the... idea.
Now I will work and study on it.
Thanks again!
Davide