<br><br><div class="gmail_quote">2009/9/26 Herbert König <span dir="ltr"><<a href="mailto:herbertkoenig@gmx.net">herbertkoenig@gmx.net</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Mariano,<br>
<br>
this is long but I'm mostly fine so if you have no time, only read the<br>
last three paragraphs.<br>
<br>
MMP> Yeah hahaha. As we talked at ESUG, SqueakDBX was not ever<br>
MMP> tested with Squeak 3.8.2. And we never tested in MySQL 4, but 5. <br>
MMP> But I will try to help you.<br>
<br>
:-)) yeah and thanks! I might port the Squeak apps to 3.10 on my own.<br>
I guess they should run with nearly no changes. But porting about 20<br>
Delphi 5 Apps where the programmer is no more available is quite a<br>
different beast :-)<br>
<br>
MMP> <br>
MMP> This is wrong. You must do a open first. So, you can do<br>
<br>
This is from <a href="http://wiki.squeak.org/squeak/6067" target="_blank">http://wiki.squeak.org/squeak/6067</a> and I think this is<br>
right. Because open before connect gives me a debugger:<br>
<br>
SqueakDBXError: SqueakDBX: You are not connected. Try connecting<br>
first.<br></blockquote><div><br>uffff I am really sorry. I read the other way. You are totally correct.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
MMP> I think you are referring to libmysql.dll here, not libmysqlbackend.dll<br>
<br>
Doh, Blush!! Thanks for reading my error messages for me.<br>
<br>
Ok I downloaded mysql5.0 community edition, unzipped it and got<br>
libmysql.dll of that package (after trying several versions I already<br>
found on my box).<br>
<br>
Now connect works and open gives a recoverable error, see debug3.png.<br>
<br>
Continuing sets connected and open of the DBX connection to true.<br>
Seems now I'm able to follow your further advice.<br></blockquote><div><br>Wait a moment....you are using MySQL client libraries form 5.0 to connect to a MySQL 4 server ???<br><br>is that possible ? or you also migrate your database to a 5.0 ? <br>
<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
MMP> So I renamed libmysqlbackend-1.dll to libmysqlbackend.dll and retried.<br>
<br>
MMP> <br>
MMP> This is weird. libmysqlbackend-1.dll should work. Which<br>
MMP> Windows are you using ? I will try to reproduce it.<br>
MMP> But I have libmysqlbackend-1.dll and everything works ok.<br>
<br>
XP Service Pack 3, automatic updates enabled. I believe this is a<br>
secondary effect. Let's not spend time on this until the first problem<br>
is solved. I already renamed it back.<br>
<br></blockquote><div><br>ok.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
MMP> <br>
MMP> This means that opendbx dll cannot find the libmysqlbackend dll <br>
MMP> They must be findable by the OS<br>
<br>
I will remember that but before using path or system32 I will try to<br>
confine everything to one single folder. Because the Delphi<br>
applications will need their versions of libmysql.dll, and my mysqlcc<br>
happily uses a third version.<br></blockquote><div><br>ok.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
MMP> What I would do is to let libmysqlbackend-1.dll AND<br>
MMP> libmysqlbackend.dll in a place where it is findable, not only by<br>
MMP> Squeak but also for the OS.<br>
MMP> Because squeak will find opendbx dll but then, this dll will find the libmysqlbackend<br>
<br>
MMP> <br>
MMP> <a href="http://wiki.squeak.org/squeak/6099" target="_blank">http://wiki.squeak.org/squeak/6099</a><br>
MMP> <br>
thanks. Optimists always put debugging information at the end of the<br>
docs. I do so myself as not to scare away interested people :-))<br>
<br></blockquote><div><br>hahahahahahah I<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Friendly Transcript is logging now.<br>
<br></blockquote><div><br>Excellent. <br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
MMP> <br>
MMP> I will ask Norbert (OpenDBX author) to see if he knows something about this.<br>
<br>
Norbert sounds German so if we get stuck, maybe I go to the opendbx<br>
list myself.<br></blockquote><div><br>Yeah, it would be better if you ask in OpenDBX mailing list. But please, don't talk in German!! I won't understand a single word ;)<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
MMP> So do you see a chance to get this configuration work?<br>
<br>
MMP> <br>
MMP> Yes. We will investigate and work together. No panic :)<br>
<br>
Thanks! and I promise not to panic :-))<br>
<br>
MMP> <br>
MMP> Yes. Now I want to understand: You must have:<br>
I understand and I will follow it exactly if I get stuck again.<br>
<br>
MMP> - libmysqlbackend-1.dll AND libmysqlbackend.dll<br>
I hope I get away without the rename after I have the new<br>
libmysql.dll.<br>
<br>
MMP> - libopendbx-1.dll<br>
MMP> - MySQL client libraries (in my case: C:\MySQL\bin\ )<br>
<br>
MMP> All of them must be findable by the OS: I won't tell you to<br>
MMP> put it in c:/windows/system32 or in $PATH, but do something :)<br>
<br>
Yes Sir :-)))<br>
<br>
MMP> Enable logging.<br>
<br>
Yea<br>
<br>
MMP> So, after having all of that, what happens if you evaluate:<br>
<br>
See debug3. But there are no nasty messages in the Transcript and the<br>
mysqladmin sees the incoming connection and the reply from mysql.<br>
<br>
And I can do "conn close. conn disconnect." with proper results in the<br>
Transcript.<br>
<br>
Following the Wiki, after connect and open I sent:<br>
<br>
result := conn execute: 'select * from Einzelpruefungen where pruefer = "A. Kreizer"'.<br>
<br>
which gave me an DBXResult set and reasonable messages in Transcript.<br>
<br>
result columnCount does work, rowsAffected gives a DNU (both from<br>
<a href="http://wiki.squeak.org/squeak/6070" target="_blank">http://wiki.squeak.org/squeak/6070</a>).<br>
<br></blockquote><div><br>which DNU here ? the one of the sql_mode ?<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
result nextRow explore gives a very reasonable DBXRow, see png.<br>
<br>
result columnDescriptions explore gives DBXTypeNotSupported (see png)<br>
for timestamp and text (see mysqlcc.png).<br>
<br></blockquote><div><br>No, sorry :( You cannot use timestamp. You have to use DATETIME :(<br>I am sorry but that's OpenDBX. Read: <a href="http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes#Temporal_types">http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes#Temporal_types</a><br>
I hope this not to be a big problem for you.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
BTW there was a typo on the Wiki the last "s" in columnDescriptions<br>
was missing.<br></blockquote><div><br>Sorry. I couldn't find it. Where is it ?<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
So basically it seems I'm fine, for the next nextRow gives a<br>
reasonable next row.<br>
<br>
Let me suggest, we only solve the "unknown system variable" problem<br>
from debug3.png and maybe find an explanation for DBXTypeNotSupported.<br>
Then I'll write up a text on what is needed to run SqueakDBX with<br>
mysql4 (I believe there is no 3.8.2 related problem). I go through the<br>
Wiki examples and report problems here and correct typos as I<br>
encounter them.<br>
<br></blockquote><div><br>That would be VERY helpful for us and we will really appreciate that. <br>I will investigate the "unknown system variable".<br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
>From my own job I tend to assume documentation errors if the user<br>
blunders (me in not copying libmysql.dll). I never compiled OpenDBX<br>
but with your permission I will clarify the single sentence about<br>
"installing your client library" in<br>
<a href="http://wiki.squeak.org/squeak/6129" target="_blank">http://wiki.squeak.org/squeak/6129</a> for end users like me.<br></blockquote><div><br>Are you referring to " In both cases, you must have installed your database client library first. " ??<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
And if you don't mind I will also go over the descriptions about<br>
Windows because as I said on my system I have one libmysql.dll in my<br>
mysql folder (for mysqladmin) and two different ones for SqueakDBX and<br>
mysqlcc. Both suggestions (path and system32) give me a headache and I<br>
vastly prefer a "could not find libmysql.dll" over the errors<br>
occurring if the system finds the wrong dll.<br>
<br></blockquote><div><br>Ok. However I already edited the wiki with your comments: <br><br><a href="http://squeakdbx.smallworks.com.ar/Compiling%20and%20installing%20OpenDBX">http://squeakdbx.smallworks.com.ar/Compiling%20and%20installing%20OpenDBX</a><br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Thanks a lot for your help,<br>
<div><div></div><div class="h5"><br></div></div></blockquote><div><br>You are welcome. <br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div class="h5">
Herbert mailto:<a href="mailto:herbertkoenig@gmx.net">herbertkoenig@gmx.net</a></div></div><br>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org">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>