Building DBD::mysql with SUNWspro and pkgsrc on Solaris 11 Express
I use resmon, which is a pretty nice system metric aggregator. It relies on the system Perl specifically for Solaris::Kstat, and so you don’t have to install pieces of the CPAN to get it running. Earlier tonight I decided to point its default MySqlStatus module at our MySQL master and ran into a few annoyances.
Historically, getting DBD::mysql installed with the system Perl has proven somewhat painful.
We use the packages from mysql.com, whose libmysqlclient is not built shared, so you can’t build DBD::mysql against them. I could have installed pkg:/database/mysql-5? but I already have a MySQL install via pkgsrc.
So, simply:
Make sure /opt/SUNWspro/bin/cc is first in your path, and:
# /bin/perl Makefile.PL —libs=”-L/usr/pkg/lib/mysql -R/usr/pkg/lib/mysql -lmysqlclient -lz” —cflags=”-I/usr/pkg/include/mysql -I/usr/include -m32” # make && make install
And huzzah. DBD::mysql.
