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.

Next step is to try to get GLORP running, not sure I'll go that route.

Phil

Reply via email to