Subject: cl-sql-mysql: can't load library in sbcl
From: Ken Bloom <[email-masked]>
To: [email-masked]
Date: Wed, 3 May 2006 13:21:06 -0500

Subject: cl-sql-mysql: can't load library in sbcl
Package: cl-sql-mysql
Version: 3.5.6-3
Severity: normal

*** Please type your report below this line ***

(clc:clc-require :clsql) is successful
(clc:clc-require :clsql-mysql) fails with the following error:
WARNING: Error opening shared object "libmysqlclient.so":
  libmysqlclient.so: cannot open shared object file: No such file or directory.
WARNING: Error opening shared object "libmysql.so":
  libmysql.so: cannot open shared object file: No such file or directory.
WARNING: Error opening shared object "libmysqlclient.a":
  libmysqlclient.a: cannot open shared object file: No such file or directory.
WARNING: Error opening shared object "libmysql.a":
  libmysql.a: cannot open shared object file: No such file or directory.
WARNING: Error opening shared object "libmysqlclient.o":
  libmysqlclient.o: cannot open shared object file: No such file or directory.
WARNING: Error opening shared object "libmysql.o":
  libmysql.o: cannot open shared object file: No such file or directory.

debugger invoked on a SIMPLE-ERROR in thread
#<THREAD "initial thread" {100253DB81}>:
  Couldn't load foreign libraries #P"/usr/lib/clsql/libmysqlclient", #P"/usr/lib/clsql/libmysql", #P"/usr/lib/libmysqlclient", #P"/usr/lib/libmysql", "libmysqlclient", "libmysql". (searched CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*)
(FIND-AND-LOAD-FOREIGN-LIBRARY
 (#P"/usr/lib/clsql/libmysqlclient" #P"/usr/lib/clsql/libmysql"
  #P"/usr/lib/libmysqlclient" #P"/usr/lib/libmysql" "libmysqlclient"
  "libmysql")
 :MODULE
 "mysql"
 :SUPPORTING-LIBRARIES
 ("c")
 :ERRORP
 T)

if I execute (uffi:load-foreign-library
"/usr/lib/libmysqlclient.so.15"), then I can continue compiling
cl-sql-mysql and get to the point of using cl-sql-mysql.

--Ken Bloom

-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16-1kenlap
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)

Versions of packages cl-sql-mysql depends on:
ii  cl-sql                        3.5.6-3    SQL Interface for Common Lisp
ii  cl-sql-uffi                   3.5.6-3    Common UFFI functions for CLSQL da
ii  libc6                         2.3.6-7    GNU C Library: Shared libraries
ii  libmysqlclient15off           5.0.20a-2  mysql database client library
ii  zlib1g                        1:1.2.3-11 compression library - runtime

cl-sql-mysql recommends no packages.

-- no debconf information