RE: Problem connecting
Héctor S. Mendoza O. <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Organization | Asesoria Corporativa |
| Message-ID | <!&!AAAAAAAAAAAYAAAAAAAAAPqDXXKKVJJDkW2fXk7LxXrCgAAAEAAAAPEG+Tyx3JFIkUDgGzUqwOABAAAAAA==@acorporativa.com.mx> |
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:[email protected]]
Enviado el: Miércoles, 17 de Mayo de 2006 12:16 p.m.
Para: "Héctor S. Mendoza O."
CC: [email protected]
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/[email protected]