Hector,
I'm not sure what you did with the access for this user (as described in
an earlier email). Can you:
Connect to the database specifying the actual hostname vs. "localhost"?
if yes: try with your script
if no: perhaps create a user (using GRANT, not modifying by hand
mysql.user) that can connect to the particular host, then
try to connect with the client, then connect with the script
Other than that, I'm not sure what the problem is. You modified your
privileges it seems, though I don't know what you mean by
"old_password". I would stick to using GRANT, and not modifying the
mysql.user table directly, which can only result in headaches as well as
having to issue "flush privileges". Whatever the problem is, it's not a
DBD::mysql issue as much as it is a privilege issue.
regards,
Patrick
Héctor S. Mendoza O. wrote:
Here is the the contents of the mysql log for the past 12 hours
060516 20:52:23 mysqld started
060516 20:52:24 InnoDB: Started; log sequence number 0 50644802
/usr/sbin/mysqld-max: ready for connections.
Version: '4.1.10a-Max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306
MySQL Community Edition - Max (GPL)
060517 12:42:11 [Note] /usr/sbin/mysqld-max: Normal shutdown
060517 12:42:11 InnoDB: Starting shutdown...
060517 12:42:12 InnoDB: Shutdown completed; log sequence number 0 50644839
060517 12:42:12 [Note] /usr/sbin/mysqld-max: Shutdown complete
060517 12:42:12 mysqld ended
060517 12:42:13 mysqld started
060517 12:42:14 InnoDB: Started; log sequence number 0 50644839
/usr/sbin/mysqld-max: ready for connections.
Version: '4.1.10a-Max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306
MySQL Community Edition - Max (GPL)
Héctor S. Mendoza Ortiz
-----Mensaje original-----
De: Patrick Galbraith [mailto:patg@xxxxxxxxx]
Enviado el: Miércoles, 17 de Mayo de 2006 12:36 p.m.
Para: "Héctor S. Mendoza O."
CC: perl@xxxxxxxxxxxxxxx
Asunto: Re: Problem connecting
Héctor S. Mendoza O. wrote:
Hector,
What I mean, is the database error log.
Thanks!
Patrick
Here is the log from the web server...
[Tue May 16 21:22:54 2006] [error] [client 10.0.10.1] DBI
connect('planos;localhost','web',...) failed: Access denied for user
'web'@'localhost' (using password: YES) at
/ispman/domains/elpaseo.com.mx/vhosts/planos/cgi-bin/planos.pl line 25
[Tue May 16 21:22:54 2006] [error] [client 10.0.10.1] 1 at
/ispman/domains/elpaseo.com.mx/vhosts/planos/cgi-bin/planos.pl line 25.
Here is the log if I run it from the shell
[root@chihuahua cgi-bin]# ./planos.pl
Content-type: text/html
<html>
<head>
<title>Planos Centro Comercial El Paseo Tehuacan</title>
</head>
<body bgcolor="white">
DBI connect('planos;localhost','web',...) failed: Access denied for user
'web'@'localhost' (using password: YES) at ./planos.pl line 25
Error al conectarse con la base de datos
1 at ./planos.pl line 25.
[root@chihuahua cgi-bin]#
Here is if I run it from mysql
[root@chihuahua cgi-bin]# mysql -u web -h localhost -p planos
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 92 to server version: 4.1.10a-Max-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> quit
Bye
[root@chihuahua cgi-bin]#
Thanks in advance!
Héctor S. Mendoza Ortiz
-----Mensaje original-----
De: Patrick Galbraith [mailto:patg@xxxxxxxxx]
Enviado el: Miércoles, 17 de Mayo de 2006 12:16 p.m.
Para: "Héctor S. Mendoza O."
CC: perl@xxxxxxxxxxxxxxx
Asunto: Re: Problem connecting
Héctor S. Mendoza O. wrote:
Hello all,
Sorry I forgot to mention, I'm using the program in Linux, perl is v5.8.3
and MySQL is 4.1.10a.
The script was working perfectly until I installed a php application that
required old_password set to 1 and an account with old password, thinking
it
would not affect anything, I switched to old_password and changed
passwords
for old_password, the new app worked fine and 5 min later I received a
call
that the rest of the apps where not working, I switched back to
old_password=0 switched again old_passwords to new passwords and still not
working.
Any ideas?
TIA
Héctor S. Mendoza Ortiz
Hector,
What does the error log say?
regards,
Patrick
--
MySQL Perl Mailing List
For list archives:
http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@xxxxxxxxxxx
