Le 22/05/11 15:58, Mariano Martinez Peck a �crit�:

Thanks Olivier. I have updated the website :)

http://www.squeakdbx.org/MySQL%20and%20PostgreSQL%20for%20mac

it's cool ;-)

Now...do you remember the links where you download the 32bits Mac OS client for PostgreSQL ?

�I haven't found a distribution of the library for PostgreSQL. I downloaded and installed the PostgreSQL server on my computer and extracted the files of the client interface.

And for MySQL did you use http://dev.mysql.com/downloads/mysql/5.1.html � "Mac OS X 10.5 (x86)"� also ?�� if not, which one ?

yes

I have created an archive with the libraries for MysqL 5.1 and PostgreSQL. You can download it at http://www.auverlot.fr/squeakdbx/squeackDBXlibclients.zip

Best regards
Olivier ;-)
www.auverlot.fr

Thanks in advance,

Mariano

On Wed, May 18, 2011 at 11:42 AM, Olivier Auverlot <olivier.auverlot@gmail.com> wrote:

In my previous note, I have forget to say that it's necessary to modify the key SqueakPluginsBuiltInOrLocalOnly in the Info.plist file. The value of this parameter must be "false".

There are also� a little error. The temporary directory is "opendbx" and not "openDBX".

Best regards
Olivier ;-)
www.auverlot.fr

Thanks a lot Olivier.
I know it is a pain. I suffered with my mac also.
So....I will update: http://www.squeakdbx.org/Different%20backends%20under%20Mac
with your data.

Thanks

On Wed, May 18, 2011 at 10:10 AM, Olivier Auverlot <olivier.auverlot@gmail.com> wrote:

After many hours to try to install OpenDBX and SqueakDBX on my Mac Intel with a 64 bit processor, I'm very happy to propose you a little step by step tutorial.

1. Download the client libraries for MySQL and PostgreSQL. Warning ! you must get the 32 bits version. Create a temporary directory named "openDBX" where you want. For me, I have put the directory at the root of my system path.My directory contains :

�� �> mysql
�� ��� �> 5.0
�� ��� ��� �> include
�� ��� ��� �> lib
�� �> PostgreSQL
�� ��� �> 9.0
�� ��� ��� �> include
�� ��� ��� �> lib
�� ��� ��� �
2. Download openDBX and compile it in 32 bits mode (because the Smalltalk virtual machine is a 32 bits application). I have write a little shell script to produce the configuration of the compiler.Of course, you must set the directories for the include files and the librairies path.

CFLAGS="-m32" \
CXXFLAGS="-m32" \
CPPFLAGS="-m32 -I/opendbx/PostgreSQL/9.0/include -I/opendbx/mysql/5.0/include" \
LDFLAGS="-m32 -L/opendbx/PostgreSQL/9.0/lib -L/opendbx/mysql/5.0/lib" \
./configure --disable-utils --with-backends="mysql pgsql sqlite3"

Run it and do :
�� �make
�� �make install
�� �
All the files are copied in the /usr/local/lib directory and the /usr/local/lib/opendbx subdirectory.

3. Copy the MySQL and PostgreSQL clients librairies into /usr/local/bin (the include files are unused).

4. Now, you must launch Pharo to install SqueakDBX.

Gofer new squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfSqueakDBX';
load.

ConfigurationOfSqueakDBX project latestVersion load.

Gofer new squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfGlorpDBX';
load.

ConfigurationOfGlorpDBX project latestVersion load.

5. You could remove the temporary "openDBX" directory (step 1).

6. The installation is completed.

Olivier ;-)
www.auverlot.fr

Hi Olivier,

�IIRC, you should:
�1) fix the location problem by putting symlink in the right place.
�2) ensure that your dylib is compiled for the right architecture (32bit) considering that current VMs are 32bits
�Perhaps this is your problem?
�what gives:

�$ lipo -info libopendbx.dylib

#Luc

2011/5/17 Olivier Auverlot <olivier.auverlot@gmail.com>

Hi,

I try to use SqueakDBX on Mac OS X 10.6. I have downloaded and compiled the libraries for PostgreSQL, MySQL and finaly compiled and installed openDBX.

CPPFLAGS="-I/opendbx/PostgreSQL/9.0/include -I/opendbx/mysql/5.0/include"
LDFLAGS="-L/opendbx/PostgreSQL/9.0/lib -L/opendbx/mysql/5.0/lib"
./configure --disable-utils --with-backends="pgsql mysql sqlite3"

