Hi,
Have a little problem:
After I upgraded mysql 4.0 (art) --> 4.1.12-1 (art) on FC2 / PSA 7.5.4 I have the following errors in mysqld.log:
050925 00:22:50 mysqld started
050925 0:22:50 [Warning] Found invalid password for user: 'chiara@localhost'; Ignoring user
050925 0:22:50 [Warning] Found invalid password for user: 'dbuser@localhost'; Ignoring user
050925 0:22:50 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone' doesn't exist trying to live without them
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Same problem on my 2nd server, also FC2.
Any idea ?
EDITED-----------------------------------------------------------------------
FIXED: forgot to run /usr/bin/mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`
-------------------------------------------------------------------------------
sorry
Kind Regards,
Bart
Mysql 4.1.12 art Update
I tuned my.cnf and httpd.conf a little bit, because mysql process was running at >90% cpu (1000 qps in mytop) and slowed down the whole server. I have 1GB Ram, but the recommended setting by Ivalics & others didn't make it and I had to limit max_connections to 200.
Now I wonder that I can't restart or stop postgresql, nor thru Plesk CP, nor by command line. Anyway, plesk is now running at 0.1 - 1.0 % cpu, yesterday (before the performance tuning) it was at 46% and almost freezing.
Also the last plesk update killed my httpd.include (blank !), happily I had took a copy before the update (recommended).
Bart
Now I wonder that I can't restart or stop postgresql, nor thru Plesk CP, nor by command line. Anyway, plesk is now running at 0.1 - 1.0 % cpu, yesterday (before the performance tuning) it was at 46% and almost freezing.
Also the last plesk update killed my httpd.include (blank !), happily I had took a copy before the update (recommended).
Bart
