topic Re: compile C program static, mysql in Operating System - Linux

compile C program static, mysql

Pohling — Thu, 23 Nov 2006 10:45:01 GMT

Hello,

I'm writing a MySql Client for HPUX 11.11.
When I compile it dynamicly it all works fine.
But I need to compile it static because I want to use the same binaries on different systems without installing the mysql-API.
So I tried to compile it this way:

cc -noshared mysql-statement-send.c -o outputBinaary -I'/opt/mysql/include/mysql' -L'/opt/mysql/lib/mysql' -lmysqlclient -lcrypt -lnsl -lm

This is the errormessage I get:
/usr/ccs/bin/ld: Unsatisfied symbols:
shl_load (code)
shl_findsym (code)

How can I avoid this problem?

Thank you,
Matthias

Re: compile C program static, mysql

Peter Nikitka — Thu, 23 Nov 2006 17:11:02 GMT

Hi,

to create a runnable executable on another system without a mySQL-API installation (does this make sense?), there is no need to link a fully archived version. Just use the shared version of the mysql library and use the default (shared libs) for the rest of the libraries, e.g.:

cc mysql-statement-send.c -o outputBinaary -I'/opt/mysql/include/mysql' -L'/opt/mysql/lib/mysql' -Wl,-a,archive -lmysqlclient -Wl,-a,default -lcrypt -lnsl -lm

mfG Peter
PS: Untested

Re: compile C program static, mysql

Pohling — Fri, 24 Nov 2006 04:18:23 GMT

Great!!!
Now it works fine.

Now I understand also the difference between static and dynamic libraries. I always thought, that I have to make them static to get an portable binary but it's all about archives. xD

Matthias Pohling