Mautic Community Forums

List of IPs to not track leads with


I pasted a list of IP addresses. After saving changes you can not see them. Is the way it should be?

I pasted a list of IP addresses. After saving changes you can not see them. Is the way it should be?

Could you try just one and see what happens? There is a max number we allow in there, and I don’t know how big your list was.

It was only 10 addresses. Only 1 pasted and also address was not saved though the message says: “Configuration successfully updated”.
Maybe something logs explanation?
And for this I have problems with SMTP configuration

Maybe something logs explanation?

[2015-07-23 09:10:45] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘INSERT INTO mau_ip_addresses (ip_address, ip_details) VALUES (?, ?)’: MySQL server has gone away” at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘INSERT INTO mau_ip_addresses (ip_address, ip_details) VALUES (?, ?)’:nnMySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 2006): MySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} []
[2015-07-23 09:10:45] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘INSERT INTO mau_ip_addresses (ip_address, ip_details) VALUES (?, ?)’: MySQL server has gone away” at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘INSERT INTO mau_ip_addresses (ip_address, ip_details) VALUES (?, ?)’:nnMySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 2006): MySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} []
[2015-07-23 10:04:53] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘INSERT INTO mau_ip_addresses (ip_address, ip_details) VALUES (?, ?)’: MySQL server has gone away” at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘INSERT INTO mau_ip_addresses (ip_address, ip_details) VALUES (?, ?)’:nnMySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 2006): MySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} []
[2015-07-23 11:53:06] mautic.ERROR: [MAIL ERROR] Connection could not be established with host smtpauth.ipartners.pl [Connection timed out #110] Log data: ++ Starting Swift_Transport_EsmtpTransport !! Connection could not be established with host smtpauth.ipartners.pl [Connection timed out #110] [] []
[2015-07-23 11:53:07] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘INSERT INTO mau_notifications (type, header, message, date_added, icon_class, is_read, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’: MySQL server has gone away” at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘INSERT INTO mau_notifications (type, header, message, date_added, icon_class, is_read, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’:nnMySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 2006): MySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} []
[2015-07-23 11:53:07] mautic.CRITICAL: Exception thrown when handling an exception (DoctrineDBALDBALException: An exception occurred while executing ‘SELECT m0_.id AS id0, m0_.type AS type1, m0_.header AS header2, m0_.message AS message3, m0_.date_added AS date_added4, m0_.icon_class AS icon_class5, m0_.is_read AS is_read6 FROM mau_notifications m0_ WHERE m0_.user_id = ? AND m0_.id > ? ORDER BY m0_.date_added DESC’ with params [1, 401]: MySQL server has gone away) {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘INSERT INTO mau_notifications (type, header, message, date_added, icon_class, is_read, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’:nnMySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 2006): MySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} []
[2015-07-23 11:54:29] mautic.ERROR: [MAIL ERROR] Connection could not be established with host smtpauth.ipartners.pl [Connection timed out #110] Log data: ++ Starting Swift_Transport_EsmtpTransport !! Connection could not be established with host smtpauth.ipartners.pl [Connection timed out #110] [] []
[2015-07-23 11:54:29] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘INSERT INTO mau_notifications (type, header, message, date_added, icon_class, is_read, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’: MySQL server has gone away” at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘INSERT INTO mau_notifications (type, header, message, date_added, icon_class, is_read, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’:nnMySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 2006): MySQL server has gone away at /home/…/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} []

Hmm. it looks like the mysql engine is crashing when the save is attempted. The mysql server is timing out when the save action is attempted.

Can you see if any of the reasons are correct? https://dev.mysql.com/doc/refman/5.0/en/gone-away.html

the application does not return any error, not save anywhere this configuration, the logs do not record anywhere operations. I am not able to track whether these addresses are actually saved, or is it a mistake.

Hi Slawek

This issue is going to be particularly tough to nail down because of what is happening.

  1. It definitely looks like the changes are not saving properly. The changes are saved in the configuration file (at app/config/local.php). But it looks like an SQL query is still executing.

  2. because the mysql server is crashing the change isn’t taking place. Also, because of the crash its likely there isn’t a log being generated (because the server that generates the log just crashed…)

I’ll ask around and see what I can find out about this.

Do you have access to MySQL server logs? For example, on an ubuntu server, these might be in /var/log/mysql/error.log. If you’re on a shared host, maybe contact the host to see if they can look up the errors for you. I would think there should be something in MySQLs error logs on why it’s “gone away.” The queries in the log seem pretty simple queries so I’m not sure why they would kill the server.

Thanks!
Alan