can"t run perl DBI on OSX

--_2f4a9468-961b-495c-a6b4-68b7e81a61fe_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi All,



I have installed mysql on my powermac G5 (64 bits) and I installed perl
DBD-mysql-4.005 and DBI-1.601 that I obtained from CPAN. The
installation did not work and I kept getting error message. I saw
somewhere that the 64 bit version of mysql was creating problems so i
installed the 32 bit version. Installing the perl modules went well but
now I get error message when running my scripts.



I get:

<<


Code: ( text )
Can't
load
'/sw/lib/perl5/5.8.6/darwin-thread-multi-2level/auto/DBI/DBI .bundle'
for module DBI:
dlopen(/sw/lib/perl5/5.8.6/darwin-thread-multi-2level/auto/D BI/DBI.bundle,
1): no suitable image found. Did find: =20
=20
/sw/lib/perl5/5.8.6/darwin-thread-multi-2level/auto/DBI/DBI. bundle:
mach-o, but wrong architecture at
/System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLo ader.pm
line 230. at /sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBI.pm line 255=
BEGIN failed--compilation aborted at /sw/lib/perl5/5.8.6/darwin-thread-mult=
i-2level/DBI.pm line 255.Compilation failed in require at connect.pl line 4=
..BEGIN failed--compilation aborted at connect.pl line 4 >> One
source of problem might be that I transferred my files and folders from
a macbook pro when I install the system on my G5. Could it carry over
stuff made for the intel architecture? my mysql version is:Server version: =
5.0.45 MySQL Community Server (GPL)osx tiger 10.4.11




How whould I proceed? What is the problem? Perl, the modules or mysql? how =
can i reinstall perl simply on my machine?
Also, if I run my script within BBedit, the script runs just fine and conne=
ct to the internet correctly.

Thanks for your help,



Christ
____________________________________________________________ _____
Express yourself with free Messenger emoticons. Get them today!
http://www.freemessengeremoticons.ca/?icid=3DEMENCA122=

--_2f4a9468-961b-495c-a6b4-68b7e81a61fe_--

Re: can"t run perl DBI on OSX

You are trying to run 32 Bit PowerPC Code on a 64 Bit x86 system. dlopen
clearly states that mismatch.

You need to compile Perl, DBI and DBD::mysql for/on the Intel System, or
use binaries compiled for that system.

I don't know if DBD::mysql (especially the parts linked in fromn the
MySQL distribution) compile and run without problems in 64 bit mode, so
you may need to fall back to using the 32 bit variants. Don't expect to
be able to mix 32 bit and 64 bit components in one process (perl), that
won't work.

So if you seek for a working system, build MySQL, perl, DBI, DBD::mysql
and all other components you might need in 32 bit mode. You may loose
some ppms in performance terms, but that way is known to work pretty well.

Regarding BBedit: I suspect BBedit uses the Perl that comes with OSX,
and not your Perl copied from the old macbook. The fact that the perl
startet from BBedit can connect to the internet (whatever that may mean)
does not mean that it can talk to MySQL.

Alexander


On 20.11.2007 15:57, christian landry wrote:
> Hi All,
>
>
>
> I have installed mysql on my powermac G5 (64 bits) and I installed perl
> DBD-mysql-4.005 and DBI-1.601 that I obtained from CPAN. The
> installation did not work and I kept getting error message. I saw
> somewhere that the 64 bit version of mysql was creating problems so i
> installed the 32 bit version. Installing the perl modules went well but
> now I get error message when running my scripts.
>
>
>
> I get:
>
> <<
>
>
> Code: ( text )
> Can't
> load
> '/sw/lib/perl5/5.8.6/darwin-thread-multi-2level/auto/DBI/DBI .bundle'
> for module DBI:
> dlopen(/sw/lib/perl5/5.8.6/darwin-thread-multi-2level/auto/D BI/DBI.bundle,
> 1): no suitable image found. Did find:
>
> /sw/lib/perl5/5.8.6/darwin-thread-multi-2level/auto/DBI/DBI. bundle:
> mach-o, but wrong architecture at
> /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLo ader.pm
> line 230. at /sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBI.pm line 255BEGIN failed--compilation aborted at /sw/lib/perl5/5.8.6/darwin-thread-multi-2level/DBI.pm line 255.Compilation failed in require at connect.pl line 4.BEGIN failed--compilation aborted at connect.pl line 4 >> One
> source of problem might be that I transferred my files and folders from
> a macbook pro when I install the system on my G5. Could it carry over
> stuff made for the intel architecture? my mysql version is:Server version: 5.0.45 MySQL Community Server (GPL)osx tiger 10.4.11
>
>
>
>
> How whould I proceed? What is the problem? Perl, the modules or mysql? how can i reinstall perl simply on my machine?
> Also, if I run my script within BBedit, the script runs just fine and connect to the internet correctly.
>
> Thanks for your help,
>
>
>
> Christ
> ____________________________________________________________ _____
> Express yourself with free Messenger emoticons. Get them today!
> http://www.freemessengeremoticons.ca/?icid=EMENCA122
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/