PDA

View Full Version : how to install DBD::MySQL?



lona
12-18-2003, 04:42 AM
My provider left me puzzled and with a great challenge as he wants me to install the DBD::MySQL module myself.
I have server admin rights, but have no clue how to continue.
I found the module at www.cpan.org
But, what to do now? I have DBD::MySQL and DBI as a tar.gz.

Is there someone here who can talk me trough this? I am a real beginner. So talking me trough this means really start from almost turning on the computer.

I would appreciate it very much.
Thanks
Lona

ProWebUK
12-18-2003, 07:24 AM
Use cpan :)

# perl -MCPAN -e shell
cpan> install DBD::MySQL

Chris

ProWebUK
12-18-2003, 07:25 AM
Moving to technical area also.

Chris

lona
12-18-2003, 10:02 AM
Sorry for posting at the wrong forum. thought it was the good one
:(

Chris mentioned:

# perl -MCPAN -e shell
cpan> install DBD::MySQL

Ye, I know, but were to do this and how? As said I am very new to this and to know nothing . It sounds lik abracadabra to me.

I type this somewhere? Where??
Lona

DirectAdmin Support
12-18-2003, 10:09 AM
Hello,

You must ssh into the server as root, then type the above commands. You'll need an ssh program, most people use "putty" to get in.

John

ProWebUK
12-18-2003, 11:16 AM
You may want to take at the linux basics section on the server checklist ( http://www.directadmin.com/forum/showthread.php?s=&threadid=65 ) aswell as use the rest of the guides for securing and maintaining your server.

Chris

lona
01-02-2004, 01:31 AM
Is active perl a good program to install the modules?
I downloaded it, but now I wonder how to continue as in ppm it says to type install and the name of the required module. Ok, but where to does ppm install it? On my own machine? That is not what I want. It needs to be installed on the server.

Or should i just give up as everything sounds to me as abracadabra.
is it easier to install DB file?

Lona

ProWebUK
01-02-2004, 03:32 AM
Everything you need to know from start to finish you do NOT need any knowledge in SSH or anything else for this - all you need to do is do what the below says!

#####################

If you are running windows download putty, an SSH client for windows:

http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe

Once you have it, simply execute the program by double clicking the icon where you saved it. A box will appear

Hostname / IP Address: enter your servers main IP address
Port: 22
[o] SSH (tick the radio box)

Click the 'open' button to connect to your server.

You will now be prompted to enter a username to login as, you can use root directly or if you wish use admin then su - to root.
<enter> = press enter on your keyboard

username: root <ENTER>

you will now be promted for your admin password, enter this note characters do not display on the screen, it will remain blank although you are actually entering the password - IGNORE THIS

you should now be at command line, from here just enter the commands mentioned previously, to enter CPAN:


perl -MCPAN -e shell


you should now see another command line showing:

cpan>

here just enter:


install DBD::MySQL


You should have now successfully installed the module.

Chris

lona
01-02-2004, 03:47 AM
This looks like a really clear and good tutorial :)
Does putty work on a linux server machine? ( my computer is windows)

Another question at the moment: you said:

You will now be prompted to enter a username to login as, you can use root directly or if you wish use admin then su - to root.

with username does this mean the username I use when I enter the server? or is it just a new username?

Lona

ProWebUK
01-02-2004, 03:50 AM
Originally posted by lona
This looks like a really clear and good tutorial :)
Does putty work on a linux server machine? ( my computer is windows)

Another question at the moment: you said:


with username does this mean the username I use when I enter the server? or is it just a new username?

Lona

Putty runs on windows and connects to linux.... or anything else running ssh on port 22 :p

Username - root is simply root and admin is pretty much unprivileged user often used when direct root access is disabled.

Chris

lona
01-02-2004, 05:09 AM
ok, i have putty, but it disappeard after i tried to use my password. ( the password that i use to log on to the server normally) Is it by the way normal that I get a warning about the right server?

So, It seems I do not understand this. Sorry about that as English is not my own language and sometimes I seem to miss important things.


admin is pretty much unprivileged user often used when direct root access is disabled.
what do you mean with pretty much unpriviliged? :confused:

lona

