Re: Compiling Perl MySQL DBD on FreeBSB for BillMax - Schuyler W Langdon - com.mysql.lists.perl

10 messages in com.mysql.lists.perlRe: Compiling Perl MySQL DBD on FreeB...

From	Sent On	Attachments
Peter LaForest	01 Oct 2002 06:43
bruc...@ida.net	01 Oct 2002 08:54
Schuyler W Langdon	01 Oct 2002 08:57
John Von Essen	01 Oct 2002 09:05
Nick Tonkin	01 Oct 2002 10:21
Peter LaForest	01 Oct 2002 10:58
Peter LaForest	02 Oct 2002 07:30
Peter LaForest	02 Oct 2002 10:47
Todd Finney	02 Oct 2002 12:56
Peter LaForest	03 Oct 2002 07:29

Subject:	Re: Compiling Perl MySQL DBD on FreeBSB for BillMax
From:	Schuyler W Langdon (gord...@hotmail.com)
Date:	10/01/2002 08:57:13 AM
List:	com.mysql.lists.perl

Hello,

I am a Unix newbie in desperate need of help.

We are building a billing server for our company:

OS: FreeBSD 4.6 APP: BillMax w/MySQL

I need to write some Perl DBI hooks to interact with the MySQL db.

I was able to compile and install DBI-1.30 and Data-ShowTable-3.3 fine.

I am trying to compile DBD-mysql-2.1020 and have read all available documentation on how to set the --cflags and --libs when running Makefile.PL but it still can't pass the make test. It fails 96% of the tests.

I know that there is also the issue with different compilers and I have tried to tell Makefile to use gcc but I can't seem to get the syntax right for my Makefile command.

Here is the info:

gcc is at /usr/lib/libgcc.a

mysql.h is at /usr/local/billmax/mysql/include/mysql

libs are at /usr/local/billmax/mysql/lib/mysql (libmysqlclient.so)

test db/user/pw are not default so I have to set these as well

I would be most appreciative if someone could help me get the syntax down for the Makefile command.

Thank you.

I had the same almost identical problem on FreeBSD 4.6. After hours of trying MCPAN, and manually compiling against the what I thought were the right mysql libraries, I finally broke down and used the ports as described.

1) Installed the mysqlclient port found in -- /usr/ports/databases/ You only need the client. This will install the libaries and bins so that the DBD::mysql port makefile will find them in the default places without having to add any flags. 2) Installed the DBD::mysql port -- think this is also in /usr/ports/databases I think this will skip the tests, not sure. But after this was installed, the DBD::mysql driver worked.