<div dir="ltr">Dear Micheal<div><br></div><div>Thank you for your quick test. </div><div>I have some question form your test. </div><div><br></div><div>1. Opencert : how to change <span style="font-size:12.8px">mPDO driver?</span></div><div><span style="font-size:12.8px">2. Can you test </span><span style="font-size:12.8px">OrangeHRM with installer setup?</span></div><div>3. For the joomla 1.5 with chinese text (Migrate from 5108R), i need add UTF8 support in my.cnf( I forget what set before.)<br></div><div><br></div><div>BTW: Thank you for your support again. You are professional on Blueonyx and Linux.</div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px"><br></span></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jan 27, 2017 at 3:08 AM, Michael Stauber <span dir="ltr"><<a href="mailto:mstauber@blueonyx.it" target="_blank">mstauber@blueonyx.it</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Mon Chan,<br>
<br>
I took a look at this:<br>
<br>
5209R, MariaDB-10.1.18 and all PHP versions from the shop installed.<br>
<br>
I installed the following WebApp modules for a quick test:<br>
<br>
- Wordpress 4.7.1: Works perfectly fine.<br>
- Joomla 3.6.4: With MySQLi driver: fine<br>
- Joomla 3.6.4: With PDO driver: fine<br>
- Joomla 1.5.26: With 'mysql' driver: fine<br>
- Joomla 1.5.26: With 'mysqli' driver: fine<br>
- OpenCart <a href="http://2.3.0.2" rel="noreferrer" target="_blank">2.3.0.2</a>: With 'MySQLi' driver: header warning<br>
- OpenCart <a href="http://2.3.0.2" rel="noreferrer" target="_blank">2.3.0.2</a>: With 'mPDO' driver: fine<br>
<br>
With that in mind I might suggest you might want to change the MySQL<br>
driver for your OpenCart install from 'MySQLi' to 'mPDO', which will get<br>
it working without error.<br>
<br>
As we can see in the example of Joomla (both 1.5 and 3.6): It works with<br>
both MySQLi and PDO drivers, because it's not picky about the headers<br>
being a different version.<br>
<br>
Generally speaking: MariaDB-10.1 will work fine on 5209R w/o header<br>
warning if:<br>
<br>
- The app doesn't care about the header version while using MySQLi<br>
- The app uses PDO drivers to connect to MariaDB<br>
- The app uses mysql-nd drivers to connect to MariaDB<br>
<br>
So after lots of digging I think I found a solution that will work just<br>
fine on 5209R:<br>
<br>
CentOS 7 ships with the RPM php-mysql (which we have installed) and the<br>
separate RPM php-mysqlnd (which we don't have installed).<br>
<br>
You cannot install both at the same time.<br>
<br>
If php-mysqlnd is installed, it switches to the MySQL libraries that are<br>
built into PHP directly. And it does so consistently for all MySQL<br>
related drivers:<br>
<br>
- PDO MySQL<br>
- MySQLi<br>
- MySQL (which will use MySQLnd instead then)<br>
<br>
I just tested this and my OpenCart v2.3.0.2 test install with MySQLi<br>
support use to throw header errors with php-mysql. But now with<br>
php-mysqlnd it just works fine without complaining.<br>
<br>
I'm now trying to figure out how we get 5209R from php-mysql to<br>
php-mysqlnd without creating a dependency mess.<br>
<br>
As for third party PHP packages from the shop? I'll recompile all with<br>
MySQLnd support as well.<br>
<br>
I should have something ready by later today.<br>
<div class="HOEnZb"><div class="h5"><br>
--<br>
With best regards<br>
<br>
Michael Stauber<br>
______________________________<wbr>_________________<br>
Blueonyx mailing list<br>
<a href="mailto:Blueonyx@mail.blueonyx.it">Blueonyx@mail.blueonyx.it</a><br>
<a href="http://mail.blueonyx.it/mailman/listinfo/blueonyx" rel="noreferrer" target="_blank">http://mail.blueonyx.it/<wbr>mailman/listinfo/blueonyx</a><br>
</div></div></blockquote></div><br></div>