# Error to upgrade mautic to 3.24 from 2.16.5 **URL:** \ **Category:** Mautic 3 - Install/Upgrade Support\ **Created:** [December 24, 2021, 11:19am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149 "2021-12-24T11:19:56Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [December 24, 2021, 11:19am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/1 "2021-12-24T11:19:56Z")
Mautic 2.16.5 php 7.3.3 OS linux update with GUI of mautic and i have this error ## Upgrading Mautic… This might take several minutes. | Starting the upgrade… | | | --- | --- | | Backing up the database if we can… | | | Applying Mautic 2 database migrations to ensure all migrations are in place prior to upgrade… | | | Downloading Mautic 3 upgrade package… | | | Extracting Mautic 3 files… | | Something went wrong on the server, but we didn’t get any further details. This might be a timeout (the script was running for too long). Please check your server logs and refresh this page to try again. in the log there is: [2021-12-24 10:34:50] ===== STARTING MAUTIC 3 UPGRADE AT 2021-12-24 10:34:50… ===== Installed Mautic version: 2.16.5 PHP version: 7.3.33 OS: Linux Upgrade type: UI [2021-12-24 10:34:50] Running pre-upgrade checks… [2021-12-24 10:34:51] One or more warnings occurred in the pre-upgrade checks: - You have 10000 or more contacts in your system. We recommend upgrading by using the CLI (command line) for the best performance and stability. [2021-12-24 10:34:54] Starting the upgrade… [2021-12-24 10:34:54] Running database backup… [2021-12-24 10:40:44] Successfully backed up database. [2021-12-24 10:40:45] Getting the amount of available Mautic 2 database migrations… [2021-12-24 10:40:45] No available database migrations found. On to the next step… [2021-12-24 10:40:46] Downloading Mautic 3 upgrade package… [2021-12-24 10:40:46] Successfully downloaded Mautic 3 upgrade package. [2021-12-24 10:40:46] Extracting Mautic 3 files… someone can help me please. Thanks Alessandro ---
**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\ **Post date:** [December 24, 2021, 3:29pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/2 "2021-12-24T15:29:24Z")
do you have ssh access to your server ? I would highly recommend doing it this way if possible. Once logged into your server run /var/www/mautic/app/console mautic:update:find and then following instructions (I cannot remember there might be an update.php file that you can run in the root directory as well) ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [December 24, 2021, 4:55pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/3 "2021-12-24T16:55:53Z")
thanks mikew, i tried but i have this message from terminal:Thank you, continuing… ===== STARTING MAUTIC 3 UPGRADE AT 2021-12-24 16:52:26… ===== Installed Mautic version: 2.16.5 PHP version: 7.3.33 OS: Linux Upgrade type: CLI Doing pre-upgrade checks… mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces Finished pre-upgrade checks. Starting upgrade… mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces Backing up your database… mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces what should i do? ---
**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\ **Post date:** [December 25, 2021, 9:35am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/4 "2021-12-25T09:35:11Z")
from reading the error messages it seems you have a password issue here. I would check my local.php file I think in 2.x it is found in /mautic/app/config/local.php and make sure your password is correct in this file for your mautic db and I would also make sure you are running console as sudo so command would be sudo php /var/www/mautic/app/console mautic:update:apply ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [December 25, 2021, 1:04pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/5 "2021-12-25T13:04:27Z")
i found the psw in local.php but when i open terminal from my Register account dont ask password or username. i tried to put “sudo php /var/www/mautic/app/console mautic:update:apply” but terminal says “bash: sudo: command not found”. ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [December 27, 2021, 12:32am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/6 "2021-12-27T00:32:11Z")
Hi, Mautic is trying to create a backup of your database with mysqldump command but it looks like it cant because of insufficient MySQL permissions. I would advise you to grant all privileges to some mysql user on mautic database and before you try to run the upgrade process again, try backing up your database using mysqldump command (you should do database backup before every mautic upgrade anyway). You can temporarily use different mysql user (the one with all privileges) and then switch it back to the current. You can switch mysql credentials in local.php @mikew pointed you too. I hope its clear enough. If you need step by step instructions (actual commands on how to achieve what is described above, let me know). Hope it helps. Regards, M. ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [December 27, 2021, 7:42am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/7 "2021-12-27T07:42:26Z")
Hi, in theory the set user has all the privileges, if not where do I see him? Thank you ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [December 27, 2021, 10:04am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/8 "2021-12-27T10:04:49Z")
Hi, you can see currently database user that is used in mautic if you open up local.php. Fields like: - db\_host - db\_name - db\_user - db\_password are the ones that are relevant to you. You can see how to grant all privileges on a specific database here: [How to Grant All Privileges on a Database in MySQL | Tutorial by Chartio](https://chartio.com/resources/tutorials/how-to-grant-all-privileges-on-a-database-in-mysql/) Hope it helps. ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [December 27, 2021, 2:33pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/9 "2021-12-27T14:33:48Z")
hi, for host, username, name and password i found it from “manage file” but i dont know how to open command line from Register CPanel. sorry for my english and my knowledge. Thanks Alessandro ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [December 27, 2021, 4:24pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/10 "2021-12-27T16:24:05Z")
You need to get to CLi (terminal). How were you able to start the upgrade process? I do not know the cpanel that well but you might be able to add mysql user via cpanel gui too. Regards, M. ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [December 28, 2021, 7:40am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/11 "2021-12-28T07:40:00Z")
hi, the update i tried to do through terminal of cpanel or gui of mautic ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [December 28, 2021, 10:22am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/12 "2021-12-28T10:22:33Z")
Thanks, so you have access to the terminal. You can try viewing the local.php file like so: `nano /app/config/local.php` or `cat /app/config/local.php` you will see credentials to mysql server and database there. I can offer you my services and resolve the issue of mysql permission error for you, since I think it would be faster. Drop me an email to [matic@sos-sw.si](mailto:matic@sos-sw.si) if interested. Regards, M. ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [December 30, 2021, 5:18pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/13 "2021-12-30T17:18:56Z")
ok, i found that my user has all privileges. i dont know why i cant update mautic ☹ my mail is [a.mosca89@gmail.com](mailto:a.mosca89@gmail.com) the error log is: [2021-12-30 18:41:30] mautic.ERROR: An error occurred while attempting to fetch the language list: SSL certificate problem: certificate has expired [2021-12-30 18:42:10] mautic.WARNING: MaxMind license key is required. [2021-12-30 18:42:10] mautic.ERROR: Failed to fetch remote IP data: No HTTP response received [2021-12-30 18:42:10] mautic.WARNING: MaxMind license key is required. ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [December 30, 2021, 7:55pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/14 "2021-12-30T19:55:35Z")
Hi, do you actually use MaxMind? If not you should unselect maxMind IP lookup service in: Configuration → System Settings → Miscellaneous Settings → IP lookup service You should get rid warnings about MaxMind settings. ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [December 31, 2021, 8:49am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/15 "2021-12-31T08:49:43Z")
ok perfect, now there is only one error: [2021-12-31 09:22:52] mautic.ERROR: An error occurred while attempting to fetch the language list: SSL certificate problem: certificate has expired ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [January 4, 2022, 10:42am UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/16 "2022-01-04T10:42:37Z")
Looking at the code that produces this error, I think that either you have the wrong translation\_url or for a while there site had invalid SSL certificate. The url in question is: [https://language-packs.mautic.com/manifest.json](https://language-packs.mautic.com/manifest.json) In short this should go away by the time you upgrade to Mautic 4. Did you manage to upgrade to Mautic 4? ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [January 4, 2022, 7:46pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/17 "2022-01-04T19:46:19Z")
no, im updating mautic from 2 to 3. but i have always this error: [2022-01-04 20:34:12] mautic.ERROR: An error occurred while attempting to fetch the language list: SSL certificate problem: certificate has expired [2022-01-04 20:46:36] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT m0\_.is\_published AS is\_published\_0, m0\_.date\_added AS date\_added\_1, m0\_.created\_by AS created\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS modified\_by\_5, m0\_.modified\_by\_user AS modified\_by\_user\_6, m0\_.checked\_out AS checked\_out\_7, m0\_.checked\_out\_by AS checked\_out\_by\_8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, m0\_.id AS id\_10, m0\_.username AS username\_11, m0\_.password AS password\_12, m0\_.first\_name AS first\_name\_13, m0\_.last\_name AS last\_name\_14, m0\_.email AS email\_15, m0\_.position AS position\_16, m0\_.timezone AS timezone\_17, m0\_.locale AS locale\_18, m0\_.last\_login AS last\_login\_19, m0\_.last\_active AS last\_active\_20, m0\_.online\_status AS online\_status\_21, m0\_.preferences AS preferences\_22, m0\_.signature AS signature\_23, m1\_.is\_published AS is\_published\_24, m1\_.date\_added AS date\_added\_25, m1\_.created\_by AS created\_by\_26, m1\_.created\_by\_user AS created\_by\_user\_27, m1\_.date\_modified AS date\_modified\_28, m1\_.modified\_by AS modified\_by\_29, m1\_.modified\_by\_user AS modified\_by\_user\_30, m1\_.checked\_out AS checked\_out\_31, m1\_.checked\_out\_by AS checked\_out\_by\_32, m1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_33, m1\_.id AS id\_34, m1\_.name AS name\_35, m1\_.description AS description\_36, m1\_.is\_admin AS is\_admin\_37, m1\_.readable\_permissions AS readable\_permissions\_38, m0\_.role\_id AS role\_id\_39 FROM mauvgo\_users m0\_ LEFT JOIN mauvgo\_roles m1\_ ON m0\_.role\_id = m1\_.id WHERE (m0\_.username = ? OR m0\_.email = ?) AND m0\_.is\_published = ?’ with params [“vegaoptic”, “vegaoptic”, 1]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away” at /home/lf343x93/public\_html/automktg/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT m0\_.is\_published AS is\_published\_0, m0\_.date\_added AS date\_added\_1, m0\_.created\_by AS created\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS modified\_by\_5, m0\_.modified\_by\_user AS modified\_by\_user\_6, m0\_.checked\_out AS checked\_out\_7, m0\_.checked\_out\_by AS checked\_out\_by\_8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, m0\_.id AS id\_10, m0\_.username AS username\_11, m0\_.password AS password\_12, m0\_.first\_name AS first\_name\_13, m0\_.last\_name AS last\_name\_14, m0\_.email AS email\_15, m0\_.position AS position\_16, m0\_.timezone AS timezone\_17, m0\_.locale AS locale\_18, m0\_.last\_login AS last\_login\_19, m0\_.last\_active AS last\_active\_20, m0\_.online\_status AS online\_status\_21, m0\_.preferences AS preferences\_22, m0\_.signature AS signature\_23, m1\_.is\_published AS is\_published\_24, m1\_.date\_added AS date\_added\_25, m1\_.created\_by AS created\_by\_26, m1\_.created\_by\_user AS created\_by\_user\_27, m1\_.date\_modified AS date\_modified\_28, m1\_.modified\_by AS modified\_by\_29, m1\_.modified\_by\_user AS modified\_by\_user\_30, m1\_.checked\_out AS checked\_out\_31, m1\_.checked\_out\_by AS checked\_out\_by\_32, m1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_33, m1\_.id AS id\_34, m1\_.name AS name\_35, m1\_.description AS description\_36, m1\_.is\_admin AS is\_admin\_37, m1\_.readable\_permissions AS readable\_permissions\_38, m0\_.role\_id AS role\_id\_39 FROM mauvgo\_users m0\_ LEFT JOIN mauvgo\_roles m1\_ ON m0\_.role\_id = m1\_.id WHERE (m0\_.username = ? OR m0\_.email = ?) AND m0\_.is\_published = ?’ with params [“vegaoptic”, “vegaoptic”, 1]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/lf343x93/public\_html/automktg/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/lf343x93/public\_html/automktg/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/lf343x93/public\_html/automktg/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} i have check the file local.php and the link is correct. while the SSL certificate has expiry date on 7/3/22 ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [January 4, 2022, 8:53pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/18 "2022-01-04T20:53:55Z")
It looks like your mysql instance is not running. Can you check if your mautic instance is running and you can login to mysql using credentials from app/config/local.php? ---
**Author:** ![steekhutze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steekhutze/32/6394_2.png) [@steekhutze](https://forum.mautic.org/u/steekhutze)\ **Post date:** [January 5, 2022, 1:45pm UTC](https://forum.mautic.org/t/error-to-upgrade-mautic-to-3-24-from-2-16-5/22149/19 "2022-01-05T13:45:30Z")
Hi, maybe yesterday mautic was on tilt because today that select error is gone. I attach file of the errors it produces. > **[prod-2022-01-05.php](https://drive.google.com/file/d/1LgsZC_WUcHkS-AouGQheN-S40RShzu-0/view?usp=sharing)** > > Google Drive file.