[Labs-l] Cannot connect to DB

Thu Jan 22 03:36:32 UTC 2015

Team:

All of a sudden, wikimetrics (a popular tool deployed to labs:
https://metrics.wmflabs.org/)
cannot connect to the labs database, this happens when there are firewall
or IP tables issues as it looks like ip tables rules are not on puppet.
However we have tried to apply the older rules we had to no avail. If
anyone could she some light as to what is going on here it will be great.

Please see set of rules applied below.

Thanks,

Nuria

---------------------------------
#The following list has been created by running
#
#  iptables -t nat -L -v -n | grep DNAT | sed -e
's/^.*\(192.168.99.[0-9]*\)[[:space:]] .*to:\(.*\)$/add_mysql_dnat_rule
"\1" "\2"/'
#
# as root on a machine that has the needed DNATs
#
add_mysql_dnat_rule "192.168.99.13" "10.64.37.4:3309"
add_mysql_dnat_rule "192.168.99.12" "10.64.37.4:3309"
add_mysql_dnat_rule "192.168.99.11" "10.64.37.4:3309"
add_mysql_dnat_rule "192.168.99.7" "10.64.37.5:3308"
add_mysql_dnat_rule "192.168.99.6" "10.64.37.5:3307"
add_mysql_dnat_rule "192.168.99.5" "10.64.37.4:3308"
add_mysql_dnat_rule "192.168.99.4" "10.64.37.4:3307"
add_mysql_dnat_rule "192.168.99.3" "10.64.37.5:3306"
add_mysql_dnat_rule "192.168.99.2" "10.64.37.4:3306"
add_mysql_dnat_rule "192.168.99.1" "10.64.20.12:3306"
add_mysql_dnat_rule "192.168.99.1" "10.64.20.12:3306"
add_mysql_dnat_rule "192.168.99.2" "10.64.37.4:3306"
add_mysql_dnat_rule "192.168.99.3" "10.64.37.5:3306"
add_mysql_dnat_rule "192.168.99.4" "10.64.37.4:3307"
add_mysql_dnat_rule "192.168.99.5" "10.64.37.4:3308"
add_mysql_dnat_rule "192.168.99.6" "10.64.37.5:3307"
add_mysql_dnat_rule "192.168.99.7" "10.64.37.5:3308
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20150121/0a73a3dd/attachment.html>