This is my configuration:<br><br>c:\mariano\squeak\SqueakVM-Win32-3.11.2-bin\<br><br>This is the folder where I have the SqueakVM and these are the files I have there:<br><br>FT2Plugin.dll<br>libmysqlbackend-1.dll<br>libopendbx-1.dll<br>
libopendbxplus-1.dll<br>libpgsqlbackend-1.dll<br>libsqlite3backend-1.dll<br>splash.bmp<br>Squeak.exe<br>Squeak.ini<br>SqueakFFIPrims.dll<br><br><br>I installed MySQL client and server in C:\MySQL\, so in C:\MySQL\bin\ I have the MySQL client libraries (libmySQL.dll). And that directory is in $PATH<br>
<br>This is the eviorment variable path:<br><br>c:\SQLServer;c:\mariano\oracle\instantclient_11_1\;c:\MinGW\bin;c:\MinGW\lib;c:\msys\1.0\lib\;c:\msys\1.0\bin\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Archivos de programa\QuickTime\QTSystem\;C:\Archivos de programa\TortoiseSVN\bin;c:\PostgreSQL\8.3\bin\;c:\Archivos de programa\Microsoft SQL Server\90\Tools\binn\;%ORACLE_HOME%\bin;C:\MySQL\bin<br>
<br>As you can see I have C:\MySQL\bin<br><br>Best<br><br>Mariano<br><br><br><div class="gmail_quote">On Sat, Sep 26, 2009 at 1:51 PM, Mariano Martinez Peck <span dir="ltr"><<a href="mailto:marianopeck@gmail.com">marianopeck@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><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><div class="im"><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><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 class="im">
<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><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 class="im">
<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><div><br>I think you are referring to libmysql.dll here, not libmysqlbackend.dll<br><br> </div><div class="im"><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><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 class="im">
<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><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><div class="im">
<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><div><a href="http://wiki.squeak.org/squeak/6099" target="_blank">http://wiki.squeak.org/squeak/6099</a></div><div class="im">
<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><div>I will ask Norbert (OpenDBX author) to see if he knows something about this.</div><div class="im">
<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><div>Yes. We will investigate and work together. No panic :)</div><div class="im">
<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><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:<div class="im"><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></div>conn open. <br><br><br>debug2.png ???<br><br></div><div class="im">
<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><div><br>We can do this in a further step. As you said, lets configure the dlls first.<br> </div><div class="im"><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><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;"><div class="im"><br>Thanks,<br>
<br>Herbert mailto:<a href="mailto:herbertkoenig@gmx.net" target="_blank">herbertkoenig@gmx.net</a><br></div>
_______________________________________________<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>
</blockquote></div><br>