RE: Problem connecting: msg#00018 db.mysql.perl

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: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

Previous by Date:	Re: Problem connecting: 00018, Patrick Galbraith
Next by Date:	RE: Problem connecting: 00018, Héctor S . Mendoza O .
Previous by Thread:	Re: Problem connectingi: 00018, Patrick Galbraith
Next by Thread:	Re: Problem connecting: 00018, Patrick Galbraith
Indexes:	[Date] [Thread] [Top] [All Lists]