Install issues on Windows Server 2022 - undefined references

[geekdad1]

DBD::mysql version

5.010

MySQL client version

No response

Server version

Windows server 2022

Operating system version

Server 2022

What happened?

Trying to create a mysql client on a server that does not have mysql installed on it. I've copied the lib and include folders from the server and put them on this machine so that the installation will at last compile.
I'm using the following command to create the makefile:

`perl MakeFile1.pl --cflags="-Ic:\mysql\install\include -Lc:\mysql\install\lib -lmysqlclient" --mysql_config=c:\mysql\install --libs=-Lc:\mysql\install\lib

when I run gmake I get the following (shortened) result. So I'm not sure what else I'm missing. Any help is appreciated.

"C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- mysql.bs blib\arch\auto\DBD\mysql\mysql.bs 644
g++ mysql.def -o blib\arch\auto\DBD\mysql\mysql.xs.dll -shared -s -L"C:\STRAWBERRY\perl\lib\CORE" -L"C:\STRAWBERRY\c\lib" -L"C:\STRAWBERRY\c\x86_64-w64-mingw32\lib" -L"C:\STRAWBERRY\c\lib\gcc\x86_64-w64-mingw32\13.2.0" dbdimp.o mysql.o socket.o "C:\STRAWBERRY\perl\lib\CORE\libperl540.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libmoldname.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libkernel32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libuser32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libgdi32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libwinspool.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libcomdlg32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libadvapi32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libshell32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libole32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\liboleaut32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libnetapi32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libuuid.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libws2_32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libmpr.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libwinmm.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libversion.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libodbc32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libodbccp32.a" "C:\STRAWBERRY\c\x86_64-w64-mingw32\lib\libcomctl32.a" -Wl,--enable-auto-image-base
C:/Strawberry/c/bin/../lib/gcc/x86_64-w64-mingw32/13.2.0/../../../../x86_64-w64-mingw32/bin/ld.exe: dbdimp.o: in function mysql_dr_connect': C:/Perl64/cpan/build/DBD-mysql-5.010-0/dbdimp.c:1208:(.text+0xa74): undefined reference to mysql_server_init'
C:/Strawberry/c/bin/../lib/gcc/x86_64-w64-mingw32/13.2.0/../../../../x86_64-w64-mingw32/bin/ld.exe: C:/Perl64/cpan/build/DBD-mysql-5.010-0/dbdimp.c:1209:(.text+0xa81): undefined reference to mysql_init' C:/Strawberry/c/bin/../lib/gcc/x86_64-w64-mingw32/13.2.0/../../../../x86_64-w64-mingw32/bin/ld.exe: C:/Perl64/cpan/build/DBD-mysql-5.010-0/dbdimp.c:1231:(.text+0xb48): undefined reference to mysql_options'
,,,

`

Other information

No response

[dveeden]

What versions of Perl, DBD::mysql, MySQL, etc are you using?
Copying lib and include might not be sufficient and might also run into issues if Perl and MySQL aren't using the same compiler, the same compiler version and the same compiler options.

There is some info on https://dev.mysql.com/doc/c-api/8.4/en/c-api-building-clients.html that might be useful

[geekdad1]

