Re: Can't connect to MySQL

Oh, I know wht's the problem. MySQL support 'show collation' command in 
version 4.1, but my Database version is 4.0.14.

By using Wireshark(Ethereal), I found LispWorsk try to query 'show 
collation' after successful login, but CLSQL don't do this. I think I 
should upgrade my database first. Maybe LispWorks Manual should note 
that common-sql doesn't support too old mysql server (<4.1).

Sorry for disturb.

Chun Tian (binghe) wrote:
> Hi, LispWorks
>
> I use an LispWorks Enterprise Edition for AMD64 Linux to connect to a 
> MySQL database, but failed:
>
> CL-USER 8 > (sql:connect "photo/ouf2003P/markdata@192.168.0.170:3306" 
> :database-type :mysql)
> ; Loading 
> /home/binghe/lispworks/lib/5-0-0-0/load-on-demand/sql/mysql/defsys.lisp 
> on demand...
> ;; Creating system MYSQL
>
> ; Loading fasl file 
> /home/binghe/lispworks/lib/5-0-0-0/load-on-demand/sql/mysql/mysql-c-types.64ufasl 
>
> ; Loading fasl file 
> /home/binghe/lispworks/lib/5-0-0-0/load-on-demand/sql/mysql/macros-and-utils.64ufasl 
>
> ; Loading fasl file 
> /home/binghe/lispworks/lib/5-0-0-0/load-on-demand/sql/mysql/mysql-c-funcs.64ufasl 
>
> ; Loading fasl file 
> /home/binghe/lispworks/lib/5-0-0-0/load-on-demand/sql/mysql/top.64ufasl
> ; Loading fasl file 
> /home/binghe/lispworks/lib/5-0-0-0/load-on-demand/sql/mysql/cursor.64ufasl 
>
> ; Loading fasl file 
> /home/binghe/lispworks/lib/5-0-0-0/patches/mysql/0001/0001.64ufasl
> ; Loaded public patch MYSQL 1.1
>
> ; Loading fasl file 
> /home/binghe/lispworks/lib/5-0-0-0/patches/mysql/0001/0002.64ufasl
> ; Loaded public patch MYSQL 1.2
>
> ; Loading fasl file 
> /home/binghe/lispworks/lib/5-0-0-0/patches/mysql/0001/0003.64ufasl
> ; Loaded public patch MYSQL 1.3
>
>
> Error: Sql-Database-Data-Error id 1064 : In PREPARE : You have an 
> error in your SQL syntax.  Check the manual that corresponds to your 
> MySQL server version for the right syntax to use near 'collation' at 
> line 1
>  1 (abort) Return to level 0.
>  2 Restart top-level loop.
>
> Type :b for backtrace, :c <option number> to proceed,  or :? for other 
> options
>
> What's the possible reason?
>
> My MySQL client library's version is 5.0.32, and I'm trying to connect 
> to MySQL 4.1 Database. OS is Debian GNU/Linux etch for AMD64.
>
> And on SBCL+CLSQL is good:
>
> * (clsql:connect '("192.168.0.170" "markdata" "photo" "ouf2003P" 
> "3306") :database-type :mysql)
>
> #<CLSQL-MYSQL:MYSQL-DATABASE 192.168.0.170:3306/markdata/photo OPEN 
> {10033092A1}>
> * (clsql:status)
>
> CLSQL STATUS: 2007-04-18 13:59:20,,0
> ------------------------------------------------------
>   DATABASE                           TYPE   RECORDING
> ------------------------------------------------------
> *  192.168.0.170:3306/markdata/photo  mysql  nil
> ------------------------------------------------------
>
> Thanks very much.
>
> Chun Tian (binghe)
>
>
>