open2300 and XAMPP

Question

Hi Kenneth,

thanks for your quick reply.

XAMPP is an apache-mysql-php-perl bundle. I did not install mysql using RPMs, but I guess mysql was installed including header files. XAMPP is by default installed in /opt/lampp

searching within this directory gave me:

apache:/opt/lampp # find . -name mysql
./bin/mysql
./lib/php/tests/DB/tests/mysql
./lib/mysql
./lib/perl5/site_perl/5.8.7/i686-linux/DBD/mysql
./lib/perl5/site_perl/5.8.7/i686-linux/auto/DBD/mysql
./var/mysql
./var/mysql/mysql
./share/mysql
./htdocs/support/vps/apache/database/mysql
./htdocs/support/mysql
./licenses/mysql

which of these files will I have to use in the Makefile instead of /usr/include/mysql and /usr/lib/mysql ?

The devel-packages were missing after I re-installed the XAMPP-Bundle. I fixed this problem and changed the Makefile to:

mysql2300:
        $(CC) $(CFLAGS) -o mysql2300 mysql2300.c rw2300.c linux2300.c $(CC_LDFLAGS) $(CC_WINFLAG) -I/opt/lampp/include/mysql -L/opt/lampp/lib/mysql -l/opt/lampp/lib/mysql/libmysqlclient.so.15
After executing mysql2300 I get: 


apache:/opt/lampp/htdocs/open2300-1.10 # make mysql2300
gcc -Wall -O3 -DVERSION=\"1.10\" -o mysql2300 mysql2300.c rw2300.c linux2300.c - lm  -I/opt/lampp/include/mysql -L/opt/lampp/lib/mysql -l/opt/lampp/lib/mysql/lib mysqlclient.so.15
/usr/lib/gcc-lib/i586-suse-linux/3.3.5/../../../../i586-suse-linux/bin/ld: cannot find -l/opt/lampp/lib/mysql/libmysqlclient.so.15
collect2: ld returned 1 exit status
make: *** [mysql2300] Error 1

Here's the content of the directory

apache:/opt/lampp/lib/mysql # ll
total 4622
drwxrwxr-x   2 root root     456 Oct 29 17:26 .
drwxr-xr-x  10 root root    6632 Oct 29 17:26 ..
-rw-r--r--   1 root root   11870 Oct 24 16:49 libdbug.a
-rw-r--r--   1 root root   45062 Oct 24 16:49 libheap.a
-rw-r--r--   1 root root  322168 Oct 24 16:49 libmyisam.a
-rw-r--r--   1 root root   27662 Oct 24 16:49 libmyisammrg.a
-rw-r--r--   1 root root 1467890 Oct 24 16:49 libmysqlclient.a
-rwxr-xr-x   1 root root     903 Oct 24 16:49 libmysqlclient.la
lrwxrwxrwx   1 root root      24 Mar  4 10:43 libmysqlclient.so -> libmysqlclient.so.15.0.0
lrwxrwxrwx   1 root root      24 Mar  4 10:43 libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
-rwxr-xr-x   1 root root 1303964 Oct 31 16:58 libmysqlclient.so.15.0.0
-rw-r--r--   1 root root 1210040 Oct 24 16:49 libmystrings.a
-rw-r--r--   1 root root  291714 Oct 24 16:49 libmysys.a
-rw-r--r--   1 root root   17152 Oct 24 16:49 libvio.a

So, this seems to be the only problem to be resolved now...

Kind Regards, Clemens

Environment

Open2300 version:	1.10
Libraries:	mysql, postgresql
Server OS:	SUSE 9.10

-- ClemensKlimczok - 18 Mar 2006

Answer