Hello All,

On Red Hat Linux 7.2 I installed: MySQL-3.23.58-1.i386.rpm and MySQL-client-3.23.58-1.i386.rpm for a basic ser ver installation. This installation works OK, I did a few basic operations and set passwords for root and anonymous accounts (all to the same password of "qwert" for setup purposes).

I then did the following installations:

Download And, install MySQL-devel-3.23.58-1.i386.rpm.

# rpm -ivh package-1.1.0-i386.rpm

DBI is needed to use DBD-mysql. Download And, install DBI-1.42.tar.gz

# tar xvfz DBI-1.42.tar.gz # cd DBI-1.42

# perl Makefile.PL # make # make install

Install DBD-mysql-2.1017 (DBD-mysql-2.1017.tar.gz) untar and:

# perl Makefile.PL # make # make test

After the "make test" I saw:

t/10dsnlist.........DBI connect('test','',...) failed: Access denied for use r: '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.

I did the following to verify that the mysql server was running:

# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 84 to server version: 3.23.58-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select host, user from mysql.user; +-----------+------+ | host | user | +-----------+------+ | localhost | | | localhost | root | | rdtest | | | rdtest | root | +-----------+------+ 4 rows in set (0.00 sec)

I studied the CPAN installation instructions and tried:

# perl Makefile.PL --testpassword=qwert 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 -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lres olv nocatchstderr (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (default ) = testpassword (Users choice) = qwert testuser (default ) =

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

Using DBI 1.42 (for perl 5.006 on i386-linux) installed in /usr/lib/perl5/si te_perl/5.6.0/i386-linux/auto/DBI Writing Makefile for DBD::mysql

Then I did a "make" which showed:

# make cflags (mysql_config) = -I'/usr/include/mysql' libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lres olv nocatchstderr (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'.

Then I did a "make test" and saw the same error as above:

# make test gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I'/usr/include/ mysql' -fno-strict-aliasing -I/usr/local/include -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.1017\" -DXS_VERSION=\"2.1017\" -fPIC -I/usr/lib/perl5/5.6. 0/i386-linux/CORE dbdimp.c /bin/sh -c true /bin/sh -c true gcc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I'/usr/include/ mysql' -fno-strict-aliasing -I/usr/local/include -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.1017\" -DXS_VERSION=\"2.1017\" -fPIC -I/usr/lib/perl5/5.6. 0/i386-linux/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs LD_RUN_PATH="/usr/lib/mysql:/usr/lib:/lib" /usr/bin/perl myld gcc -o blib/ar ch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -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 PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6. 0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verb ose); $verbose=0; runtests @ARGV;' t/*.t t/00base............ t/00base............ok 1/5 t/00base............ok 2/5 t /00base............ok 3/5 t/00base............ok 4/5 t/00base............ok 5/5 t/00base............ok t/10dsnlist.........DBI connect('test','',...) failed: Access denied for use r: '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.