Having trouble connecting to MySQL 5.1 Server

[thaimann]

I have Lazarus 0.9.29 installed on a Fedora Core 12 Laptop, with Zeos 6.6.6 installed. What do I need to do to connect to a MySQL 5.1 Server?

I have gone in and added “/usr/lib/mysql to my path.

I have dropped a Zconnection on my form and set values for Database, user, & password.
I then set protocal to one of the following:

mysql
mysql-5
mysqld-5

and then tried to change Connected to true and got the following error messages.

mysql: None of the dynamic libraries can be found: libmysqlclient.so.15, libmysqlclient.so
mysql-5: None of the dynamic libraries can be found: libmysqlclient.so.15, libmysqlclient.so
mysqld-5: None of the dynamic libraries can be found: libmysqld.so

I don't know what is wrong., but I suspect that it is looking for a 5.0 server.

I am pretty sure that I have the correct libraries:

yum list installed | grep mysql
mysql.i686 5.1.42-7.fc12 @updates
mysql-embedded.i686 5.1.42-7.fc12 @updates
mysql-libs.i686 5.1.42-7.fc12 @updates
mysql-server.i686 5.1.42-7.fc12 @updates
php-mysql.i686 5.3.2-1.fc12 @updates
qt-mysql.i686 1:4.6.2-20.fc12 @updates

[marcov]

I think you also need mysql-dev or something similar. It provides the symlink for development.

If that doesn't solve it, it would be helpful to see what .so files exist in /usr/lib/mysql

Another thing you could try is set LD_LIBRARY_PATH to that dir.

[thaimann]

No, it said I already had it, I upgraded it anyway. I then retried my test which failed as previously described. Is there a way to test what paths the compiler sees. I have run a test to see if /usr/lib/mysql is in my path, which it is. But in the past I noted that Lazarus doesn't seem to have the same paths as my user does and was wondering if there was a way to see what it is. Well anyway, here is the output from my dir command:

ls -l /usr/lib/mysql
total 20600
-rw-r--r-- 1 root root 1704 2010-05-24 14:57 libdbug.a
-rw-r--r-- 1 root root 111898 2010-05-24 14:57 libheap.a
-rw-r--r-- 1 root root 516440 2010-05-24 14:57 libmyisam.a
-rw-r--r-- 1 root root 96874 2010-05-24 14:57 libmyisammrg.a
-rw-r--r-- 1 root root 1787660 2010-05-24 14:57 libmysqlclient.a
-rw-r--r-- 1 root root 1800900 2010-05-24 14:57 libmysqlclient_r.a
lrwxrwxrwx 1 root root 26 2010-07-30 11:10 libmysqlclient_r.so -> libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 root root 26 2010-07-25 19:38 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
-rwxr-xr-x 1 root root 1531076 2010-05-24 14:57 libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 root root 24 2010-07-30 11:10 libmysqlclient.so -> libmysqlclient.so.16.0.0
lrwxrwxrwx 1 root root 24 2010-07-25 19:38 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
-rwxr-xr-x 1 root root 1525280 2010-05-24 14:57 libmysqlclient.so.16.0.0
lrwxrwxrwx 1 root root 18 2010-02-20 16:28 libmysqld.so.0 -> libmysqld.so.0.0.1
-rwxr-xr-x 1 root root 8882504 2010-01-29 12:08 libmysqld.so.0.0.1
-rw-r--r-- 1 root root 1445228 2010-05-24 14:57 libmystrings.a
-rw-r--r-- 1 root root 422116 2010-05-24 14:57 libmysys.a
-rw-r--r-- 1 root root 1821650 2010-05-24 14:57 libndbclient.a
lrwxrwxrwx 1 root root 21 2010-07-30 11:10 libndbclient.so -> libndbclient.so.3.0.0
lrwxrwxrwx 1 root root 21 2010-07-25 19:38 libndbclient.so.3 -> libndbclient.so.3.0.0
-rwxr-xr-x 1 root root 1075896 2010-05-24 14:57 libndbclient.so.3.0.0
-rw-r--r-- 1 root root 18080 2010-05-24 14:57 libvio.a
-rwxr-xr-x 1 root root 13128 2010-05-24 14:57 mysqlbug
-rwxr-xr-x 1 root root 6356 2010-05-24 14:57 mysql_config
drwxr-xr-x 2 root root 4096 2010-07-25 19:38 plugin

[mdaems]

mysql: None of the dynamic libraries can be found: libmysqlclient.so.15, libmysqlclient.so
mysql-5: None of the dynamic libraries can be found: libmysqlclient.so.15, libmysqlclient.so
mysqld-5: None of the dynamic libraries can be found: libmysqld.so

I can only confirm this means the executable can't find the name files when searching for the libraries.

I see libmysqlclient.so is decalred in the list but I don't know why it can't be found by your program. Mayby adding a link in the directory of your projects executable could help.

Mark