Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2015
    Location
    Cyprus
    Posts
    72
    Plugin Contributions
    0

    Default 2.01 Uncaught PDOException: PDO::__construct(): Error while reading greeting packet

    On totally clean installation of either 1.5.8 or ZC 2.01, mysql becomes unstable and goes away with the error log below. Is this a PHP error ...

    Zencart 1.5.8 and 2.01 clean installation, nothing added from the standard code, except the demo data. MySQL 5.7.31, PHP Version: 8.1.28 (Zend: 4.1.28),

    MySQL Mode: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION


    PHP Fatal error: Uncaught PDOException: PDO::__construct(): Error while reading greeting packet. PID=1886 in /laravel/vendor/illuminate/database/Connectors/Connector.php:70
    Click image for larger version. 

Name:	PDOL70.jpg 
Views:	360 
Size:	30.6 KB 
ID:	20620
    Stack trace:
    #0 /laravel/vendor/illuminate/database/Connectors/Connector.php(70): PDO->__construct()
    #1 /laravel/vendor/illuminate/database/Connectors/Connector.php(100): Illuminate\Database\Connectors\Connector->createPdoConnection()
    #2 /laravel/vendor/illuminate/database/Connectors/Connector.php(50): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()
    #3 /laravel/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
    #4 /laravel/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
    #5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
    #6 /laravel/vendor/illuminate/database/Connection.php(1181): call_user_func()
    #7 /laravel/vendor/illuminate/database/Connection.php(1217): Illuminate\Database\Connection->getPdo()
    #8 /laravel/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->getReadPdo()
    #9 /laravel/vendor/illuminate/database/Connection.php(414): Illuminate\Database\Connection->getPdoForSelect()
    #10 /laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
    #11 /laravel/vendor/illuminate/database/Connection.php(899): Illuminate\Database\Connection->runQueryCallback()
    #12 /laravel/vendor/illuminate/database/Connection.php(879): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
    #13 /laravel/vendor/illuminate/database/Connection.php(723): Illuminate\Database\Connection->handleQueryException()
    #14 /laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
    #15 /laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
    #16 /laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
    #17 /laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
    #18 /laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
    #19 /laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
    #20 /laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
    #21 /includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
    #22 /MacAdmin!/includes/application_bootstrap.php(174): Zencart\PluginManager\PluginManager->getInstalledPlugins()
    #23 /MacAdmin!/index.php(10): require_once('...')
    #24 {main}

    Next PDOException: SQLSTATE[HY000] [2006] MySQL server has gone away in /laravel/vendor/illuminate/database/Connectors/Connector.php:70

    Click image for larger version. 

Name:	Screenshot 2024-05-21 at 3.41.01 PM.jpg 
Views:	357 
Size:	34.0 KB 
ID:	20621
    Click image for larger version. 

Name:	Screenshot 2024-05-21 at 3.41.54 PM.jpg 
Views:	362 
Size:	53.8 KB 
ID:	20622

  2. #2
    Join Date
    Sep 2013
    Location
    Devon, UK
    Posts
    85
    Plugin Contributions
    0

    Default Re: 2.01 Uncaught PDOException: PDO::__construct(): Error while reading greeting pack

    Quote Originally Posted by Georgecy View Post
    Next PDOException: SQLSTATE[HY000] [2006] MySQL server has gone away in /laravel/vendor/illuminate/database/Connectors/Connector.php:70
    That looks to me as though either the MySQL server itself or the connection from the web server to the MySQL server has hit a problem. The PHP errors would happen if the database server stopped responding. I don't think the cause of the problem is anything to do with PHP code on the web server.

  3. #3
    Join Date
    Jun 2005
    Posts
    313
    Plugin Contributions
    0

    Default Re: 2.01 Uncaught PDOException: PDO::__construct(): Error while reading greeting pack

    Zen Cart v1.5.8 requires MySQL 5.7.8+ or MariaDB 10.2.7+
    2 + 2 = 5 for extremely large values of 2

    Pez Collectors Store

  4. #4
    Join Date
    Jul 2012
    Posts
    16,760
    Plugin Contributions
    17

    Default Re: 2.01 Uncaught PDOException: PDO::__construct(): Error while reading greeting pack

    Quote Originally Posted by gothstone View Post
    Zen Cart v1.5.8 requires MySQL 5.7.8+ or MariaDB 10.2.7+
    MySql 5.7.31 > MySql 5.7.8.

    Based on BillJ's assessment, I could see file on questions about hosting. Dedicated server? Shared hosting? Local setup?

    Doing a search on the primary message, "Uncaught PDOException: PDO::__construct(): Error while reading greeting packet. " suggested that the server name for the MySql server may be *a* cause based on server configuration. E.g. if using a domain name for the server, may need to use localhost or the same with a port number.

    In absence of additional (posting tips related) infotainment, would suggest contacting your host to trouble shoot.

    Next question would be related to past history of running perhaps an earlier version on the same server, did it used to work, but now the newer version doesn't? All sorts of ways to look at the issue depending on additional information.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    Jan 2015
    Location
    Cyprus
    Posts
    72
    Plugin Contributions
    0

    Default Re: 2.01 Uncaught PDOException: PDO::__construct(): Error while reading greeting pack

    Quote Originally Posted by mc12345678 View Post
    MySql 5.7.31 > MySql 5.7.8.

    Based on BillJ's assessment, I could see file on questions about hosting. Dedicated server? Shared hosting? Local setup?

    Doing a search on the primary message, "Uncaught PDOException: PDO::__construct(): Error while reading greeting packet. " suggested that the server name for the MySql server may be *a* cause based on server configuration. E.g. if using a domain name for the server, may need to use localhost or the same with a port number.

    In absence of additional (posting tips related) infotainment, would suggest contacting your host to trouble shoot.

    Next question would be related to past history of running perhaps an earlier version on the same server, did it used to work, but now the newer version doesn't? All sorts of ways to look at the issue depending on additional information.
    Thank for the comments. The server is dedicated in house and is the same version for a couple years and it runs ZC1.5.7d with PHP 7.4 without any issue. If PHP is changed from 8.1.28 to 8.0.10 for ZC2.01 then it runs more stable.

    I am not sure if the Laravel mechanism may cause a problem. Is it a way to bypass the Laravel mechanism and use the previous one that supported only Mysql?
    In mysql localhost is always used.
    The ZC158a installation was removed just in case and I will continue with the 2.01.
    I will install the Bootstrap Template and see the effects.
    I am not upgrading the database yet as to avoid any new issues.

    I will let you know if the issue is resolved

    Thanks guys

 

 

Similar Threads

  1. v200 nginx error: upstream sent too big header while reading response header from upstream
    By torvista in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 11 Mar 2024, 02:17 PM
  2. Replies: 2
    Last Post: 25 Aug 2023, 01:47 AM
  3. v153 PHP Warning: Error while sending QUERY packet. PID=29537
    By icecold in forum General Questions
    Replies: 4
    Last Post: 17 Oct 2017, 08:17 PM
  4. v155 PHP Warning: Error while sending QUERY packet
    By buildingblocks in forum General Questions
    Replies: 5
    Last Post: 11 Jun 2017, 03:40 AM
  5. v154 Error while sending QUERY packet. PID=752804
    By buildingblocks in forum General Questions
    Replies: 8
    Last Post: 1 Oct 2015, 03:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR