Koozali.org: home of the SME Server

How to upgrade MySQL.

Offline Skalviai

  • *
  • 35
  • +0/-0
Re: How to upgrade MySQL.
« Reply #15 on: November 01, 2023, 08:34:23 AM »

you have established  that you need to use a different version of mariadb and for that pointing the the right socket, and this is done by using localhost:/var/lib/mysql/mariadb105.sock on joomla 4


Thanks for the information.

The solution should not be looked for if Sme Server used newer databases in the standard installation, or in the upgrade it was possible to upgrade with the "yum" command.
For example: yum update mariadb or yum update mysql

In which configuration file does Joomla indicate the use of the mysql command or the mariadb database, it has not yet been found. We'll keep looking.

Joomla 3 works perfectly with mariadb 10.5. This is checked on another server (not SmeServer).

Virtual temporary servers are used for the migration process. Only after verification, everything is transferred to the working server.
.........

Offline warren

  • *
  • 293
  • +0/-0
Re: How to upgrade MySQL.
« Reply #16 on: November 01, 2023, 10:02:42 AM »
Thanks for the information.

The solution should not be looked for if Sme Server used newer databases in the standard installation, or in the upgrade it was possible to upgrade with the "yum" command.
For example: yum update mariadb or yum update mysql

The solution was supplied  :-?  ...here
you simply do not.
Sme comes with mariadb 5.5. not mysql.

you can use SCLO and install along side mariadb 10.5. See the wiki for the procedure to install the contrib.

and here...
https://wiki.koozali.org/MySQL

https://wiki.koozali.org/Mariadb105#Configuration

https://wiki.koozali.org/Mariadb105#Usage

https://wiki.koozali.org/PHPMyAdmin

Saves me writing it all out again.


In which configuration file does Joomla indicate the use of the mysql command or the mariadb database, it has not yet been found. We'll keep looking.

Maybe have a look in joomlas config file for the section containing the DB params....
ok il bite...
Code: [Select]
configuration.php
public $dbtype = 'mysqli';
        public $host = 'localhost:/var/lib/mysql/mariadb105.sock';
        public $user = 'joomadmin';
        public $password = 'yourpassword';
        public $db = 'yourdbname';


Offline Skalviai

  • *
  • 35
  • +0/-0
Re: How to upgrade MySQL.
« Reply #17 on: November 01, 2023, 12:47:36 PM »
        public $host = 'localhost:/var/lib/mysql/mariadb105.sock';

The solution, as always, is simple. That was all that was needed.
Thanks for the help.
.........