Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
3
Erster Beitrag:
vor 9 Monaten, 1 Woche
Letzter Beitrag:
vor 9 Monaten, 1 Woche
Beteiligte Autoren:
Julio Cesar, kingdr

Error with WD Linux app and MySQL

Startbeitrag von Julio Cesar am 14.02.2017 13:56

Hi

My linux windev 20 application can not access a mysql database. I'm already install the linux driver for mysql and my SO is Ubuntu 16.04 64.

Here is the error:


The '%1' control cannot be initialized, the following HFSQL error occurred:
=============================
%2
=============================

----- Technical Information -----

Project : default

What happened?
The '%1' control cannot be initialized, the following HFSQL error occurred:
=============================
%2
=============================

Error code: 10085
Level: fatal error (EL_FATAL)
WD55 error code: 3001

Dump of the error of 'wd200obj64.so' module (20.0.327.5).
Identifier of detailed information (.err): 10085
Debugging information:
IEWDMSQL=101.23
Module=
Version=
Additional Information:
EIT_NATIVECODE :
EIT_LOGICALTABLENAME :

----- Sub-error #1 -----

What happened?
The following error was returned by the database:
Error number = .
Error message:
Client does not support authentication protocol requested by server; consider upgrading MySQL client

Error code: 22
Level: fatal error (EL_FATAL)

Dump of the error of 'wd200msql64.so' module (20.0.10.0).
Identifier of detailed information (.err): 22
Debugging information:
IEWDMSQL=101.16
Module=
Version=
Client layer: /home/jcesar/Documentos/Exe/infonet_linux
Provider: WinDevMySQL
User: root
Data source: XX.XXX.XX.XXX
Database: infonet
Connection time-out: 30
Command time-out: 30
Unicode supported: 1
Page code of WL: 1252
Page code of the connection: 1252
Additional Information:
EIT_BASECODE :
EIT_INFOCLIENT :

Antworten:

Hi

I'm working fine with version 21 with u1604.01 linux 64-bit server.

It's file access right issue, pls check carefully.

I suggest that you should use version 21 for hfSql and mySql and it's backward compatible
and it's all free.

Beside, you should install as below:

sudo apt-get update
sudo apt-get install gufw

then click Preference>Firewall configuration (if it is LXDE theme)

and open the port 3306 in/out as mysql default.

Simplest thing also to download mySql workbench in server to see if
it works then install mySql workbench in client side and you must also
open port 3306 in your router allowing incoming/out going in this case.

Also you may you wdsql64.exe or wdsql.exe to test around if you
don't have mySqlworkbench installed in client windows/linux w/s.
(just use your public ip instead of xxx.xxx.xxx.xxx,3306 if you
are using native mySql driver from windev).

Good luck

HTH

King

von kingdr - am 14.02.2017 16:01
Thanks for the reply, King.

I create a user with a blank password and works. Is not the best choice, but is better than upgrade my windev to version 21.

von Julio Cesar - am 14.02.2017 23:08
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.