Re: Running clsql on Windows with Mysql
Russ Tyndall <[email protected]> Fri, 16 Feb 2018 11:57:06 -0500
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============9080006914538757771== Content-Type: multipart/alternative; boundary="------------1C808725A2BC2266650C5B9A" Content-Language: en-US This is a multi-part message in MIME format. --------------1C808725A2BC2266650C5B9A Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Honestly the mysql backend for clsql is the one with the least amount of work on it. It very much needs to be rewritten / organized as it has received the most amount of user complaints and is generally found to be lacking. I dont think it would take too much work to that that backend working, and it would be good, but honestly I haven't had the time or monetary impetus to spend a bunch of time looking at it. Wish I could be of more assistance, but I don't use windows or lispworks. If someone were to tackle it, I would be happy to help merge that patch. Similar issues: https://github.com/UnwashedMeme/clsql/issues/9 From 8 Years ago: http://comp.lang.lisp.narkive.com/yEv8KJNw/lispworks-and-clsql Looking at it, my guess would be that the fastest fix would be to rebuild the DLL with current stuff (db-mysql/Makefile.msvc) but the git issue seems to imply that wont be totally sufficient. If you do manage, please let us know how, so that we can either streamline that or supply appropriate instructions. Cheers, Russ Tyndall Acceleration.net On 02/15/2018 04:33 PM, Brian Sorg wrote: > Afternoon - > > I am trying to use clsql with Lispworks 7.1 32 bit to connect to the > Mysql 5.5.57 community server on Windows, and in doing so I keep > running into the following error: > > The following error has occured: Foreign function > MYSQL:CLSQL-MYSQL-FIELD-FLAGS trying to call to unresolved external > function "clsql_mysql_field_flags". > > I have double checked that the clsql_mysql.dll file is in the right > location to be loaded and tried manually loading it using the > (uffi:load-foreign-library ..) function, and I am still getting the > same error. So I am thinking that there is a problem with the dll > included in the package. > > I then tried to recreate the dll using cygwin with the make file > included but that resulted in an error message when running, and I > tried to use the cygwin gcc command line options to manually recreate > it but that is also giving me errors when trying to create the dll file. > > Does anyone have a current version of the clsql_mysql.dll that is > working for them or could put me on the right path to re-creating it? > > I not sure if it matters or not, but the foreign-function call is > referenced in the mysql-sql.lisp file in the function > make-type-list-for-auto. > > I am using the clsql version "clsql-20160208-git" that quicklisp > retrieves. > > Thanks, > > -- > Brian Sorg > Director and Founder Liberating Insight LLC > [email protected] <mailto:[email protected]> > Office: 260.918.0490 > Mobile: 260.602.1086 > www.liberatinginsight.com <http://www.liberatinginsight.com> > > > _______________________________________________ > CLSQL mailing list > CLSQL-2NDrxpH/[email protected] > http://lists.kpe.io/cgi-bin/mailman/listinfo/clsql --------------1C808725A2BC2266650C5B9A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body text="#000000" bgcolor="#FFFFFF"> <p>Honestly the mysql backend for clsql is the one with the least amount of work on it. <br> </p> <p>It very much needs to be rewritten / organized as it has received the most amount of user complaints and is generally found to be lacking. I dont think it would take too much work to that that backend working, and it would be good, but honestly I haven't had the time or monetary impetus to spend a bunch of time looking at it. Wish I could be of more assistance, but I don't use windows or lispworks.</p> <p>If someone were to tackle it, I would be happy to help merge that patch.</p> <p>Similar issues:<br> </p> <p><a class="moz-txt-link-freetext" href="https://github.com/UnwashedMeme/clsql/issues/9">https://github.com/UnwashedMeme/clsql/issues/9</a></p> <p>From 8 Years ago: <a class="moz-txt-link-freetext" href="http://comp.lang.lisp.narkive.com/yEv8KJNw/lispworks-and-clsql">http://comp.lang.lisp.narkive.com/yEv8KJNw/lispworks-and-clsql</a><br> </p> <p>Looking at it, my guess would be that the fastest fix would be to rebuild the DLL with current stuff (db-mysql/Makefile.msvc) but the git issue seems to imply that wont be totally sufficient. If you do manage, please let us know how, so that we can either streamline that or supply appropriate instructions.<br> </p> <br> Cheers,<br> Russ Tyndall<br> Acceleration.net<br> <br> <div class="moz-cite-prefix">On 02/15/2018 04:33 PM, Brian Sorg wrote:<br> </div> <blockquote type="cite" cite="mid:CAC29X8fUY3-3VFkmp=hGJJcmxHaGgg30sBvPPkLy4k2hBoZ87g-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org"> <div dir="ltr"> <div> <div> <div>Afternoon - <br> <br> </div> I am trying to use clsql with Lispworks 7.1 32 bit to connect to the Mysql 5.5.57 community server on Windows, and in doing so I keep running into the following error: <br> <br> The following error has occured: Foreign function MYSQL:CLSQL-MYSQL-FIELD-FLAGS trying to call to unresolved external function "clsql_mysql_field_flags". <br> <br> </div> I have double checked that the clsql_mysql.dll file is in the right location to be loaded and tried manually loading it using the (uffi:load-foreign-library ..) function, and I am still getting the same error. So I am thinking that there is a problem with the dll included in the package.<br> <br> I then tried to recreate the dll using cygwin with the make file included but that resulted in an error message when running, and I tried to use the cygwin gcc command line options to manually recreate it but that is also giving me errors when trying to create the dll file. <br> <br> </div> <div>Does anyone have a current version of the clsql_mysql.dll that is working for them or could put me on the right path to re-creating it? <br> <br> </div> <div>I not sure if it matters or not, but the foreign-function call is referenced in the mysql-sql.lisp file in the function make-type-list-for-auto. <br> <br> </div> <div>I am using the clsql version "clsql-20160208-git" that quicklisp retrieves. <br> </div> <div><br> </div> <div>Thanks, <br clear="all"> <div> <div> <div><br> -- <br> <div class="gmail_signature">Brian Sorg <br> Director and Founder Liberating Insight LLC<br> <a href="mailto:[email protected]" target="_blank" moz-do-not-send="true">[email protected]</a><br> Office: 260.918.0490<br> Mobile: 260.602.1086<br> <a href="http://www.liberatinginsight.com" target="_blank" moz-do-not-send="true">www.liberatinginsight.com</a></div> </div> </div> </div> </div> </div> <br> <fieldset class="mimeAttachmentHeader"></fieldset> <br> <pre wrap="">_______________________________________________ CLSQL mailing list <a class="moz-txt-link-abbreviated" href="mailto:CLSQL-2NDrxpH/[email protected]">CLSQL-2NDrxpH/[email protected]</a> <a class="moz-txt-link-freetext" href="http://lists.kpe.io/cgi-bin/mailman/listinfo/clsql">http://lists.kpe.io/cgi-bin/mailman/listinfo/clsql</a> </pre> </blockquote> <br> </body> </html> --------------1C808725A2BC2266650C5B9A-- --===============9080006914538757771== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KQ0xTUUwgbWFp bGluZyBsaXN0CkNMU1FMQGxpc3RzLmtwZS5pbwpodHRwOi8vbGlzdHMua3BlLmlvL2NnaS1iaW4v bWFpbG1hbi9saXN0aW5mby9jbHNxbAo= --===============9080006914538757771==--