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.
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
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
Hi, I have a similar problem, apparently it does not exist or has deleted the user ispconfig from mysql.user table. I have errors like this in syslog: authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Access denied for user 'ispconfig'@'localhost' (using password: YES) I tried to update the user password but I don't see it is there MariaDB [mysql]> update user set Password = PASSWORD('MYPASS') WHERE User = 'ispconfig'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 I have made many changes: update debian 6-7 update the ispconfig to ISPConfig 3.0.5.4p8 version, reconfiguring services installing MariaDB instead of mysql and I had to copy and then restore once installed MariaDB the /var/lib/mysql folder, before updating cp -R /var/lib/mysql /var/lib/_mysql cp -Ruv /var/lib/_mysql/. /var/lib/mysql/. Could you tell me how to insert the ispconfig user again? Thx
I think I've solved: mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2903 Server version: 10.1.10-MariaDB-1~wheezy mariadb.org binary distribution Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> grant all privileges on *.* to'ispconfig'@'localhost' identified by 'MYPASS'; MariaDB [(none)]> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A MariaDB [mysql]> update user set Password = PASSWORD('MYPASS') WHERE User = 'ispconfig'; MariaDB [mysql]> flush privileges; And apparently everything is working properly now. Thx
