[geeklog-devel] mysql connection issue

[cordiste]

I needed to delete and then recreate all DB users to make it work.

2016-01-08 20:29 GMT+01:00 Tom <websitemaster at cogeco.net>:
> Weird. Let us know what the outcome is.
>
> -----Original Message-----
> From: geeklog-devel [mailto:geeklog-devel-bounces at lists.geeklog.net] On
> Behalf Of cordiste
> Sent: Friday, January 8, 2016 1:52 PM
> To: Geeklog Development <geeklog-devel at lists.geeklog.net>
> Subject: Re: [geeklog-devel] mysql connection issue
>
> Yes I'm sure :)
>
> Thanks for the link.
>
> On this VPS, some of the Geeklog  sites are 1.8.2 (no mysqli) and some are
> 2.1.1. The strange thing is that other CMS are working with PHP not compiled
> with MySQL 5.6 8) and Geeklog is not :(
>
> The hosting provider is also checking this issue...
>
> 2016-01-08 15:58 GMT+01:00 Tom <websitemaster at cogeco.net>:
>> Are you sure? Maybe you are using the mysqli php extension (which
>> Geeklog will default to) and the others are using the regular mysql php
> extension.
>>
>> You could modify lib-database.php around line 133 and remove the
>> mysqli check and just include:
>>
>> require_once $_CONF['path_system'] . 'databases/'. $_DB_dbms .
>> '.class.php';
>>
>>
>> Here is someone else who is having a similar problem (different
>> versions
>> though) and the solution. It looks like you will need to upgrade PHP
>> or at least the extension you are using. See below:
>>
>> http://stackoverflow.com/questions/10759334/headers-and-client-library
>> -minor
>> -version-mismatch
>>
>> Your PHP was compiled with MySQL 5.1 but now it is linking a mysql
>> library of 5.5.X family. You have to upgrade PHP to a version compiled
>> with MySQL
>> 5.5 or revert back mysql client libraries to 5.1.x.
>>
>> Tom
>>
>>
>> -----Original Message-----
>> From: geeklog-devel [mailto:geeklog-devel-bounces at lists.geeklog.net]
>> On Behalf Of cordiste
>> Sent: Friday, January 8, 2016 8:14 AM
>> To: Geeklog Development <geeklog-devel at lists.geeklog.net>
>> Subject: Re: [geeklog-devel] mysql connection issue
>>
>> Very strange because all users on this VPS are using the same php version.
>>
>> Ben
>>
>> 2016-01-08 12:52 GMT+01:00 Tom <websitemaster at cogeco.net>:
>>> Your Geeklog install must be using a different php extension to try
>>> and connect to mysql than the other cms's. Make sure you update that
>>> extension to version 5.6.
>>>
>>> Tom
>>>
>>> -----Original Message-----
>>> From: geeklog-devel [mailto:geeklog-devel-bounces at lists.geeklog.net]
>>> On Behalf Of cordiste
>>> Sent: Friday, January 8, 2016 6:00 AM
>>> To: Geeklog <geeklog-devel at lists.geeklog.net>
>>> Subject: [geeklog-devel] mysql connection issue
>>>
>>> Hi all,
>>>
>>> I just updated a server to mysql 5.6 and every sites with Geeklog
>>> display "Unfortunately, an error has occurred rendering this page.
>>> Please try again later. "
>>>
>>> Debug tell me the error is mysql_connect(): Headers and client
>>> library minor version mismatch. Headers:50542 Library:50627
>>>
>>> The question is why wordpress or joomla sites are still working on
>>> the same server and not Geeklog?
>>>
>>> Ben
>>> _______________________________________________
>>> geeklog-devel mailing list
>>> geeklog-devel at lists.geeklog.net
>>> https://pairlist8.pair.net/mailman/listinfo/geeklog-devel
>>>
>>> _______________________________________________
>>> geeklog-devel mailing list
>>> geeklog-devel at lists.geeklog.net
>>> https://pairlist8.pair.net/mailman/listinfo/geeklog-devel
>>>
>> _______________________________________________
>> geeklog-devel mailing list
>> geeklog-devel at lists.geeklog.net
>> https://pairlist8.pair.net/mailman/listinfo/geeklog-devel
>>
>> _______________________________________________
>> geeklog-devel mailing list
>> geeklog-devel at lists.geeklog.net
>> https://pairlist8.pair.net/mailman/listinfo/geeklog-devel
>>
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> https://pairlist8.pair.net/mailman/listinfo/geeklog-devel
>
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> https://pairlist8.pair.net/mailman/listinfo/geeklog-devel
>