<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>I believe this is a version issue. I tested my code with MySQL 5.0.67 on Mac OS X. The details of the test platform combinations are in the project page in Squeaksource.</span></div><div><span><br></span></div><div><span> Could you please let me know your MySQL version and platform? It is entirely possible that for certain versions/conditions the handshake protocol does another extra step. This is something I found NOT applicable for the version I was working with, although the reference C implementation does have such provisions.</span></div><div><br><span></span></div><div><span>I will also keep looking for more details meanwhile.<br></span></div><div><br><span></span></div><div><span>Best,</span></div><div><span>Anindya<br></span></div><div><br></div><div style="font-family: times new roman, new york, times,
serif; font-size: 12pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Andreas Raab <andreas.raab@gmx.de><br><b><span style="font-weight: bold;">To:</span></b> The general-purpose Squeak developers list <squeak-dev@lists.squeakfoundation.org><br><b><span style="font-weight: bold;">Sent:</span></b> Thursday, September 29, 2011 11:19 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [squeak-dev] Re: Now available: a database conectivity API and its MySQL implementation<br></font><br>
On 9/29/2011 19:28, Andreas Raab wrote:<br>> On 9/29/2011 16:40, Anindya Haldar wrote:<br>>> Thanks Andreas. The MySQL protocol is a native all-Smalltalk MySQL<br>>> driver. There is no FFI or plugin associated with it. The driver<br>>> implements the MySQL wire protocol on top of socket stream.<br>><br>> Awesome! I'll see if I can get it to work on the weekend. What platforms<br>> have you tested it on?<br><br>My first tests ends up with an error "This part of the handshake is not <br>implemented" during the connect operation. Is this maybe a MySql version <br>problem? What versions have you successfully tested with?<br><br>Cheers,<br> - Andreas<br><br>><br>> Cheers,<br>> - Andreas<br>><br>>> ------------------------------------------------------------------------<br>>> *From:* Andreas Raab <<a ymailto="mailto:andreas.raab@gmx.de"
href="mailto:andreas.raab@gmx.de">andreas.raab@gmx.de</a>><br>>> *To:* Anindya Haldar <<a ymailto="mailto:anindya_haldar@yahoo.com" href="mailto:anindya_haldar@yahoo.com">anindya_haldar@yahoo.com</a>>; The general-purpose<br>>> Squeak developers list <<a ymailto="mailto:squeak-dev@lists.squeakfoundation.org" href="mailto:squeak-dev@lists.squeakfoundation.org">squeak-dev@lists.squeakfoundation.org</a>><br>>> *Sent:* Thursday, September 29, 2011 1:22 AM<br>>> *Subject:* Re: Now available: a database conectivity API and its MySQL<br>>> implementation<br>>><br>>> Very nice. Quick question: How are you accessing the MySQL db? Are you<br>>> using a network connection or some FFI facilities? If you are using a<br>>> network connection, we might have use for your project right away; our<br>>> current FFI based ODBC implementation causes headaches when the calls<br>>> take a long
time (>1sec).<br>>><br>>> Cheers,<br>>> - Andreas<br>>><br>>> On 9/29/2011 10:11, Anindya Haldar wrote:<br>>> > I am extremely pleased to offer to the community a generic Smalltalk<br>>> API<br>>> > for database connectivity API, along with a MySQL implementation<br>>> written<br>>> > from ground up. Think of JDBC and DBI like interfaces in other<br>>> languages<br>>> > and environments, and this one offers abstract facilities like<br>>> > connection, prepared statement, resultset, row, metdata and so on for<br>>> > the application.<br>>> ><br>>> > The API implementation uses driver delegates, and insulates the<br>>> > applications from the driver specific interfaces. As of now, a MySQL<br>>> > implementation is available, with other databases engine supports in<br>>> the<br>>> > future
plans.<br>>> ><br>>> > The API supports server side prepared sta tements and cursor based<br>>> fetch<br>>> > implemented in the MySQL driver.<br>>> ><br>>> > The implementation is currently available in 3 parts:<br>>> ><br>>> > 1) StdbCore project: This is primarily the API definitions and the<br>>> > delegation logic<br>>> > URL: http://www.squeaksource.com/StdbCore.html<br>>> ><br>>> > 2) StdbMysqlImpl project: This is the MySQL implementation of the<br>>> > StdbCore API<br>>> > URL: http://www.squeaksource.com/StdbMysqlImpl.html<br>>> ><br>>> > 3) StdbMysqlProtocol project: This is the underlying MySQL protocol<br>>> > driver, and used by the MySQL API implementation<br>>> > URL: http://www.squeaksource.com/StdbMysqlProtocol.html<br>>> ><br>>> > There is a package load
ordering dependency (documented in the MySQL<br>>> > implementation project). Please load the core and the protocol driver<br>>> > packages first, before you load the implementation package.<br>>> ><br>>> > Combined, the packages has around 200 tests (most of them in the<br>>> > protocol driver and the API implementation) and are running green on<br>>> > Pharo 1.1.1 one click, Squeak 4.2 one click, Squeak 3.10 (with Seaside<br>>> > 2-8-573 dev image) under Mac OS X 10.5.8 with MySQL server 5.0.67.<br>>> ><br>>> > This was in the making for some time; and I feel it is time to share it<br>>> > with the community. I will continue to post more documentation and code<br>>> > snippets in the project page Wiki sections. For now, looking up the<br>>> > tests may be your best guide.<br>>> ><br>>> > Happy programming!<br>>>
><br>>> > Best,<br>>> > Anindya Haldar<br>>> ><br>>> ><br>>> ><br>>> ><br>>> ><br>>><br>>><br>>><br>>><br>>><br>>><br>><br>><br>><br><br><br><br><br></div></div></div></body></html>