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
  #11  
Old 16th September 2011, 07:55
AlexGer83 AlexGer83 is offline
Junior Member
 
Join Date: Sep 2011
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hey Falko,
thanks for your reply but:


Code:
root@L-SRV-2:~# mysqld_safe --skip-grant-tables
110916 07:50:54 mysqld_safe Logging to syslog.
110916 07:50:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
can't enter anything

Thanks
Alex

EDIT:
I started the sqlserver on the slave:
Code:
/usr/bin/mysqld_safe --skip-grant-tables &
[1] 4611
...
Code:
root@L-SRV-2:~# mysql --user=root mysql
ERROR 1049 (42000): Unknown database 'mysql'

Last edited by AlexGer83; 16th September 2011 at 08:05.
Reply With Quote
Sponsored Links
  #12  
Old 16th September 2011, 08:33
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

Code:
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
?
Reply With Quote
  #13  
Old 16th September 2011, 08:38
AlexGer83 AlexGer83 is offline
Junior Member
 
Join Date: Sep 2011
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hey Mark_NL,
tried that already:

Code:
root@L-SRV-2:~# mysql_upgrade --force
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run                                                                                                                                                             /mysqld/mysqld.sock'
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run                                                                                                                                                             /mysqld/mysqld.sock'
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : File './mysql/general_log.CSM' not found (Errcode: 13)
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : File './mysql/slow_log.CSM' not found (Errcode: 13)
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
ERROR 1036 (HY000) at line 102: Table 'user' is read only
ERROR 1036 (HY000) at line 108: Table 'user' is read only
ERROR 1036 (HY000) at line 109: Table 'host' is read only
ERROR 1036 (HY000) at line 110: Table 'db' is read only
ERROR 1036 (HY000) at line 113: Table 'user' is read only
ERROR 1036 (HY000) at line 114: Table 'db' is read only
ERROR 1036 (HY000) at line 115: Table 'host' is read only
ERROR 1036 (HY000) at line 121: Table 'user' is read only
ERROR 1036 (HY000) at line 126: Table 'user' is read only
...
Alex
Reply With Quote
  #14  
Old 16th September 2011, 09:19
AlexGer83 AlexGer83 is offline
Junior Member
 
Join Date: Sep 2011
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
Can you set a new password in debian.cnf and then try this post?
http://www.howtoforge.com/reset-forg...-root-password

But in the update statement please use debian-sys-maint instead of root:

Code:
update user set Password=PASSWORD('new-password') where user='debian-sys-maint';
flush privileges;
exit;
OK I coppied the Databases from mysql_bak to mysql
changed the debian.cnf to an other password (test123)
changed also in the mysql to test123

finaly i can start the mysql with:
/etc/init.d/mysql start

what is the next step?
Shall i continue with the tutorial?
or should i change the passwort again to the original i have setup on the master?

Thanks so far!
Alex
Reply With Quote
  #15  
Old 16th September 2011, 09:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

I think you can now continue with the tutorial.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
AlexGer83 (16th September 2011)
  #16  
Old 16th September 2011, 15:12
AlexGer83 AlexGer83 is offline
Junior Member
 
Join Date: Sep 2011
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Thumbs up Solved

Hello again :-)

Everything is working now!
Thank's for all helping answers!

I've got still one question...
How are the files being synchronised?
Is the sync from server1 to server2 secure?
If not, how can i make it secure?

Thank's
Alex
Reply With Quote
  #17  
Old 17th September 2011, 11:13
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

AFAIK this is all handled by GlusterFS.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
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
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Monit & Munin SamTzu HOWTO-Related Questions 1 4th May 2008 18:03
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
"Too many open files in system" problems Berry Installation/Configuration 3 10th November 2007 21:58


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


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