OpenDBX > MySQL and OSX Lion : working on 2.0

Hi Phil! Thank you very much, I'm taking some minutos to update the tutorial right now.

However, some questions :).

On Sun, Jul 28, 2013 at 10:20 PM, Philippe Back <[hidden email]> 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

So far so good 

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`

Why do you need to add that in path? I've just tried compiling myself and I didn't need Xcode usr/bin in my path...

 

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

Just copypasted and it works :).

 

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

Another solution is to add the path of the dynamic libraries to DYLD_LIBRARY_PATH

 

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.

Just doing it :)

 

--
You received this message because you are subscribed to the Google Groups "DBXTalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
You received this message because you are subscribed to a topic in the Google Groups "DBXTalk" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dbxtalk/Zqn7WoDKYXs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.