|
|
Re: Problem connecting: msg#00021
db.mysql.perl
|
Subject: |
Re: Problem connecting |
Héctor S. Mendoza O. wrote:
If your password has some characters that need to be escaped and aren't,
perhaps that might be the issue. Try changing to a alphanumeric password
(using GRANT syntax) if your current password has non-alphanumeric
characters.
btw - please turn off the email receipt confirmation to me ;)
Here is another log file running mysql with --log=/tmp/connections.log
[root@chihuahua root]# cat /tmp/connections.log
/usr/sbin/mysqld-max, Version: 4.1.10a-Max-log. started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
060517 12:59:08 1 Connect Access denied for user 'web'@'localhost'
(using password: YES)
060517 12:59:22 2 Connect web@localhost on planos
060517 12:59:23 2 Quit
[root@chihuahua root]#
Connection 1 is from the script, connection 2 is from the 'mysql -u web -h
localhost -p planos'
I already double checked passwords and I'm typing in both the same password
TIA
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
|
|
