[Pharo-project] SqueakDBX and MacOS X

May 17, 2011

      Hi,

I try to use SqueakDBX on Mac OS X 10.6. I have downloaded and compiled 
the libraries for PostgreSQL, MySQL and finaly compiled and installed 
openDBX.

CPPFLAGS="-I/opendbx/PostgreSQL/9.0/include -I/opendbx/mysql/5.0/include"
LDFLAGS="-L/opendbx/PostgreSQL/9.0/lib -L/opendbx/mysql/5.0/lib"
./configure --disable-utils --with-backends="pgsql mysql sqlite3"

Now, I have in /usr/local/lib:

-rwxr-xr-x  1 root  wheel   17040 17 mai 09:10 libopendbx.1.dylib
-rw-r--r--  1 root  wheel   32584 17 mai 09:10 libopendbx.a
lrwxr-xr-x  1 root  wheel      18 17 mai 09:10 libopendbx.dylib -> 
libopendbx.1.dylib
-rwxr-xr-x  1 root  wheel    1001 17 mai 09:10 libopendbx.la
-rwxr-xr-x  1 root  wheel   74624 17 mai 09:10 libopendbxplus.1.dylib
-rw-r--r--  1 root  wheel  385056 17 mai 09:10 libopendbxplus.a
lrwxr-xr-x  1 root  wheel      22 17 mai 09:10 libopendbxplus.dylib -> 
libopendbxplus.1.dylib
-rwxr-xr-x  1 root  wheel    1054 17 mai 09:10 libopendbxplus.la

and in /usr/local/opendbx :
-rwxr-xr-x  1 root  wheel  17232 17 mai 09:10 libmysqlbackend.1.so
-rw-r--r--  1 root  wheel  38960 17 mai 09:10 libmysqlbackend.a
-rwxr-xr-x  1 root  wheel   1051 17 mai 09:10 libmysqlbackend.la
lrwxr-xr-x  1 root  wheel     20 17 mai 09:10 libmysqlbackend.so -> 
libmysqlbackend.1.so
-rwxr-xr-x  1 root  wheel  16904 17 mai 09:10 libpgsqlbackend.1.so
-rw-r--r--  1 root  wheel  28624 17 mai 09:10 libpgsqlbackend.a
-rwxr-xr-x  1 root  wheel   1036 17 mai 09:10 libpgsqlbackend.la
lrwxr-xr-x  1 root  wheel     20 17 mai 09:10 libpgsqlbackend.so -> 
libpgsqlbackend.1.so
-rwxr-xr-x  1 root  wheel  16856 17 mai 09:10 libsqlite3backend.1.so
-rw-r--r--  1 root  wheel  25936 17 mai 09:10 libsqlite3backend.a
-rwxr-xr-x  1 root  wheel   1053 17 mai 09:10 libsqlite3backend.la
lrwxr-xr-x  1 root  wheel     22 17 mai 09:10 libsqlite3backend.so -> 
libsqlite3backend.1.so

ok...

I have downloaded the OneClick distribution of Pharo 1.2.1 and installed 
SqueakDBX and GlorpDBX.

Gofer new squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfSqueakDBX';
load.

ConfigurationOfSqueakDBX project latestVersion load.

Gofer new squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfGlorpDBX';
load.

ConfigurationOfGlorpDBX project latestVersion load.

Now, I try to do a SQL request to MySQL:

connect
      | conn connectionSettings result |

     connectionSettings := DBXConnectionSettings
         host: 'mysql.domaine.fr'
         port: '3306'
         database: 'test'
         userName: 'username'
         userPassword: 'hello'.

     conn := DBXConnection
         platform: DBXMySQLPlatform new
         settings: connectionSettings.

     conn connect.

     conn open.
     result := conn execute: 'SELECT * from data'.

     DBXTranscript show: result.

     conn close.

But I get an error :  'Unable to find function address'

SqueakDBX didn't found the libraries ? I have try to copy the librairies 
in /usr/lib and /usr/lib/opendbx but with no results. In the Resources 
subdirectory, I have created a symbolic link to 
/usr/local/lib/libopendbx.dylib but without progress.

ln -s /usr/local/lib/libopendbx.dylib opendbx

  I get the same error :-(

If i modify the info.plist file to set the SqueakDebug key at 1 and the 
SqueakPluginsBuiltInOrLocalOnly key at false, I can see the search of 
librairies by the SqueakVM. The SqueakVM doesn't seem to try to load the 
openddbx libraries.

You can download the log file at 
http://www.auverlot.fr/squeakdbx/squeakdbx.txt

My previous tests under Linux have worked fine but i didn't find a 
solution with Mac OS X. Someone has an idea for help me ???

Thanks for your help.

Best regards
Olivier
www.auverlot.fr

[Pharo-project] SqueakDBX and MacOS X

Olivier Auverlot