Error running "make" on AIX 5.3

[Harry Jamieson]

I have been unable to install DBI on our AIX 5.3 using either CPAN ("out
of memory") or the "perl Makefile.PL" method. I've read the entire
thread started by Don Walters on this subject begun on 3 Aug 2012, and
it looks like his problem boiled down to his cc_r being linked to gcc.
Mine is linked to xlc, as it should be. My perl is 5.8.8. The results
from my Makefile.PL run are in the attached file "makefile.tst". They
look normal to me. The installation fails during "make", which dies
with the error "lib/DBD/Gofer.pm:841: Unknown command paragraph
"=encoding ISO8859-1"" Here is the output from "make".

/usr/bin/perl /usr/opt/perl5/lib/5.8.8/ExtUtils/xsubpp -typemap
/usr/opt/perl5/lib/5.8.8/ExtUtils/typemap -typemap typemap DBI.xs >
DBI.xsc && mv DBI.xsc DBI.c
cc_r -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES -qlonglong -O -DVERSION=\"1.622\"
-DXS_VERSION=\"1.622\"
"-I/usr/opt/perl5/lib/5.8.8/aix-thread-multi/CORE" DBI.c
Running Mkbootstrap for DBI ()
chmod 644 DBI.bs
rm -f blib/arch/auto/DBI/DBI.so
ld -bhalt:4 -bexpall -G -bnoentry -lpthreads -lc DBI.o -o
blib/arch/auto/DBI/DBI.so
chmod 755 blib/arch/auto/DBI/DBI.so
cp DBI.bs blib/arch/auto/DBI/DBI.bs
chmod 644 blib/arch/auto/DBI/DBI.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiprof.PL dbiprof
Extracted dbiprof from dbiprof.PL with variable substitutions.
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiproxy.PL dbiproxy
Extracted dbiproxy from dbiproxy.PL with variable substitutions.
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbilogstrip.PL dbilogstrip
Extracted dbilogstrip from dbilogstrip.PL with variable substitutions.
cp dbiprof blib/script/dbiprof
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/dbiprof
cp dbiproxy blib/script/dbiproxy
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/dbiproxy
cp dbilogstrip blib/script/dbilogstrip
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/dbilogstrip
Manifying blib/man1/dbiprof.1
Manifying blib/man1/dbiproxy.1
Manifying blib/man1/dbilogstrip.1
Manifying blib/man3/DBI::Gofer::Response.3
Manifying blib/man3/DBD::Proxy.3
Manifying blib/man3/DBI::Gofer::Transport::Base.3
Manifying blib/man3/DBD::DBM.3
Manifying blib/man3/DBI::Gofer::Serializer::DataDumper.3
Manifying blib/man3/DBI::Const::GetInfoType.3
Manifying blib/man3/DBI::DBD::Metadata.3
Manifying blib/man3/DBI::Const::GetInfo::ODBC.3
Manifying blib/man3/DBD::Gofer::Transport::pipeone.3
Manifying blib/man3/DBI::ProfileDumper::Apache.3
Manifying blib/man3/DBD::File.3
Manifying blib/man3/DBD::File::Roadmap.3
Manifying blib/man3/DBI::Util::CacheMemory.3
Manifying blib/man3/DBI::ProfileSubs.3
Manifying blib/man3/DBD::Gofer.3
Manifying blib/man3/DBD::File::HowTo.3
Manifying blib/man3/DBI::DBD::SqlEngine::HowTo.3
Manifying blib/man3/DBD::Gofer::Transport::Base.3
Manifying blib/man3/DBD::Gofer::Transport::corostream.3
Manifying blib/man3/DBI::FAQ.3
Manifying blib/man3/DBD::Gofer::Policy::rush.3
Manifying blib/man3/DBI::SQL::Nano.3
Manifying blib/man3/DBI::Gofer::Request.3
Manifying blib/man3/DBI::Const::GetInfo::ANSI.3
Manifying blib/man3/DBD::Gofer::Transport::stream.3
Manifying blib/man3/DBD::Gofer::Policy::classic.3
Manifying blib/man3/DBI::Gofer::Transport::stream.3
Manifying blib/man3/DBI::Gofer::Serializer::Storable.3
Manifying blib/man3/DBI.3
Manifying blib/man3/DBD::Gofer::Policy::Base.3
Manifying blib/man3/DBI::Const::GetInfoReturn.3
Manifying blib/man3/DBD::Sponge.3
Manifying blib/man3/DBD::Gofer::Policy::pedantic.3
Manifying blib/man3/DBI::Gofer::Transport::pipeone.3
Manifying blib/man3/DBI::DBD::SqlEngine::Developers.3
Manifying blib/man3/DBI::W32ODBC.3
Manifying blib/man3/DBD::Gofer::Transport::null.3
Manifying blib/man3/Bundle::DBI.3
Manifying blib/man3/DBD::File::Developers.3
Manifying blib/man3/DBI::Profile.3
Manifying blib/man3/DBI::ProfileDumper.3
Manifying blib/man3/DBI::Gofer::Serializer::Base.3
Manifying blib/man3/DBI::ProxyServer.3
Manifying blib/man3/DBI::Gofer::Execute.3
Manifying blib/man3/DBI::DBD.3
Manifying blib/man3/Win32::DBIODBC.3
Manifying blib/man3/DBI::DBD::SqlEngine.3
Manifying blib/man3/DBI::PurePerl.3
Manifying blib/man3/DBI::ProfileData.3

Any help that you could give me with getting this installed would be
appreciated. We plan to be using MySQL.

Harry Jamieson
PER Software

[Martin Gainty]

Looks like a comment
http://fossies.org/dox/DBI-1.622/Gofer_8pm_source.html

what happens if you wrap the comment in a comment block?
/* =encoding ISO8859-1 */

Martin
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.


> Date: Mon, 13 Aug 2012 13:44:29 -0600
> From: ha...@persoftware.com
> To: dbi-...@perl.org
> Subject: Error running "make" on AIX 5.3

[Harry Jamieson]

On 8/14/2012 6:13 AM, Tim Bunce wrote:
> The =encoding directive is a standard part of perl pod
> http://perldoc.perl.org/5.8.9/perlpod.html#Formatting-Codes
>
> I don't know why it's causing a problem for you. It works for
> most people with perl 5.8.8.
> http://matrix.cpantesters.org/?dist=DBI%201.622;reports=1;perl=5.8.8
>
> The quick fix is to just delete the =encoding line.
>
> Tim.

>
>
> On Mon, Aug 13, 2012 at 10:15:21PM -0400, Martin Gainty wrote:
>> Looks like a comment
>> http://fossies.org/dox/DBI-1.622/Gofer_8pm_source.html
>>
>> what happens if you wrap the comment in a comment block?
>> /* =encoding ISO8859-1 */
>>

>>> Date: Mon, 13 Aug 2012 13:44:29 -0600
>>> From: ha...@persoftware.com
>>> To: dbi-...@perl.org
>>> Subject: Error running "make" on AIX 5.3
>>>
>>> I have been unable to install DBI on our AIX 5.3 using either CPAN ("out
>>> of memory") or the "perl Makefile.PL" method. I've read the entire
>>> thread started by Don Walters on this subject begun on 3 Aug 2012, and
>>> it looks like his problem boiled down to his cc_r being linked to gcc.
>>> Mine is linked to xlc, as it should be. My perl is 5.8.8. The results
>>> from my Makefile.PL run are in the attached file "makefile.tst". They
>>> look normal to me. The installation fails during "make", which dies
>>> with the error "lib/DBD/Gofer.pm:841: Unknown command paragraph
>>> "=encoding ISO8859-1""
>

Thank you both for your responses. I apologize for being a little slow
in getting back to you, but I only work Monday, Wednesday, and Friday
(I'm semi-retired). After writing my post to you, I tried commenting
the encoding line out by simply removing the "=" sign. The "make" then
ran fine but then I got a slew of errors from the "make test". I then
did some research and found that the encoding line should read
"=encoding ISO-8859-1", with a "-" after the "ISO", according to

http://www.w3.org/TR/html4/charset.html#h-5.2.1

I changed the line to that, but still got my "Unknown command paragraph"
error. If this line is unnecessary, then I'll comment it out and ask
you to help me to determine why I'm getting so many errors. I *do* have
xcl as my compiler, and cc_r is linked to it.

Thanks for all of your help so far.

Harry Jamieson

[Martin J. Evans]

I thought you were using an old Perl and I don't think pod supported =encoding since day 1. I could be wrong.

Martin

--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

[Harry Jamieson]

I'm using the 5.8.8 version of perl which comes with AIX 5.3. I have
commented the =encoding line out of Gofer.pm, this time with a C-like
"/* */", and am getting ready to run "make test" again to capture the
results.

Harry

[Harry Jamieson]

make test output file.

[Martin J. Evans]

On 15/08/12 16:45, Harry Jamieson wrote:
> make test output file.
>
That is a lot of failures. What does

prove -vb t/06attrs

output?

[Harry Jamieson]

On 8/15/2012 9:55 AM, Martin J. Evans wrote:
> On 15/08/12 16:45, Harry Jamieson wrote:
>> make test output file.
>>
> That is a lot of failures. What does
>
> prove -vb t/06attrs
>
> output?
>
> Martin

# /usr/opt/perl5/bin/prove -vb t/06attrs.t
t/06attrs....1..148
ok 1 - use DBI;
String found where operator expected at t/06attrs.t line 289, near "note
"Checki
ng inheritance\n""
(Do you need to predeclare note?)
syntax error at t/06attrs.t line 289, near "note "Checking inheritance\n""
Execution of t/06attrs.t aborted due to compilation errors.
# Looks like you planned 148 tests but only ran 1.
# Looks like your test died just after 1.
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-148
Failed 147/148 tests, 0.68% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/06attrs.t 255 65280 148 294 198.65% 2-148
Failed 1/1 test scripts, 0.00% okay. 147/148 subtests failed, 0.68% okay.

[Martin J. Evans]

You need a more up to date Test::More.

The dependency must be wrong.

[Martin J. Evans]

As an aside, could you tell us what:

perl -MTest::More -le 'print $Test::More::VERSION' outputs.

[Harry Jamieson]

# perl -MTest::More -le 'print $Test::More::VERSION'
0.62

[Martin J. Evans]

Then I'm a little confused as DBI requires Test::Simple 0.90 and that contains Test::More so I guess you must have ignored a warning saying your Test::Simple was too old.

[Harry Jamieson]

I did ignore it, for in that other thread about problems installing on
AIX 5 I noticed that he had the same warning. Also, I don't know where
to go to find a newer version.

Harry

[Harry Jamieson]

Never mind. I found it at http://search.cpan.org/dist/Test-Simple/

Harry

[Harry Jamieson]

Test Simple now 0.98.

# perl -MTest::More -le 'print $Test::More::VERSION'

0.98

And I now get this from "make test".

All tests successful, 38 tests and 565 subtests skipped.
Files=182, Tests=8385, 931 wallclock secs (112.93 cusr + 14.71 csys =
127.64 CPU
)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
test.pl
DBI test application $Revision: 12537 $
Switch: DBI 1.622 by Tim Bunce, 1.622
Available Drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge
dbi:ExampleP:: testing 3 sets of 20 connections:
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
connect 20 and disconnect them, 3 times: 0.0404s / 60 = 0.0007s
Testing handle creation speed...
24096 NullP sth/s perl 5.008008 aix-thread-multi (cc_r 9.0.0.2 -O) 0.000042s

test.pl done
Target "test" is up to date.

I will now try "make install".

The next thing that I need to do is to download the MySQL module, but I
cannot find this module at CPAN.

Harry

[Martin J. Evans]

Go to search.cpan.org and enter DBD::mysql into the search box and hit search. Click on the second link to DBD::mysql (the one with a version in the link). Don't forget you'll need to install mysql client and mysql client development packages first before attempting to build DBD::mysql.

[Harry Jamieson]

My thanks to you, Martin, and to Tim as well. It turns out that MySQL
no longer has a distribution for AIX 5.3, 5.4, or 6.1 (IBM is ceasing
support for these versions), and so we have decided to instead try to go
with DB2, which we already have installed. We're running with these old
OS versions because that's what our potential customer base is most
likely to have right now. Of course, nothing is ever easy in the world
of Unix, and I'm having problems installing DBD::DB2. Problems like these:


sqlcli.h: No such file or directory
sqlc1l1.h: No such file or directory
sqlext.h: No such file or directory


I have my DB2_HOME and DB2LIB variables set to /usr/opt/db2_08_01 and
/usr/opt/db2_08_01/include, where these files should be, but running
"find" from root (and as root) shows that they don't exist on my
machine. I'm guessing that whoever ordered DB2 for us didn't order the
developer's version. :( I'm going do some more research on this. In
the meantime, again, I appreciate your help with DBI.

Harry