[cl-debian] Bug#339824: Couldn't load foreign libraries #P"/usr/lib/clsql/clsql_mysql"

[edgardenny at comcast.net]

Package: cl-sql-mysql
Version: 3.4.6-1
Severity: serious

Hi,

I get the following error trying to load cl-sql-mysql with sbcl (and something similar with cmucl):

; /var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl written
; compilation finished in 0:00:01
WARNING: Error opening shared object "/usr/lib/clsql/clsql_mysql.so":
  libmysqlclient.so.15: cannot open shared object file: No such file or directory.
WARNING: Error opening shared object "clsql_mysql.so":
  clsql_mysql.so: cannot open shared object file: No such file or directory.
WARNING: Error opening shared object "clsql_mysql.a":
  clsql_mysql.a: cannot open shared object file: No such file or directory.
WARNING: Error opening shared object "clsql_mysql.o":
  clsql_mysql.o: cannot open shared object file: No such file or directory.

Which is strange since:

$ ls -l /usr/lib/clsql/clsql_mysql.so
-rw-r--r-- 1 root root 2848 Nov 16 03:08 /usr/lib/clsql/clsql_mysql.so


Edgar.

sbcl: 0.9.6.0-12
common-lisp-controller: 4.25

Couldn't load foreign libraries #P"/usr/lib/clsql/clsql_mysql", #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql", #P"/usr/lib/clsql_mysql", 
#P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql", "clsql_mysql", 
#P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql". (searched CLSQL-SYS:*FOREIGN-LIBRARY-SEARCH-PATHS*)
   [Condition of type SIMPLE-ERROR]

