socket to connect to mysql instead of connecting over tcp/ip

[xlevel]

I'm upgrading from milestone 2.1 to 2.2. After loading the files the software stopped working. Oscommerce trying to use a socket to connect to mysql instead of connecting over tcp/ip. Has anyone else had this problem. I can't upgrade until this is resolved.

[Guest]

I am actually having the same problem... I hope to solve it soon, but it seems that once you choose 'localhost' as the DB_SERVER in the config file it changes the way it connects.

 

Are there any mySQL expertst that can help in pointing out a mysql configuration change?

 

Thanks!

[Guest]

If you are using localhost, then it shouldn't be connecting over tcp/ip. You probably need to connect to something different. Note: this would be a host dependent setting. I.e. the correct value is dependent on the way your host set up the database. For example, is it on the same machine? Is it on a different machine? Is the domain of the user match what you are putting in the machine?

 

Btw, there is no MS 2.1 or 2.2. There is a version 2.1 and a couple milestones of 2.2 (MS 1 and MS2, with MS3 coming and MS4 planned).

 

Hth,

Matt

[Guest]

Thanks on the version correction, just to tired and typing too fast to make it right.

 

I solved my problem, but I feel like I am cheating a little. Need to brush up on mysql a bit more. But here is a way to cheat if your webserver and mysql are on the same machine and you can't connect using sockets.

 

Change the DB_SERVER setting from localhost to 127.0.0.1

 

Again, this is a quick and dirty fix, I am off to get to the bottom of this, but the above worked for me.

 

Also a good article for those of you who have some cotrol over your environment but have trouble connecting:

 

http://www.mysql.com/doc/en/Can_not_connec..._to_server.html

 

Andy