|
|
Re: Problem connecting: msg#00020
db.mysql.perl
|
Subject: |
Re: Problem connecting |
Héctor S. Mendoza O. wrote:
Hector,
hmmm, try perhaps setting a DBD->trace and see what exactly the script
is doing. I'm a bit baffled why it won't work. It worked before your
change for PHP right?
regards,
Patrick
Patrick:
I tried already replacing localhost with hostname and ip address and i get
the same result, I can connect using mysql command but not the script.
Regarding the user, I thought also that I messed up the user, I deleted the
user and create it again, I used for this command line and "MySQL
Administrator" tool and in both I got the same result.
As far as the old_password in mysql 4.1 there was a change in password
hashing, I've searched everywhere and found that since 4.1 there's been a
lot of problems specially with php regarding this change in password
hashing, the new app I was trying to install required old_password=1 in the
/etc/my.cfg and a change in the password SET OLD_PASSWORD('secret') instead
of SET PASSWORD('secret')
Regarding my password having characters that need to be escaped, I have
none, it's just letters [aA..zZ] and numbers [0..9], so the password
escaping is not the issue also.
The weird thing and why I think is perl (DBD, DBI) the problem is that I can
connect to mysql via the command line with the same user, password, host and
database and the perl script can't.
Regarding the email receipt, sorry, it's a security issue on the company,
actually I don't have it configured on my mail tool, but it's enforced by
the mail server. I'll try to contact the sysadmin to turn you off email
receipt.
Thanks again for the help
Héctor S. Mendoza Ortiz
-----Mensaje original-----
De: Patrick Galbraith [mailto:patg@xxxxxxxxx]
Enviado el: Miércoles, 17 de Mayo de 2006 01:08 p.m.
Para: "Héctor S. Mendoza O."
CC: perl@xxxxxxxxxxxxxxx
Asunto: 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
| |