Restarts:
  0: [RETRY] Retry performing #<ASDF:LOAD-OP NIL {9FD33C1}> on #<ASDF:CL-SOURCE-FILE "mysql-loader" {9E54211}>.
  1: [ACCEPT] Continue, treating #<ASDF:LOAD-OP NIL {9FD33C1}> on #<ASDF:CL-SOURCE-FILE "mysql-loader" {9E54211}> as having been successful.
  2: [ABORT] Abort SLIME compilation.
  3: [ABORT-REQUEST] Abort handling SLIME request.
  4: [TERMINATE-THREAD] Terminate this thread (#<THREAD "repl-thread" {A100C01}>)

Backtrace:
  0: (CLSQL-UFFI:FIND-AND-LOAD-FOREIGN-LIBRARY (#P"/usr/lib/clsql/clsql_mysql" #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql" 
#P"/usr/lib/clsql_mysql" #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql" "clsql_mysql" 
#P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql") :MODULE "clsql-mysql" :SUPPORTING-LIBRARIES ("c") :ERRORP T)
      Locals:
        #:ERRORP-DEFAULTING-TEMP = T
        CLSQL-UFFI::FILENAMES = (#P"/usr/lib/clsql/clsql_mysql" #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql" #P"/usr/lib/clsql_mysql" 
#P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql" "clsql_mysql" 
#P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/clsql_mysql")
        #:MODULE-DEFAULTING-TEMP = "clsql-mysql"
        #:SUPPORTING-LIBRARIES-DEFAULTING-TEMP = ("c")
  1: ((SB-PCL::FAST-METHOD CLSQL-SYS:DATABASE-TYPE-LOAD-FOREIGN ((EQL :MYSQL))) #<unavailable argument> #<unavailable argument> #<unavailable argument>)
      Locals:
        SB-DEBUG::ARG-0 = :<NOT-AVAILABLE>
        SB-DEBUG::ARG-1 = :<NOT-AVAILABLE>
        SB-DEBUG::ARG-2 = :<NOT-AVAILABLE>
  2: ((LAMBDA (SB-PCL::.PV-CELL. SB-PCL::.NEXT-METHOD-CALL. SB-PCL::.ARG0.)) #<unavailable argument> #<unavailable argument> :MYSQL)
      Locals:
        SB-DEBUG::ARG-0 = :<NOT-AVAILABLE>
        SB-DEBUG::ARG-1 = :<NOT-AVAILABLE>
        SB-DEBUG::ARG-2 = :MYSQL
  3: ((SB-C::TOP-LEVEL-FORM (CLSQL-SYS:DATABASE-TYPE-LOAD-FOREIGN :MYSQL)))
  4: (SB-FASL::LOAD-FASL-GROUP #<SB-SYS:FD-STREAM for "file /var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl" {B1B0F79}>)
      Locals:
        SB-DEBUG::ARG-0 = 1
        SB-DEBUG::ARG-1 = #<SB-SYS:FD-STREAM for "file /var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl" {B1B0F79}>
      Catch-tags:
        SB-FASL::FASL-GROUP-END
  5: (SB-FASL::LOAD-AS-FASL #<SB-SYS:FD-STREAM for "file /var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl" {B1B0F79}> NIL #<unavailable 
argument>)
  6: (SB-FASL::INTERNAL-LOAD #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl" 
#P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl" :ERROR NIL NIL :BINARY NIL)
      Locals:
        SB-FASL::CONTENTS = :BINARY
        SB-FASL::EXTERNAL-FORMAT = NIL
        SB-FASL::IF-DOES-NOT-EXIST = :ERROR
        PATHNAME = #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl"
        PRINT = NIL
        TRUENAME = #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl"
        SB-FASL::VERBOSE = NIL
  7: (SB-FASL::INTERNAL-LOAD #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl" 
#P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl" :ERROR NIL NIL NIL :DEFAULT)
      Locals:
        SB-FASL::CONTENTS = NIL
        SB-FASL::EXTERNAL-FORMAT = :DEFAULT
        SB-FASL::IF-DOES-NOT-EXIST = :ERROR
        PATHNAME = #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl"
        PRINT = NIL
        TRUENAME = #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl"
        SB-FASL::VERBOSE = NIL
  8: (LOAD #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl")
      Locals:
        SB-DEBUG::ARG-0 = 1
        SB-DEBUG::ARG-1 = #P"/var/cache/common-lisp-controller/edenny/sbcl/clsql-mysql/db-mysql/mysql-loader.fasl"
  9: ((SB-PCL::FAST-METHOD ASDF:PERFORM (ASDF:LOAD-OP ASDF:CL-SOURCE-FILE)) #<unavailable argument> #<unavailable argument> #<ASDF:LOAD-OP NIL {9FD33C1}> 
#<ASDF:CL-SOURCE-FILE "mysql-loader" {9E54211}>)
      Locals:
        SB-DEBUG::ARG-0 = :<NOT-AVAILABLE>
        SB-DEBUG::ARG-1 = :<NOT-AVAILABLE>
        SB-DEBUG::ARG-2 = #<ASDF:LOAD-OP NIL {9FD33C1}>
        SB-DEBUG::ARG-3 = #<ASDF:CL-SOURCE-FILE "mysql-loader" {9E54211}>
 10: ((LAMBDA (SB-PCL::.PV-CELL. SB-PCL::.NEXT-METHOD-CALL. SB-PCL::.ARG0. SB-PCL::.ARG1.)) #<unavailable argument> #<unavailable argument> #<ASDF:LOAD-OP NIL {9FD33C1}> 
#<ASDF:CL-SOURCE-FILE "mysql-loader" {9E54211}>)
      Locals:
        SB-DEBUG::ARG-0 = :<NOT-AVAILABLE>
        SB-DEBUG::ARG-1 = :<NOT-AVAILABLE>
        SB-DEBUG::ARG-2 = #<ASDF:LOAD-OP NIL {9FD33C1}>
        SB-DEBUG::ARG-3 = #<ASDF:CL-SOURCE-FILE "mysql-loader" {9E54211}>
 11: ((LAMBDA NIL))
      Locals:
 12: (SB-C::%WITH-COMPILATION-UNIT #<CLOSURE (LAMBDA NIL) {B114C0D}>)
      Locals:
        SB-DEBUG::ARG-0 = 1
        SB-DEBUG::ARG-1 = #<CLOSURE (LAMBDA NIL) {B114C0D}>
 13: (ASDF:OPERATE ASDF:LOAD-OP "web-nutr")
      Locals:
        ASDF::ARGS = NIL
        ASDF::OPERATION-CLASS = ASDF:LOAD-OP
        ASDF:SYSTEM = "web-nutr"