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