| |
Posted on October, 19 2017 - 11:08 AM |
Morning All,
My Hosting company have made some upgrades and are now using mariadb in place of Mysql.
Before the upgrade, my site was working perfectly well. After the upgrade is does not - it says there is a timeout http error 500.
The response from their support is -
Hi,
We have already increased the max execution time to 120 seconds, fairly higher value. You script is still timing out and causing the error. Please have your developer look in to this.
Any thoughts are appreciated.
Kindest Regards,
Mike Allison |
| |
| |
| | | |
|
| | |
| |
Posted on October, 19 2017 - 12:31 PM |
| |
| |
| | | |
|
| | |
| |
Posted on October, 19 2017 - 2:00 PM |
Hi Paulo,
Thanks for your reply.
I Read the docs and I don't have -
MyConnection..Provider = hNativeAccessMariaDB as an option.
I am using WB20. Is there a patch to allow this? I used to use hNativeAccessMysql
Any help appreciated.
Thanks,
Mike Allison |
| |
| |
| | | |
|
| | |
| |
Posted on October, 19 2017 - 3:16 PM |
Hi Mike,
If I remember correctly, and as MariaDB is coming from MySQL, it did work in the past (before they made a mariaDB native access) with the mysql native access against a MariaDB server.
Again, If I remember correctly, it was a question of using the right MySQL client dll (not the most recent ones, but a version that dated from before the MariaDB branch). My understanding is that it worked because of backward compatibility concerns on the MariaDB side.
So in your case, if you cannot switch to 22, then trying out older client dlls -MAY- be a solution.
Best regards |
| |
| |
| | | |
|
| | |
| |
Posted on October, 19 2017 - 3:49 PM |
| |
| |
| | | |
|
| | |
| |
Posted on October, 19 2017 - 4:31 PM |
Hi Paulo / Fabrice,
I have downloaded the connector and installed. I have also checked to make sure that I hadn't missed any patches.
I am going to install the connector again and reboot the machine to see if it makes any difference.
I will let you know how I get on.
Mike |
| |
| |
| | | |
|
| | |
| |
Posted on October, 19 2017 - 9:54 PM |
Hi All,
Still not working!
I have deleted the analysis and tried to reinstall. I get Error 27
In the "Connections Defined in the Analysis" MariaDB is not installed. I have installed the connector 3 times and it says that it is successful.
What is the name of the dll and where do I find it to check AND How do I manually force installation?
TIA
Mike |
| |
| |
| | | |
|
| | |
| |
Posted on October, 20 2017 - 5:56 AM |
Hello,
You didn't forget to insert also the Client layer of MariaDB (libmariadb.DLL file) ?
The instructions are at :http://doc.windev.com/en-US/…[/url]
Hope this helps.
Regards,
Guy |
| |
| |
| | | |
|
| | |
| |
Posted on October, 20 2017 - 7:52 AM |
Hi Mike,
There 's no issue even if you use mysql native to connect to mariadb .
I have program develop using WD12 connect to mariadb 10.3.x run without any problem
even though the libmysqldb.DLL is very old version .
your problem may on other parts. |
| |
| |
| | | |
|
| | |
| |
Posted on October, 20 2017 - 11:18 AM |
Hi Guys,
I have passed this to my ISP.
They upgraded to MariaDB from MySQL when it was sold to Oracle and they are making changes.
Mike |
| |
| |
| | | |
|
| | |