Cannot login to very slow login page after Mysql dump import

Discussion in 'Installation/Configuration' started by tbcham, Jun 21, 2013.

  1. tbcham

    tbcham New Member

    Installed ISCPconfig with no error, everything worked great, then I imported dumped database files from old server. As mysql username was different everything got messed up when changing password back to the one used for ISCPonfig set up after flush privileges. However sorted that all out got mysql back up with the original install password for root, however cannot login to ISCPConfig and the log in page is very slow.

    When I go to check the user iscpconfig in the user table for mysql there is no such user.

    Using /etc/init.d/mysql restart works fine and I can log into mysql as root and same password,

    however if I use mysql restart I get: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO),
    Using mysql restart --skip-grant-tables
    mysql: unknown option '--skip-grant-tables'
    root@server1:~# mysqld --skip-grant-tables
    130621 14:36:21 [Note] Plugin 'FEDERATED' is disabled.
    130621 14:36:21 InnoDB: Initializing buffer pool, size = 8.0M
    130621 14:36:21 InnoDB: Completed initialization of buffer pool
    InnoDB: Unable to lock ./ibdata1, error: 11
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    130621 14:36:21 InnoDB: Retrying to lock the first data file
    InnoDB: Unable to lock ./ibdata1, error: 11
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    InnoDB: Unable to lock ./ibdata1, error: 11

    At end message is:

    130621 14:38:01 [ERROR] Plugin 'InnoDB' init function returned error.
    130621 14:38:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    130621 14:38:01 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
    130621 14:38:01 [ERROR] Do you already have another mysqld server running on port: 3306 ?
    130621 14:38:01 [ERROR] Aborting

    130621 14:38:01 [Note] mysqld: Shutdown complete

    When I do

    lsof -i:3306
    COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
    mysqld 18809 mysql 10u IPv4 853706 0t0 TCP localhost.localdomain:mysql (LISTEN)

    ps aux | grep mysql
    tim 19274 0.3 0.0 2435116 532 s000 R+ 2:43pm 0:00.00 grep mysql

    So I kill the service

    kill -9 18809

    user@server1:~# mysql restart
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

    but /etc/init.d/mysql restart starts mysql no problem.

    In phpmyadmin the dbispconfig is there, as are the users I created in the sys_user table.
     
  2. tbcham

    tbcham New Member

    ispconfig log shows these warnings:

    PHP Warning: mysqli::escape_string(): Couldn't fetch db in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 215
    PHP Warning: mysqli::close(): Couldn't fetch db in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 82

    PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 62
    DB::__construct Access denied for user 'ispconfig'@'localhost' (using password: YES)

    PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72
    DB::__construct Access denied for user 'ispconfig'@'localhost' (using password: YES)

    PHP Warning: mysqli::close(): Couldn't fetch db in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 82
     
  3. tbcham

    tbcham New Member

    Retried:

    ps aux | grep mysql

    root 3364 0.0 0.0 9892 832 pts/0 S+ 17:46 0:00 grep mysql
    root 27309 0.0 0.0 13008 1488 pts/0 S 14:47 0:00 /bin/sh /usr/bin/mysqld_safe
    mysql 27421 0.0 0.7 314488 128980 pts/0 Sl 14:47 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
    root 27422 0.0 0.0 7692 692 pts/0 S 14:47 0:00 logger -t mysqld -p daemon.error
     
  4. tbcham

    tbcham New Member

    added the user ispconfig to the mysql.user table and am logged in.
     

Share This Page