Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

mysql default socket error


5 replies to this topic

#1 dculley

  • Community Member
  • 72 posts
  • Real Name:Dean Culley
  • Gender:Male
  • Location:North Charleston, SC (USA)

Posted 17 January 2012, 02:08

I'm trying to setup/install osc. I'm at the step to connect the database. First line enter database server name: when i enter the server name or ip address I get

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Read all I could find, checked with my hosting coming and mysql is running no errors.

I changed and typed in " localhost" now I get:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I would love to get by this step and move on. Can anyone help?

#2 dculley

  • Community Member
  • 72 posts
  • Real Name:Dean Culley
  • Gender:Male
  • Location:North Charleston, SC (USA)

Posted 17 January 2012, 02:44

I've been more resurch. I might be missing something in the php.ini. Can this be the cause? if so any suggestions?

#3 dculley

  • Community Member
  • 72 posts
  • Real Name:Dean Culley
  • Gender:Male
  • Location:North Charleston, SC (USA)

Posted 18 January 2012, 03:36

I was hoping that someone knew of an answer. I really wanted to try and use Osc. I have been trying for days to get around and get the program installed and past the above problem. I don't see a "attach" button or I would attach my php.ini file for you to look at and see if that is the problem. or is there a setting to change in the mysql that needs to be changed? If there is no one to help me, I will have to give up on osc and go with another package. I would like to get this up and running if at all possible.

#4 DunWeb

  • Community Sponsor
  • 10,466 posts
  • Real Name:Chris Dunn
  • Gender:Male
  • Location:Tecumseh, Ontario, Canada N8N 1X8

Posted 18 January 2012, 03:38

@dculley,

I would check with your hosting provider to determine the correct database name for your database server. Your Php.ini file has nothing to do with your database as almost always the database is not stored on the same server as your files.


Chris
:|: Was this post helpful ? Click the LIKE THIS button :|:

:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:

:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:

#5 geoffreywalton

  • Community Sponsor
  • 7,731 posts
  • Real Name:Geoffrey Walton
  • Gender:Male
  • Location:Norfolk, UK (close to the centre of the universe)

Posted 18 January 2012, 10:29

Try putting this in google

site:forums.oscommerce.com Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Several good suggestion are returned.

Cheers

G
Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

Virus Threat Scanner
My Contributions
Basic install answers.
Click here for Contributions / Add Ons.
UK your site.
Site Move.
Basic design info.

For links mentioned in old answers that are no longer here follow this link Useful Threads.

If this post was useful, click the Like This button over there ======>>>>>.

#6 dculley

  • Community Member
  • 72 posts
  • Real Name:Dean Culley
  • Gender:Male
  • Location:North Charleston, SC (USA)

Posted 20 January 2012, 02:40

I found and figured it out - I'm in. Tricky but it works.