Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: at9 on September 12, 2006, 11:26:57 AM

Title: error in log
Post by: at9 on September 12, 2006, 11:26:57 AM: 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: [60G
: 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: [60G[
: mysql.init:
: rc.e-smith: Starting mysql.init: failed

What should i do?? Some times ago i updated SME 6.0 to 7.0.
Title: Re: error in log
Post by: cactus on September 12, 2006, 12:34:32 PM: Quote from: "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: [60G
: 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: [60G[
: 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
Title: hm
Post by: at9 on September 12, 2006, 01:34:15 PM: 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:)
Title: Re: hm
Post by: cactus on September 13, 2006, 11:07:40 AM: Quote from: "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:)
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