Strawberry perl 5.40.0.1 DBD::mysql 5-010 MySql: 8.0.39 Community What is in the mysql-config file? Is it just the my.ini file? It seems to imply that it's a program, but one I don't have on any of my systems. Doug Poulin Chief Technology Officer Medinet Health Systems, Inc. Voice: 604-742-8845 Support: 604-737-1477 Toll free:800-737-3771 From: Daniël van Eeden ***@***.***> Sent: Sunday, December 15, 2024 11:39 PM To: perl5-dbi/DBD-mysql ***@***.***> Cc: Doug Poulin ***@***.***>; Author ***@***.***> Subject: Re: [perl5-dbi/DBD-mysql] Install issues on Windows Server 2022 - undefined references (Issue #455) What versions of Perl, DBD::mysql, MySQL, etc are you using? Copying lib and include might not be sufficient and might also run into issues if Perl and MySQL aren't using the same compiler, the same compiler version and the same compiler options. There is some info on https://dev.mysql.com/doc/c-api/8.4/en/c-api-building-clients.html that might be useful - Reply to this email directly, view it on GitHub<#455 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ACWG55H2MYKSJOC3CBOO2RL2FZ7S5AVCNFSM6AAAAABTVGQ4AOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKNBUHAYTGNZTGE>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

[dveeden]

On Linux and most other systems mysql_config is a tool that is part of the MySQL development installation and returns the flags that should be used to compile programs that use MySQL.

$ mysql_config
Usage: /usr/bin/mysql_config-64 [OPTIONS]
Compiler: GNU 14.2.1
Options:
        --cflags         [-I/usr/include/mysql -m64 ]
        --cxxflags       [-I/usr/include/mysql -m64 ]
        --include        [-I/usr/include/mysql]
        --libs           [-L/usr/lib64/mysql -lmysqlclient -lz  -lssl  -lcrypto -lresolv -lm]
        --libs_r         [-L/usr/lib64/mysql -lmysqlclient -lz  -lssl  -lcrypto -lresolv -lm]
        --plugindir      [/usr/lib64/mysql/plugin]
        --socket         [/var/lib/mysql/mysql.sock]
        --port           [0]
        --version        [9.1.0]
        --variable=VAR   VAR is one of:
                pkgincludedir [/usr/include/mysql]
                pkglibdir     [/usr/lib64/mysql]
                plugindir     [/usr/lib64/mysql/plugin]
$ mysql_config --cflags --libs
-I/usr/include/mysql -m64 
-L/usr/lib64/mysql -lmysqlclient -lz  -lssl  -lcrypto -lresolv -lm
$ rpm -qf $(which mysql_config)
mysql-community-devel-9.1.0-10.fc41.x86_64

On Windows mysql_config is not part of MySQL, but is a simple batch file that Strawberry Perl ships to allow you to compile things against the MySQL client library that it ships.

However the MySQL client library that Strawberry Perl ships is based on MySQL 5.7.x last time I checked and MySQL 5.7 is EOL and too old for recent versions of DBD::mysql. It will probably work with the last v4.x version of DBD::mysql.

The file is here: https://github.com/StrawberryPerl/build-extlibs/blob/master/mysql.special/mysql_config.bat

[dveeden]

@geekdad1 could you have a look at this and see if that helps to get a working DBD::mysql installation?

[geekdad1]

That link was a great help. having a mysql_config.bat file went a long way toward solving the problem.

The other steps was I copied the mysql/lib and mysql/include folders off the server and put them on this server which got me through the compile errors. You need to run perl MakeFile.PL --mysql_config=c:\folderpath
to get that to work.
Lastly I had to copy the libmysql.dll to the c:\strawberry\c\bin folder in order to resolve a loader error when trying to connect to a database

[rripple]

Perl: 5.36.1
DBD-mysql: 5.013-3
MySql: 8.4.6 Community

This thread has helped me on move forward. It solved my missing references linker issues.
Now I have the following ..

../DBD-mysql-5.013-3/dbdimp.c:2856: undefined reference to `mysql_stmt_bind_named_param'
collect2.exe: error: ld returned 1 exit status

I know this is an older thread, but this information was great. If you could please advise, thanks.

[dveeden]

mysql_stmt_bind_named_param() was introduced to replace mysql_stmt_bind_param(). The latter is now deprecated as indicated in the table on https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-function-reference.html

Is this symbol listed in the library file that you are using? You probably have to change the command to the Windows equivalent.

$ objdump -T /usr/lib64/mysql/libmysqlclient.so.24 | grep mysql_stmt_bind
000000000000a840 g    DF .text	0000000000000011  libmysqlclient_24.0 mysql_stmt_bind_param
000000000000aa30 g    DF .text	0000000000000230  libmysqlclient_24.0 mysql_stmt_bind_result
000000000000a4c0 g    DF .text	0000000000000373  libmysqlclient_24.0 mysql_stmt_bind_named_param

(ChatGPT says something like dumpbin /EXPORTS libmysql.dll | findstr mysql_stmt_bind might work if you have Visual Studio installed)

Maybe you used the headers of MySQL 8.4, but are linking to MySQL 8.0 libraries?

[rripple]

MySQL 8.4.6 and 9.4.0 both failed looking for that function.
We backed up and went with 8.0.43 and it worked now. This is a closer match to MySQL on AWS Aurora also.

Thanks again!