Bugzilla having problem connecting to MySQL database on Mac OS X Lion

[jasonM]

Hi,
I'm trying to install Bugzilla 4.0.1 on Mac OS X Lion. I've
managed to install all necessary and most optional Perl modules. When
I run the checksetup.pl script, I get the following error:

There was an error connecting to MySQL:

install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.
Compilation failed in require at (eval 1296) line 3, <DATA> line 522.

at Bugzilla/DB.pm line 1154

This might have several reasons:

* MySQL is not running.
* MySQL is running, but there is a problem either in the
server configuration or the database access rights. Read the Bugzilla
Guide in the doc directory. The section about database configuration
should help.
* Your password for the 'bugs' user, specified in $db_pass, is
incorrect, in './localconfig'.
* There is a subtle problem with Perl, DBI, or MySQL. Make
sure all settings in './localconfig' are correct. If all else fails,
set
'$db_check' to 0.

I've followed the installation instructions for Bugzilla. I can log
into MySQL with the username and password I've set in localconfig, and
I've set up the bugs user as defined in the Bugzilla installation
instructions (i.e. permissions as described here,
http://www.bugzilla.org/docs/3.0/html/configuration.html#database-engine).
Has anyone seen this error and know what it means and how to resolve
it? I have installed mysql-5.5.15-osx10.6-x86_64.

Thanks,

Jason Mazzotta

[bugedbybugzilla]

Hi Jason,

Did you ever find a solution to this problem? I'm having the same problem.

Thanks!

[kim....@gmail.com]

Solve:
http://probably.co.uk/problems-installing-dbdmysql-on-os-x-snow-leopard.html

sudo install_name_tool -id /usr/local/mysql-5.5.19-osx10.6-x86_64/lib/libmysqlclient.18.dylib /usr/local/mysql-5.5.19-osx10.6-x86_64/lib/libmysqlclient.18.dylib


otool -D `mdfind libmysqlclient.18.dylib` /usr/local/mysql-5.5.19-osx10.6-x86_64/lib/libmysqlclient.18.dylib: /usr/local/mysql-5.5.19-osx10.6-x86_64/lib/libmysqlclient.18.dylib

copy:
sudo /usr/local/mysql-5.5.19-osx10.6-x86_64/lib/libmysqlclient.18.dylib /usr/lib

[expi...@gmail.com]

Thanks, Copying libmysqlclient.18.dylib to /usr/lib did solve my problem.