Page 1 of 3

falta libreria hbmysql

Posted: Mon Mar 08, 2021 5:44 pm
by edufloriv
Saludos amigos,

Por fin pude construir HMG 3.5 a 64 bits y pude construir el compilador gracias a una distribución que descargue de aqui del foro.

El tema ahora es que al tratar de compilar un proyecto que tengo sobre MySql me lanza error:
D:\MySQL\InfoFarmaMySQL>C:\HMG35\BUILD64 INFOFARMA
Harbour 3.2.0dev (r1604201603)
Copyright (c) 1999-2016, http://harbour-project.org/
C:/Users/User/AppData/Local/Temp/hbmk_v4bk6e.dir/INFOFARMA.o:INFOFARMA.c:(.data+0x1a70): undefined reference to `HB_FUN_TMYSQLSERVER'
collect2.exe: error: ld returned 1 exit status
hbmk2: Error: Ejecutando enlazador. 1
gcc.exe C:/Users/User/AppData/Local/Temp/hbmk_v4bk6e.dir/INFOFARMA.o C:/Users/User/AppData/Local/Temp/hbmk_v4bk6e.dir/hbmk_n10k68.o D:/MySQL/InfoFarmaMySQL/_temp.o -pthread -static-libgcc -static-libstdc++ -static -lpthread -mwindows -Wl,--start-group -l"hmg-64" -l"crypt-64" -l"edit-64" -l"editex-64" -l"graph-64" -l"ini-64" -l"report-64" -l"hfcl-64" -lmsvfw32 -lvfw32 -l"hbvpdf-64" -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lhbodbc -lodbc32 -lhbhpdf -lhbnetio -lxhb -lpng -llibhpdf -lhbzebra -lhbextern -lhbdebug -lhbvmmt -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib -Wl,--end-group -oINFOFARMA.exe -L"C:/HMG35/harbour-64/lib/win/mingw64" -L"C:/HMG35/lib-64"

hbmk2: Sugerencia: Instala el paquete hbmysql y añade la opción 'hbmysql.hbc'
para la(s) funcion(es) que falta(n): TMySQLServer()

El mensaje es claro, esta faltando un paquete. Cuando comparo mi version 3.4 (HARBOUR\CONTRIB) con la nueva 3.5 (HARBOUR-64\CONTRIB) efectivamente no existe la carpeta hbmysql:

hbmysql.png
hbmysql.png (196.67 KiB) Viewed 4349 times

¿ Donde consigo el paquete para 64bits para esta libreria ?

De antemano muchas gracias por su tiempo.

Cordiales saludos

Re: falta libreria hbmysql

Posted: Mon Mar 08, 2021 6:07 pm
by martingz
Eduardo date una vuelta por http://whosaway.com/
tienes que pedir acceso pero te lo da rapido

saludos

Re: falta libreria hbmysql

Posted: Mon Mar 08, 2021 8:01 pm
by danielmaximiliano
Copia la carpeta , contruye la librería de nuevo, recuerda tener instalado los fuentes de Mysql

Re: falta libreria hbmysql

Posted: Tue Mar 09, 2021 8:27 am
by serge_girard
HMG 3.5 + 64 bit + MySQL: misery .... !

Serge

Re: falta libreria hbmysql

Posted: Fri Mar 26, 2021 8:45 am
by joerg
Hi guys :D ,

"HMG 3.5 + 64 bit + MySQL: misery .... !"
Unfortunately I have to agree with Serge.

HMG is a really good development environment and I'm loving Harbour programming language - it's much better then most programming languages I've got experience with.
As a sideline to my main job as SAP consultant and ABAP programmer I've developed an ERP and CRM system "WENE" in HMG based on a Harbour solution. This ERP system relies 100 % on mySQL and I put a lot of effort to enhance an existing object oriented mySQL interface provided by Maurilio Longo. As of today I put an effort of 4351 hours into this ERP system which is (unfortunately) only productive once. This is mostly due to the fact that I haven't got much time to push it (I'm quite busy with SAP jobs ...).

The next project is a WooCommerce WebShop integration / interfaces to WooCommerce and enhancement of WooCommerce with a generic product configuration like already programmed in HMG for WENE.
Since WooCommerce is based on mySQL (like most of the Web), with the extended mySQL interface I have a good tool to program interfaces.

With HMG I'm unfortunately stock with mySQL Server 5.6.
I tried to install mySQL Server 8.0.20 but failed to make it work with HMG because I couldn't find a 32 bit libmysql.dll library file for it - so I had to fall back on mySQL Server 5.6.
I didn't check on MySQL Community Server 8.0.23 but I fear nothing has changed.

I failed to compile WENE with HMG 3.5 both in 32 and 64 bit after spending hours trying.
Main reason: Missing mySQL and OpenSSL integration (I need OpenSSL for a digital signature thing which is a legal requirement in Austria - "Registrierkassenpflicht")

ANYHOW THERE IS NO WAY AROUND GOING 64-BIT TO HAVE A LONG TERM PERSPECTIVE!

I want to provide WENE as open source software to the world, too.
It has a generic .DBF to mySQL interface to move data once before productive start. It is a powerful, multi language (currently English and German) ERP system with tons of functionality ranging from MRP to generic product configuration, a WENE application builder to build the backbone of mySQL based applications without coding, an outbound e-mail client, a script language WENEscript to create forms, reports and labels, etc. ...
And hopefully in about a year I'll have WENE integrated with the worldwide most popular open source webshop solution WooCommerce ...

I really wish you could provide a 64-BIT only HMG release with integrated OpenSSL and mySQL libraries working with the latest MySQL Community Server 8.0.23.!

And I promise to provide WENE as open source (GNU licenced) ERP and CRM system with WooCommerce interfaces all coded in HMG ...

Thanks to all - you are doing a great job!

Re: falta libreria hbmysql

Posted: Fri Mar 26, 2021 10:42 am
by serge_girard
Joerg,

Yes it is really frustating to see "HMG 3.5 + 64 bit + MySQL: misery .... !"
I will stick to old 32bits and HMG3.4...

Serge

Re: falta libreria hbmysql

Posted: Fri Mar 26, 2021 11:05 am
by danielmaximiliano
Buen dia Muchachos
el dia de hoy baje las 2 versiones de instalador MySQL Installer 8.0.23 desde https://dev.mysql.com/downloads/windows ... r/8.0.html
Sin título-1.png
Sin título-1.png (37.67 KiB) Viewed 3448 times
en cualquiera de ellos al intentar usar cualquiera de las opciones de instalacion me dice que no estan los paquetes, supongo que si descargo el MSI de 422 megabits debe minimo tener la instalacion de Cliente con su respectivo conector
2021-03-26 08_01_16-Window.png
2021-03-26 08_01_16-Window.png (12.72 KiB) Viewed 3448 times
hago algo mal ?

Re: falta libreria hbmysql

Posted: Fri Mar 26, 2021 11:27 am
by Claudio Ricardo
Hola... Yo uso MariaDB Server, viene con Heidi y todos los .dll conectores (dentro de la carpeta del Heidi)
Para total compatibilidad con MySQL usar la versión 5.5.68 sólo 50 mb. el .msi... Cero problemas y todo free...

Re: falta libreria hbmysql

Posted: Fri Mar 26, 2021 1:15 pm
by jayadevu
Hi,

Please look into SQLMIX Rdd, which is native to Harbour and an excellent tool to communicate with wide variety of RDMS including MYSQL,MSSQL etc. The query execution is very fast.

I am efficiently using it to communicate with MYSQL 8.0.23 (64 bits) using 32 bits program based on HMG and MiniGui Extended.

HTH,

Warm regards,

Jayadev

Re: falta libreria hbmysql

Posted: Fri Mar 26, 2021 8:07 pm
by Ismach
A tener en cuenta amigos, como Mariadb se desligo de algunas partes NO GPL que solia tener Mysql en sus inicios a partir de Mariadb version 10 dejo de incorporar algunos gestores internos de almacenamiento e indexacion y tambien dejo de incorprar libmysql.Dll y la reemplazo por LibMariadb.dll pero internamente tambien cambio de manera que no tenemos la libmariadb.a ni libmariadb.lib para HMG si usamos Mariadb 10, yo ya lo habia comentado antes.
Saludos