GluterFS not start mysql

[AlexGer83]

Hey Falko,
thanks for your reply but:

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:

/usr/bin/mysqld_safe --skip-grant-tables &
[1] 4611

...

root@L-SRV-2:~# mysql --user=root mysql
ERROR 1049 (42000): Unknown database 'mysql'

[Mark_NL]

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.

?

[AlexGer83]

Hey Mark_NL,
tried that already:

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

[AlexGer83]

Originally Posted by falko

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:

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

[falko]

I think you can now continue with the tutorial.

[AlexGer83]

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

[falko]

AFAIK this is all handled by GlusterFS.