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
  #21  
Old 15th September 2009, 14:32
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 Posts
Default

Please see my post above for the instructions in case that the uninstall script fails.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Sponsored Links
  #22  
Old 15th September 2009, 23:02
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Sometimes I feel I have too little experience with linux :-)
How can I delete the ispconfig user in the mysql.user table?

When I connect to the main server I don't find a mysql.user table.
Reply With Quote
  #23  
Old 16th September 2009, 11:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 Posts
Default

The easiest way is to use phpmyadmin. Every mysql database server has a database called mysql and it must contain several tables incl. a user table.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #24  
Old 16th September 2009, 22:56
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Quote:
Originally Posted by till View Post
The easiest way is to use phpmyadmin. Every mysql database server has a database called mysql and it must contain several tables incl. a user table.
I deleted the mysql.user table. But now I can't login to mysql anymore all users are denied even root.
Help.... how to restore the mysql.user database without access to mysql??

Last edited by skoena; 17th September 2009 at 09:10.
Reply With Quote
  #25  
Old 17th September 2009, 00:27
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

What I have done to fix it.
Edited the /etc/mysql/my.cnf file. I have added
Quote:
skip-grant-tables
after
Quote:
[mysqld]
. Restarted the mysql server
Quote:
/etc/init.d/mysql restart
I now was able to get into mysql without login and password. I imported the backupped mysql.user table. Deleted the "skip-grant-tables" from the my.cnf file. Rebooted the server and everyting was fine again. Phoeffffff.

Another question now. What should I delete from the mysql.user table. I know now not the whole table.
Reply With Quote
  #26  
Old 17th September 2009, 11:28
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 Posts
Default

Please delet just the record for the user named "ispconfig" instead of the complete table. Look also trough all other tables in the database "mysql" and delete records were the username is "ispconfig". Then restart mysql.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #27  
Old 17th September 2009, 12:04
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Sorry for my noob problems :-)

I find this in the DB table:
*localhost dbispconfig ispconfig Y Y Y Y N N N N N N N N N N N N N
*192.168.1.102 dbispconfig ispcsrv6 Y Y Y Y N N N N N N N N N N N N N
*192.169.1.102 dbispconfig ispcsrv2 Y Y Y Y N N N N N N N N N N N N N
*nameofhost dbispconfig ispcsrv6 Y Y Y Y N N N

And this in the user table:
*localhost ispconfig *password* N N N N N etc.
*% ispconfig *password* Y Y Y Y etc.

Please tell me what should I do?

Last edited by skoena; 19th September 2009 at 13:30.
Reply With Quote
  #28  
Old 19th September 2009, 13:29
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Quote:
Originally Posted by rudolfpietersma View Post
Sorry for my noob problems :-)

I find this in the DB table:
*localhost dbispconfig ispconfig Y Y Y Y N N N N N N N N N N N N N
*192.168.1.102 dbispconfig ispcsrv6 Y Y Y Y N N N N N N N N N N N N N
*192.169.1.102 dbispconfig ispcsrv2 Y Y Y Y N N N N N N N N N N N N N
*nameofhost dbispconfig ispcsrv6 Y Y Y Y N N N

And this in the user table:
*localhost ispconfig *password* N N N N N etc.
*% ispconfig *password* Y Y Y Y etc.

Please tell me what should I do?
So if i'm right I should delete:
**localhost dbispconfig ispconfig Y Y Y Y N N N N N N N N N N N N N from the DB table.
And
**localhost ispconfig *password* N N N N N etc.
**% ispconfig *password* Y Y Y Y etc. from the USER table right?
Reply With Quote
  #29  
Old 21st September 2009, 09:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 Posts
Default

Delete all entry for the user with the name "ispconfig" and also all "ispcsrv" users (you did not mentioned that this is the master database of a multiserver setup. After you cleaned this up, yopu will ahve to reinstall all slave servers too.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #30  
Old 21st September 2009, 13:35
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
 
Default

So I deleted all the entries mentioned.
I reinstalled ispconfig via de 2nd server and selected expert setup.

Everyting was installed succesfully. But when I want to logon to ispconfig now I get these mysql errors:

Quote:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73
What to do?

Also I notice that my sites are very slow. Also to get into ispconfig is very slow and into /phpmyadmin as well. When I restart apache it's speed is normal but decreases within minutes.

Last edited by skoena; 21st September 2009 at 14:21.
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


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


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