HMGforum.com

EDK

Muchas gracias ya recompile bien tidi y ya no me da error.
Solo que ahora no me puedo conectar al servidor ni tampoco crear la base de datos ni tablas, tendré que ver como le hago,

¿Qué versión del servidor MySQL tienes?

Edward,

First compilation give this error:
I have this in my HBC-file:

I suppose C:\hmg.3.6\hmg64.hbc (P:\hmg.3.6\hmg64.hbc in my case) need some adjustments?

Serge

Edward, How about UNICODE? It got my program compiled (SSL stuff in REMARK) and now it works but my SQL results with french accents (ç .. ë è ..) are unreadable....

Serge

EDK

Realmente uso MARIADB 11.5

Jorge,
I think this will not be a problem!
Serge

jorge.posadas wrote: ↑Tue Nov 26, 2024 3:31 pm EDK

Realmente uso MARIADB 11.5

For the MariaDB server, you need to build hbmysql in a slightly different way.
Specify the location of the MariaDB SQL server installation instead of MySQL and use the libmariadb.dll library by renaming it to libmysql.dll
Here is configuration for MariaDB 11.5: Copy the c:\Program Files\MariaDB 11.5\lib\libmariadb.dll library to the folder where your application is located, renaming the file to libmysql.dll

serge_girard wrote: ↑Tue Nov 26, 2024 10:33 am Edward,

First compilation give this error:

Code: Select all

P:/hmg.3.6/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/13.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -lssl: No such file or directory
P:/hmg.3.6/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/13.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -lcrypto: No such file or directory

I have this in my HBC-file:

Code: Select all

libs=hbssl
libs=libeay32
libs=ssleay32

I suppose C:\hmg.3.6\hmg64.hbc (P:\hmg.3.6\hmg64.hbc in my case) need some adjustments?

Serge

Hi Serge.
There are no SSL libraries, so we have to build them. We proceed in a similar way as with hbmysql.

Preparing OpenSSL v.3:

Download the Win64 OpenSSL v3.4.0 EXE installer ( 64-bit! ) from the website https://slproweb.com/products/Win32OpenSSL.html
Run the downloaded installer and install OpenSSL to the C:\OpenSSL-Win64-3.4.0 folder, when asked where to copy the OpenSSL DLLS indicate "The OpenSSL binaries (/bin) directory"

Building the hbssl library:

As with the missing hbmysql, we need to have the harbour sources. The hbssl sources are located in the core-master\contrib\hbssl\ folder. Copy the hbssl folder to c:\hmg.3.6\harbour64\contrib\ (in your case it would be P:\hmg.3.6\harbour64\contrib\ )
In the copied folder, create a batch file build_hbssl.bat * in the HMGPATH variable we define the path where our HMG 3.6 is installed (in your case it would be P:\hmg.3.6)
* in the HB_WITH_OPENSSL variable we define the path where OpenSSL 3 is installed

Modification of hbssl.hbc for OpenSSL 3 library:

In OpenSSL 3 the names of the library files have changed, so you need to edit the file c:\hmg.3.6\harbour64\contrib\hbssl.hbc to the following notations: We build the hbssl library by running the build_hbssl.bat file.

That's all.

In this version of hbssl with OpenSSL 3, no external .dll libraries are required, because they are imported into the liblibcrypto-3-x64.a and liblibssl-3-x64.a libraries, so they will be included in the application executable

If you compile using an IDE, put the following in the configuration: or simpler, it is enough to do the following: (must be .hbc extension)

If you compile using a build64.bat, add the following to .hbp file in your project:

Thanks, this SSL-thing will be something for tomorrow...
Serge

Hola Colegas ! Estoy tratando de compilar en 64 bits, usando libmysql.dll, hice todos los paso del PDF para la integracion de MySQL con HMG 3.6., pero al compilar desde el IDE me sale este error :

hbmk2[Motel]: Warning: Cannot find hbmysql=hbmysql.hbc (referenced from
C:\hmg.3.6\hmg64.hbc)
hbmk2: Linking... Motel.exe
C:/hmg.3.6/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/13.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: .hbmk/win/mingw64/Main.o:Main.c:(.data+0xa30): undefined reference to `HB_FUN_TMYSQLSERVER'
collect2.exe: error: ld returned 1 exit status
hbmk2[Motel]: Error: Running linker. 1
gcc.exe .hbmk/win/mingw64/Main.o .hbmk/win/mingw64/Administracion.o .hbmk/win/mingw64/Caja.o .hbmk/win/mingw64/Configuracion.o .hbmk/win/mingw64/Inicio.o .hbmk/win/mingw64/Mucamas.o .hbmk/win/mingw64/Recepcion.o .hbmk/win/mingw64/Shared.o .hbmk/win/mingw64/_hbmkaut_Main.o C:/Work/temp/_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 -lsoftail -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 -lwinmm -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib -Wl,--end-group -oMotel.exe -LC:/hmg.3.6/harbour64/lib/win/mingw64 -L"C:/hmg.3.6/lib-64"

hbmk2: Hint: Add option 'hbmysql.hbc' for missing function(s): TMySQLServer()


le di varias vueltas, pero no consigo entender ......... Ayuda !

Saludos.