RE: Problem connecting
Héctor S. Mendoza O. <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Organization | Asesoria Corporativa |
| Message-ID | <!&!AAAAAAAAAAAYAAAAAAAAAPqDXXKKVJJDkW2fXk7LxXrCgAAAEAAAAO4J/[email protected]> |
Here is the the contents of the mysql log for the past 12 hours 060516 20:52:23 mysqld started 060516 20:52:24 InnoDB: Started; log sequence number 0 50644802 /usr/sbin/mysqld-max: ready for connections. Version: '4.1.10a-Max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Max (GPL) 060517 12:42:11 [Note] /usr/sbin/mysqld-max: Normal shutdown 060517 12:42:11 InnoDB: Starting shutdown... 060517 12:42:12 InnoDB: Shutdown completed; log sequence number 0 50644839 060517 12:42:12 [Note] /usr/sbin/mysqld-max: Shutdown complete 060517 12:42:12 mysqld ended 060517 12:42:13 mysqld started 060517 12:42:14 InnoDB: Started; log sequence number 0 50644839 /usr/sbin/mysqld-max: ready for connections. Version: '4.1.10a-Max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Max (GPL) 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]