Any server admin here can help me install DBD::mysql Perl module ?

[Henrique]

How much do you chage for that?

Thank you,

[SinSational]

you have webmin? takes .9 seconds. contact me if you need help.

[Henrique]

nope, dont have webmin, tried installing it by myself but Im getting some errors that I dont know how to fix, do you know installing it without webmin?

[MrHits]

What are the errors?

you are probably missing the mysql libraries...paste here.

[prodiac]

nope, dont have webmin, tried installing it by myself but Im getting some errors that I dont know how to fix, do you know installing it without webmin?

From root ssh shell
# perl -MCPAN -e shell

When you get to a prompt,

> install DBD::mysql

If it fails testing due to username/password, type quit, go to /root/.cpan/build/DBD-mysql*
make install

[Henrique]

FIRST I USE PERL MAKEFILE.PL:

Creating files for MySQL ....................
WARNING: CAPI is not a known parameter.
WARNING: PL_FILES takes a hash reference not a array reference.
Please inform the author.
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lgz
Note (probably harmless): No library found for -lgcc
Multiple copies of Driver.xst found in: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI at ./Makefile.PL line 68
Using DBI 1.38 installed in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules

THAN, WHEN I USE MAKE I GOT THIS:
Makefile:83: *** missing separator. Stop.

I open the file Makefile and at line 83 has a line just writte sit:
SITELIBEXP = '/usr/lib/perl5/site_perl'
sit
SITEARCHEXP = /usr/lib/pe

I DELETED THIS LINE AND TRIED AGAIN AND GOT THE SAME ERROR, BUT ANOTHER LINE WRITTE JUST man3d, I DELETED IT AND CONTINUED WITH THE INSTALLATION USING: make, AND GOT THIS:

/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.8.0/i386-linux-thread-multi \
-I/usr/lib/perl5/5.8.0 -Ilib -MExtUtils::PerlPP \
-e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm"
/usr/bin/pod2text mysql/lib/DBD/mysql.pm >README
make[1]: Entering directory `/Msql-Mysql-modules-1.2219/mysql'
cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm
cp lib/Mysql.pm ../blib/lib/Mysql.pm
cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -I../dbd -I/u/auto/DBI -I/usr/lib/perl5/5.8.0/i386-linux-thread-multi -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DDBD_MYSQL dbdimp.c
dbdimp.c: In function `mysql_db_login':
dbdimp.c:725: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
dbdimp.c: In function `mysql_db_FETCH_attrib':
dbdimp.c:1013: warning: initialization discards qualifiers from pointer target type
dbdimp.c:1019: warning: initialization discards qualifiers from pointer target type
dbdimp.c:1027: warning: initialization discards qualifiers from pointer target type
dbdimp.c:1048: warning: initialization discards qualifiers from pointer target type
dbdimp.c:1059: warning: initialization discards qualifiers from pointer target type
dbdimp.c: In function `mysql_st_internal_execute':
dbdimp.c:1203: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
dbdimp.c:1264: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer targettype
dbdimp.c: In function `mysql_st_fetch':
dbdimp.c:1427: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
dbdimp.c: In function `MysqlReconnect':
dbdimp.c:2164: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.0/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 281
Warning: duplicate function definition 'rows' detected in mysql.xs, line 407
gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -I../dbd -I/u/auto/DBI -I/usr/lib/perl5/5.8.0/i386-linux-thread-multi -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DDBD_MYSQL mysql.c
mysql.xs: In function `XS_DBD__mysql__dr__ListDBs':
mysql.xs:98: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__dr__admin_internal':
mysql.xs:138: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs:186: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__db__ListDBs':
mysql.xs:250: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
mysql.xs: In function `XS_DBD__mysql__db__ListTables':
mysql.xs:271: warning: passing arg 3 of `mysql_dr_error' discards qualifiers from pointer target type
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f ../blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib:/lib" gcc -shared -L/usr/local/lib dbdimpub mysqlub -L/usr/lib/mysql -o ../blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lm -lz -L/usr/lib/gcc-lib/i386-redhat-linux/3.2.3
gcc: dbdimpub: No such file or directory
gcc: mysqlub: No such file or directory
make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1
make[1]: Leaving directory `/Msql-Mysql-modules-1.2219/mysql'
make: *** [subdirs] Error 2

