Topic: How to upgrade MySQL.

[Skalviai]

Joomla 4 minimum requirements - mysql 5.6 or higher. SmeServer 10 comes with mysql 5.5.
How to install version 5.6 or higher?

[Jean-Philippe Pialasse]

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.

[Skalviai]

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

We have successfully installed mariadb 10.5. How to use it in Joomla 4.

Like wordpress for example:

For Wordpress adjust the DB_HOST value in the wp-config.php file accordingly.
 define( 'DB_HOST', 'localhost:/var/lib/mysql/mariadb105.sock' );

[ReetP]

How to use it in Joomla 4.

Read the Joomla documentation?

By default Maria DB runs on a socket. Joomla should be able to connect using localhost.

If not you can enable a port (less safe than socket). See the wiki.

Please be VERY careful when reading other web pages. With the templating engine, SME is NOT standard so don't just go manually hacking files without knowing EXACTLY what you are doing.

Take backups before starting anything.

[Skalviai]

Thanks for the reply.

Then the next question.
After running the mysql command, we get MariaDB version 5.5.68.
How to change sme server settings so that the mysql command uses MariaDB version 10.5.9?

[ReetP]

Your question tells me you are not reading our wiki.

Please, go back and read it all, carefully. Let your eyes be your guide.

[Skalviai]

Your question tells me you are not reading our wiki.

Please, go back and read it all, carefully. Let your eyes be your guide.

I'm looking for a concrete answer, and your answer is "I know how to do it, but read the wiki, google, and you'll find it yourself."

[ReetP]

You have asked a question which has a concrete, documented answer. You just need to read.

There are also various threads here on using it.

You won't learn anything if you can't be bothered to read.

Do you think I magically acquired some knowledge? No, I went and read copiuosly, over years.

Like many of us here I have limited time which I  don't want to waste on answering questions that already have simple solution.

People here will help those who help themselves.

https://forums.koozali.org/index.php/topic,54724.0.html

[ReetP]

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.

[Skalviai]

https://wiki.koozali.org/MySQL
https://wiki.koozali.org/Mariadb105#Configuration
https://wiki.koozali.org/Mariadb105#Usage
https://wiki.koozali.org/PHPMyAdmin

Thank you very much, but I have read these articles many times, but there is no solution for Joomla. WordPress only. Joomla theme is not popular in your forum. 0 requests per year.

[warren]

Thank you very much, but I have read these articles many times, but there is no solution for Joomla. WordPress only. Joomla theme is not popular in your forum. 0 requests per year.

I just tested this and can install joomla 4.40 on sme in ibay , follow the instructions  to configure / setup mariadb105 :

Code: [Select]

mysqladmin105 create yourdbname

Code: [Select]

mysql105
GRANT ALL PRIVILEGES ON yourdbname.* TO whoever@localhost IDENTIFIED BY 'YourPassword'

[quote

Like wordpress for example:

    For Wordpress adjust the DB_HOST value in the wp-config.php file accordingly.
     define( 'DB_HOST', 'localhost:/var/lib/mysql/mariadb105.sock' );

Did you try putting the above in the config file; From the installer if i put 'localhost:/var/lib/mysql/mariadb105.sock' for the database setup it installs :

[ReetP]

I just tested this and can install joomla 4.40 on sme in ibay , follow the instructions  to configure / setup mariadb105 :

Thanks Warren. I was pretty sure it was fairly simple but I am busy fixing some contribs right now.

As I pointed out to them, but they didn't read:

After running the mysql command, we get MariaDB version 5.5.68.

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

<sigh>

The issue is the information is there but the OP can't be bothered to read it and try to understand. They skim it, not really wanting to learn or understand. They just want it popped on a sugar coated spoon to save them their time, but happy to consume ours. it is hugely frustrating.

If they had asked "I read the wiki page and found the command mysqladmin105 and tried to create a DB and it failed" I'd have more sympathy.

As the OP pointed out, not many people use Joomla here (they do but like you, don't necessarily post), but between the documentation here, at Joomla, and a bit of trial and error and learning they would have got it fixed. Wordpress and Joomla are very similar as far as configuration goes so not difficult. I'd have probably leaped in if they had actually done something themselves. As it is they have done, and learned, nothing.

And then you ask for people help us build SME - they'll all want a new version shortly - and then they say they know nothing or are too busy, but expect 'someone else' to do it.

I think I need get out of here and retire. Too old and crochety.

[Skalviai]

f they had asked "I read the wiki page and found the command mysqladmin105 and tried to create a DB and it failed" I'd have more sympathy.

The situation is different. There is no problem to create or transfer a database to mariadb 10.5. This was immediately done. The problem is different. SmeServer works with Joomla 3 with mysql (mariadb 5.5.6). And it works very well. However, migrating (without installation) to Joomla4 requires a newer version of mariadb.
If you had to install Joomla4, there probably wouldn't be any questions.
Thanks to everyone who wastes precious time and helps even a little.

[Jean-Philippe Pialasse]

your issue is not related to SME, but to migration process of joomla.

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


now indeed joomla 4 requires a higher mysql/mariadb, but does joomla3 supports mariadb 10.5? Does joomla 3 support same socket path than joomla does?
Here is not the right forum to ask, you would have more chance asking at the right place… Joomla wiki and forum!

also migrating need planification.  So you might understand that before pointing your joomla3 to mariadb 10.5 you need to dump your db and restore it to the new mariadb 10.5. Phpmyadmin might help you in the process or using the mysqldump and mysql105 commands to dump and then restore to the right service. This is not either specific to SME.


then once it is done, it is also on the side of joomla forum or documentation you will find the info of what file and what variable to edit to put the string to point to mariadb 10.5

[ReetP]

Classic XY problem.

Should have expained the issue properly at the start.

https://xyproblem.info/

It wasn't "how to ugrade a db" but "how to upgrade Joomla".

If the OP had really read they'd have seen these here - but I knew they hadn't.

https://forums.koozali.org/index.php/topic,54724.0.html

Tell us about your problem, not your attempts at a solution:
https://xyproblem.info/

How to report bugs effective:
https://www.chiark.greenend.org.uk/~sgtatham/bugs.html

How to ask a smart question that will attract attention:
http://www.catb.org/esr/faqs/smart-questions.html

Hey ho.