Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Using CodeIgniter Installation & Setup MariaDB upgrade issue
MariaDB upgrade issue
  • Offline ZeroNine
    Junior Member
  • **
  • Posts: 10
    Threads: 4
    Joined: Oct 2014
    Reputation: 0
#1
10-03-2015, 06:43 PM

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?
Reply
  • Offline sampoyigi
    Web Developer
  • **
  • Posts: 22
    Threads: 1
    Joined: Nov 2014
    Reputation: 3
#2
10-04-2015, 05:19 AM

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
TastyIgniter - Open Source Restaurant Ordering and Management System
Reply
  • Offline ZeroNine
    Junior Member
  • **
  • Posts: 10
    Threads: 4
    Joined: Oct 2014
    Reputation: 0
#3
10-04-2015, 10:49 AM

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.
Reply
  • Offline Narf
    Me
  • *******
  • Posts: 1,589
    Threads: 1
    Joined: Oct 2014
    Reputation: 121
#4
10-05-2015, 01:37 AM

(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.
Reply
  • Offline sampoyigi
    Web Developer
  • **
  • Posts: 22
    Threads: 1
    Joined: Nov 2014
    Reputation: 3
#5
10-05-2015, 02:59 AM
(This post was last modified: 10-05-2015, 03:01 AM by sampoyigi.)

(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?
TastyIgniter - Open Source Restaurant Ordering and Management System
Reply
  • Offline Narf
    Me
  • *******
  • Posts: 1,589
    Threads: 1
    Joined: Oct 2014
    Reputation: 121
#6
10-05-2015, 09:20 AM

(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.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB