Re: CLSQL-MYSQL on Lispworks for OSX

On Sep 17, 2012, at 6:40 PM, Alexandre Paes <[email protected]> wrote:
> I'm having a slight problem when trying to load clsql-mysql on lispworks in OSX.
> ...
> CL-USER> (push #p"/usr/local/mysql/lib/" clsql-sys:*foreign-library-search-paths*)
> (#P"/usr/local/mysql/lib/" #P"/Users/user/quicklisp/dists/quicklisp/software/clsql-20120520-git/db-
> mysql/" #P"/Users/user/quicklisp/dists/quicklisp/software/clsql-20120520-git/uffi/")
> ...
> Error: Undefined function MYSQL:MYSQL-GET-CLIENT-INFO in form (SYMBOL-FUNCTION MYSQL:MYSQL-GET-CLIENT-INFO).

Hi Alexandre,

I suspect that you might have incompatible bit-width (32 or 64) versions of Lispworks and the MySQL library you installed in /usr/local/mysql/lib/.

For example, on my OSX system, I use 64-bit versions of Lisp along with a 64-bit version of the mysql library installed by MacPorts. You can use the 'file' command to help you.

kevin@gazelle:~$ file /usr/local/bin/sbcl
/usr/local/bin/sbcl: Mach-O 64-bit executable x86_64

kevin@gazelle:~$ file /opt/local/lib/mysql55/mysql/libmysqlclient.dylib 
/opt/local/lib/mysql55/mysql/libmysqlclient.dylib: Mach-O 64-bit dynamically linked shared library x86_64

Kevin