I have just update my fpc to v2.2.0 under fedora 7. But error occured while compile program that uses mysql4, "lmysqlclient not found". Even after make symbolic link to /usr/lib/mysql/...I have no idea why this always happen again every migrate. Thanks

____________________________________________________________________________________ Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/

Op donderdag 20-09-2007 om 15:24 uur [tijdzone -0700], schreef Andi Purwito:

I have just update my fpc to v2.2.0 under fedora 7. But error occured while compile program that uses mysql4, "lmysqlclient not found". Even after make symbolic link to /usr/lib/mysql/...I have no idea why this always happen again every migrate. Thanks

I had the same problem yesterday. And it has to do with Fedora 7. Some ppl thought that it would be a good idea to supply two versions of the mysql-client. Version 3 and 4.1.

Obviously, both versions need a different name, so they supplied libmysqlclient14.so and libmysqlclient11.so. But not a 'default' libmysqlcient.so...

Adding a link should solve this. That it didn't work for you is most probable because you made the link in /usr/lib/mysql. Place a link in /usr/lib or run /sbin/ldconfig after you made the link.

btw: why do you still use programs which use mysql4? Maybe you'd better use mysql41dyn.

My question now is: how do other programs on Fedora handle this? How do they now which libmysqlclient.so to use? Does anybody know that?

Joost.

Or try

-XLAmysqlclient=mysqlclient14

My question now is: how do other programs on Fedora handle this? How do they now which libmysqlclient.so to use? Does anybody know that?

They don't. Manually patching and adapting for every distro, messing with scripts (see our steadily increasing install.sh) and other workarounds at best.

Sorry, i mean that i have made a symbolic link to /usr/lib/mysql/libmysqlclient_r.so.15.0.0 as lmysqlclient. But compiler said lmysqlclient not found. And then in separately, another one to /usr/lib/mysql/libmysqlclient.so.15.0.0, there's still not found. Until final i am confused because there are too many lmysqlclient.* that i don't know which the default is. These are files in my /usr/lib/mysql:

-rw-r--r-- 1 root root 12218 2007-03-30 06:44 libdbug.a -rw-r--r-- 1 root root 50516 2007-03-30 06:44 libheap.a -rw-r--r-- 1 root root 376560 2007-03-30 06:44 libmyisam.a -rw-r--r-- 1 root root 30506 2007-03-30 06:44 libmyisammrg.a -rw-r--r-- 1 root root 1638736 2007-03-30 06:44 libmysqlclient.a -rw-r--r-- 1 root root 1650150 2007-03-30 06:44 libmysqlclient_r.a lrwxrwxrwx 1 root root 26 2007-09-18 15:34 libmysqlclient_r.so -> libmysqlclient_r.so.15.0.0 lrwxrwxrwx 1 root root 26 2007-09-11 23:35 libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0 -rwxr-xr-x 1 root root 1459164 2007-03-30 06:44 libmysqlclient_r.so.15.0.0 lrwxrwxrwx 1 root root 24 2007-09-18 15:34 libmysqlclient.so -> libmysqlclient.so.15.0.0 lrwxrwxrwx 1 root root 24 2007-09-11 23:35 libmysqlclient.so.15 -> libmysqlclient.so.15.0.0 -rwxr-xr-x 1 root root 1450644 2007-03-30 06:44 libmysqlclient.so.15.0.0 -rw-r--r-- 1 root root 1363940 2007-03-30 06:44 libmystrings.a -rw-r--r-- 1 root root 324994 2007-03-30 06:44 libmysys.a -rw-r--r-- 1 root root 15068 2007-03-30 06:44 libvio.a -rwxr-xr-x 1 root root 12394 2007-03-30 06:43 mysqlbug -rwxr-xr-x 1 root root 5449 2007-03-30 06:43 mysql_config

My question is how to make all of these simply, maybe for the next FPC version? I always found the same "...not found" error every upgrade to newest FPC. How if these complication made more user friendly?

---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more.

Andi Purwito wrote

Sorry, i mean that i have made a symbolic link to /usr/lib/mysql/ libmysqlclient_r.so.15.0.0 as lmysqlclient.

You should not make these symlinks manually. These should be made automatically when installing the "-dev" versions of the rpm/deb/ whatever packages you use. This does not just go for MySQL by the way, but for /any/ package you may want to use with fpc/gcc/gpc/<any compiler> under *nix.

Jonas

I've found how Fedora handles this:

edit /etc/ld.so.conf.d/mysqlclient14-i386.conf (-x86_64 for 64 bit) and change it to (for example) /lib/mysql4/mysql

Then run ldconfig.

If you want to link statically, you'll need the -dev-package. Note that this has nothing to do with fpc, but it's a fedora in combination with mysql-history/license-issue.

Joost.

Op maandag 24-09-2007 om 19:37 uur [tijdzone -0700], schreef Andi Purwito: