Hi, I am in a similar quandry!
Here is a message I wrote yesterday.
Fran Parker wrote:
>
> I also have uninstalled the cooker mysql and installed the one from the
stable
> current. Still doesn't work.
>
> This is what I get:
>
> [fran@flp fran]$ su Password: [root@flp fran]# cd / [root@flp /]# perl -e
'use
> DBD::mysql;'; Can't load
> '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for
module
> DBD::mysql:
/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so:
> undefined symbol: pthread_key_create at
> /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169.
> at -e line 1 BEGIN failed--compilation aborted at -e line 1. [root@flp
> /]#
This was the reply I got...which I took to heart and did:
>You need to upgrade to the latest Perl packages which will
>s/5.005/5.6.0/
>
>I'd be willing to bet you'll find Mysql.pm in
>
>/usr/lib/perl5/site_perl/5.6.0/
>
>or
>
>/usr/lib/perl5/site_perl/i386-linux/
>
>--
>
>Steve Fox
>http://k-lug.com
Well...now perl still won't do it since upgraded to perl/5.6.0
I don't know what to do now!
Here is what I get when I tried to do the same thing again after installing
5.6.0:
[fran@flp fran]$ su Password: [root@flp fran]# perl -e 'use DBD::mysql;';
[root@flp fran]# mysql -u root ERROR 2002: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) [root@flp fran]#
This is the same error I was getting after successfully doing the data-ShowTable
thingey...with previous version of perl, see below:
All tests successful.
Files=17, Tests=128, 10 wallclock secs ( 5.12 cusr + 1.83 csys = 6.95 CPU)
/usr/bin/make test -- OK
Running make install
Installing /usr/lib/perl5/site_perl/5.005/Data/ShowTable.pm
Installing /usr/man/man1/showtable.1
Installing /usr/lib/perl5/man/man3/Data::ShowTable.3
Installing /usr/bin/showtable
Writing /usr/lib/perl5/site_perl/5.005/i386-linux/auto/Data/ShowTable/.packlist
Appending installation info to /usr/lib/perl5/5.00503/i386-linux/perllocal.pod
/usr/bin/make install -- OK
[root@flp Msql-Mysql-modules-1.2211]# cd..
[root@flp fran]# cd /
[root@flp /]# perl -e 'use DBD::mysql;';
[root@flp /]# mysql -u root
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m
ysql.sock' (111)
[root@flp /]# whoami
root
Any help on this would be helpful. Note: Mandrake site had the perl 5.6.0 but
did not have the perl base for the same version anywhere on the site.
I hope someone can help with this. I am just trying to change from .CSV to
mysql for the database for Pronto! mail. .CSV is too slow. This has been a
nightmare so far for 4 days now. I am at a loss as to what to do about this
incompatibility thing.
Thanks for anyhelp anyone can give on this.
Bambi
