Re: Clean Install

2011-06-18 Thread Marek Stepanek

On 6/17/11 11:58 PM, Sherm Pendley wrote:



Don't shoot the messenger! :-)

DynaLoader is just doing its job and reporting the problem. DBD::mysql
can't load, because it's linked against libmysqlclient.18.dylib, and
that .dylib is MIA - that's the problem.

Is MySQL installed in the same place it was when you built DBD::mysql?

sherm--




Thank you Sherm!


Yes, first I was installing mysql, 64-bit, immediately after DBI, and 
than DBD::mysql, with some dirty tricks (see my first posting). And I 
have only one mysql installed on my HD ...


MIA - I was googeling this abbreviation. Does it mean Miami
Dolphins or Miami Airport? Sorry for this question, but some
times there are not only native speakers in such kind of
mailing list.

Should I start over again, install everything for the 40th time? Perhaps 
I should try with use lib ... ??? pointing to the right 
libmysqlclient.18.dylib ???



marek



Re: Clean Install

2011-06-18 Thread John Delacour

At 10:46 +0200 18/06/2011, Marek Stepanek wrote:


MIA - I was googeling this abbreviation. Does it mean Miami
Dolphins or Miami Airport?


Missing in Action == fatally absent


I thought I'd give myself a little useless suffering by installing 
MySQL (the Mac 64-bit .dmg) and then trying to install DBD::mysql 
with similar results to yours.


I then tried various supposed solutions to no effect.

Finally I discovered this suggestion and hey presto! success with 
both installations:



$ cd /usr/local/bin
$ sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib 
/usr/lib/libmysqlclient.18.dylib

$ sudo ./cpan
[...]
cpan[1] install DBD::mysql
[...]
Appending installation info to 
/usr/local/lib/perl5/5.14.0/darwin-2level/perllocal.pod

  CAPTTOFU/DBD-mysql-4.019.tar.gz
  /usr/bin/make install  -- OK
_

$ cd
$ sudo cpan
[...]
cpan[1] install DBD::mysql
[...]
Appending installation info to 
/Library/Perl/Updates/5.10.0/darwin-thread-multi-2level/perllocal.pod

  CAPTTOFU/DBD-mysql-4.019.tar.gz
  /usr/bin/make install  -- OK


JD


Re: Clean Install

2011-06-18 Thread Marek Stepanek

Ok, Sherm, I did reinstall everything now.

% which perl
/Users/mstep/perl5/perlbrew/perls/perl-5.14.0/bin/perl

mysql-5.5.13-osx10.6-x86_64.dmg

and with cpanp

DBI

and manually DBD::mysql

% perl Makefile.PL --testuser=mstep --testpassword=s3kr1t

% make

% make test

with the result:


PERL_DL_NONLAZY=1 /Users/mstep/perl5/perlbrew/perls/perl-5.14.0/bin/perl 
-MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 
'blib/arch') t/*.t

t/00base.t .. 1/6
#   Failed test 'use DBD::mysql;'
#   at t/00base.t line 21.
# Tried to use 'DBD::mysql'.
# Error:  Can't load 
'/Users/mstep/.cpanplus/5.14.0/build/DBD-mysql-4.019/blib/arch/auto/DBD/mysql/mysql.bundle' 
for module DBD::mysql: 
dlopen(/Users/mstep/.cpanplus/5.14.0/build/DBD-mysql-4.019/blib/arch/auto/DBD/mysql/mysql.bundle, 
2): Library not loaded: libmysqlclient.18.dylib
#   Referenced from: 
/Users/mstep/.cpanplus/5.14.0/build/DBD-mysql-4.019/blib/arch/auto/DBD/mysql/mysql.bundle
#   Reason: image not found at 
/Users/mstep/perl5/perlbrew/perls/perl-5.14.0/lib/5.14.0/darwin-2level/DynaLoader.pm 
line 194.

#  at (eval 7) line 2
# Compilation failed in require at (eval 7) line 2.
# BEGIN failed--compilation aborted at (eval 7) line 2.
Bailout called.  Further testing stopped:  Unable to load DBD::mysql
FAILED--Further testing stopped: Unable to load DBD::mysql
make: *** [test_dynamic] Error 255
[Marek-Stepaneks-MacBook-Pro:5.14.0/build/DBD-mysql-4.019] mstep% which perl
/Users/mstep/perl5/perlbrew/perls/perl-5.14.0/bin/perl


the mysql daemon is running ... Here too this mystic error of DynaLoader 
...



marek


Re: Clean Install

2011-06-18 Thread John Delacour

At 12:51 +0200 18/06/2011, Marek Stepanek wrote:


...and with cpanp

DBI

and manually DBD::mysql

% perl Makefile.PL --testuser=mstep --testpassword=s3kr1t

..Library not loaded: libmysqlclient.18.dylib



Just create the symbolic link as I have just (not originally) suggested:

sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib

You will then get:

$ cd /usr/lib; ls -al | grep *mysql*
lrwxr-xr-x1 root  wheel44 18 Jun 11:22 
libmysqlclient.18.dylib - 
/usr/local/mysql/lib/libmysqlclient.18.dylib



DBD::mysql and install using CPAN.

JD


Re: Clean Install

2011-06-18 Thread Marek Stepanek

On 6/18/11 12:42 PM, John Delacour wrote:


$ sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib
/usr/lib/libmysqlclient.18.dylib



Ahhh, I have had this link on my old laptop already. Thank you John!!! 
This link made it possible that the manual install succeeded :-) I am 
wondering, how I managed before.


And now I spend a lot of time again ... I forgot the hint of Chas. doing:

% ./intro6.pl

Which is not working with my

#!/usr/bin/perl

so I have to do it like that:

% perl intro6.pl

!!

or I have to change like follows:

#!/Users/mstep/perl5/perlbrew/perls/perl-5.14.0/bin/perl


Thank you all for your great help!



marek


Re: Clean Install

2011-06-18 Thread John Delacour

At 13:23 +0200 18/06/2011, Marek Stepanek wrote:


And now I spend a lot of time again ... I forgot the hint of Chas. doing:

% ./intro6.pl

Which is not working with my

#!/usr/bin/perl

so I have to do it like that:

% perl intro6.pl

!!

or I have to change like follows:

#!/Users/mstep/perl5/perlbrew/perls/perl-5.14.0/bin/perl


Yes, well portablility is a great thing and that's why I install Perl 
in the default location /usr/local/bin, which is linked to from 
/usr/bin on most servers.  I am sure perlbrew has its uses but I have 
a poor memory and if I install things in the usual places I can more 
easily find the answers to my problems.  In the home environment I 
simply use either #!/usr/bin/perl or #!/usr/local/bin/perl depending 
which perl I want to use.  On most remote servers the two are 
equivalent and I have no control over which Perl they have installed.



Thank you all for your great help!


Glad it worked.  If you want some real fun, try installing PDL :-)

JD