[gnome-db] Provider Error on Mac OS X 10.5.8

[Patrick McEvoy <pmcevoy silvacapitalmanagement com>]

Hello,

I have built libgda-4.2.8 on Mac OS X Leopard using gtk-osx but I am
having issues with the MySQL Provider. The machine has
mysql-5.5.15-osx10.5-x86.dmg installed.  When I try to connect the the
database I get the error "Could not open a connection to the MYSQL
Database.  No provider 'MySQL' found."

I built libgda using:

./configure --with-mysql=yes
make
sudo make install

For mysql ./configure has the following output:

Configuration summary for version 4.2.8
   Installation prefix = /usr/local
   Building GTK+ UI extension: yes
   Building Libxslt extension: yes
   Building libgda GObject Introspection: no
   Building libgda-ui GObject Introspection: no
   Compiled providers:
      Berkeley DB = no
      Berkeley DB SQL = no
      MDB (MS Access) = no
      MySQL = yes
      Oracle = no
      PostgreSQL = no
      SQLite = yes (embedded)
      SQLCipher = yes
      JDBC = no
      WEB = no
      LDAP = yes

And config.log has:

configure:20511: checking for mysql_config
configure:20529: found /usr/local/mysql/bin/mysql_config
configure:20541: result: /usr/local/mysql/bin/mysql_config

config.status:1432: creating providers/reuseable/mysql/Makefile
config.status:1432: creating providers/mysql/Makefile
config.status:1432: creating providers/mysql/libgda-mysql-4.0.pc

ac_cv_path_MYSQL_CONFIG=/usr/local/mysql/bin/mysql_config

MYSQL_CFLAGS='-I/usr/local/mysql/include  -Os -g -fno-common
-fno-strict-aliasing -arch i386'
MYSQL_CONFIG='/usr/local/mysql/bin/mysql_config'
MYSQL_FALSE='#'
MYSQL_LIBS='-L/usr/local/mysql/lib -lmysqlclient   -lpthread'
MYSQL_TRUE=''

The output of bash-3.2$ gda-sql -L is:

                                  Installed providers list
Provider  |
Description                                                                       

----------+------------------------------------------------------------------------------------
SQLite    | Provider for SQLite
databases                                                     
SQLCipher | Provider for
SQLCipher                                                            
Ldap      | Provider for database where tables are based on data
contained in an LDAP directory

The output of make has these errors for sql_parser:

/usr/bin/gcc-4.2 -o lemon ./lemon.c
./lemon -q -d -T./lempar.c ./delimiter.y
./lemon -d -T./lempar.c ./parser.y
3 parsing conflicts.
make[2]: [parser.h] Error 1 (ignored)

and for postgres, mysql, capi:

/usr/bin/gcc-4.2 -o gen_def
-DIMPOSED_HEADER=\""../../../libgda/sql-parser/token_types.h"\" ./gen_def.c
../../../libgda/sql-parser/lemon -q -d
-T../../../libgda/sql-parser/lempar.c ./parser.y
3 parsing conflicts.
make[3]: [parser.h] Error 1 (ignored)

And a lot of warnings of:

Warning: cannot load module 'mallard', using automatic detection (-a).

And for make install:

Reports the above Errors.

Are the errors the cause of the provider issue?  Does anyone have any
tips on how to debug this issue?

Thanks,

Patrick McEvoy