Re: Problem connecting
Patrick Galbraith <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
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:[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]