<br><br>
<div class="gmail_quote">2009/9/26 Herbert König <span dir="ltr"><<a href="mailto:herbertkoenig@gmx.net" target="_blank">herbertkoenig@gmx.net</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">Hi Folks,<br><br>I'm trying something maybe non standard.<br>I use Squeak 3.8.2 and MySQL 4.0.15.<br>
<br></blockquote>
<div> </div>
<div>Yeah hahaha. As we talked at ESUG, SqueakDBX was not ever tested with Squeak 3.8.2. And we never tested in MySQL 4, but 5. But I will try to help you. I am glad you are giving SqueakDBX a try.</div>
<div> </div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">After installing opendbx 1.4.3 in the Squeak folder and installing<br>OpenDBX-Core-Mariano.230.mcz I started with the connection example.<br>
<br>I verified that the following settings work with the native mySQL<br>driver for Squeak. So:<br><br>connectionSettings := DBXConnectionSettings<br> host: 'ALDI_1'<br> port: '3306'<br>
database: 'Pruefzeiten'<br> userName: 'readonly'<br> userPassword: '****'.<br><br>conn := DBXConnection platform: DBXMySQLPlatform new settings: connectionSettings.<br>
<br>conn connect.<br><br></blockquote>
<div> </div>
<div>This is wrong. You must do a open first. So, you can do conn open. conn connect. Or use directly conn connectAndOpen.</div>
<div>Read here: <a href="http://wiki.squeak.org/squeak/6067" target="_blank">http://wiki.squeak.org/squeak/6067</a></div>
<div> </div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">Here (in connect) I first got an error indicating that<br>libmysqlbackend.dll could not be found. (err1.png).</blockquote>
<div><br>I think you are referring to libmysql.dll here, not libmysqlbackend.dll<br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
Trying the dlls<br>
Mariano sent to this list on September 21st didn't change anything.</blockquote>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">So I renamed libmysqlbackend-1.dll to libmysqlbackend.dll and retried.<br><br></blockquote>
<div> </div>
<div>This is weird. libmysqlbackend-1.dll should work. Which Windows are you using ? I will try to reproduce it.<br>But I have libmysqlbackend-1.dll and everything works ok. <br></div>
<div> </div>
<div> </div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">This time a Squeak debugger popped up, see debug1.png and continuing<br>this debugger gave conn a handle which was not nil.<br>
</blockquote>
<div> </div>
<div>This means that opendbx dll cannot find the libmysqlbackend dll </div>
<div>They must be findable by the OS</div>
<div>What I would do is to let libmysqlbackend-1.dll AND libmysqlbackend.dll in a place where it is findable, not only by Squeak but also for the OS.<br>Because squeak will find opendbx dll but then, this dll will find the libmysqlbackend<br>
<br></div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"><br>So I tried:<br><br>conn open<br><br>and got debug2.png<br><br>Digging in the code there should be some logging to the Transcript but<br>
the transcript stays empty. So how to get at the log?<br></blockquote>
<div> </div>
<div><a href="http://wiki.squeak.org/squeak/6099" target="_blank">http://wiki.squeak.org/squeak/6099</a></div>
<div> </div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"><br>Another suspect might be the authentication method as I believe<br>authentication between mySQL 4 and 5 changed.<br>
<br></blockquote>
<div> </div>
<div>I will ask Norbert (OpenDBX author) to see if he knows something about this.</div>
<div> </div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">If it weren't for the first error with the dll's name I'd say my<br>Squeak and my mySQL are just too old. As they represent a big<br>
investment chances to update any of those are very small.<br><br>So do you see a chance to get this configuration work? </blockquote>
<div> </div>
<div>Yes. We will investigate and work together. No panic :)</div>
<div> </div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">First thing is<br>to verify the proper dlls are loaded. </blockquote>
<div> <br>Yes. Now I want to understand: You must have:<br><br>- libmysqlbackend-1.dll AND libmysqlbackend.dll<br>- libopendbx-1.dll<br>- MySQL client libraries (in my case: C:\MySQL\bin\ )<br><br>All of them must be findable by the OS: I won't tell you to put it in c:/windows/system32 or in $PATH, but do something :)<br>
</div>
<div><br>Enable logging.<br><br>So, after having all of that, what happens if you evaluate:<br><br>connectionSettings := DBXConnectionSettings<br> host: 'ALDI_1'<br> port: '3306'<br>
database: 'Pruefzeiten'<br> userName: 'readonly'<br> userPassword: '****'.<br><br>conn := DBXConnection platform: DBXMySQLPlatform new settings: connectionSettings.<br>
<br>conn connect.<br>conn open. <br><br><br>debug2.png ???<br><br></div>
<div> </div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">Then I'd like to see what is<br>sent to the database and what mySQL returns.<br><br></blockquote>
<div><br>We can do this in a further step. As you said, lets configure the dlls first.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
Any hints are greatly appreciated.<br>
<br></blockquote><div><br>Best,<br><br>Mariano<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"><br>Thanks,<br><br>Herbert mailto:<a href="mailto:herbertkoenig@gmx.net" target="_blank">herbertkoenig@gmx.net</a><br>
_______________________________________________<br>SqueakDBX mailing list<br><a href="mailto:SqueakDBX@lists.squeakfoundation.org" target="_blank">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br><br></blockquote></div><br>