ProWebUK
01-02-2004, 05:13 AM
The admin user cant do much..... considering its admin, which most people consider very high priviliged if not the highest (which would be root of course :D) if they don't know much about ssh / users with linux etc

Chris

lona
01-02-2004, 05:31 AM
so as i understand this in easy english it would mean I have no acces to the root???

very strange as my host asked me to install the module myself:confused:
lona

ProWebUK
01-02-2004, 06:02 AM
If its your server and you have 'admin' access to directadmin you more than likely have access to root... your host telling you that you have to install them yourself would more than likely mean your server is unmanaged.

Chris

etegration
04-11-2004, 06:52 AM
Originally posted by ProWebUK
Use cpan :)

# perl -MCPAN -e shell
cpan> install DBD::MySQL

Chris

i get an error:


cpan> install DBD::MySQL
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Sun, 11 Apr 2004 02:57:36 GMT
Warning: Cannot install DBD::MySQL, don't know what it is.
Try the command

i /DBD::MySQL/

to find objects with matching identifiers.


What should i do?

and when i do a i /DBD::MySQL/ as suggested above:


cpan> i /DBD::MySQL/
Bundle Bundle::DBD::mysql (J/JW/JWIED/Msql-Mysql-modules-1.2219.tar.gz)
Module DBD::mysql (R/RU/RUDY/DBD-mysql-2.9003.tar.gz)
Module DBD::mysql::AutoTypes (G/GR/GRISHACE/DBD-mysql-AutoTypes-1.0.tar.gz)
Module DBD::mysql::GetInfo (R/RU/RUDY/DBD-mysql-2.9003.tar.gz)
Module DBD::mysql::Install (J/JW/JWIED/Msql-Mysql-modules-1.2219.tar.gz)
Module DBD::mysqlPP (O/OY/OYAMA/DBD-mysqlPP-0.04.tar.gz)
Module DBIx::DBSchema::DBD::mysql (I/IV/IVAN/DBIx-DBSchema-0.23.tar.gz)
Module SQL::AnyDBD::Mysql (T/TB/TBONE/SQL-AnyDBD-0.02.tar.gz)
8 items found

hostpc.com
04-11-2004, 09:49 AM
wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-2.9002.tar.gz
wget http://www.cpan.org/modules/by-module/DBD/DBI-1.38.tar.gz
tar xvzf DBI-1.38.tar.gz
tar xvzf DBD-mysql-2.9002.tar.gz
cd DBI-1.38
perl Makefile.PL
make
make install
cd ..
cd DBD-mysql-2.9002
perl Makefile.PL
make
make install

etegration
04-14-2004, 07:12 AM
Originally posted by hostpc.com
wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-2.9002.tar.gz
wget http://www.cpan.org/modules/by-module/DBD/DBI-1.38.tar.gz
tar xvzf DBI-1.38.tar.gz
tar xvzf DBD-mysql-2.9002.tar.gz
cd DBI-1.38
perl Makefile.PL
make
make install
cd ..
cd DBD-mysql-2.9002
perl Makefile.PL
make
make install

it worked!!!

just that on above,m i had to use


unset LANG; perl Makefile.PL; make

for

perl Makefile.PL

after for cd DBD-mysql-2.9002 in your kind above instructions!

Thanks again!

Wunk
04-22-2004, 01:18 AM
If the perl -e shell -MCPAN fails while testing, you can still install the downloaded files..

cd /root/.cpan/build
Look for the DBD-mysql directory, go there, do a:
perl Makefile.PL
make; make install

thuskey
04-23-2004, 08:41 PM
Originally posted by etegration
i get an error:



What should i do?

and when i do a i /DBD::MySQL/ as suggested above: this would have worked if the mysql part was spelled in all lower case letters.

XYZed
05-09-2004, 10:45 PM
Everytime I try any of the above for DBD::mysql on a RH9 server I get:
linux-thread-multi/auto/DBI at Makefile.PL line 295
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
[root@server DBD-mysql-2.9003]# make
Makefile:89: *** missing separator. Stop.

I normally do get it, but after 80 hours of no sleep I can't remember how.

Any suggestions?

Thanks.

