Saturday, November 14, 2009

Solution to CPAN hangs on Fetching with LWP:

When I tried to fetch stuff with CPAN it started hanging right away
Fetching with LWP:
  ftp://ftp.planetmirror.com/pub/perl/CPAN/modules/02packages.details.txt.gz
This is likely happening because you are behind a NAT or firewall, and you need to do ftp in passive mode.
Find your perls libnet.cfg file:
% locate libnet.cfg
/etc/perl/Net/libnet.cfg
Edit that file and change the ftp_int_passive setting to 1.

Sunday, November 8, 2009

How to repair mysql master-master replication errors

Say you have a server in the replication setup down for a couple of days, and when you turn it back on and check if sync is working proper:


mysql -uroot -p
show slave status\G


In case it's all good:

Slave_IO_Running: Yes
Slave_SQL_Running: Yes


Possible error 1:

Slave_IO_Running: Yes
Slave_SQL_Running: No



Can be fixed by this url