Using MySQL libraries for a client app
checking for mysql_init in -lmysqlclient... yes checking whether mysql clients can run... no configure: error: Your MySQL client libraries aren't properly installed I'm a bit confused. It is able to do mysql_init() and gets a response, but when it checks the libmysqlclient.so it doesn't work. I've gone to the custom directory that I have it installed in (/usr/local/mysql/lib) and tried running libmysqlclient.so and I get a segmentation fault. Would it be a matter of permissions for the ./configure, the $LDFLAGS variable, or something else that I am missing? I've looked at the PureFTP archives and they aren't particularly helpful, so I tried the MySQL archives to see if there is a problem with the shared libraries. I did a search for pureftp, pure-ftpd, pure-ftp, Your MySQL client libraries aren't properly installed, checking whether mysql clients can run... no, and no useful results. I've also google'd those errors and got between 5 and 10 responses, of which most are in Chinese, Japanese, Swedish, German, and Russian. My english is already bad enough and I'm a Texan. All of the packages I'm installing are compiled from source, so RPMs are not as much of an issue. I've done RPMs before, but they don't always set them up the way I like. Also, this is for my developer box, because I have a lot of projects that either require or will require database hooks. The config that I used for MySQL 5.0 is: ./configure --prefix=/usr/local/mysql \ --with-unix-socket-path=/var/lib/mysql/mysql.sock \ --with-tcp-port=3306 \ --with-mysqld-user=mysql \ --with-openssl=/usr/local/openssl \ --with-openssl-includes=/usr/local/openssl/includes \ --with-openssl-libs=/usr/local/openssl/libs \ --with-big-tables \ --with-berkeley-db=/usr/local/bdb \ --with-berkeley-db-includes=/usr/local/bdb/includes \ --with-berkeley-db-libs=/usr/local/bdb/libs \ --with-example-storage-engine \ --with-archive-storage-engine \ --with-csv-storage-engine \ --with-blackhole-storage-engine \ --with-ndbcluster \ --with-ndb-test \ --with-ndb-docs \ --with-ndb-port \ --with-ndb-port-base \ --with-federated-storage-engine I've also done a side-by-side thinking it might be the client is incompatible so did MySQL 4.0 ./configure --prefix=/usr/local/mysqlclient \ --without-server I've specified for the environment variables: $LDFLAGS='-L/usr/local/mysql/include/ -L/usr/local/mysql/lib/mysql/lib -L/usr/local/mysql/libexec/ -L/usr/local/mysql/' then $LDFLAGS='-L/usr/local/mysqlclient/include/ -L/usr/local/mysqlclient/lib/mysql/lib -L/usr/local/mysqlclient/libexec/ -L/usr/local/mysqlclient/' Am I wasting my (and your) time posting this here, or is it really something with the MySQL client libraries? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Using MySQL libraries for a client app
Argh.. I'm stupid. http://64.233.161.104/search?q=cache:hzZrZNEtu6wJ:jim.3tchina.com/tech/ftp/0 40607_pureftpd_mysql.php+%22Your+MySQL+client+libraries+aren%27t+properly+in stalled%22hl=en%20target=nw cp /usr/local/mysql/lib/mysql/* /usr/lib Please disregard. 3 For China :D -Original Message- From: Steven Altsman [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 11:37 AM To: 'mysql@lists.mysql.com' Subject: Using MySQL libraries for a client app checking for mysql_init in -lmysqlclient... yes checking whether mysql clients can run... no configure: error: Your MySQL client libraries aren't properly installed I'm a bit confused. It is able to do mysql_init() and gets a response, but when it checks the libmysqlclient.so it doesn't work. I've gone to the custom directory that I have it installed in (/usr/local/mysql/lib) and tried running libmysqlclient.so and I get a segmentation fault. Would it be a matter of permissions for the ./configure, the $LDFLAGS variable, or something else that I am missing? I've looked at the PureFTP archives and they aren't particularly helpful, so I tried the MySQL archives to see if there is a problem with the shared libraries. I did a search for pureftp, pure-ftpd, pure-ftp, Your MySQL client libraries aren't properly installed, checking whether mysql clients can run... no, and no useful results. I've also google'd those errors and got between 5 and 10 responses, of which most are in Chinese, Japanese, Swedish, German, and Russian. My english is already bad enough and I'm a Texan. All of the packages I'm installing are compiled from source, so RPMs are not as much of an issue. I've done RPMs before, but they don't always set them up the way I like. Also, this is for my developer box, because I have a lot of projects that either require or will require database hooks. The config that I used for MySQL 5.0 is: ./configure --prefix=/usr/local/mysql \ --with-unix-socket-path=/var/lib/mysql/mysql.sock \ --with-tcp-port=3306 \ --with-mysqld-user=mysql \ --with-openssl=/usr/local/openssl \ --with-openssl-includes=/usr/local/openssl/includes \ --with-openssl-libs=/usr/local/openssl/libs \ --with-big-tables \ --with-berkeley-db=/usr/local/bdb \ --with-berkeley-db-includes=/usr/local/bdb/includes \ --with-berkeley-db-libs=/usr/local/bdb/libs \ --with-example-storage-engine \ --with-archive-storage-engine \ --with-csv-storage-engine \ --with-blackhole-storage-engine \ --with-ndbcluster \ --with-ndb-test \ --with-ndb-docs \ --with-ndb-port \ --with-ndb-port-base \ --with-federated-storage-engine I've also done a side-by-side thinking it might be the client is incompatible so did MySQL 4.0 ./configure --prefix=/usr/local/mysqlclient \ --without-server I've specified for the environment variables: $LDFLAGS='-L/usr/local/mysql/include/ -L/usr/local/mysql/lib/mysql/lib -L/usr/local/mysql/libexec/ -L/usr/local/mysql/' then $LDFLAGS='-L/usr/local/mysqlclient/include/ -L/usr/local/mysqlclient/lib/mysql/lib -L/usr/local/mysqlclient/libexec/ -L/usr/local/mysqlclient/' Am I wasting my (and your) time posting this here, or is it really something with the MySQL client libraries? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using MySQL libraries for a client app
Steven Altsman wrote: checking whether mysql clients can run... no configure: error: Your MySQL client libraries aren't properly installed Read through config.log to see what test was tried, and how it failed. I've looked at the PureFTP archives and they aren't particularly helpful I take it the configure script output above is from the PureFTP package? If so, you really should take this up on their mailing list. Each package tests for required libraries in a slightly different way, so you need some package-specific expertise here. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using MySQL libraries for a client app
Steven Altsman wrote: cp /usr/local/mysql/lib/mysql/* /usr/lib No no no! There are several better options: 1. Add /usr/local/mysql/lib/mysql to your system's dynamic loader configuration. On Linux, for instance, this is /etc/ld.so.conf; you need to run ldconfig after changing that file. 2. Apparently you've installed MySQL from source. Reconfigure it to install the library file in /usr/lib, if that's what you want. Say ./configure --help and read. 3. The ProFTPD configure script may have flags you can pass to tell it where MySQL is. If not, you should send them a patch to add it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
