SAMP perl dbi mysql
I have Solaris 10 0606 running with Apache2 mysql and php - all standard. I can access data on mysql thru a simple php script via Apache2. I would like to run a Perl cgi script to access the mysql database, but am having problems. It appears DBI.pm is not available. Does Solaris 10's 0606 full install support the ability to access mysql data via Perl DBI or other mechanism? If so, does anyone have a simple example of how this was done? If it is not supported, and additional Perl modules or other configurations are needed, does any one have a listing of steps to get this working? Thanks!
[601 byte] By [
_junkken] at [2007-11-26 8:59:58]
# 1
Here is a forum link which mentions "because the net is infested with other people having fits with this on solaris...."
http://forum.sun.com/jive/thread.jspa?threadID=96067&messageID=331249
And more information
http://woss.name/2006/05/21/installing-dbimysql-on-solaris-10/
# 2
This is a bug report I filed with Blastwave.org after attempt to use their DBI::Mysql package.
*****
perl: fatal: relocation error
Description I cant get Solaris 5.10 0606 packaged version of perl and Mysql to connect using Blastwave added module pm_dbi and pm_dbdmysql. Fails with -- ld.so.1: perl: fatal: relocation error: file /opt/csw/lib/perl/csw/auto/DBI/DBI.so: symbol Perl_Gthr_key_ptr: referenced symbol not found
Additional Information SunOS sol10 5.10 Generic_118855-15 i86pc i386 i86pc
This is perl, v5.8.4 built for i86pc-solaris-64int
(with 28 registered patches, see perl -V for more detail)
mysql Ver 12.22 Distrib 4.0.24, for pc-solaris2.10 (i386)
smupdate 07-25-2006
$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
Supporting information:
http://woss.name/2006/05/21/installing-dbimysql-on-solaris-10/
http://forum.sun.com/jive/thread.jspa?threadID=96067&messageID=331249
******************************
And the bug report response:
******************************
http://www.blastwave.org/mantis/view_bug_page.php?f_id=0001674
This is not a bug in CSWpmdbi. All blastwave perl modules are built to use CSWperl. CSWpmdbi is also built to work with CSWmysql4.
I recommend that you use the blastwave packages and not the Sun supplied packages. Many sites use the blastwave packages and they can use any other blastwave package that needs perl and mysql. The same is true for perl and postgresql.
Or, if you believe that you must use the Sun supplied perl and mysql, you should be able to build and install DBI. You will need to download Studio 11. Studio 11 is available at no cost to you.
# 3
I ended up downloading the free Studio 11 and installing the necessary
modules from CPAN. It was very easy. Thanks Sun for providing this for
free. Install requirements are here :
http://docs.sun.com/source/819-3052/introduction.html
which is a bit much for just getting Perl to talk to Mysql.
Makes me wonder why Sun does not provide the necessary componants to
install Perl modules in the Solaris distribution.
