Results 1 to 10 of 31

Hybrid View

  1. 2 Aug 2015, 03:06 PM #1
    RixStix
    RixStix is offline Totally Zenned
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket

    myDEBUG logs began last night @ 11:03pm. Below is the contents of the first myDEBUG file. Many, many others. slightly different filesizes.
    This is way over my head, so any suggestings greatly appreciated.

    I am guessing something changed by host since I was in bed at that time.

    First indication from host is "Mysql is up and running fine in your server"

    ZC1.5.4
    upgraded from zc1.5.3 several weeks ago

    Code:
    [01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
[01-Aug-2015 23:03:46 America/Los_Angeles] #1  mysqli_connect(localhost, DBnameREMOVED, DBpasswordREMOVED) called at [/home/chainwea/public_html/includes/classes/db/mysql/query_factory.php:62]
#2  queryFactory->connect(localhost, DBnameREMOVED, DBpasswordREMOVED, DBnameREMOVED, false, ) called at [/home/chainwea/public_html/includes/init_includes/init_database.php:23]
#3  require(/home/chainwea/public_html/includes/init_includes/init_database.php) called at [/home/chainwea/public_html/includes/autoload_func.php:48]
#4  require(/home/chainwea/public_html/includes/autoload_func.php) called at [/home/chainwea/public_html/includes/application_top.php:158]
#5  require(/home/chainwea/public_html/includes/application_top.php) called at [/home/chainwea/public_html/index.php:26]

[01-Aug-2015 23:03:46 America/Los_Angeles] PHP Warning:  mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/chainwea/public_html/includes/classes/db/mysql/query_factory.php on line 62
    Last edited by RixStix; 2 Aug 2015 at 03:10 PM.
    Reply With Quote Reply With Quote
  2. 2 Aug 2015, 05:42 PM #2
    RixStix
    RixStix is offline Totally Zenned
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default Re: myDEBUG files Public down: Admin OK

    Not sure what caused the problem but it magically fixed itself instantly when host 'repaired' the database.
    The issue began surprisingly at the exact time the host restarted the mySQL server last nite for an undisclosed reason.

    Only 1000+ myDEBUG files later..... and a plethora of grumpy customer emails this morning.
    Reply With Quote Reply With Quote
  3. 2 Aug 2015, 09:08 PM #3
    lat9's Avatar
    lat9
    lat9 is offline Administrator
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,949
    Plugin Contributions
    96

    Default Re: myDEBUG files Public down: Admin OK

    Darn, it sure would have been "interesting" to see the before and after databases! Do you have any idea what "repair" was performed?
    My website
    Reply With Quote Reply With Quote
  4. 2 Aug 2015, 10:41 PM #4
    RixStix
    RixStix is offline Totally Zenned
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default Re: myDEBUG files Public down: Admin OK

    The repair was a one-click "Repair" action from within cpanel.


    • I am waiting to see if the host has a DB backup from between 11:03pm PDT last night and the one-click repair.
    • I have a backup made shortly after the repair.
    • I also have a backup made yesterday morning.


    Coincidently, the mySQL server was restarted last night at 11:03pm, the exact time that the myDEBUG logs began. The log above was the first one. The files afterwards are slightly different, smaller in size but I didn't bother looking at the details other than I saw references to whosonline.php in them. I don't mind looking if you're interested.

    The only thing presented to website visitors was a white screen containing ....
    WARNING: An Error occurred, please refresh the page and try again.
    Reply With Quote Reply With Quote
  5. 3 Aug 2015, 01:00 PM #5
    lat9's Avatar
    lat9
    lat9 is offline Administrator
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,949
    Plugin Contributions
    96

    Default Re: myDEBUG files Public down: Admin OK

    If your host can find such a backup and you're willing to share the before/after database contents, let me know via PM and I'll run a "diff" between the two versions and report back.
    My website
    Reply With Quote Reply With Quote
  6. 3 Aug 2015, 03:20 PM #6
    RixStix
    RixStix is offline Totally Zenned
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default Re: myDEBUG files Public down: Admin OK

    I think I have before and after.

    Darn Windows10 is not being cooperative. Seems to be hiding files that I know exist and that can be seen by my ftp program. I'll let you know when/if I find them.
    Reply With Quote Reply With Quote
  7. 4 Aug 2015, 05:04 PM #7
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: myDEBUG files Public down: Admin OK

    Quote Originally Posted by RixStix View Post
    Coincidently, the mySQL server was restarted last night at 11:03pm, the exact time that the myDEBUG logs began. The log above was the first one.
    The timing is revealing. It could easily be that when the MySQL server was restarted it corrupted some data somehow. Perhaps a consequence of the hosting company doing software upgrades that went badly. If they're willing to admit it I suspect they probably had to "repair" everybody else's database on the same server too.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
    Reply With Quote Reply With Quote
  8. 4 Aug 2015, 06:03 PM #8
    RixStix
    RixStix is offline Totally Zenned
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default Re: myDEBUG files Public down: Admin OK

    That's what I suspected. They have been working to upgrade all their VPS for a while and inspite of testing, they are still working minor bugs.

    I didn't get to grab a DB backup from the interim timeslot. Not that it would make much difference.
    Reply With Quote Reply With Quote
 

 
« Previous Thread | Next Thread »

Similar Threads

  1. v154 mysqli_connect(): (HY000/2002): No such file or directory
    By adb34 in forum General Questions
    Replies: 24
    Last Post: 16 Aug 2020, 02:38 PM
  2. v154 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory
    By RixStix in forum General Questions
    Replies: 10
    Last Post: 11 Feb 2016, 10:30 PM
  3. mysqli_connect fails through socket '/var/lib/mysql/mysql.sock'
    By liderbug in forum General Questions
    Replies: 4
    Last Post: 13 Dec 2014, 04:48 AM
  4. 2002 - The server is not responding (or the local MySQL server's socket is not correc
    By fontaholic in forum Installing on a Mac Server
    Replies: 1
    Last Post: 10 May 2010, 05:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

disjunctive-egg
Content and Graphics Copyright (c) 2003 - 2026 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC