Results 1 to 7 of 7

Thread: Upgrade from 16.04 LTS to 18.04.1 LTS - MySQL server problem

  1. #1
    Join Date
    Aug 2021
    Beans
    6

    Question Upgrade from 16.04 LTS to 18.04.1 LTS - MySQL server problem

    Hello,

    I've made an upgrade form 16.04 to 18.04.1 without apparently any problem (hosted on a 1&1 dedicated server)
    This server is running different Joomla! based sites
    Had to restart MySQL server and then no more any response form MySQL server

    Have tried re-installation with :
    Code:
    sudo apt-get remove mysql-server
    sudo apt-get install mysql-server
    Without any luck (ie none of our sites are running now)
    Tried to stop and start MySQL server : no problem

    Tried re-configuration with :
    Code:
    sudo dpkg-reconfigure mysql-server-5.7
    Got this message after re-configuration :
    Code:
    Checking if update is needed.
    This installation of MySQL is already upgraded to 5.7.35, use --force if you still need to run mysql_upgrade
    Didn't help either... I'm not that familiar with MySQL server (have installed it many times, never had any problem... used it without any problem)
    But now I'm lost !

    has someone an idea what I should do ?
    Should I give you more information, fell free to ask (please dive me the bash command to enter, I'm not that fluent in Bash ) ?

    Thanks in advance for your help and advises,

    Stéphane

    PS : please forgive me my English as it is not my mother language, I am French

  2. #2
    Join Date
    Aug 2021
    Beans
    6

    Re: Upgrade from 16.04 LTS to 18.04.1 LTS - MySQL server problem

    Forgot to say

    Code:
    /var/lib/mysql
    has still all the databases (I cannot loose them !)
    I have recent backups of all of my sites via Akeeba Backup (site and database included)

    Thanks for reading and for your help
    Stéphane

  3. #3
    Join Date
    Mar 2010
    Location
    USA
    Beans
    Hidden!
    Distro
    Ubuntu Development Release

    Re: Upgrade from 16.04 LTS to 18.04.1 LTS - MySQL server problem

    I'm just curious if the database are running or not physically? Or just communications to them are down?

    Concurrent coexistance of Windows, Linux and UNIX...
    Ubuntu user # 33563, Linux user # 533637
    Sticky: [all variants] Graphics Resolution- Upgrade /Blank Screen after reboot
    UbuntuForums system-info Script

  4. #4
    Join Date
    Aug 2021
    Beans
    6

    Re: Upgrade from 16.04 LTS to 18.04.1 LTS - MySQL server problem

    Quote Originally Posted by MAFoElffen View Post
    I'm just curious if the database are running or not physically? Or just communications to them are down?
    Hello MAFoElffen,

    I do not know... how could I verify this ?

    Thanks for your help and advises

  5. #5
    Join Date
    Aug 2021
    Beans
    6

    Re: Upgrade from 16.04 LTS to 18.04.1 LTS - MySQL server problem

    I know where the problem come's from !

    I've installed a Joomla! extention that requested some modifications in the Mysql configuration
    So I've modified the /etc/mysql/mysql.conf.d/mysqld.cnf file with the following inputs :
    Code:
    interactive_timeout = 120
    wait_timeout  = 120
    connect_timeout = 120
    and this without stopping MySQL !

    I messed all up this way...
    But now, how could I rebuild/rewind ?

    Thanks for your help and advises
    Stéphane

  6. #6
    Join Date
    Aug 2021
    Beans
    6

    Re: Upgrade from 16.04 LTS to 18.04.1 LTS - MySQL server problem

    I've uploaded the mysql error log file from yesterday onto my Gdrive, here's the link :
    https://drive.google.com/file/d/1ooB...ew?usp=sharing

  7. #7
    Join Date
    Aug 2021
    Beans
    6

    Re: Upgrade from 16.04 LTS to 18.04.1 LTS - MySQL server problem

    Problem solved !

    the error camed form a Joomla! extension. This extension suggested to modify some PHP.ini parameters. Their suggestion is not good !
    Set the parameters back to what they should be, and all my sites where back !

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
  •