Using MySQL libraries for a client app

2005-08-19 Thread Steven Altsman

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

2005-08-19 Thread Steven Altsman

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]