From aa4125be3e3fbf88d628aeaeac470e1080fb8052 Mon Sep 17 00:00:00 2001 From: "Kevin M. Rosenberg" Date: Thu, 10 Nov 2005 22:17:28 +0000 Subject: [PATCH] r10815: 11 Nov 2005 Kevin Rosenberg * Version 3.4: Add MySQL 5 support * db-mysql/mysql-client-info.lisp: Recognize MySQL 5 * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5 * doc/mysql-macosx-notes.txt: New document from Martin Brooks --- ChangeLog | 2 ++ doc/mysql-macosx-notes.txt | 60 ++++++++++++++++++++++++++++++++++++++ 2 files changed, 62 insertions(+) create mode 100644 doc/mysql-macosx-notes.txt diff --git a/ChangeLog b/ChangeLog index 1c9a372..29a6496 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,6 +1,8 @@ 11 Nov 2005 Kevin Rosenberg + * Version 3.4: Add MySQL 5 support * db-mysql/mysql-client-info.lisp: Recognize MySQL 5 * db-mysql/mysql-sql.lisp: Add support for views in MySQL 5 + * doc/mysql-macosx-notes.txt: New document from Martin Brooks 7 Nov 2005 Kevin Rosenberg * src/time.lisp: Apply patch from Aleksandar Bakic for ROLL diff --git a/doc/mysql-macosx-notes.txt b/doc/mysql-macosx-notes.txt new file mode 100644 index 0000000..9687f1d --- /dev/null +++ b/doc/mysql-macosx-notes.txt @@ -0,0 +1,60 @@ +Instructions: + +---------------- +1. Install MySQL from Fink, not from mysql.com + +It is sufficient to install the binaries from Fink. +CLSQL requires the MySQL library libmysqlclient.dylib; this library +is not provided with the mysql binary install. +This library is in /sw/lib/mysql . However, it is actually called +libmysqlclient.14.0.0.dylib . +----------------- +2. After installing MySQL, do the following at the shell. +(Assuming that you do not want to have to load CLSQL as root user +every time you use it.) + +2a. Create a symbolic link from libmysqlclient.14.0.0.dylib to the +name libmysqlclient.dylib . +2b. Change ownership to yourself along the path /sw/lib/mysql/ +libmysqlclient.dylib . +----------------- +3. Either install CocoaMySQL or download the source of MySQL (e.g. +5.0) from mysql.com. + +CLSQL requires MySQL's header files. These files are not provided +with Fink's binary MySQL install. +In CocoaMySQL the headers are found at: /Applications/CocoaMySQL.app/ +Contents/Frameworks/SMySQL.framework/Versions/A/Headers +In MySQL 5.0 sources, the headers are found at: ~/Desktop/ +mysql-5.0.15/include + +3a. Copy the directory full of headers to /sw/include/mysql +3b. Make yourself the owner of these files. + +You may now dispose of CocoaMySQL or the MySQL sources, if you desire. +----------------- +4. In the CLSQL sources, modify db-mysql/makefile to read as follows: + +... CFLAGS="-I /sw/include/mysql" LDFLAGS=" -L/sw/lib/mysql/ ... + +----------------- +5. In Lisp, do the following: + +Assuming asdf and the CLSQL & UFFI sources are in the same directory; +substitute the appropriate path for ~ . +The code below is right out of the CLSQL docs, but note particularly +the commented expression. + +(load "~/asdf.lisp") + +(progn + (push "~/uffi-1.5.5/" asdf:*central-registry*) + (asdf:operate 'asdf:load-op :uffi) + (push "~/clsql-3.3.4/" asdf:*central-registry*) + (asdf:operate 'asdf:load-op :clsql)) + +(progn + (in-package :clsql) + (setf *default-database-type* :mysql) + (clsql:push-library-path "/sw/lib/mysql/") ; !! + (asdf:operate 'asdf:load-op 'clsql-mysql)) -- 2.34.1