Silverstripe and ProxySQL II - cannot get this working at all

General
1

I have been trying to get Silverstripe 4.11 working with ProxySQL but have not succeeded. If I set up ProxySQL with an SS site and attempt to access the site I get this error:

[Unknown Error] Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
GET /

Line 344 in /container/application/public/vendor/silverstripe/framework/src/ORM/Connect/PDOConnector.php
Source

335         $this->databaseError($this->getLastError(), $errorLevel, $sql);
336         return null;
337     }
338 
339     public function query($sql, $errorLevel = E_USER_ERROR)
340     {
341         $this->beforeQuery($sql);
342 
343         // Directly query against connection
344         $statement = $this->pdoConnection->query($sql);
345 
346         // Generate results
347         if ($statement === false) {
348             $this->databaseError($this->getLastError(), $errorLevel, $sql);
349         } else {
350             return $this->prepareResults(new PDOStatementHandle($statement), $errorLevel, $sql);

If I enable fast_forward=1 (which by passes the ProxySQL query layer) then the connection works and data is returned for the site. However, nothing is captured in the ProxySQL query log which is what I want ProxySQL for.

Has anyone managed to get SS working with ProxySQL?

Thank you.

2

I’m going to close this thread as a duplicate of SilverStripe and ProxySQL
Please refrain from creating the same topic twice. If there is additional context in this thread that you think belongs in your original thread, feel free to edit your post or add a new comment.