Elgg cannot connect to itself to test rewrite rules properly
Hello All
I have two servers running ubuntu 18.04 my dev server is setup the same as my production server but unfortunately I have the following issue on my production server whereas my development server doesn't.
I seem to have an issue running elgg 2.3.10 on my Ubuntu 18.04 server running Vestacp apache/nginx
I have managed to install elgg without any issues, I've set up my data directory outside the public_html directory and configured my open_basedir.
Like I said the site is working without any other issues other than when I try to use the upgrade.php I get the following error:
Elgg cannot connect to itself to test rewrite rules properly. Check that curl is working and there are no IP restrictions preventing localhost connections.
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/tanertemel/web/t3.bolton365.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104 Stack trace: #0 /home/tanertemel/web/t3.bolton365.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('INSERT INTO elg...') #1 /home/tanertemel/web/t3.bolton365.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(954): Doctrine\DBAL\Driver\PDOConnection->query('INSERT INTO elg...') #2 /home/tanertemel/web/t3.bolton365.net/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php(443): Doctrine\DBAL\Connection->query('INSERT INTO elg...') #3 /home/tanertemel/web/t3.bolton365.net/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php(252): Elgg\Database->executeQuery('INSERT INTO elg...', Object(Doctrine\DBAL\Connection), Array) #4 /home/tanertemel/web/t3.bolton365.net/public_html/vendor/elgg/elgg/engine/classes/Elgg/Http/DatabaseSess in /home/tanertemel/web/t3.bolton365.net/public_html/vendor/elgg/elgg/engine/classes/Elgg/Database.php on line 446
I've googled this issue but haven't managed to find any solution.
would really apreciate any help.
- Rohit Gupta@Rohit_1990_3676
Rohit Gupta - 0 likes
- Nikolai Shcherbin@rivervanrain
Nikolai Shcherbin - 0 likes
- iionly@iionly
iionly - 0 likes
- Taner Temel@clu55ter
Taner Temel - 0 likes
- Taner Temel@clu55ter
Taner Temel - 0 likes
PDO support
enabled
PDO drivers
mysql
PDO Driver for MySQL
enabled
Client API version
mysqlnd 5.0.12-dev
- Taner Temel@clu55ter
Taner Temel - 0 likes
- Nikolai Shcherbin@rivervanrain
Nikolai Shcherbin - 0 likes
- Nikolai Shcherbin@rivervanrain
Nikolai Shcherbin - 0 likes
- Taner Temel@clu55ter
Taner Temel - 0 likes
You must log in to post replies.The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection.
There is an entire page for this on MySQL site. https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
Perhaps, you've not installed
curlextension for PHP.Check your PHP version and installed extensions/modules:
For installation
php-curlrun this command:Where 7.0 means the major version of your PHP version.
Read this also.
Also, is the PDO PHP extension installed?
Thank you for your response
curl
cURL support => enabled
cURL Information => 7.58.0
php version 7.2
@iionly PDO is installed
PDO
pdo_mysql
Cold this issue have anything to do with the server FQDN?
Check MySQL error log, e.g.
/var/log/mysql/error.logCheck PHP error log, e.g.
/var/log/php7.2-fpm.logAlso, check
elgg-config/settings.phpFor checking FQDN, run
hostnameand look at/etc/hostsA few months ago our customer had same issue on the GoDaddy hosting. The problem was solved after renaming the Elgg root installed folder w/o any .dots in its name.
Ask your hosting provider about this.
I just want to thank you for all your comments and help, this issue has now been resolved!
After installing another CMS on the same server I got the following error:
Important: HTTP Loopback Connections are not enabled on this server.
After a bit of Googling I added my ip and my.domainname.com record to my server /etc/hosts file and I am now able to use upgrade.php function without any errors.
Thank you all and I'm sorry to have taken the elgg community time with something unrelated.