Thanks! Once (when the project was still named squeakDBX) we used to have a tutorial (step by step) for each combination of OS and database (ok, not for all of them, but for most). But we kind of lost the image and we couldn't recover that. Anyway, it's time to start building that again.

Thanks! 

On Mon, Jul 29, 2013 at 6:09 AM, Guillermo Polito <guillermopolito@gmail.com> wrote:

Thanks! I updated the tutorial with your info :).

On Sun, Jul 28, 2013 at 9:49 PM, phil@highoctane.be <phil@highoctane.be> wrote:

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

--
Mariano
http://marianopeck.wordpress.com