[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] Set-up MySQL on RaQ 550

Is osCommerce looking for MySQL on the TCP port or on the local MySQL socket?
As far as I can see in the osCommerce support forums, its looking for "/tmp/mysql.sock" rather than the tcp port.
There should be a config option in osCommerce to set the location of the socket file. To find the socket file, do as root: 

find / -name mysql.sock


the forum mentions a user who gets the following error:

"Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
so, you could telnet to the tcp port and get a response ok, but if the osCommerce app is using the socket file, it wouldnt be able to connect. 


just a possibility...

:)
jalon



At 11:53 PM 1/11/2003, you wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> I am in search of some info in regards to MySQL on a RaQ 550. I
> know it comes installed as a default.
>
> I have started the MySQL services. I can connect to MySQL by mysql
> in telnet I can see DB's and stats. It seems like everything is
> working ok. When I go to try and connect to it from a virtual site
> I simply can't. Is there something I need to do to MySQL to make it
> work with virtual sites and os Commerce or other programs?

1. Have you already created at least one MySQL username and password
   for 'os commerce' in the 'user' table of the 'mysql' database?
2. Have you created a separate database for 'os commerce'?
3. Have you granted access privileges for the 'os commerce' user
   to the 'os commerce' database in the 'db' table of the 'mysql'
   database?
4. Have you reloaded MySQL so changes to the grants table take effect?
5. If 1-4 are 'yes' can you manually connect to MySQL as the 'os
   commerce' user to the 'os commerce' database and manipulate it
   properly?
6. If 5 is 'yes' then the problem is with the script/etc for 'os
   commerce' (it's not configured to use the right database name,
   username, password, etc)
7. If 5 is 'no' go back to 1-4 and make sure they are done properly
   (especially check #4 - I _always_ forget to do that myself!)