Hello there,<br>
<br>
Kudos first to the blastwave maintainers! I've been trying to get
unixodbc and myodbc working on a solaris 10 x86 system, got all the
packages at blastwave. Have had no success in using these, always
segfaults at the statement my_sqlprepare.<br>
<br>
Here's a trace of an isql crash:<br>
Reading ld.so.1<br>
Reading libodbc.so.1.0.0<br>
Reading libdl.so.1<br>
Reading libiconv.so.2.2.0<br>
Reading libreadline.so.5<br>
Reading libthread.so.1<br>
Reading libc.so.1<br>
Reading libcurses.so.1<br>
Reading <a href="http://libmyodbc3-3.51.11.so">libmyodbc3-3.51.11.so</a><br>
Reading libmysqlclient.so.14.0.0<br>
Reading librt.so.1<br>
Reading libgen.so.1<br>
Reading libsocket.so.1<br>
Reading libnsl.so.1<br>
Reading libm.so.1<br>
Reading libssl.so.0.9.7<br>
Reading libcrypto.so.0.9.7<br>
Reading libz.so.1.2.3<br>
Reading libodbcinst.so.1.0.0<br>
Reading libssl.so.0.9.8<br>
Reading libcrypto.so.0.9.8<br>
Reading libaio.so.1<br>
Reading libmd5.so.1<br>
Reading libmp.so.2<br>
Reading libscf.so.1<br>
Reading libdoor.so.1<br>
Reading libuutil.so.1<br>
Reading nss_files.so.1<br>
t@null (l@1) program terminated by signal SEGV (no mapping at the fault address)<br>
0xd242157d: my_SQLPrepare+0x0064: cmpl $0x00000000,0x00000004(%ecx)<br>
(dbx) where<br>
=>[1] my_SQLPrepare(0x808d388, 0x8063c20, 0xfffffffd), at 0xd242157d<br>
[2] SQLPrepare(0x808d388, 0x8063c20, 0xfffffffd), at 0xd242150e<br>
[3] SQLPrepare(0x808cda8, 0x8063c20, 0xfffffffd), at 0xd273bcd0<br>
[4] 0x80517be(0x8067768, 0x8063c20, 0x0, 0x0, 0x0), at 0x80517be<br>
[5] main(0x4, 0x8047b90, 0x8047ba4), at 0x8051482<br>
<br>
<br>
while here's a trace when using php_odbc:<br>
Reading ld.so.1<br>
Reading libcrypt_i.so.1<br>
Reading libmm.so.13.0.20<br>
Reading <a href="http://libdb-4.3.so">libdb-4.3.so</a><br>
Reading librt.so.1<br>
Reading libresolv.so.2<br>
Reading libm.so.1<br>
Reading libsocket.so.1<br>
Reading libnsl.so.1<br>
Reading libz.so.1.2.3<br>
Reading libxml2.so.2.6.26<br>
Reading libdl.so.1<br>
Reading libpthread.so.1<br>
Reading libiconv.so.2.2.0<br>
Reading libc.so.1<br>
Reading libgen.so.1<br>
Reading libaio.so.1<br>
Reading libmd5.so.1<br>
Reading mysql.so<br>
Reading libmysqlclient.so.15.0.0<br>
Reading libssl.so.0.9.8<br>
Reading libcrypto.so.0.9.8<br>
Reading mysqli.so<br>
Reading odbc.so<br>
Reading libodbc.so.1.0.0<br>
Reading libthread.so.1<br>
Reading <a href="http://libmyodbc3-3.51.11.so">libmyodbc3-3.51.11.so</a><br>
Reading libmysqlclient.so.14.0.0<br>
Reading libssl.so.0.9.7<br>
Reading libcrypto.so.0.9.7<br>
Reading libodbcinst.so.1.0.0<br>
Reading libmp.so.2<br>
Reading libscf.so.1<br>
Reading libdoor.so.1<br>
Reading libuutil.so.1<br>
Reading nss_files.so.1<br>
t@null (l@1) program terminated by signal SEGV (no mapping at the fault address)<br>
0xd1c4157d: my_SQLPrepare+0x0064: cmpl $0x00000000,0x00000004(%ecx)<br>
(dbx) where<br>
=>[1] my_SQLPrepare(0x8361670, 0x834cf88, 0xfffffffd), at 0xd1c4157d<br>
[2] SQLExecDirect(0x8361670, 0x834cf88, 0xfffffffd), at 0xd1c3e480<br>
[3] SQLExecDirect(0x83506a0, 0x834cf88, 0xfffffffd), at 0xd1cd1d6a<br>
[4] zif_odbc_exec(0x2, 0x834bec8, 0x0, 0x0, 0x1), at 0xd1d44ebe<br>
[5] 0x81a8cb6(0x8047408), at 0x81a8cb6<br>
[6] 0x81ab077(0x8047408), at 0x81ab077<br>
[7] execute(0x834cfb8), at 0x81a86a2<br>
[8] zend_execute_scripts(0x8, 0x0, 0x3, 0x0, 0x8047a68, 0x0), at 0x818daf2<br>
[9] php_execute_script(0x8047a68), at 0x8154550<br>
[10] main(0x2, 0x8047ba8, 0x8047bb4), at 0x81dfdda<br>
<br>
This happens for both mysql4 and mysql5, even if I also got both at blastwave.<br>
<br>
Any help would be dearly appreciated. Googling gave no additional info
or workarounds. I've tried compiling the source packages from the
unixodbc and myodbc websites, but compilation of these doesn't seem
that straightforward for solaris.<br>
<br>
Thanks so much,<br>
Tim<br>
<br>
<br>
<br>