Using DBD::Mysql on OS X Lion Server

Question

Level 3

507 points

Using DBD::Mysql on OS X Lion Server

Hello together,

I have MySQL running on Mac OS X Lion Server.

The server was upgraded from Leopard Server so it is the Apple installed MySQL server version from Mac OS X Server 10.5.

/usr/libexec/mysqld Ver 5.0.67-log for apple-darwin9.0 on i686 (Source distribution)

Now I want to install DBD::Mysql vom cpan but whatever I tried, it didn´t work.

After googling I first I thought it might be an issue of headers and libraries so I copied /usr/local/lib/mysql and /usr/local/include/mysql from a OS X client machine, where I did install DBD::Mysql months ago.

But I got some errors like

dyld: Symbol not found: _mysql_init, referer: ...

and

dyld: lazy symbol binding failed: Symbol not found: _mysql_init, referer: ....

(This is from appache error_log since I am have cgi scripts which use DBD::Mysql)

Then I read some articles that it might be an issue of 32-bit an 64-bit incompatibilities.

Could anyone give me some advice on how to get DBD::Mysql up an running or at least how to find out what the problem really is.

Thanks in advance and best regards

macmartin

OS X Server

Posted on Dec 22, 2012 3:25 PM

Reply

Answer 1

Best reply

macmartin Author

Level 3

507 points

Dec 23, 2012 8:36 AM in response to macmartin

In the meantime I tried many differnt things.

Finally I copied theses files from Mac OS X 10.7 client to the 10.7 Server:

/Library/Perl/5.12/darwin-thread-multi-2level/Bundle/DBD/mysql.pm

/Library/Perl/5.12/darwin-thread-multi-2level/DBD/mysql.pm

/Library/Perl/5.12/darwin-thread-multi-2level/DBD/mysql/GetInfo.pm

/Library/Perl/5.12/darwin-thread-multi-2level/DBD/mysql/INSTALL.pod

/Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bs

/Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle

/usr/local/lib/mysql/

/usr/local/include/mysql

/usr/local/mysql/lib

So if anyone runs into the same problem one possible solution could be to set up DBD::Mysql on 10.7 client and copy the appropriate files to the server.

Best regards

macmartin

Reply