(Using password: NO) while installing DBD::mysql, Full version, ignore previous message

Hello All,

The previous send of this email was cut off at the end (including cutting of
f my questions). I hope this gets through as the full version.

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.



I tried to fix the problem by entering the password (qwert) with a switch (#
perl Makefile.PL --testpassword=qwert), but it seems the password disappear
ed between the Makefil.PL and the make. So the questions are:

1. Can anyone tell me how to fix this problem?

2. More specifically, what does "(Using password: NO)" mean in the error mes
sage? Does it mean that no password is necessary? Or, that I didn't enter/
specify a password? Other?

3. What does "or you have no permissions for acessing the DSN DBI:mysql:test
This test requires a running server and write permissions." mean? Are th
e "permissions" something I can set in the "# perl Makefile.PL", or are thes
e something like read/write permissions for a test file that I have to set u
sing mysql commands? If you can tell me what to set the permissions on, and
what to set them to, I can study the manual to learn how to set permissions
I've never used mysql before so it would speed things up if you can at le
ast tell me what commands I would use for this process.


I'm new to mysql so please make your suggestions clear and simple. Any help
would be greatly appreciated.

Thank you very much,

Ben




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org