Hello all!
Sorry for bothering you again with this long posting! Meanwhile I
decided to make a clean install on my new MBP. Thinking, that this will
help to solve all problems. But a clean install is making really heavy work:
<offtopic>
Just if somebody is going through this hard experience too:
truecrypt and MacFuse (64 bit - hack) - I know the solution
stop spotlight to index your HD - I know the solution
stop to open .zip files after download - still searching for a solution
install Fink with the old gcc - I have only the new XCode 4.0.2
installed - still searching for a solution
Apple is putting us more and more under tutelage ...
</offtopic>
After the advice of Charly Garrison and Chas. Owens in the thread "New
Perl-Installation on new OS X" I installed the perlbrew That's really a
neat piece of software. I only did not understand how to make it
permanent to use perlbrew and Perl 5.14 ...
And I am not sure, whether Perl 5.14 is really "everywhere" (?).
Printing the %ENV I get also these lines:
VERSIONER_PERL_PREFER_32_BIT => no,
VERSIONER_PERL_VERSION => 5.10.0,
Is here the problem?
After a long while, finally I could install DBI and DBD-mysql. The last
module was tricky, because while the "make test" there is an error
message, that the Version Number of MakeMaker.pm "6.57_43" is not a
numeric number ... So I have had to edit this file, and I shortened the
version number to:
our $VERSION = '6.57'; (!)
The tests of DBD-mysql where only possible, by putting the testuser and
testpassword like follows:
perl Makefile.PL --testuser=mstep --testpassword=s3kr1t (!)
although these settings were shown in the default in this process. Ok,
finally everything is installed so far. But executing my humble
mysql-scripts is popping up a new problem:
the content of a test script:
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my ($dbh, $sth, $anz);
$dbh = DBI->connect("DBI:mysql:host=localhost;database=webdb",
"webdev","webdevpass",
{PrintError => 1, RaiseError => 1});
$sth = $dbh->prepare ("SELECT name, wins, losses FROM teams");
$sth->execute ();
$anz=0;
while (my @zeile = $sth->fetchrow_array ()){
printf "name = %s, wins = %d, losses = %d\n",
$zeile[0], $zeile[1], $zeile[2];
++$anz;
}
print "$anz Zeilen insgesamt \n";
$sth->finish ();
$dbh->disconnect;
exit (0);
And I get the following errors:
% ./intro6.pl
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
contains: /Library/Perl/Updates/5.10.0/darwin-thread-multi-2level
/Library/Perl/Updates/5.10.0
/System/Library/Perl/5.10.0/darwin-thread-multi-2level
/System/Library/Perl/5.10.0
/Library/Perl/5.10.0/darwin-thread-multi-2level /Library/Perl/5.10.0
/Network/Library/Perl/5.10.0/darwin-thread-multi-2level
/Network/Library/Perl/5.10.0 /Network/Library/Perl
/System/Library/Perl/Extras/5.10.0/darwin-thread-multi-2level
/System/Library/Perl/Extras/5.10.0 .) at (eval 3) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge.
at ./intro6.pl line 8
And yes, yes, perlbrew activated the right perl:
perl -v
This is perl 5, version 14, subversion 0 (v5.14.0) built for darwin-2level
Thank you for your patience!
marek
