Topic: error in log

[at9]

I instaled
awstats-1[1].2-2.noarch.rpm
smeserver-awstats-1[1].2-2.noarch.rpm
I have not AWSTAT in server-manager and i have some error in log:

...
: mysql.init: Loading 20mysql_migrate_horde into mysql
: 20mysql_migrate_horde: ERROR
: 20mysql_migrate_horde:  1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: Loading 20mysql_migrate_horde into mysql failed
: serwercl mysql.init: 
: serwercl mysql.init:
: mysql.init: Loading 21horde.mysql_set_password into mysql
: 21horde.mysql_set_password: ERROR
: 21horde.mysql_set_password:  1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: Loading 21horde.mysql_set_password into mysql failed
: mysql.init:
: mysql.init: Loading 30mysql_create_tables into mysql
: 30mysql_create_tables: ERROR
: 30mysql_create_tables:  1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: Loading 30mysql_create_tables into mysql failed
" mysql.init:
: mysql.init: Loading 50turba_upgrade into mysql
: 50turba_upgrade: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/turba_upgrade line 44
: mysql.init: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/turba_upgrade line 44
: mysql.init: Loading 50turba_upgrade into mysql failed
: mysql.init: [
: mysql.init:
: rc.e-smith: Starting mysql.init:  failed

What should i do?? Some times ago i updated SME 6.0 to 7.0.

[cactus]

I instaled
awstats-1[1].2-2.noarch.rpm
smeserver-awstats-1[1].2-2.noarch.rpm
I have not AWSTAT in server-manager and i have some error in log:

...
: mysql.init: Loading 20mysql_migrate_horde into mysql
: 20mysql_migrate_horde: ERROR
: 20mysql_migrate_horde:  1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: Loading 20mysql_migrate_horde into mysql failed
: serwercl mysql.init: 
: serwercl mysql.init:
: mysql.init: Loading 21horde.mysql_set_password into mysql
: 21horde.mysql_set_password: ERROR
: 21horde.mysql_set_password:  1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: Loading 21horde.mysql_set_password into mysql failed
: mysql.init:
: mysql.init: Loading 30mysql_create_tables into mysql
: 30mysql_create_tables: ERROR
: 30mysql_create_tables:  1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
: mysql.init: Loading 30mysql_create_tables into mysql failed
" mysql.init:
: mysql.init: Loading 50turba_upgrade into mysql
: 50turba_upgrade: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/turba_upgrade line 44
: mysql.init: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/turba_upgrade line 44
: mysql.init: Loading 50turba_upgrade into mysql failed
: mysql.init: [
: mysql.init:
: rc.e-smith: Starting mysql.init:  failed

What should i do?? Some times ago i updated SME 6.0 to 7.0.

It looks to me that there is something wrong with your root password for the root@localhost MySQL user. Somehow it seems to be changed, probably by you.

Reset it like this (mind the dots, if you use putty just copy and paste):

Code: [Select]

cd /var/service/mysqld
runsvctrl d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
runsvctrl u .

edit: removed unnneccesarry backslash causing errors

[at9]

In line:
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables \ < ./set.password
have a monit:
to many arguments (first extra is' ')

...
I do it from pine as You wrote:)

[cactus]

In line:
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables \ < ./set.password
have a monit:
to many arguments (first extra is' ')

...
I do it from pine as You wrote:)

Oops, it was a multiline statement and I forgot to remove the backslash I guess, corrected it. Above line should read:

Code: [Select]

/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-table < ./set.password