DO YOU HAVE ANY IDEA WHAT IS HAPPENING?

[Henrique]

USING CPAN I GOT THIS ERROR:
Fetching with LWP:
ftp://archive.progeny.com/CPAN/modul...odlist.data.gz
Going to read y/sources/modules/03modlist.data.gz
Going to write y/Metadata
Running install for module DBD::mysql
Running make for C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz
Fetching with LWP:
ftp://archive.progeny.com/CPAN/autho...-3.0002.tar.gz
CPAN: Digest::MD5 loaded ok
Fetching with LWP:
ftp://archive.progeny.com/CPAN/autho...TOFU/CHECKSUMS
Checksum for y/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz ok
Scanning cache y/build for sizes
gzip: y/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz: No such file or directory
gzip: y/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz: No such file or directory
/bin/tar: y/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz: Cannot open: No such file or directory
/bin/tar: Error is not recoverable: exiting now
Using Tar:/bin/tar xvf y/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz:
/bin/tar: y/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz: Cannot open: No such file or directory
/bin/tar: Error is not recoverable: exiting now
Couldn't untar y/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz

AND THERE IS NO DIRECTORY:
/root/.cpan/build/DBD-mysql

[MickeyG]

use yum -678

[Henrique]

use yum -678

Sorry, what is yum -678

[mrkris]

I don't have problems with: perl -MCPAN -e 'install DBD::Mysql' ... your error looks like it is having trouble finding the mysql sources to build the module from. What OS are you using (Linux/BSD/Solaris)

[MickeyG]

Sorry, what is yum -678

its just yum

http://linux.duke.edu/projects/yum/

its a great tool for keeping your system up to date as well as adding new packages.

[blazin]

its just yum

http://linux.duke.edu/projects/yum/

its a great tool for keeping your system up to date as well as adding new packages.

That looks like a nice tool.... could do with something like this.

[MickeyG]

That looks like a nice tool.... could do with something like this.

yeah yum kicks ass, you can update your entire server just by typing "yum update" or install apps including all dependencies by typing "yum install blah"

i love it

[mrkris]

yum reminds me of yet "another" package management system. I don't use linux anyway, I use openbsd for all my servers. In fact, I just bought a 1u dual xeon supermicro server and is about to get openbsd slapped on it ;)

[Brujah]

I can get it done for $300

[PussyTeenies]

on Freebsd

cd to either one of these (depending on you mysql server version)
/usr/ports/databases/p5-DBD-mysql/
/usr/ports/databases/p5-DBD-mysql40/
/usr/ports/databases/p5-DBD-mysql41/
/usr/ports/databases/p5-DBD-mysql50/

#make install clean distclean rmconfig

thats all

--or--

for all flavors

#perl -MCPAN -e shell

install DBD::mysql


--eof---

remember you have to be root or uid=0 (or via sudo .. ) just have root privileges

[Henrique]

I don't have problems with: perl -MCPAN -e 'install DBD::Mysql' ... your error looks like it is having trouble finding the mysql sources to build the module from. What OS are you using (Linux/BSD/Solaris)

Im using Linux...

Cant get YUM installed here, I tried to install and Im having this problem after installing and typing yum:
#yum
Traceback (most recent call last):
File "/usr/bin/yum", line 6, in ?
import yummain
File "/usr/share/yum-cli/yummain.py", line 23, in ?
import yum
ImportError: No module named yum

anyone can help me with yum or the DBD::mysql Perl module ?

Thanks,