I added the line to the configuration file and removed "--log-error=" line
from startup line but it still creates the /usr/local/mysql/var/yoda2.err
as well as /var/log/mysql/error.log
I am assuming it is reading from my.cnf as I get the following when I run
"mysqladmin variables"
log_error | /var/log/mysql/error.log
I also checked for possible duplicate my.cnf files but there is only one.
Is there another way to check to be sure it's reading the configuration file?
At 12:40 PM Sunday, 6/5/2005, Gleb Paharenko wrote -=>
Unfortunately I could give suggestion only about your second question.
Is it possible that /var/log/mysql/error.log created by mysqld_safe
(you're specifying it with --log-error command line option) and
/usr/local/mysql/var/yuda2.err is created by mysqld process if it
founds problems before applying location of error log to it's internal
variable? Specify
log-error = /var/log/mysql/error.log
in your configuration file, and check that MySQL Server actually reads
this file.
Ed Kasky wrote:
> Hello there -
>
> I have a couple of questions regarding a new install of MySql 4.1.12 on
> RH 7.2. Being new to this list, I sure do hope this hasn't been covered
> before. I have scrubbed Google and searched the archives for this list
> but can't find an explanation or a solution to 2 issues:
>
> 1. I get the following error when starting the daemon:
>
> 050605 7:08:51 [Warning] Found an entry in the 'db' table with empty
> database name; Skipped
>
> Is this something that should be fixed and if so, how does one go about it?
>
> 2. I have set the error log to /var/log/mysql/error.log in the init
> script:
>
> LOG_ERROR="/var/log/mysql/error.log"
> $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file
> --log-error=$LOG_ERROR
>
> However, I am still getting 2 error logs:
>
> What I am assuming is the default "/usr/local/mysql/var/yoda2.err"
> and the one specified - "/var/log/mysql/error.log"
>
> Is this expected behavior? Is there another place aside from
> /etc/my.cnf that I might look?
>
> Thanks in advance for any tips and/or suggestions.
>
> Ed
>
> . . . . . . . . . . . . . . . . . .
> Randomly Generated Quote (116 of 975):
> "It had long since come to my attention that people of
> accomplishment rarely sat back and let things happen
> to them. They went out and happened to things." - Elinor Smith
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
. . . . . . . . . . . . . . . . . .
Randomly Generated Quote (203 of 975):
"To climb steep hills requires slow pace at first."
- William Shakespeare
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]