DBD:mysql

[Dixiesys]

ok been messing with this one for a bit now.

RH9's RPM's for perl-DBD-mysql require libmysqlclient.so.10 and mysql 4 seems to install libmysqlclicent.so.12 and from what I'm reading .10 and .12 are pretty different.

So I tried a manual install using the cpan files, and I get errors during make

So I tried an rpmbuild --rebuild of the source rpm and still errors.

This is necessary for movable type which is a VERY popular script so I'd like to figure this one out.

Thanks!

[DirectAdmin Support]

Hello,

Here is a quick tutorial to install dbi and dbd... (untested)



wget http://www.cpan.org/modules/by-module/DBD/DBI-1.38.tar.gz
tar xvzf DBI-1.38.tar.gz
cd DBI-1.38
perl Makefile.pl
make
make install

cd ..
wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-2.9002.tar.gz
tar xvzf DBD-mysql-2.9002.tar.gz
cd DBD-mysql-2.9002
perl Makefile.pl
make
make installJohn

[Dixiesys]

This is what I did and when I run "make" for perl-DBD I get an error:

[root@da11 DBD-mysql-2.9002]# make
Makefile:89: *** missing separator. Stop.
[

And that's where it stops, if I use the src.rpm's and rebuild, same error only it's line 88 in the src.rpm

[UltimeWWW]

Originally posted by DirectAdmin Support
Hello,

Here is a quick tutorial to install dbi and dbd... (untested)



wget http://www.cpan.org/modules/by-module/DBD/DBI-1.38.tar.gz
tar xvzf DBI-1.38.tar.gz
cd DBI-1.38
perl Makefile.pl
make
make install

cd ..
wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-2.9002.tar.gz
tar xvzf DBD-mysql-2.9002.tar.gz
cd DBD-mysql-2.9002
perl Makefile.pl
make
make installJohn

I installed this to my server some days ago, it works fine.

[Dixiesys]

Originally posted by UltimeWWW
I installed this to my server some days ago, it works fine.

Well I'm glad to hear it works for you, are you using RH 9?

[The Prohacker]

Do you have the latest glibc installed for RH9?

http://updates.redhat.com/9/en/os/i686/

[Dixiesys]

No I didn't, I do now, no change. Thanks anyway :)

Hmm a search reveals this:

http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=87682

Sounds like a major issue so is no one on RH9 done this yet or is my version of perl just not updated...

Well doing a 'export LANG=C' before I ran perl Makefile.PL fixed this but just strikes me as odd no one else has encountered this it's not like we've hacked apart his box it's pretty much straight RH9 :)

[Wunk]

On new redhat servers I always put the following line at the end of /etc/bashrc

export LANG=en_US

And then relogin..

The default setting will rise a lot of problems with compiling certain applications (you can completely break CPAN if you try to update it with the default LANG setting)

And no, you're not the only one, I have it with all my redhat 9 installs, so does a friend of mine who works at a major ISP as unix sysadmin..

Directadmin will install fine though with the default setting, just don't try and compile perl stuff :)

[UltimeWWW]

It is RedHat 7.3.

[outpernet]

so we can do that steps in rh9 without risk?

[outpernet]

well, i tried. The first step was ok (change .pl to .PL), but in the second one when i write perl Makefile.PL it shows a lot of errors:

Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97.
Can't locate DBI/DBD.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at Makefile.PL line 294.


My perl has the perl -V patch.

[Peter]

Originally posted by Dixiesys
This is what I did and when I run "make" for perl-DBD I get an error:

[root@da11 DBD-mysql-2.9002]# make
Makefile:89: *** missing separator. Stop.
[

And that's where it stops, if I use the src.rpm's and rebuild, same error only it's line 88 in the src.rpm

I have got the same problem, any clue?

[Peter]

I did some more searching, but it looks unfindable :p

[DirectAdmin Support]

Hello,

http://www.nntp.perl.org/group/perl.dbi.users/17822


unset LANG; perl Makefile.PL; makeJohn

[Peter]

I found that already and it worked... thanks =)

[hostpc.com]

Here's an updated "how to":

cd /root

wget http://www.cpan.org/authors/id/R/RU/RUDY/DBD-mysql-2.9003.tar.gz

tar xzf DBD-mysql-2.9003.tar.gz

cd DBD-mysql-2.9003

unset LANG; perl Makefile.PL; make test; make install


You may see a couple of errors, but they can be safely ignored, this install works on RH9.

Joe