<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>I have not tried the package in 5.0.77; I will try to get one (unfortunately macports version is 5.0.67 only) installed in my box and try it. I am not sure under what conditions that particular server behavior (the one you are encountering) will trigger. I am looking into it right now, and hopefully can get to answer pretty soon.</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> Friday, September 30, 2011 12:57 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/30/2011 4:35, Anindya Haldar wrote:<br>> I believe this is a version issue. I tested my code with MySQL 5.0.67 on<br>> Mac OS X. The details of the test platform combinations are in the<br>> project page in Squeaksource.<br>><br>> Could you please let me know your MySQL version and platform? It is<br>> entirely possible that for certain versions/conditions the handshake<br>> protocol does another extra step. This is something I found NOT<br>> applicable for the version I was working with, although the reference C<br>> implementation does have such provisions.<br><br>I'm running MySql 5.0.77 server on CentOS 5.6 (which is the <br>out-of-the-box version you get on CentOS via yum). This seems pretty <br>close to what you're using. Is there a chance that I need to set up the <br>database credentials in a specific way? I've just been using an existing <br>user which works fine in other contexts but perhaps there's something
<br>specific that needs to be done?<br><br>Cheers,<br> - Andreas<br><br>><br>> I will also keep looking for more details meanwhile.<br>><br>> Best,<br>> Anindya<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:* The general-purpose Squeak developers list<br>> <<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 11:19 AM<br>> *Subject:* [squeak-dev] Re: Now available: a database conectivity API<br>> and its MySQL implementation<br>><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> <mailto:<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><br>> <mailto:<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>> <mailto:<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<br>> share it<br>> >> > with the community. I will continue to post more documentation and<br>> 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>><br>><br>><br><br><br><br><br></div></div></div></body></html>