---
- hosts: starfish
become: yes
vars:
# Use these on the first run of this playbook
# current_mysql_root_password: ""
# updated_mysql_root_password: "KingKong"
# current_mysql_asterisk_password: ""
# updated_mysql_asterisk_password: "KingKong"
# Comment the above out after the first run
# Uncomment these for subsequent runs
current_mysql_root_password: "KingKong"
updated_mysql_root_password: "KingKong"
current_mysql_asterisk_password: "KingKong"
updated_mysql_asterisk_password: "KingKong"
tasks:
- name: Install epel-release
dnf:
name: epel-release
state: present
- name: Install dependencies
dnf:
name: ['vim', 'wget', 'MySQL-python']
state: present
- name: Install the MySQL repo.
dnf:
name: http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
state: present
- name: Install mysql-server
dnf:
name: mysql-server
state: present
- name: Override variables for MySQL (RedHat).
set_fact:
mysql_daemon: mysqld
mysql_packages: ['mysql-server']
mysql_log_error: /var/log/mysqld.err
mysql_syslog_tag: mysqld
mysql_pid_file: /var/run/mysqld/mysqld.pid
mysql_socket: /var/lib/mysql/mysql.sock
when: ansible_os_family == "RedHat"
- name: Ensure MySQL server is running
service:
name: mysqld
state: started
enabled: yes
- name: update mysql root pass for localhost root account from local servers
mysql_user:
login_user: root
login_password: "KingKong"
name: root
host: "{{ item }}"
password: "KingKong"
with_items:
- localhost
- name: update mysql root password for all other local root accounts
mysql_user:
login_user: root
login_password: "KingKong"
name: root
host: "{{ item }}"
password: "KingKong"
with_items:
- "{{ inventory_hostname }}"
- 127.0.0.1
- ::1
- localhost.localdomain
- name: create asterisk database
mysql_db:
login_user: root
login_password: "KingKong"
name: asterisk
state: present
- name: asterisk mysql user
mysql_user:
login_user: root
login_password: "KingKong"
name: asterisk
host: "{{ item }}"
password: "KingKong"
priv: "asterisk.*:ALL"
with_items:
- "{{ inventory_hostname }}"
- 127.0.0.1
- ::1
- localhost
- localhost.localdomain
- name: remove anonymous user
mysql_user:
login_user: root
login_password: "KingKong"
name: ""
state: absent
host: "{{ item }}"
with_items:
- localhost
- "{{ inventory_hostname }}"
- 127.0.0.1
- ::1
- localhost.localdomain
- name: remove test database
mysql_db:
login_user: root
login_password: "KingKong"
name: test
state: absent
- user:
name: asterisk
state: present
createhome: yes
- group:
name: asterisk
state: present
- user:
name: astmin
groups: asterisk,wheel
state: present
- name: Install other dependencies
dnf:
name:
- unixODBC
- unixODBC-devel
- mysql-connector-odbc
- MySQL-python
- tcpdump
- ntp
- ntpdate
- jansson
- bind-utils
state: present
# Tweak the firewall for UDP/SIP
- firewalld:
port: 5060/udp
permanent: true
state: enabled
# Tweak firewall for UDP/RTP
- firewalld:
port: 10000-20000/udp
permanent: true
state: enabled
- name: Ensure NTP is running
service:
name: ntpd
state: started
enabled: yes
# The libmyodbc8a.so file is versioned, so if you don't have version 8, see
what the
# /usr/lib64/libmyodbc<version>a.so file is, and refer to that instead
# on your 'Driver64' line, and then run the playbook again
- name: update odbcinst.ini
lineinfile:
dest: /etc/odbcinst.ini
regexp: "{{ item.regexp }}"
line: "{{ item.line }}"
state: present
with_items:
- regexp: "^Driver64"
line: "Driver64 = /usr/lib64/libmyodbc8a.so"
- regexp: "^Setup64"
line: "Setup64 = /usr/lib64/libodbcmyS.so"
- name: create odbc.ini
blockinfile:
path: /etc/odbc.ini
create: yes
block: |
[asterisk]
Driver = MySQL
Description = MySQL connection to 'asterisk' database
Server = localhost
Port = 3306
Database = asterisk
UserName = asterisk
Password = KingKong
#Socket = /var/run/mysqld/mysqld.sock
Socket = /var/lib/mysql/mysql.sock
...
On Sunday, 18 October 2020 at 00:09:26 UTC+5:30 [email protected] wrote:
>
> With the amount of context you've given it's not possible to tell.
> Share the playbook, at least.
>
>
> On Sat, 17 Oct 2020 at 19:21, Prabhakaran Karuppaih <[email protected]>
> wrote:
>
>> [root@localhost playbooks]# ansible-playbook starfish.yml
>> [DEPRECATION WARNING]: The firewalld module has been moved to the
>> ansible.posix
>> collection. This feature will be removed from community.general in version
>> 2.0.0. Deprecation warnings can be disabled by setting
>> deprecation_warnings=False in ansible.cfg.
>>
>> PLAY [starfish]
>> ****************************************************************
>>
>> TASK [Gathering Facts]
>> *********************************************************
>> ok: [localhost]
>>
>> TASK [Install epel-release]
>> ****************************************************
>> ok: [localhost]
>>
>> TASK [Install dependencies]
>> ****************************************************
>> fatal: [localhost]: FAILED! => {"changed": false, "failures": ["No
>> package MySQL-python available."], "msg": "Failed to install some of the
>> specified packages", "rc": 1, "results": []}
>>
>> PLAY RECAP
>> *********************************************************************
>> localhost : ok=2 changed=0 unreachable=0 failed=1 skipped=0 rescued=0
>> ignored=0
>>
>> [root@localhost playbooks]#
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Ansible Project" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/ansible-project/a0cffd7a-1eda-4641-985a-b7aac5e6be5fn%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/ansible-project/a0cffd7a-1eda-4641-985a-b7aac5e6be5fn%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
> --
> Sent from a mobile device - please excuse the brevity, spelling and
> punctuation.
>
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/cf33aa94-768f-44a0-a28c-3bde3d0ebb7fn%40googlegroups.com.
