Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2017-11-08, 00:25:51

Author Topic: Troubles with MariaDB 10.0.4  (Read 999 times)

0 Members and 1 Guest are viewing this topic.

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,944
  • Karma: +1/-0
    • View Profile
Troubles with MariaDB 10.0.4
« on: 2013-10-07, 21:12:34 »
Since few days some of my pages reports:

"Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/wraten/sportnews-24.pl/mysql.php on line 31

Fatal error: Uncaught exception 'Exception' with message 'Error while connecting to database;"

When I restart MariaDB it starts to work again properly.

The trouble is I'm able to login to each of this database via phpMyAdmin, but not from the php side. Maybe there is a bug inside php-mysql or php-mysqli 5.4.20 ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Troubles with MariaDB 10.0.4
« Reply #1 on: 2013-10-07, 21:36:36 »
Look like php 5.4.x less stable then 5.3. Many issues found in php 5.4.x rather than php 5.3.x
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Troubles with MariaDB 10.0.4
« Reply #2 on: 2013-10-07, 21:38:13 »
Also, better use MariaDB 5.5 instead 10.0. It's because 5.5 as 'stable' and 10.0 as 'dev' version.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,944
  • Karma: +1/-0
    • View Profile
Re: Troubles with MariaDB 10.0.4
« Reply #3 on: 2013-10-08, 00:49:54 »
Quote from: "MRatWork"
Also, better use MariaDB 5.5 instead 10.0. It's because 5.5 as 'stable' and 10.0 as 'dev' version.

We were using MariaDB 10.0 from March this year and never had issues until now.

The funny thing is that MariaDB-server is working, but some customers are unable to connect via PHP and some works normally.

When MariaDB is restarted all back to normal.

I suspect PHP 5.4.20 from remi repo which is not so compatible with MariaDB but with normal MySQL I had to use mysqlclient18 5.5.28 from atomic repo.
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Troubles with MariaDB 10.0.4
« Reply #4 on: 2013-10-08, 01:03:36 »
I have no comment for other repos outside 'default' repos inside kloxo-mr.repo.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,944
  • Karma: +1/-0
    • View Profile
Re: Troubles with MariaDB 10.0.4
« Reply #5 on: 2013-10-08, 01:29:48 »
Quote from: "MRatWork"
I have no comment for other repos outside 'default' repos inside kloxo-mr.repo.

I will be switching from remi's php to your php54.
« Last Edit: 1970-01-01, 01:00:00 by Guest »

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine

Page created in 0.038 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM