MariaDB Headers and Client Library minor version mismatch

[Thomas Loyd]

Ok, I've gone through and set up everything for my install of ResourceSpace on my server and I get the following error no matter what page I go to:

/.../.../.../resourcespace/include/db.php line 84: mysqli_connect(): Headers and client library minor version mismatch. Headers:50173 Library:50312

Here's the line in the file: dp.php: $db=mysqli_connect($mysql_server,$mysql_username,$mysql_password,$mysql_db);

I've been to a couple of websites and don't really have a solution:

Link 1: http://forum.opencart.com/viewtopic.php?t=123132&p=488650

Link 2: http://stackoverflow.com/questions/10759334/headers-and-client-library-minor-version-mismatch/22454051#22454051

I still haven't gotten it to work yet and I'm plumbing the depths of my Linux CentOS server.

If anyone has a solution for this I'm open for suggestions.

Thanks,

Tom

[Allison Stec]

https://mariadb.com/kb/en/mariadb/installation-issues-with-php5/

Sounds like php might have been installed with the intention of using another flavor of mysql. The link above gives specific information to fix this, but I can't confirm any of the options work.

The few LAMP how-tos for CentOS suggest that mariadb be installed before php. Was this the order of your install?

Allison Stec
Senior Developer & Asset Management Specialist
Colorhythm
http://www.colorhythm.com

Main Office: +1 415-399-9921
Fax: +1 415-399-9928

as...@colorhythm.com

--
ResourceSpace: Open Source Digital Asset Management
http://www.resourcespace.org
---
You received this message because you are subscribed to the Google Groups "ResourceSpace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to resourcespac...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Thomas Loyd]

Allison,

Thank you very much for the response! However, I've already been over this but forgot to include the link to it in my first post. I'm looking at a few options to get this resolved once I get a chance to sit down and try them out.  This has been a little bothersome since MariaDB is supposed to be a "drop-in replacement" for MySQL and I come up with minor nuanced issues like this left and right as I go about using it.  I'm kinda unhappy that the ResourceSpace folks haven't looked at using PostgreSQL instead since it is, in my opinion, a better database.  Anyway, if anyone else has had this issue please post below. When/if I get it resolved I'll post how I accomplished it today.

Thanks!

Thomas Loyd

[Roger Howard]

On Mar 17, 2015, at 8:09 AM, Thomas Loyd <loy...@gmail.com> wrote:

Allison,

Thank you very much for the response! However, I've already been over this but forgot to include the link to it in my first post. I'm looking at a few options to get this resolved once I get a chance to sit down and try them out.  This has been a little bothersome since MariaDB is supposed to be a "drop-in replacement" for MySQL and I come up with minor nuanced issues like this left and right as I go about using it.  

MariaDB is a drop-in replacement for the same version of MySQL - the client ABIs are the same for the same versions, but that doesn’t mean any version of Maria is a drop-in for any version of MySQL (any more than MySQL itself is).

I'm kinda unhappy that the ResourceSpace folks haven't looked at using PostgreSQL instead since it is, in my opinion, a better database.  

Well, I don’t disagree that Postgres is better in every way, but I’m not sure it really matters for Resourcespace, nor would there be much benefit to offset the relatively large amount of work it’d take to move RS safely to another SQL platform. Without actually taking advantage of Postgres-specific features, it’d just be an expensive port. MySQL makes a lot of sense for this product… at very least, this particular issue is not a good reason to move off MySQL (this is not an RS bug, it’s a problem with your PHP environment - these things happen).

What features of Postgres make it superior for *this application*? I mean, I love writing custom table plugins… but not relevant here. I am smitten with the JSONB support, but not really relevant here. Performance is variable, certainly both can be tuned to scream or be dogs… 

Anyway, if anyone else has had this issue please post below. When/if I get it resolved I'll post how I accomplished it today.

Run

php -i

and look for the Client API Header version and Client API Library version values - they aren’t matching, right? This just means that the PHP module was compiled against a different minor version of the PHP than you’re actually using… it’s really not a Maria-specific issue, this would be a problem with MySQL Server too.

[Roger Howard]

Also, I’m not much of a CentOS guy, but if there’s a package called php5-mysqlnd (or similar) in a mainstream repository, install that. It should fix the problem (it’s an alternate PHP-MySQL driver - nothing magic, but it should link against the right libs).

[Thomas Loyd]

Roger,

Thanks for the response! I didn't want to come across as negative and appreciate all the work you all do for this. PostgreSQL is just a little more preferred in my opinion having been a DBA and I agree with you on the JSONB. However, I prefer it but am not married to it in my opinion and since you can't see my facial expressions you can only make an assumption from the text. Anyway, I'm REALLY appreciative of the work you do. Once I get the problem resolved I'll post up here how I did it so someone else will have the solution too because I'm sure I'm not the only one that has this problem.  Keep up the good work too!

Thanks,

Tom

[Roger Howard]

On Wednesday, March 18, 2015 at 9:45:23 AM UTC-7, Thomas Loyd wrote:

Roger,

Thanks for the response! I didn't want to come across as negative and appreciate all the work you all do for this. PostgreSQL is just a little more preferred in my opinion having been a DBA and I agree with you on the JSONB. However, I prefer it but am not married to it in my opinion and since you can't see my facial expressions you can only make an assumption from the text. Anyway, I'm REALLY appreciative of the work you do. Once I get the problem resolved I'll post up here how I did it so someone else will have the solution too because I'm sure I'm not the only one that has this problem.  Keep up the good work too!

Thanks but I don't actually deserve any credit for RS, I'm just a user who's also a developer on other projects.

Really, it should be easy to fix - if you don't want to mess around and just want to move forward I'd just install the php5-mysqlnd package; otherwise, if you want to get a consistent install, back up your DB and Apache data and configs; dump both; and reinstall your *AMP components from fresh packages. This really looks like a systems issue, not anything MariaDB specific.