I have been going round-and-a-round for about 24 hrs trying to setup an AMD64 system running Solaris 10 11/06

FYI:
Installed Solaris 10 11/06 from DVD
Installed SunStudio 11 from DVD
Spent hours installing patches from Sun

Installed from source using gcc the following:

Perl5.8.8
MySQL 5.0.45
Apache2
Data-Dumper-2.121
Data-ShowTable-3.3
DBI-1.58


Perl and MySQL seemed to install and run just fine however when I went to install DBD::MySQL things went bad fast.

I have tried installing the following different items with no success.

mysql-connector-odbc-3.51.19-solaris10-x86-32bit.pkg

Msql-Mysql-modules-1.2219

When I do:

pkgadd -d mysql-connector-odbc-3.51.19-solaris10-x86-32bit.pkg

I get the following error:

Installing MySQL Connector/ODBC (GPL) as <myodbc3>

## Installing part 1 of 1.
verifying class <none>
## Executing postinstall script.
ld.so.1: myodbc3i: fatal: libodbcinst.so.1: open failed: No such file or directory
Killed
ERROR: Could not register the driver. Please make sure you have the driver manager "unixODBC"
installed before you install this package
pkgadd: ERROR: postinstall script did not complete successfully

Installation of <myodbc3> failed.

ls -l /usr/local/lib/libodbcinst* showes the following

-rwxr-xr-x 1 root root 821 Aug 22 07:55 /usr/local/lib/libodbcinst.la
lrwxrwxrwx 1 root root 20 Aug 22 07:55 /usr/local/lib/libodbcinst.so -> libodbcinst.so.1.0.0
lrwxrwxrwx 1 root root 20 Aug 22 07:55 /usr/local/lib/libodbcinst.so.1 -> libodbcinst.so.1.0.0
-rwxr-xr-x 1 root root 289856 Aug 22 07:55 /usr/local/lib/libodbcinst.so.1.0.0

I then tried to compile and install Msql-Mysql-modules-1.2219

When I ran make I received the following error(s)

gcc -c -I/usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI -I/usr/local/mysql/include/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI -I/usr/local/lib/perl5/5.8.8/i86pc-solaris -fno-strict-aliasing -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -O -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -fPIC "-I/usr/local/lib/perl5/5.8.8/i86pc-solaris/CORE" -DDBD_MYSQL mysql.c
mysql.xs: In function `XS_DBD__mysql__dr__ListDBs':
mysql.xs:98: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__dr__admin_internal':
mysql.xs:138: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs:144: error: too few arguments to function `mysql_shutdown'
mysql.xs:186: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__db__ListDBs':
mysql.xs:250: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__db__ListTables':
mysql.xs:271: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
*** Error code 1

make: Fatal error: Command failed for target `mysql.o'

Current working directory /src/Msql-Mysql-modules-1.2219/mysql
*** Error code 1
The following command caused the error:
cd mysql && make -f Makefile all LIBPERL_A="libperl.a" LINKTYPE="dynamic" OPTIMIZE="-O" PREFIX="/usr/local"
make: Fatal error: Command failed for target `subdirs'

I then tried to compile and install Msql-Mysql-modules-1.2219

When I ran make I received the following error(s)

gcc -c -I/usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI -I/usr/local/mysql/include/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI -I/usr/local/lib/perl5/5.8.8/i86pc-solaris -fno-strict-aliasing -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -O -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -fPIC "-I/usr/local/lib/perl5/5.8.8/i86pc-solaris/CORE" -DDBD_MYSQL mysql.c
mysql.xs: In function `XS_DBD__mysql__dr__ListDBs':
mysql.xs:98: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__dr__admin_internal':
mysql.xs:138: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs:144: error: too few arguments to function `mysql_shutdown'
mysql.xs:186: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__db__ListDBs':
mysql.xs:250: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__db__ListTables':
mysql.xs:271: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type

*** Error code 1
make: Fatal error: Command failed for target `mysql.o'
Current working directory /src/Msql-Mysql-modules-1.2219/mysql
*** Error code 1

The following command caused the error:
cd mysql && make -f Makefile all LIBPERL_A="libperl.a" LINKTYPE="dynamic" OPTIMIZE="-O" PREFIX="/usr/local"

make: Fatal error: Command failed for target `subdirs'


Trying to install from CPAN was no better.

I could really use some assistance in solving this/my problem.

In reply to DBD::MySQL Install Problem by SeekerOfPerl

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.