Codebeef's questions

I have the following task (and a debug task):

- name: get list of error logs
  set_fact:
    centralised_logs: "{{ centralised_logs | default([]) | union([{'name': '{{ item }} error log'}])}}"
  with_items:
    - "one"
    - "two"
    - "three"

- debug: msg="{{ centralised_logs }}"

I'd expect the centralised_logs fact to accumulate an array of dictionaries that contain the interpolated strings in the union statement, but instead, I get the following (note that it works for the second and third items, but not the first):

TASK [nginx : get list of error logs] ******************************************
ok: [127.0.0.1] => (item=one)
ok: [127.0.0.1] => (item=two)
ok: [127.0.0.1] => (item=three)

TASK [nginx : debug] ***********************************************************
fatal: [127.0.0.1]: FAILED! => {"failed": true, "msg": "[{'name': u'two error log'}, {'name': u'three error log'}, {'name': u'{{ item }} error log'}]: 'item' is undefined"}

Why is the first value failing to be interpolated correctly?

Ansible version 2.1.0.0.

I'm attempting to replicate from an external MySQL master to an RDS instance. I don't really want to be sending data in the clear over the Internet, so I have an EC2 instance that I have set up an ssh tunnel on. The tunnel opens port 3307 on the EC2 instance, and connects to the external instance that is running the target master MySQL DB. From that EC2 instance I can run

mysql -u <user> -p -h 127.0.0.1 -P3307

and connect to the target remote DB. All is well there. Furthermore, I can connect to the RDS DB from this instance without problems.

The problem I'm having is that when I set up the replication parameters on my RDS instance, I cannot connect to the remote instance. I'm doing something along the lines of (from the EC2 instance that has access to both DB's):

mysql.rds_set_external_master('<host>', 3307, 'repl_user', '<repl_pass>', 'mysql-bin.000001', 107, 0);

... where has been 'localhost', '127.0.0.1', the private DNS name of the EC2 instance, the private IP, the public IP and the public DNS. On each try, running SHOW SLAVE STATUS\G displays an error along the lines of:

Last_IO_Error: error connecting to master 'repl_user@<host>:3307'

My question is: When running the rds_set_external_master call, is the host relative to the client that's sending the call or relative to the RDS instance? If the latter, how can I tunnel to my remote instance?

Is there a command I can use to easily find the path to an executable? I'm looking for identify on my local machine - something like pwd?

pwd identify
=> /usr/local/bin/identify

Is there any command I can run from bash that will tell me whether a port is already open?

I'm after a list of the largest files on a windows box, i.e. Not just in one folder, but anywhere on the disk. Is there any easy way of getting this?