Please see:
https://mariadb.com/kb/en/release-notes-mariadb-102-series/
10.2.9 isn't 10.2.29 ...
https://mariadb.com/kb/en/mariadb-10229-release-notes/
Assume your server admin can upgrade MariaDB.
https://mariadb.com/kb/en/yum/
https://mariadb.com/kb/en/installing-mariadb-deb-files/
Uhhh ... I don't run MariaDB myself ... just doing some 'leg work' for your admin person.
'SoS', Ken
Hello Ken,
Thank You.
There is Problem, I'm not server admin.
And they can't change configs,
Here is their answer:
Version 10.2.29 of mariadb is a fork of MySQL of version 5.7. This means that in practice they are the same software but from different "manufacturers". However, these are backwards compatible so the application in question should work without problems. Have you tried to use the support?
Do you see any solution?
Thanks in Advance
António
Do I see a problem????!!!! Well, yeah! :\
Sounds like where you host they provide 0 - that's a ZERO - support for hosting a Moodle!!! And you have no access? (no cPanel, no ssh, no ... nada nothing!???)
And while MariaDB is a fork of MySQL 10.2.29 doesn't equate to MySQL 5.7 in general ... no sense in asking them but 5.7.X ... what's the X?
What databases does hosting allow? And to kinda point right back to them ... and their understanding ... since they said that MariaDB is equal to MySQL then there should be no issues with you switching DB's!!!!
The only time one would see a 'red' check in environment check of a Moodle is when moodle code sees a version of something that won't support what ever version you had in the drop down list of that form.
'And they can't change configs,' ... might be true ... depending upon where you host ... but most hosting providers can/could change ... if not on share hosting where a change like that would affect all customers on that server.
So time for you to fully disclose ... where do you host? Provider name. What option/package have you leased from them? (shared/VPS/other).
'SoS', Ken
Antonio, click your File Manager in CPanel, open your root directory of moodle
there you will see config,php file, open that and edit the following (shown in pic), yours must be $CFG->dbtype = 'mysql', provided your hosting provider has MariaDB installed as well (hosting providers can accommodate both), all you have to do is change into 'mariadb'.
Maybe it's me, but am not at all certain we are all on the same page.
@António - can you get to your Moodles Environment check page?
Site administration -> Server -> Environment
or by URL:
http://yoursite/admin/environment.php
The drop down for moodle version will show current version of Moodle. What is that?
Set the drop down for Moodle 3.9 and beyond.
Server Checks table displays. The third row checks the database.
What does that say?
OF, if anything is 'red' under status, what is that?
'SoS', Ken
Antonio's Environment check is a little confusing.
On a CentOS 8 with MariaDB 10.3.17
Environment check for database shows:
"version 10.2.29 is required and you are running 10.3.17"
Antonio's check says running MariaDB 10.2.2 and shows running MySQL 5.7. Have never seen the environment check mix MariaDB and MySQL before. But, then again, I've never had provider change DB servers on me either.
So did provider change the DB for the server?
If so ... and that being the case, if it's true, config.php should have
mysqli for the DB driver.
BTW, found in these forums or DB admin out there, that
DB type could be mysqli for a MariaDB server and it would still run!
Maybe it's me, but am not at all certain we are all on the same page.
@António - can you get to your Moodles Environment check page?
Site administration -> Server -> Environment
or by URL:
http://yoursite/admin/environment.php
The drop down for moodle version will show current version of Moodle. What is that?
Set the drop down for Moodle 3.9 and beyond.
Server Checks table displays. The third row checks the database.
What does that say?
OF, if anything is 'red' under status, what is that?
'SoS', Ken
Hello Ken, Thanks in advance for pacience.
Here It is the page after I 've done upadate from softacolous.. trought Cpanel
António
This looks like mariaDB already, but matching fork of MySQL (sorry cant read Spanish/Portuguese) , can you ask your hosting provider to upgrade to MariaDB 10.2.x ? As Barracuda default is from 10.2.x
Says mariadb (5.7.30) which isn't a Mariadb version number.
Then says requires 10.2.29 which is a true MariaDB version and you are running 5.7.30 which is a mysql version number.
Was your Moodle originally installed via Softaculous? What version was your Moodle before the upgrade?
BTW, no one that has been participating in this thread works for Softaculous ... which is a commercial addon to commercial cPanel. So your Provider,cPanel, and Softac folks should work this out instead of pointing you to community forums - if that's what they did. Criminal in my book!
Is your site working 100% ... I see some images missing ... like for 'backups' (unless that category never had a category image/icon). Is running server: Apache x-powered-by: PHP/7.4.7 which is PHP max for Moodle 3.9+ and theme is Adaptable.
Is theme up to date?
https://moodle.org/plugins/pluginversions.php?plugin=theme_adaptable
'SoS', Ken
Hello everyone.
I am new to the moodle world that I use to communicate information and training in a non-profit organization, and I have never had any problems until now.
I can't update the moodle, returning the following error that I can't fix.
I use CPanel. Someone help???
mariadb (10.1.45-MariaDB-cll-lve) é requerida a versão 10.2.29 e está a correr a versão 10.1.45
is it a new installation you're going with, or upgrading an older one?
If you already had moodle, then better to stay on that version until you have affirmed meeting requirements for moodle 3.9, many people jump ship the moment new version comes out later to experience troubles during upgrade or after it.
When your site was a 3.8.x (prior to upgrade attempt) did you make a site backup ... an archive of code, a database dump, and an archive of at least moodledata/filedir/?
Also, when site was a 3.8, did you view the environment check? Was that the screen you shared here ... the one that showed mariadb but a MySQL version number?
At this stage of confusion, it might be best to restore the 3.8.x site. Then double check the issue with your Moodle being able to recognize what DB service it's running ... mariaDB or MySQL .. and what verion.
If you made a site backup, but don't know how to restore, then we might be able to help. Your hosting provider help desk probably won't go there.
IF you didn't make a site backup, all hope is not lost ... but depends upon hosting provider. Many hosting providers do backup customer accounts ... ie, your entire server. They don't do that very often ... since this is end of June, their last customer site backup might have been first of the month ... 1st of June. They could, if they have that, restore it. That's means, of course, anything that was done on the site between the date of the customer backup and now is lost. But it's not all lost.
'SoS', Ken
IF I found your site, looks like you are running a 3.9 now.
And the DB issue has been resolved.
If that's true, please let us both know so we can move onto other things!
'SoS', Ken
Well, we're not really helping ourselves here.
We, folks who are trying to help, must have accurate info.
Screen shot of environment check you shared earlier has
ask.com.pt/formacoes/
And now you say it's another url!
Am confused ...
www.bvfao.com/elearning
A dig on that FQDN shows this:
www.bvfao.com. 1400 IN CNAME www.bvfao.com.cdn.cloudflare.net.
www.bvfao.com.cdn.cloudflare.net. 300 IN CNAME cloudflare-resolve-to.bvfao.com.
cloudflare-resolve-to.bvfao.com. 1400 IN CNAME bvfao.com.
bvfao.com. 14400 IN A 88.99.93.149
cloudflare sits in front of your server DNS wise ... that IP is with Hetzner Online GmbH as provider.
curl -I https://www.bvfao.com/
Renders this:
HTTP/1.1 406 Not Acceptable
Server: Apache
X-Powered-By: PHP/7.2.31
Can't do any curl test at https://www.bvfao.com/elearning/ at all.
The IP address is really sv0.weblx-0.net (88.99.93.149).
So dunno how anyone can help!
Cept to suggest maybe turning off the cloudflare content delivery setup. I could not begin to tell you how to do that ... don't host where you host.
You probably should contact technical support of hosting provider.
'SoS', Ken
Yep ... was confused wasn't I!!!
Very good! Next time ... don't piggy back on someone else's thread/posting. Your problem deserves attention ... in and of itself!
In moving forward ... make sure you do 2 things ... a site backup and do check environment. Research the 'red' checks. And remember not everyone host where you host with same combo, etc. So be accurate with description of hosting + everything/anything related. Consider filling out your profile more in these forums with technical info.
You have made a site backup now that you are up and running again ... right? ;)
'SoS', Ken
Hello from Russia. Today I ran into similar problem installing latest Moodle 3.9 on server. The error was: “database mariadb (5.7.26-29) version 10.2.29 is required and you are running 5.7.26.29”. Solution was to edit config.php as follows:
$CFG->dbtype = 'mysqli'; (not mysql) It solved the problem. Probably it would have been better to choose mysqli, not mariadb from start during installation, I am not sure.
It’s interesting that on local PC using XAMPP things look different. If I choose mariadb, everything goes smooth. But if I pick mysqli it comes to error and I have to edit config.php writing mariadb. Go figure) May be folks in Moodle should slow down a bit and not run ahead of existing infrastructure.
Petr
Yes this happened to me, I also edited the config file and changed mariadb to mysqli and it fixed the issue
Thanks
