Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008
    Posts
    7

    Default How can i fix this error.

    After backup restore to a new machine, got this error on every reboot:
    -----------------------

    Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 InnoDB: Started; log sequence number 0 7827358
    Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
    Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 [Note] Starting crash recovery...
    Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 [Note] Crash recovery finished.
    Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 [Note] /usr/sbin/mysqld: ready for connections.
    Dec 2 06:02:58 mail mysqld[4430]: Version: '5.0.32-Debian_7.5.200902111628-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4485]: Upgrading MySQL tables if necessary.
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4488]: ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4488]: Error executing '/usr/bin/mysql --defaults-extra-file=/var/lib/mysql/mysql_upgrade_defaults --force --no-auto-rehash --batch --user=debian-sys-m
    aint mysql < /usr/share/mysql/mysql_fix_privilege_tables.sql'
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4494]: Checking for crashed MySQL tables.
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]: WARNING: mysqlcheck has found corrupt tables
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]:
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]: Improperly closed tables are also reported if clients are accessing
    Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]: the tables *now*. A list of current connections is below.
    Dec 2
    ------------------------------------------

    also on shutdown, the mysql daemon shows error shutting down.

    Everything else seems to be working

  2. #2
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    Hi,

    seems like you've also backupped and restored the "mysql" table. This one contains a debian user "debian-sys-maint" with a system-specific password. This user is required to start/stop mysql correctly. You might want to change its password to the one specified at /etc/mysql/debian.cnf.

    Greetings

  3. #3
    Join Date
    Apr 2008
    Posts
    7

    Default Changing the password cli

    Thanks for the reply Martin,

    The backup/restore procedure was made using 100% UMC backup capability - nothing manually.
    Experimentations with OX AE are not ending up very happily allways, so for example the passowd in /etc/mysql/debian.cnf is: 123456

    so the right way to do it from the shell should be:
    ---------------------
    mysql -u root

    SET PASSWORD FOR 'debian-sys-maint'@'localhost' = PASSWORD('123456');

    flush privileges;
    ---------------------

    Im i right ?


    Aleksander
    Last edited by sasskass; 12-02-2009 at 04:32 PM.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •