CodeIgniter Forums
MariaDB upgrade issue - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: Installation & Setup (https://forum.codeigniter.com/forum-9.html)
+--- Thread: MariaDB upgrade issue (/thread-63181.html)



MariaDB upgrade issue - ZeroNine - 10-03-2015

I recently upgraded the mysql database on a perfectly functioning codeigniter 3 web app to MariaDB. Now I am unable to get it working because it is not connecting to the database.


Code:
A Database Error Occurred

Unable to connect to your database server using the provided settings.
Filename: core/CodeIgniter.php
Line Number: 500



My dbdriver is set to 'mysqli'. I tried setting it to 'mysql' but I got different error.
Is is possible to have these both working together?


RE: MariaDB upgrade issue - sampoyigi - 10-04-2015

Yes, its probably possible to have both working together with seperate database configuration option in config/database.php. However you might need the MariaDB driver


RE: MariaDB upgrade issue - ZeroNine - 10-04-2015

Thank you for the info sampoyigi!

I solved this issue. It was a compatibility issue with EasyApache 4 on Cpanel/WHM. When I upgraded to MariaDB and activated EasyApache 4 on Cpanel/WHM the sites were no longer able to connect to the database. Once I reverted back to EasyApache 3. and reinstalled MariaDB, everything started working again.


RE: MariaDB upgrade issue - Narf - 10-05-2015

(10-04-2015, 05:19 AM)sampoyigi Wrote: Yes, its probably possible to have both working together with seperate database configuration option in config/database.php. However you might need the MariaDB driver

There is no MariaDB driver ... I know it sounds logical to you that one may exist, but you don't know that and you're making it up; confusing people with that.


RE: MariaDB upgrade issue - sampoyigi - 10-05-2015

(10-05-2015, 01:37 AM)Narf Wrote:
(10-04-2015, 05:19 AM)sampoyigi Wrote: Yes, its probably possible to have both working together with seperate database configuration option in config/database.php. However you might need the MariaDB driver

There is no MariaDB driver ... I know it sounds logical to you that one may exist, but you don't know that and you're making it up; confusing people with that.

It does sound logical... However, I should have looked it up before suggesting. Just trying to help Smile

So just to clarify, since the MariaDB is a fork of MySQL, it uses the mysqli driver instead?


RE: MariaDB upgrade issue - Narf - 10-05-2015

(10-05-2015, 02:59 AM)sampoyigi Wrote:
(10-05-2015, 01:37 AM)Narf Wrote:
(10-04-2015, 05:19 AM)sampoyigi Wrote: Yes, its probably possible to have both working together with seperate database configuration option in config/database.php. However you might need the MariaDB driver

There is no MariaDB driver ... I know it sounds logical to you that one may exist, but you don't know that and you're making it up; confusing people with that.

It does sound logical... However, I should have looked it up before suggesting. Just trying to help Smile

So just to clarify, since the MariaDB is a fork of MySQL, it uses the mysqli driver instead?

Yes.