Hi,<div><br></div><div>Here's the output of ./odbxplustest -b oracle -p 1521 -d 'mysid' -u 'user' -w 'password' -v</div><div><br></div><div><br></div><div><div>1. Run:</div><div> Conn::Conn()</div>
<div>Loading backend library oracle, liboraclebackend.so or /usr/local/lib/opendbx/liboraclebackend.so failed</div><div><br></div><div>dlopen(/usr/local/lib/opendbx/liboraclebackend.so, 1): Library not loaded: /b/32_216/rdbms/lib/libclntsh.dylib.10.1</div>
<div> Referenced from: /usr/local/lib/opendbx/liboraclebackend.so</div><div> Reason: image not found</div><div>Caught exception: Loading backend library failed</div><div><br></div><div>Cheers</div><div>Colin</div><br><div class="gmail_quote">
On Sun, Aug 1, 2010 at 7:00 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="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br><br><div class="gmail_quote"><div class="im">On Sun, Aug 1, 2010 at 7:38 PM, Colin Doherty <span dir="ltr"><<a href="mailto:colin.doherty@gmail.com" target="_blank">colin.doherty@gmail.com</a>></span> wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">Hi,<div><br></div><div class="im"><div>Ok I've tried using the Squeak5.7b1 64-32 VM with the Pharo 1.1 image and opendbx-1.5.0 with debug-log option, the error is:</div>
<div><br></div><div>Error: call to an external function failed.</div>
<div><br></div></div></blockquote><div><br>Grrrrr okok. It is failing in the apiInitialize:backend:host:port:<br>but I don't know why.<br><br><br></div><div class="im"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div><div><br></div><div><br></div><div>No error messages were produced in /var/log/system.log when this occurred and no additional opendbx debug log was produced that I could see.</div></div></blockquote></div><div><br>
Check the created files in the directory where you have the image or where you have the VM. They are something like this 'opendbx-0x9af4610.dbg'<br>
where 0x9af4610 is the connection handle. <br><br></div><div class="im"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><div><br></div><div>
I've run the FFIPlugin tests, these two failed in the standard Pharo-1.1 with <span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse"> Squeak 4.2.5beta1U VM</span>:</div>
<div><br></div><div>FFIPluginTests>>#testLongLongs</div><div>FFIPluginTests>>#testPoint2</div></blockquote></div><div><br>Ok, that's correct. The problem seems to be in OpenDBX.<br><br>Now, can you do another test?<br>
<br>When you configure and compile OpenDBX, you can see there is /test inside the folder of OpenDBX.<br><br>in /test you have an executable to run tests. YOu can do:<br><br> ./odbxplustest -b oracle -p 1521 -d 'mysid' -u 'user' -w 'password' -v<br>
<br>-v is verbose <br><br>run that from command line and see if it works or if there is a problem. In such case, please paste console. <br><br><br>Cheers<br><font color="#888888"><br>Mariano <br><br><br></font></div><div>
<div></div><div class="h5"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div><br></div><div>With the <span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse"> Squeak 64-32 5.7b1 VM all the FFIPluginTests produced an error/failed, it is an experimental 64bit VM though so I guess that's expected ?</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse"><br></span></div><div><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Thanks</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Colin</span></div><div><div></div><div><div><br><br><div class="gmail_quote">On Sun, Aug 1, 2010 at 5:24 PM, Mariano Martinez Peck <span dir="ltr"><<a href="mailto:marianopeck@gmail.com" target="_blank">marianopeck@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><br><br><div class="gmail_quote"><div>On Sun, Aug 1, 2010 at 5:04 PM, Colin Doherty <span dir="ltr"><<a href="mailto:colin.doherty@gmail.com" target="_blank">colin.doherty@gmail.com</a>></span> wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
Hi,<div><br></div><div><div>I've tried using the Pharo 1.1 OneClick image (not sure what the VM version is for this) and have tried Squeak Seaside 3.0 image, Squeak/VM version 4.1 I think ?. I installed it using Metacello. This is the version of OpenDBX: OpenDBX-Core-MarianoMartinezPeck.246 and SqueakDBX-Smalltalk-Dialect-MarianoMartinezPeck.3 from what I can see in ConfigurationOfSqueakDBX>>version11.</div>
<div><br></div></div></blockquote><div><br>Ok, this is perfect. Now...could you test the same image of Pharo 1.1 but using another VM than the one that it is in the one click.<br><br>The one click VM is Squeak 4.2.5beta1U<br>
Can you try with Squeak 64-32 5.7b1 ??<br>
<a href="ftp://ftp.smalltalkconsulting.com/Squeak%2064-32%205.7b1.app.zip" target="_blank">ftp://ftp.smalltalkconsulting.com/Squeak%2064-32%205.7b1.app.zip</a><br>
<br>In addition (to see if we have more logs) can you enable the debug mode in those VMs ? <br><br>to do that, you need to open the .app (show package contents) and then, in the file Info.plist you have to enable debug mode:<br>
<br> <key>SqueakDebug</key><br> <integer>1</integer><br><br>or...from the mac os tool to edit .plist<br><br>then...open first the Mac OS Console, and luckily we will have more information. <br>
<br> </div><div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><div></div><div>I've just tried a simple connect example:</div><div>
<br></div>
<div><div>|conn connectionSettings rs |</div><div><br></div><div>connectionSettings:= DBXConnectionSettings </div><div>host:'<a href="http://hostname.com" target="_blank">hostname.com</a>'</div>
<div>port:'1521'</div><div>database:'mysid'</div><div>userName:'username'</div><div>userPassword: 'pw'.</div><div><br></div><div>conn := DBXConnection platform: DBXOraclePlatform new settings: connectionSettings.</div>
<div>conn connect.</div><div>conn open.</div><div>rs := conn execute: 'select job from emp'.</div></div><div><br></div></blockquote></div><div><br>Ok...what happens if you do all that but not the conn execute ? (i mean, jut connect and open). Try this:<br>
<br><div><div><div>|conn connectionSettings rs |</div><div><br></div><div>connectionSettings:=
DBXConnectionSettings </div><div>host:'<a href="http://hostname.com/" target="_blank">hostname.com</a>'</div>
<div>port:'1521'</div><div>database:'mysid'</div><div>userName:'username'</div><div>userPassword:
'pw'.</div><div><br></div><div>conn := DBXConnection platform:
DBXOraclePlatform new settings: connectionSettings.</div>
<div>conn connect.</div><div>conn open.</div></div><div>conn disconnect.<br><br>does it work?<br></div></div><br> </div><div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div></div><div>I've done no tests of FFI but it installed ok as far as I could see.</div><div><br></div></blockquote></div><div><br>No, but they came with FFI. Check in the category FFI-Tests there are tests like FFIPluginTests<br>
<br> <br></div><div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><div></div>
<div>I'm using opendbx-1.4.5. </div></blockquote></div><div><br>Ok...can you please recompile using the debug mode enabled?<br> To do that ./configure --enable-debug-<span>log</span> and then a
.<span>log</span> file per connection is generated in the
directory where you are calling opendbx <br><br>However, if I remember correctly, this was added in opendbx-1.5.0, not in 1.4.5.<br><br>You can download it from: <a href="http://linuxnetworks.de/opendbx/download/libopendbx-1.5.0.tar.gz" target="_blank">http://linuxnetworks.de/opendbx/download/libopendbx-1.5.0.tar.gz</a><br>
<br>So...compile like that, and run your test again. Then, please send the generated log.<br><br>Let's do all these tests, and then we can contact someone to help us.<br><br>Thanks<br><font color="#888888"><br>Mariano<br>
</font></div><div><div></div><div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div><br></div><div>Thanks</div><div>Colin</div><div><font color="#888888"><br><br></font><div class="gmail_quote"><div>On Sun, Aug 1, 2010 at 3:17 PM, Mariano Martinez Peck <span dir="ltr"><<a href="mailto:marianopeck@gmail.com" target="_blank">marianopeck@gmail.com</a>></span> wrote:<br>
</div><div><div></div><div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">HI. wow...never saw this problem.<br><br>Which Squeak VM are you using?<br>
<br>What is exactly what you are running in the image side that brings that error ? <br>
<br>thanks<br><br>mariano<br><br><div class="gmail_quote"><div><div></div><div>On Sun, Aug 1, 2010 at 4:04 PM, Colin Doherty <span dir="ltr"><<a href="mailto:colin.doherty@gmail.com" target="_blank">colin.doherty@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><div><div></div><div>Hi,<div><br></div><div>I've tried installing squeakDBX and got it installed using the 32 bit Oracle 10.2.0.4 instant client using this config:</div>
<div><br></div><div>CFLAGS="-m32" CPPFLAGS="-m32 -I/usr/local/instantclient10_2/sdk/include" LDFLAGS="-arch i386 -L/usr/local/instantclient10_2" ./configure --disable-utils --with-backends="oracle"</div>
<div><br></div><div>However, I'm getting the following error when I try to use it in either squeak 4.1 or pharo 1.1:</div><div><br></div><div>Out of memory error</div><div><br></div><div>This is from the log:</div><div>
<br></div><div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading /Users/DevelopmentSmalltalk/Pharo/Plugins/opendbx.so</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading /Users/Development/Smalltalk/Pharo/Plugins/opendbx.dylib</div>
<div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading /Users/Development/Smalltalk/Pharo/Plugins/libopendbx</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading /Users/Development/Smalltalk/Pharo/Plugins/libopendbx.so</div>
<div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading /Users/Development/Smalltalk/Pharo/Plugins/libopendbx.dylib</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading ./opendbx.bundle/Contents/MacOS/opendbx</div>
<div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading ./opendbx</div><div>Jul 31 20:57:47: --- last message repeated 1 time ---</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading ./opendbx.so</div>
<div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading ./opendbx.dylib</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading ./libopendbx</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading ./libopendbx.so</div>
<div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading ./libopendbx.dylib</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading /Users/Development/Smalltalk/Pharo/Pharo-1.1-OneClick.app/Contents/Resources/opendbx.bundle/Contents/MacOS/opendbx</div>
<div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: tryLoading /Users/Development/Smalltalk/Pharo/Pharo-1.1-OneClick.app/Contents/Resources/opendbx</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: ioFindExternalFunctionIn(odbx_init, 2155408)</div>
<div>Jul 31 20:57:47 MacBook Squeak VM Opt[22081]: Squeak VM Opt(22081,0xa0bf2500) malloc: *** error for object 0xf1f2f3f4: pointer being freed was not allocated\n*** set a breakpoint in malloc_error_break to debug</div>
<div>
Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: Squeak VM Opt(22081,0xa0bf2500) malloc: *** error for object 0xf1f2f3f4: pointer being freed was not allocated</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: *** set a breakpoint in malloc_error_break to debug</div>
<div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: ioFindExternalFunctionIn(odbx_error, 2155408)</div><div>Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: ioFindExternalFunctionIn(odbx_error_type, 2155408)</div>
<div>Jul 31 21:01:49 MacBook Safari[8492]: INSERT-HANG-DETECTED: Tx time:18.496361, # of Inserts: 0, # of bytes written: 0, Did shrink: YES</div><div>Jul 31 21:05:31 MacBook [0x0-0x39039].org.squeak.pharo[22081]: VM: MouseModifierStateCarbon buttonStateBits 1 modifier</div>
</div><div><br></div><div>I've also tried compiling a 64 bit version which worked and used the experimental 64 bit squeak vm, this doesn't work but generates no errors. Any ideas on how to fix the 32 bit out of memory issue ?</div>
<div><br></div><div>Thanks</div>
<br></div></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>
<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></div></div><br></div>
<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></div></div><br>
<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></div>
</div></div><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></div></div><br>
<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></div>