jdlitson
05-09-2004, 11:51 PM
Lona, I would like to recomend VTC to you. What you are looking for is Unix Shell Fundamentals. Virtual Training Company (http://vtc.com/)

They have all sorts of video tutorials on how to use diferent types of software. It costs $25 US per month. You can start by watching the free videos in the first 2 chapters of all of the different tutorials they have to offer. It is well worth it.

Good Luck -Jason :D

Wunk
05-09-2004, 11:55 PM
Originally posted by XYZed
Everytime I try any of the above for DBD::mysql on a RH9 server I get:
linux-thread-multi/auto/DBI at Makefile.PL line 295
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
[root@server DBD-mysql-2.9003]# make
Makefile:89: *** missing separator. Stop.

I normally do get it, but after 80 hours of no sleep I can't remember how.

Any suggestions?

Thanks.

Type in a bash shell (and also add it to /etc/bashrc):
export LANG=en_US

Then start the cpan again in that same shell, it's a bug in the default language setting in Redhat 9 and bash.., compilers don't like it :)

XYZed
05-10-2004, 02:54 AM
Hi Wunk,

Thanks - Also remembered the thread I read each time.
http://www.directadmin.com/forum/showthread.php?s=&threadid=1981&highlight=DBDmysql

(I'll paste it here for next time I find this thread and not that one LOL)

Thanks.

blacknight
05-27-2004, 12:03 PM
Originally posted by lona
Is active perl a good program to install the modules?
I downloaded it, but now I wonder how to continue as in ppm it says to type install and the name of the required module. Ok, but where to does ppm install it? On my own machine? That is not what I want. It needs to be installed on the server.

Or should i just give up as everything sounds to me as abracadabra.
is it easier to install DB file?

Lona
Active Perl is for Windows. If you want to use and run perl on a windows machine work away, but it won't help you get the perl modules onto your *nix box.

sander815
06-09-2004, 02:46 PM
i am trying to add some perl modules, but i can get into cpan

[root@server01 root]# perl -MCPAN -e shell
Can't locate CPAN.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 .).
BEGIN failed--compilation aborted.
[root@server01 root]#

is this not installed by default

sander815
06-09-2004, 03:07 PM
hmm, comparing this server tpo another i miss A LOT perl modules :/...is there an easy way to add them? reinstall perl?

l0rdphi1
06-09-2004, 03:25 PM
Hello,

I would install CPAN manually and use CPAN to install the missing modules.

wget http://cpan.uwinnipeg.ca/cpan/authors/id/A/AN/ANDK/CPAN-1.76.tar.gz
tar xzf CPAN-1.76.tar.gz
cd CPAN-1.76
perl Makefile.PL
make
make test
make install

I think that'll do it. Then you can do the normal perl -MCPAN -e shell

Phi1.

sander815
06-10-2004, 12:14 AM
ok

done that
sorry, i am not into perl :(
cpan came with some questions, that i used the default answers too, is that ok?

now its finished and i see this:
Terminal does not support AddHistory.

cpan shell -- CPAN exploration and modules installation (v1.76)
ReadLine support available (try 'install Bundle::CPAN')

cpan>
is this for installing various perl modules?


--
now, if i want to add modules, what do i do?

Wunk
06-10-2004, 12:28 AM
Just type: install <packagename>


Like:
install DBD::mysql
install CGI
install Net::SSLeay


Full list of modules:
http://www.cpan.org/modules/00modlist.long.html

I put up a basic CPAN guide at:
http://www.fedora-linux.org/index.php?option=content&task=view&id=15&Itemid=33

l0rdphi1
06-10-2004, 12:29 AM
Hello,

Going with the default for those questions should be fine :)

As for using CPAN, it is simple. Just find a package you want on cpan.org and type: install {package}
Where, of course, {package} is the package you've found :)

For instance: install CGI
That will install the CGI module (http://cpan.uwinnipeg.ca/module/CGI).

Have fun ;)

Phi1.

l0rdphi1
06-10-2004, 12:30 AM
Originally posted by Wunk
Just type: install <packagename> Opps. I see I've been beat to the cheese! :D

:)

sander815
06-11-2004, 12:35 AM
lots of errors: for f.i. DBD-mysql-2.9003/


[root@server1 DBD-mysql-2.9003]# perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/usr/include'
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

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 295
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
[root@server1 DBD-mysql-2.9003]#


