dyln: perl Undefined symbols

2002-05-09 Thread Clint Moore


Output of 'perl Makefile.PL' in the libwww-perl-5.64 tree:


Checking for Digest::MD5 ..loading libraries for image: 
/Library/Perl/darwin/auto/Digest/MD5/MD5.bundle
dyld: perl Undefined symbols:
_Perl_PerlIO_read
_Perl_sv_2pv_flags

I saw in the archives errors from within DBI::MySQL and mod_perl 
and other modules but never from perl itself.  Since I installed the os, 
patched, and installed the devel tools i've done the following:

1. Tried to compile and install perl-5.7.3 which did compile fine but 
did not install any of the core modules like Exporter.  So when I tried 
/usr/local/bin/perl5.7.3 -V it, died with

Can't locate Exporter.pm in @INC (@INC contains: /Library/Perl/darwin 
/Library/Perl /Library/Perl/darwin /Library/Perl /Library/Perl 
/Network/Library/Perl/darwin /Network/Library/Perl 
/Network/Library/Perl .) at /Library/Perl/darwin/Config.pm line 2.
BEGIN failed--compilation aborted at /Library/Perl/darwin/Config.pm line 
2.
Compilation failed in require.
BEGIN failed--compilation aborted.


2. Tried to install CPAN 1.61 by hand since using the installed CPAN 
module results in CPAN trying to download and install perl 5.6.1 which, 
as I understand, will not work.  I haven't let it go to see what 
happens, rather, I hit cntrl-c while it is downloading the tarball.
When trying to use 1.61 I get the following.

cpan> install HTML::Parser
loading libraries for image: 
/Library/Perl/darwin/auto/Storable/Storable.bundle
dyld: perl Undefined symbols:
_PerlIO_getc
_PerlIO_putc
_Perl_PerlIO_read
_Perl_PerlIO_write
_Perl_sv_2pv_flags

It is an educated guess, but i'm pretty sure this is coming from 
perl itself, no?  Has anyone else ever seen this?  I'm going to download 
the development tools image again and see if it doesn't help to 
reinstall them.  While it's possible that I overwrote the 5.0 
/Library/Perl with some or all of the 5.7.3 stuff, I would assume that 
Exporter.pm would be able to load if that is the case.

Anyway, if anyone has any suggestions I would love to hear them.

-cm




Re: DBI mySQL load data infile

2002-05-09 Thread Sherm Pendley

On Thursday, May 9, 2002, at 07:53 PM, nellA hciR wrote:

> starting w 3.23.49 of mySQL, how do i via perl/DBI make a dB connection 
> with load data infile enabled

There's nothing special about the "load data infile" statement - you 
prepare and execute it exactly as you would any other SQL statement.

Note, however, that MySQL permissions are a bit tricky on this point. 
Granting a user access with "grant all privileges" does *not* give that 
user the "file" privilege needed to read external files. An addtional 
"grant file on * to..." is needed to do that.

Also, the "file" privilege is global; that is, it's applied on a 
per-user basis, not on a per-database or per-table basis. The normal 
access restrictions still apply, however - a user who has been granted 
"file" privilege is only able to load a file into a database or table to 
which (s?)he has write access.

sherm--

Never put off until tomorrow what you can do today. There might be a law 
against it by that time.




DBI mySQL load data infile

2002-05-09 Thread nellA hciR

iH

starting w 3.23.49 of mySQL, how do i via perl/DBI make a dB connection 
with load data infile enabled

thanks,
- hcir