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@stripped]
>Enviado el: Miércoles, 17 de Mayo de 2006 12:36 p.m.
>Para: "Héctor S. Mendoza O."
>CC: perl@stripped
>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@stripped]
>>Enviado el: Miércoles, 17 de Mayo de 2006 12:16 p.m.
>>Para: "Héctor S. Mendoza O."
>>CC: perl@stripped
>>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
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
