I've been struggling to get the whole thing to work in Pharo 2.0
So, here are some pointers:
I am using Xcode 4.6.3 with command line tools installed.
I used the MySQL 32-bit client: mysql-connector-c-6.1.0-osx10.7-x86.dmg
I used opendbx stable-1.4
To compile OpenDBX itself in 32 bits mode and all, here is the script I used.
[PhilMac:~/Documents/Smalltalk/2-MyWorkspaces/workspaceOpenDbx philippeback$] cat compileopendbxosx.sh
PATH=/Applications/Xcode.app/Contents/Developer/usr/bin:${PATH}
echo `which ld`
CPPFLAGS="-m32 -I/usr/local/mysql-connector-c-6.1.0-osx10.7-x86/include" \
CXXFLAGS="-m32 -I/usr/local/mysql-connector-c-6.1.0-osx10.7-x86/include" \
CFLAGS="-m32 -I/usr/local/mysql-connector-c-6.1.0-osx10.7-x86/include" \
LDFLAGS="-m32 -L/usr/local/lib -L/usr/local/mysql-connector-c-6.1.0-osx10.7-x86/lib -lmysqlclient" \
./configure --with-backends="mysql" --disable-utils LDFLAGS="-m32 -L/usr/local/mysql-connector-c-6.1.0-osx10.7-x86/lib"
make
make install
Now, I had to copy the libraries of the mysql client into /usr/local/lib/
The client libraries were in /usr/local/mysql-connector-c-6.1.0-osx10.7-x86/lib
(you can ln -s them if you do not want to copy).
To test that things were okay, I created the sodbxtest user, database, and all in MySQL.
Then let's make sure we can use that one:
mysql -usodbxtest -psodbxtest sodbxtest
And then went to stable-1.4/test and issued:
./odbxtest -b mysql -h localhost -p 3306 -d sodbxtest -u sodbxtest -w sodbxtest
Which should work.
You can open the MySQL Workbench Admin tab > server status tab and see the commands issued.
I had to do a symlink in:
:
/usr/local/pharo/bin/pharo-vm/Pharo.app/Contents/MacOS/Plugins/
(where I have my pharo vm installed)
so that:
libopendbx.dylib was pointing to /usr/local/lib/libopendbx.dylib
Then, start the image where you have loaded the OpenDBXDriver configuration and run the tests.
You can get the configuration from the World menu > Configurations
OpenDBXDriver (GuillermoPolito.20)
I installed the configuration and then did:
(ConfigurationOfOpenDBXDriver project version: #stable) load.
All tests for the MySQL backend turned up green.
Maybe someone can put the above things in the right sections on the DBXTalk site, I didn't got enough info for the OSX version.