[Maria-discuss] service on port 4567 is not starting
Hi All,
I would appreciate a little help.
I have done everything how it is in the installation steps, but the galera service on the port 4567 is not starting.
No errors in mysql or syslog :( Tried on debian and centos as well.
Right now server version: 5.5.28a-MariaDB-a1~squeeze-log mariadb.org binary distribution, wsrep_23.7rc1.rXXXX but I have tried with relevant mysql binaries as well. Do you have any idea why is it not starting the cluster service?
wsrep.conf on node1:
root@mariaclu01:/etc/mysql# cat /etc/mysql/conf.d/wsrep.cnf
[wsrep]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://"
wsrep_sst_auth=sst:sstpass123
wsrep.conf on node2:
root@mariaclu02:~# cat /etc/mysql/conf.d/wsrep.cnf
[wsrep]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.1.30:4567"
wsrep_sst_auth=sst:sstpass123
MariaDB [(none)]> show status like 'wsrep%';
+--------------------------+----------------------+
| Variable_name | Value |
+--------------------------+----------------------+
| wsrep_cluster_conf_id | 18446744073709551615 |
| wsrep_cluster_size | 0 |
| wsrep_cluster_state_uuid | |
| wsrep_cluster_status | Disconnected |
| wsrep_connected | OFF |
| wsrep_local_index | 18446744073709551615 |
| wsrep_provider_name | |
| wsrep_provider_vendor | |
| wsrep_provider_version | |
| wsrep_ready | ON |
+--------------------------+----------------------+
root@mariaclu01:/etc/mysql# netstat -tulpn | grep -e 4567 -e 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3387/mysqld
Thank you in advance!
Cheers,
Daniel
dudu@ihd.hu
Hi Daniel,
On 2/12/2013 3:30 AM, Kőszegi Dániel wrote:
Hi All,
I would appreciate a little help.
I have done everything how it is in the installation steps, but the galera service on the port 4567 is not starting.
No errors in mysql or syslog :( Tried on debian and centos as well.
Right now server version: 5.5.28a-MariaDB-a1~squeeze-log mariadb.org binary distribution, wsrep_23.7rc1.rXXXX but I have tried with relevant mysql binaries as well. Do you have any idea why is it not starting the cluster service?
wsrep.conf on node1:
root@mariaclu01:/etc/mysql# cat /etc/mysql/conf.d/wsrep.cnf
[wsrep]
These are server options. You need to name the config section [mysqld], or [mariadb], or [server] -- whichever you prefer -- but not [wsrep].
Please be prepared that there might be more configuration problems on the way, don't lose your resolve; but once you fix this one, your syslog should become very verbose and contain a lot of records starting with WSREP.
Regards, Elena
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://"
wsrep_sst_auth=sst:sstpass123
wsrep.conf on node2:
root@mariaclu02:~# cat /etc/mysql/conf.d/wsrep.cnf
[wsrep]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.1.30:4567"
wsrep_sst_auth=sst:sstpass123
MariaDB [(none)]> show status like 'wsrep%';
+--------------------------+----------------------+
| Variable_name | Value |
+--------------------------+----------------------+
| wsrep_cluster_conf_id | 18446744073709551615 |
| wsrep_cluster_size | 0 |
| wsrep_cluster_state_uuid | |
| wsrep_cluster_status | Disconnected |
| wsrep_connected | OFF |
| wsrep_local_index | 18446744073709551615 |
| wsrep_provider_name | |
| wsrep_provider_vendor | |
| wsrep_provider_version | |
| wsrep_ready | ON |
+--------------------------+----------------------+
root@mariaclu01:/etc/mysql# netstat -tulpn | grep -e 4567 -e 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3387/mysqld
Thank you in advance!
Cheers,
Daniel
dudu@ihd.hu
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi Elena,
Thank you very much, this solved my problem, replication is working! :)
Cheers, Dan
-----Original Message----- From: Elena Stepanova [mailto:elenst@montyprogram.com] Sent: Tuesday, February 12, 2013 2:03 AM To: Kőszegi Dániel Cc: maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] service on port 4567 is not starting
Hi Daniel,
On 2/12/2013 3:30 AM, Kőszegi Dániel wrote:
Hi All,
I would appreciate a little help.
I have done everything how it is in the installation steps, but the galera service on the port 4567 is not starting.
No errors in mysql or syslog :( Tried on debian and centos as well.
Right now server version: 5.5.28a-MariaDB-a1~squeeze-log mariadb.org binary distribution, wsrep_23.7rc1.rXXXX but I have tried with relevant mysql binaries as well. Do you have any idea why is it not starting the cluster service?
wsrep.conf on node1:
root@mariaclu01:/etc/mysql# cat /etc/mysql/conf.d/wsrep.cnf
[wsrep]
These are server options. You need to name the config section [mysqld], or [mariadb], or [server] -- whichever you prefer -- but not [wsrep].
Please be prepared that there might be more configuration problems on the way, don't lose your resolve; but once you fix this one, your syslog should become very verbose and contain a lot of records starting with WSREP.
Regards, Elena
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://"
wsrep_sst_auth=sst:sstpass123
wsrep.conf on node2:
root@mariaclu02:~# cat /etc/mysql/conf.d/wsrep.cnf
[wsrep]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.1.30:4567"
wsrep_sst_auth=sst:sstpass123
MariaDB [(none)]> show status like 'wsrep%';
+--------------------------+----------------------+
| Variable_name | Value |
+--------------------------+----------------------+
| wsrep_cluster_conf_id | 18446744073709551615 |
| wsrep_cluster_size | 0 |
| wsrep_cluster_state_uuid | |
| wsrep_cluster_status | Disconnected |
| wsrep_connected | OFF |
| wsrep_local_index | 18446744073709551615 |
| wsrep_provider_name | |
| wsrep_provider_vendor | |
| wsrep_provider_version | |
| wsrep_ready | ON |
+--------------------------+----------------------+
root@mariaclu01:/etc/mysql# netstat -tulpn | grep -e 4567 -e 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3387/mysqld
Thank you in advance!
Cheers,
Daniel
dudu@ihd.hu
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (2)
-
Elena Stepanova -
Kőszegi Dániel