then make ;make install: doesn't install


[root@server1 DBD-mysql-2.9003]# make
gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I'/usr/include' -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 -O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" dbdimp.c
In file included from dbdimp.c:19:
dbdimp.h:21:49: mysql.h: No such file or directory
dbdimp.h:22:49: errmsg.h: No such file or directory
In file included from dbdimp.c:19:
dbdimp.h:106: parse error before "MYSQL"
dbdimp.h:106: warning: no semicolon at end of struct or union
dbdimp.h:117: parse error before '}' token
dbdimp.h:146: parse error before "MYSQL_RES"
dbdimp.h:146: warning: no semicolon at end of struct or union
dbdimp.h:159: parse error before '}' token
In file included from dbdimp.c:19:
dbdimp.h:195: parse error before '*' token
dbdimp.h:198: parse error before "MYSQL_RES"
dbdimp.h:202: parse error before '*' token
dbdimp.h:202: parse error before '*' token
dbdimp.h:203: warning: data definition has no type or storage class
dbdimp.c:121: parse error before '*' token
dbdimp.c: In function `ParseParam':
dbdimp.c:130: `slenPtr' undeclared (first use in this function)

etc etc

dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2300: dereferencing pointer to incomplete type
dbdimp.c:2303: dereferencing pointer to incomplete type
dbdimp.c:2303: dereferencing pointer to incomplete type
dbdimp.c:2303: warning: passing arg 3 of `mysql_dr_error' makes pointer from integer without a cast
dbdimp.c:2304: dereferencing pointer to incomplete type
dbdimp.c:2305: dereferencing pointer to incomplete type
dbdimp.c:2308: dereferencing pointer to incomplete type
dbdimp.c: In function `mysql_db_quote':
dbdimp.c:2444: dereferencing pointer to incomplete type
make: *** [dbdimp.o] Error 1
[root@server1 DBD-mysql-2.9003]#

long list
i have no idea whats wrong

same errors with these commands, or from cpan

Wunk
06-11-2004, 12:53 AM
Are you using RedHat 9 ?

If so, the LANG setting is screwed up, perl and C don't like the UTF-8 setting..

Try:
export LANG=en_US

And try again..

sander815
06-11-2004, 03:00 AM
its redhat 9

after the command export LANG=en_US
i still get the same errors

some other modules do install though

sander815
06-11-2004, 03:01 AM
maybe cause its installed already? do i have to remove the old version first, then install the new?

Wunk
06-11-2004, 03:26 AM
In general it should just upgrade it to the newest version..

try a:
make clean ; perl Makefile.PL ; make ; make install


If that fails, try d/ling the package again..

sander815
06-11-2004, 04:03 AM
from with CPAN how can i delete a package

DBD::mysql is already there, only an older version
Maybe if i can remove that, i can install the new version

Wunk
06-11-2004, 04:21 AM
Uninstalling is a tad harder, the CPANPLUS module can most likely do that, but I have no experience with that.., it SHOULD just write over the existing modules if those are older..

I'm a bit out of options...

sander815
06-11-2004, 07:59 AM
Originally posted by sander815
[B]lots of errors: for f.i. DBD-mysql-2.9003/

[code][root@server1 DBD-mysql-2.9003]# perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/usr/include'
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.



from my earlier post:
seems like it tries to login mysql? testdb, testhost, testpassword?

hmm

sander815
06-11-2004, 08:33 AM
yep, that was the reason...it tries to connect to test db, but it can't, cause its pw protected

sander815
06-11-2004, 12:42 PM
this is how i did it:



[root@server1 DBD-mysql-2.9003]# perl /root/.cpan/build/DBD-mysql-2.9003/Makefile.PL \
> --testdb=test \
> --testuser=root \
> --testpassword=<mypass> \
> --testhost=localhost
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/usr/include/mysql'
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (Users choice) = test
testhost (Users choice) = localhost
testpassword (Users choice) = <mypass>
testuser (Users choice) = root

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

ProWebUK
06-11-2004, 12:45 PM
perl -MCPAN -e shell
cpan> install DBD::mysql

Note its all case sensitive.

Chris

