Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
10
Erster Beitrag:
vor 7 Monaten
Letzter Beitrag:
vor 7 Monaten
Beteiligte Autoren:
cardcoder, Paulo Oliveira, ccc2, Fabrice Harari, Guy F.

WB20 Maria DB Connection

Startbeitrag von cardcoder am 19.10.2017 09:08

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

Antworten:

Did you change your app to use the mariadb native access instead of the mysql native access?

https://doc.windev.com/en-US/?1000021527

von Paulo Oliveira - am 19.10.2017 10:31
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

von cardcoder - am 19.10.2017 12:00
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

von Fabrice Harari - am 19.10.2017 13:16
Mariadb native access is available for V20 as far i can see in the download page.
I don't have v20 installed, i can't check if it works.

http://www.windev.com/ts/download/webdev20/index.html

von Paulo Oliveira - am 19.10.2017 13:49
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

von cardcoder - am 19.10.2017 14:31
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

von cardcoder - am 19.10.2017 19:54
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/?1000021527[/url]
Hope this helps.

Regards,
Guy

von Guy F. - am 20.10.2017 03:56
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.

von ccc2 - am 20.10.2017 05:52
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

von cardcoder - am 20.10.2017 09:18
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.