Date: Mon, 26 May 2014 01:00:00 GMT From: John Ko <john@johnko.ca> To: freebsd-ports-bugs@FreeBSD.org Subject: Re: ports/189257: [NEW PORT] databases/percona56-xtradb-cluster Message-ID: <201405260100.s4Q100NC082494@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
The following reply was made to PR ports/189257; it has been noted by GNATS. From: John Ko <john@johnko.ca> To: Daniel Ylitalo <daniel@blodan.se> Cc: "bug-followup@FreeBSD.org" <bug-followup@freebsd.org> Subject: Re: ports/189257: [NEW PORT] databases/percona56-xtradb-cluster Date: Sun, 25 May 2014 20:53:59 -0400 --047d7b5d3eecc6e1b704fa4303e2 Content-Type: text/plain; charset=UTF-8 Oops just found out my umask was 077... which means my /server/mysql/data didn't let galera write to it it appears to work now: # pgrep -lf mysql 64880 /usr/local/libexec/mysqld --defaults-extra-file=/server/mysql/my.cnf --basedir=/usr/local --datadir=/server/mysql/data --plugin-dir=/usr/local/lib/mysql/plugin --user=mysql --log-error=/server/mysql/data/NXQCSO-NXQCSO.err --pid-file=/server/mysql/data/NXQCSO-NXQCSO.pid --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1 64249 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/server/mysql/my.cnf --user=mysql --datadir=/server/mysql/data --pid-file=/server/mysql/data/NXQCSO-NXQCSO.pid -- John _ On Sun, May 25, 2014 at 8:50 PM, John Ko <john@johnko.ca> wrote: > Looks like I can't even boot up the first node: > > More in my gist here: > https://gist.github.com/johnko/f22c87931e31246598eb > > # grep mysql /etc/rc.conf > mysql_limits="YES" > mysql_dbdir="/server/mysql/data" > mysql_optfile="/server/mysql/my.cnf" > mysql_enable="YES" > mysql_args="" > > ##### > > # cat /server/mysql/my.cnf > [mysqld] > datadir = /server/mysql/data > tmpdir = /server/mysql/tmp > log-error = /var/log/mysql-error.log > slow-query-log-file = /var/log/mysql-slow.log > port = 3306 > innodb_autoinc_lock_mode = 2 > wsrep_sst_method = xtrabackup-v2 > wsrep_provider = /usr/local/lib/libgalera_smm.so > wsrep_provider_options = "gmcast.listen_addr=tcp://127.0.0.1:4567" > wsrep_cluster_name = mycluster > wsrep_node_name = NXQCSO-NXQCSO > wsrep_node_address = 127.0.0.1 > wsrep_slave_threads = 8 > wsrep_sst_auth = "sst:25awfaSADF4toih4t" > server-id = 1 > wsrep_cluster_address=gcomm:// > > > --047d7b5d3eecc6e1b704fa4303e2 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Oops just found out my umask was 077... which means my /se= rver/mysql/data didn't let galera write to it<div><br></div><div>it app= ears to work now:</div><div><br></div><div> <p class=3D""><span class=3D"">#</span> pgrep -lf mysql</p> <p class=3D"">64880 /usr/local/libexec/mysqld --defaults-extra-file=3D/serv= er/mysql/my.cnf --basedir=3D/usr/local --datadir=3D/server/mysql/data --plu= gin-dir=3D/usr/local/lib/mysql/plugin --user=3Dmysql --log-error=3D/server/= mysql/data/NXQCSO-NXQCSO.err --pid-file=3D/server/mysql/data/NXQCSO-NXQCSO.= pid --wsrep_start_position=3D00000000-0000-0000-0000-000000000000:-1</p> <p class=3D"">64249 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-fil= e=3D/server/mysql/my.cnf --user=3Dmysql --datadir=3D/server/mysql/data --pi= d-file=3D/server/mysql/data/NXQCSO-NXQCSO.pid</p></div><div class=3D"gmail_= extra"> <br clear=3D"all"><div><div dir=3D"ltr">--<br>John<br>_<br></div></div> <br><br><div class=3D"gmail_quote">On Sun, May 25, 2014 at 8:50 PM, John Ko= <span dir=3D"ltr"><<a href=3D"mailto:john@johnko.ca" target=3D"_blank">= john@johnko.ca</a>></span> wrote:<br><blockquote class=3D"gmail_quote" s= tyle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div dir=3D"ltr"><div class=3D"gmail_extra">Looks like I can't even boo= t up the first node:</div><div class=3D"gmail_extra"><br></div><div class= =3D"gmail_extra">More in my gist here:</div><div class=3D"gmail_extra"><a h= ref=3D"https://gist.github.com/johnko/f22c87931e31246598eb" target=3D"_blan= k">https://gist.github.com/johnko/f22c87931e31246598eb</a><br>; </div><div class=3D"gmail_extra"><br></div><div class=3D"gmail_extra"> <p># grep mysql /etc/rc.conf<br><span>mysql</span>_limits=3D"YES"= <br><span>mysql</span>_dbdir=3D"/server/<span>mysql</span>/data"<= br><span>mysql</span>_optfile=3D"/server/<span>mysql</span>/my.cnf&quo= t;<br> <span>mysql</span>_enable=3D"YES"<br><span>mysql</span>_args=3D&q= uot;"</p><p>#####</p><p> </p><p><span>#</span>=C2=A0cat /server/mysql/my.cnf<br>[mysqld]<br>datadir= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /server/mysql/data<br>= tmpdir =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /server/mysql/t= mp<br>log-error=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /var/log/mysql= -error.log<br> slow-query-log-file=C2=A0 =3D /var/log/mysql-slow.log<br>port =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D 3306<br>innodb_autoinc_lock_= mode =3D 2<br>wsrep_sst_method =C2=A0 =C2=A0 =C2=A0 =3D xtrabackup-v2<br>ws= rep_provider =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /usr/local/lib/libgalera_smm.s= o<br>wsrep_provider_options =3D "gmcast.listen_addr=3Dtcp://<a href=3D= "http://127.0.0.1:4567" target=3D"_blank">127.0.0.1:4567</a>"<br> wsrep_cluster_name =C2=A0 =C2=A0 =3D mycluster<br>wsrep_node_name=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =3D NXQCSO-NXQCSO<br>wsrep_node_address =C2=A0 =C2=A0 =3D= 127.0.0.1<br>wsrep_slave_threads=C2=A0 =C2=A0 =3D 8<br>wsrep_sst_auth =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =3D "sst:25awfaSADF4toih4t"<br>server-id= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D 1<br> wsrep_cluster_address=3Dgcomm://</p><p><br></p></div></div> </blockquote></div><br></div></div> --047d7b5d3eecc6e1b704fa4303e2--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201405260100.s4Q100NC082494>