Now, I have in /usr/local/lib:

-rwxr-xr-x� 1 root� wheel�� 17040 17 mai 09:10 libopendbx.1.dylib
-rw-r--r--� 1 root� wheel�� 32584 17 mai 09:10 libopendbx.a
lrwxr-xr-x� 1 root� wheel����� 18 17 mai 09:10 libopendbx.dylib -> libopendbx.1.dylib
-rwxr-xr-x� 1 root� wheel��� 1001 17 mai 09:10 libopendbx.la
-rwxr-xr-x� 1 root� wheel�� 74624 17 mai 09:10 libopendbxplus.1.dylib
-rw-r--r--� 1 root� wheel� 385056 17 mai 09:10 libopendbxplus.a
lrwxr-xr-x� 1 root� wheel����� 22 17 mai 09:10 libopendbxplus.dylib -> libopendbxplus.1.dylib
-rwxr-xr-x� 1 root� wheel��� 1054 17 mai 09:10 libopendbxplus.la

and in /usr/local/opendbx :
-rwxr-xr-x� 1 root� wheel� 17232 17 mai 09:10 libmysqlbackend.1.so
-rw-r--r--� 1 root� wheel� 38960 17 mai 09:10 libmysqlbackend.a
-rwxr-xr-x� 1 root� wheel�� 1051 17 mai 09:10 libmysqlbackend.la
lrwxr-xr-x� 1 root� wheel���� 20 17 mai 09:10 libmysqlbackend.so -> libmysqlbackend.1.so
-rwxr-xr-x� 1 root� wheel� 16904 17 mai 09:10 libpgsqlbackend.1.so
-rw-r--r--� 1 root� wheel� 28624 17 mai 09:10 libpgsqlbackend.a
-rwxr-xr-x� 1 root� wheel�� 1036 17 mai 09:10 libpgsqlbackend.la
lrwxr-xr-x� 1 root� wheel���� 20 17 mai 09:10 libpgsqlbackend.so -> libpgsqlbackend.1.so
-rwxr-xr-x� 1 root� wheel� 16856 17 mai 09:10 libsqlite3backend.1.so
-rw-r--r--� 1 root� wheel� 25936 17 mai 09:10 libsqlite3backend.a
-rwxr-xr-x� 1 root� wheel�� 1053 17 mai 09:10 libsqlite3backend.la
lrwxr-xr-x� 1 root� wheel���� 22 17 mai 09:10 libsqlite3backend.so -> libsqlite3backend.1.so

ok...

I have downloaded the OneClick distribution of Pharo 1.2.1 and installed SqueakDBX and GlorpDBX.

Gofer new squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfSqueakDBX';
load.

ConfigurationOfSqueakDBX project latestVersion load.

Gofer new squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfGlorpDBX';
load.

ConfigurationOfGlorpDBX project latestVersion load.

Now, I try to do a SQL request to MySQL:

connect
���� | conn connectionSettings result |

��� connectionSettings := DBXConnectionSettings
��� ��� host: 'mysql.domaine.fr'
��� ��� port: '3306'
��� ��� database: 'test'
��� ��� userName: 'username'
��� ��� userPassword: 'hello'.
��� ���
��� conn := DBXConnection
��� ��� platform: DBXMySQLPlatform new
��� ��� settings: connectionSettings.
��� ���
��� conn connect.
���
��� conn open.
��� result := conn execute: 'SELECT * from data'.

��� DBXTranscript show: result.

��� conn close.

But I get an error :� 'Unable to find function address'

SqueakDBX didn't found the libraries ? I have try to copy the librairies in /usr/lib and /usr/lib/opendbx but with no results. In the Resources subdirectory, I have created a symbolic link to /usr/local/lib/libopendbx.dylib but without progress.

ln -s /usr/local/lib/libopendbx.dylib opendbx

�I get the same error :-(

If i modify the info.plist file to set the SqueakDebug key at 1 and the SqueakPluginsBuiltInOrLocalOnly key at false, I can see the search of librairies by the SqueakVM. The SqueakVM doesn't seem to try to load the openddbx libraries.

You can download the log file at http://www.auverlot.fr/squeakdbx/squeakdbx.txt

My previous tests under Linux have worked fine but i didn't find a solution with Mac OS X. Someone has an idea for help me ???

Thanks for your help.

Best regards
Olivier
www.auverlot.fr

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

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