Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st June 2013, 15:17
tbcham tbcham is offline
Junior Member
 
Join Date: Jun 2013
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cannot login to very slow login page after Mysql dump import

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.
Reply With Quote
Sponsored Links
  #2  
Old 21st June 2013, 17:47
tbcham tbcham is offline
Junior Member
 
Join Date: Jun 2013
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #3  
Old 21st June 2013, 17:54
tbcham tbcham is offline
Junior Member
 
Join Date: Jun 2013
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 21st June 2013, 19:24
tbcham tbcham is offline
Junior Member
 
Join Date: Jun 2013
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ispconfig 3 cant receive emails lishaw1968 Installation/Configuration 25 19th August 2013 10:37
mysql root login cwtudor Server Operation 4 8th April 2013 19:58
ISPConfig 3 - MultiServer Setup - With Dedicated Control Panel - How? SuperJC Installation/Configuration 4 16th October 2012 20:03
Need help with ISPConfig Mail and Squirrelmail m.xander Installation/Configuration 109 3rd February 2012 00:15
F11 courier-imap fails. Nachogrande General 6 1st November 2010 17:55


All times are GMT +2. The time now is 12:29.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.