sander815
06-11-2004, 01:39 PM
as i wrote some msgs back, that didn't work for me...

either with perl Makefile.PL or from within cpan, same errors as some msgs back

Seth
07-03-2004, 03:12 PM
Originally posted by hostpc.com
wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-2.9002.tar.gz
wget http://www.cpan.org/modules/by-module/DBD/DBI-1.38.tar.gz
tar xvzf DBI-1.38.tar.gz
tar xvzf DBD-mysql-2.9002.tar.gz
cd DBI-1.38
perl Makefile.PL
make
make install
cd ..
cd DBD-mysql-2.9002
perl Makefile.PL
make
make install

Worked for me, thanks!

aboyz
08-24-2004, 12:13 PM
cpan> install DBD::mysql
Running install for module DBD::mysql
Running make for R/RU/RUDY/DBD-mysql-2.9004.tar.gz
LWP not available
CPAN: Net::FTP loaded ok
Fetching with Net::FTP:
ftp://ftp.perl.org/pub/CPAN/authors/id/R/RU/RUDY/DBD-mysql-2.9004.tar.gz
CPAN: Digest::MD5 loaded ok
LWP not available
Fetching with Net::FTP:
ftp://ftp.perl.org/pub/CPAN/authors/id/R/RU/RUDY/CHECKSUMS
Checksum for /root/.cpan/sources/authors/id/R/RU/RUDY/DBD-mysql-2.9004.tar.gz ok
Scanning cache /root/.cpan/build for sizes
DBD-mysql-2.9004/
DBD-mysql-2.9004/t/
DBD-mysql-2.9004/t/mysql2.t
DBD-mysql-2.9004/t/akmisc.t
DBD-mysql-2.9004/t/60leaks.t
DBD-mysql-2.9004/t/10dsnlist.t
DBD-mysql-2.9004/t/ak-dbd.t
DBD-mysql-2.9004/t/50chopblanks.t
DBD-mysql-2.9004/t/mysql.t
DBD-mysql-2.9004/t/lib.pl
DBD-mysql-2.9004/t/40blobs.t
DBD-mysql-2.9004/t/40nulls.t
DBD-mysql-2.9004/t/insertid.t
DBD-mysql-2.9004/t/40listfields.t
DBD-mysql-2.9004/t/40bindparam.t
DBD-mysql-2.9004/t/mysql.dbtest
DBD-mysql-2.9004/t/dbdadmin.t
DBD-mysql-2.9004/t/20createdrop.t
DBD-mysql-2.9004/t/00base.t
DBD-mysql-2.9004/t/30insertfetch.t
DBD-mysql-2.9004/t/40numrows.t
DBD-mysql-2.9004/t/50commit.t
DBD-mysql-2.9004/t/mysql.mtest
DBD-mysql-2.9004/MANIFEST
DBD-mysql-2.9004/myld
DBD-mysql-2.9004/dbdimp.c
DBD-mysql-2.9004/lib/
DBD-mysql-2.9004/lib/DBD/
DBD-mysql-2.9004/lib/DBD/mysql/
DBD-mysql-2.9004/lib/DBD/mysql/GetInfo.pm
DBD-mysql-2.9004/lib/DBD/mysql/INSTALL.pod
DBD-mysql-2.9004/lib/DBD/mysql.pm
DBD-mysql-2.9004/lib/Mysql/
DBD-mysql-2.9004/lib/Mysql/Statement.pm
DBD-mysql-2.9004/lib/Bundle/
DBD-mysql-2.9004/lib/Bundle/DBD/
DBD-mysql-2.9004/lib/Bundle/DBD/mysql.pm
DBD-mysql-2.9004/lib/Mysql.pm
DBD-mysql-2.9004/dbdimp.h
DBD-mysql-2.9004/mysql.xs
DBD-mysql-2.9004/MANIFEST.SKIP
DBD-mysql-2.9004/README
DBD-mysql-2.9004/INSTALL.html
DBD-mysql-2.9004/META.yml
DBD-mysql-2.9004/Makefile.PL
DBD-mysql-2.9004/ChangeLog
DBD-mysql-2.9004/constants.h
DBD-mysql-2.9004/TODO

CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9004.tar.gz

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
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 295
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
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
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 -mcpu=i486 -fno-strength-reduce -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 -O2 -march=i386 -mcpu=i686 -g -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" dbdimp.c
/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 196
Warning: duplicate function definition 'rows' detected in mysql.xs, line 294
gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce -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 -O2 -march=i386 -mcpu=i686 -g -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql:/usr/local/lib:/lib" /usr/bin/perl myld gcc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/Mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok
t/10dsnlist........DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/10dsnlist........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20createdrop.....DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/20createdrop.t line 45
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/20createdrop.....dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetch....DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/30insertfetch.t line 48
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/30insertfetch....dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40bindparam......DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40bindparam.t line 64
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/40bindparam......dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-28
Failed 28/28 tests, 0.00% okay
t/40blobs..........DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40blobs.t line 68
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/40blobs..........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40listfields.....DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40listfields.t line 57
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/40listfields.....dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-18
Failed 18/18 tests, 0.00% okay
t/40nulls..........DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40nulls.t line 50
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/40nulls..........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40numrows........DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/40numrows.t line 59
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/40numrows........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/50chopblanks.....DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/50chopblanks.t line 57
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/50chopblanks.....dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-35
Failed 35/35 tests, 0.00% okay
t/50commit.........DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/50commit.t line 64
Can't call method "tables" on an undefined value at t/lib.pl line 216.
t/50commit.........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/60leaks..........skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed
t/ak-dbd...........DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/ak-dbd.t line 59
t/ak-dbd...........NOK 1Can't call method "tables" on an undefined value at t/lib.pl line 216.
t/ak-dbd...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1, 4-90
Failed 88/90 tests, 2.22% okay
t/akmisc...........Mysql connect('database=test;host=','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/akmisc.t line 140
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
It looks as if your server is not up and running.
This test requires a running server.
Please make sure your server is running and retry.
t/akmisc...........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-351
Failed 351/351 tests, 0.00% okay
t/dbdadmin.........DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/dbdadmin.t line 74
Cannot connect: Access denied for user: 'root@localhost' (Using password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/dbdadmin.........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-21
Failed 21/21 tests, 0.00% okay
t/insertid.........DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/insertid.t line 13
t/insertid.........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-12
Failed 12/12 tests, 0.00% okay
t/mysql............Mysql connect('database=test;host=','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/mysql.t line 55
not ok 1: Access denied for user: 'root@localhost' (Using password: NO)
It looks as if your server is not up and running.
This test requires a running server.
Please make sure your server is running and retry.
t/mysql............FAILED tests 1-68
Failed 68/68 tests, 0.00% okay
t/mysql2...........Mysql connect('database=test;host=','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/mysql2.t line 29
Can't call method "getserverinfo" on an undefined value at t/mysql2.t line 30.
t/mysql2...........dubious
Test returned status 255 (wstat 65280, 0xff00)
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/10dsnlist.t 10 2560 9 9 100.00% 1-9
t/20createdrop.t 10 2560 5 5 100.00% 1-5
t/30insertfetch.t 10 2560 11 11 100.00% 1-11
t/40bindparam.t 10 2560 28 28 100.00% 1-28
t/40blobs.t 10 2560 11 11 100.00% 1-11
t/40listfields.t 10 2560 18 18 100.00% 1-18
t/40nulls.t 10 2560 11 11 100.00% 1-11
t/40numrows.t 10 2560 25 25 100.00% 1-25
t/50chopblanks.t 10 2560 35 35 100.00% 1-35
t/50commit.t 255 65280 30 30 100.00% 1-30
t/ak-dbd.t 255 65280 90 88 97.78% 1 4-90
t/akmisc.t 10 2560 351 351 100.00% 1-351
t/dbdadmin.t 10 2560 21 21 100.00% 1-21
t/insertid.t 255 65280 12 12 100.00% 1-12
t/mysql.t 68 68 100.00% 1-68
t/mysql2.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 16/18 test scripts, 11.11% okay. 723/730 subtests failed, 0.96% okay.
make: *** [test_dynamic] Error 2
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force

nate
09-17-2004, 02:52 PM
I am getting the same error. any help is appreciated.

hostpc.com
09-17-2004, 03:34 PM
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 install