OpenDBX > MySQL and OSX Lion : working on 2.0

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

OpenDBX > MySQL and OSX Lion : working on 2.0

philippe.back@highoctane.be
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.

--
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.
 
 
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: OpenDBX > MySQL and OSX Lion : working on 2.0

Guillermo Polito
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 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.
 
 
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: OpenDBX > MySQL and OSX Lion : working on 2.0

philippeback
Cool.

I needed to put the path to Xcode tools since I've other stuff on this box (MacPorts) and this caused the wrong ld to be picked up for example (/opt/local/bin/ld coming out of which ld).

Phil



---
Philippe Back
Dramatic Performance Improvements
Mob: +32(0) 478 650 140 | Fax: +32 (0) 70 408 027
Blog: http://philippeback.be | Twitter: @philippeback

High Octane SPRL
rue cour Boisacq 101 | 1301 Bierges | Belgium

Featured on the Software Process and Measurement Cast
Sparx Systems Enterprise Architect and Ability Engineering EADocX Value Added Reseller
 



On Mon, Jul 29, 2013 at 10:51 AM, Guillermo Polito <[hidden email]> wrote:
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.
 
 

--
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.
 
 
Loading...