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

am 11.06.2004 06:22:29 von Ben Burford

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

Re: (Using password: NO) while installing DBD::mysql, Full

am 11.06.2004 08:07:51 von Jochen Wiedmann

On Fr, 2004-06-11 at 06:22, Ben Burford wrote:

> 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 ) =

For unknown reasons, the Makefile is regenerated at this point -
*without* the password. I have no idea why. Is your machines system
clock alright?

Jochen

--
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

Re: (Using password: NO) while installing DBD::mysql, Full

am 11.06.2004 08:07:51 von Jochen Wiedmann

Re: (Using password: NO) while installing DBD::mysql, Fullversion, ignore previous message

am 11.06.2004 09:03:18 von Ben Burford

Hello Jochen,

I didn't see a way to respond to your message from the website, so this resp
onse may start a new thread. . . .

As far as I know the system clock is fine. It has always shown the correct
date and time. I don't know of any particular method to check for this.

Basically, I have the same question as you - why did the password show up in
the "# perl Makefile.PL" and then disappear in the "# make"???

I don't understand how the perl process works (I've never studied it, I'm ju
st following the instructions in the documentation):
# perl Makefile.PL
# make
# make test
# make install

I was hoping the answer/solution would be simple (e.g. specify an additional
switch). Your saying "I have no idea why" indicates that there's something
unusual and wrong in a basic process/mechanism, which is bad news for me.
Any other ideas for things I can try? Do you know of any way to force the p
assword in the "# make" (by editing a file, or interrupting the "# make" pro
cess and forcing a value, using a switch, or otherwise getting inside the "#
make" process)?

Can you tell me what "(Using password: NO)" means - does it mean that a pass
word was not specified? Does "(Using password: YES)" mean that a password w
as specified? Other???

Also, is there some documentation that describes how this whole process work
s (what each step is doing)?

I will note one further thing. As I wrote in my original message, I did the
following:
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

So this process worked successfully for installing DBI-1.42 (although no pas
sword was involved). Then (as the next step in my process) when I tried it
for (DBD-mysql-2.1017.tar.gz) it failed (perhaps only because the password w
as involved).

Any help is greatly appreciated.

Thank you,

Ben

At 08:07 2004/06/11 +0200, you wrote:
> On Fr, 2004-06-11 at 06:22, Ben Burford wrote:
>
> > Then I did a "make" which showed:
> >
> > # make
> > cflags (mysql_config) = -I'/usr/include/mysql'
> > libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcr
ypt
> > -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 ) =
>
> For unknown reasons, the Makefile is regenerated at this point -
> *without* the password. I have no idea why. Is your machines system
> clock alright?
>
>
> Jochen
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe: http://lists.mysql.com/perl?unsub=sugiarto.Then@infotro
nik.com
>

--
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

Re: (Using password: NO) while installing DBD::mysql, Fullversion, ignore previous message

am 11.06.2004 09:03:18 von Ben Burford

Re: (Using password: NO) while installing DBD::mysql, Fullversion,

am 11.06.2004 11:02:00 von Jochen Wiedmann

On Fr, 2004-06-11 at 09:03, Ben Burford wrote:

> I didn't see a way to respond to your message from the website, so this resp
> onse may start a new thread. . . .
>
> As far as I know the system clock is fine. It has always shown the correct
> date and time. I don't know of any particular method to check for this.
>
> Basically, I have the same question as you - why did the password show up in
> the "# perl Makefile.PL" and then disappear in the "# make"???

It is intentionally, that the Makefile checks, whether it is uptodate.
Usually this happens by comparing the mtimes of Makefile.PL and
Makefile. The idea is, that Makefile gets updated automatically, if the
developer updates the Makefile.PL.

In a normal build, the Makefile should always be newer than Makefile.PL.
In other words, "make" should never trigger a rebuild of Makefile.
However, your output clearly demonstrates, that the Makefile *is*
rebuilt. The rebuild occurs without the parameters you specified when
invoking Makefile.PL manually, hence the "no password".

I have no idea, what goes wrong. I can simply tell my diagnosis. If you
want to proceed without evaluating the problem, you should temporarily
disable passwords for the "test" database or ignore the errors and
proceed to "make install" immediately.

Jochen

--
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

Re: (Using password: NO) while installing DBD::mysql, Fullversion,

am 11.06.2004 11:02:00 von Jochen Wiedmann

Re: (Using password: NO) while installing DBD::mysql, Fullversion,ignore previous message

am 11.06.2004 16:21:35 von shortt

On Fri, 11 Jun 2004, Ben Burford wrote:

> Can you tell me what "(Using password: NO)" means - does it mean that a pass
> word was not specified? Does "(Using password: YES)" mean that a password w
> as specified? Other???

it means it attempted to login without using a password (..word: NO) and
the mysql server did not allow it. you can recreate it from the command
line like such.

$ mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

HTH

-k

--
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

Re: (Using password: NO) while installing DBD::mysql, Fullversion,ignore previous message

am 11.06.2004 16:21:35 von shortt