dan-aksenov/ansible

My ansible playbooks

ansible's Issues

mamonsu not signed

error when installing
Package mamonsu-2.3.0-1.el7.centos.noarch.rpm is not signed

Decompose Postgresql installation into atomic roles.

List of separate roles:

• postgres_repo
  • move "centos 8 disable repo task" to this role instead of postgres_install.
  • ensure all molecule tests passed. make them first
• postgres_install
  • all molecule tests passed. no testinfra yet.
• postgres_patroni
  • ensure all molecule tests passed
    • default (1 etcd and 1 patroni on single node)
    • 2 node centos7
    • 2 node centos8
• postgres_initdb
  • ensure all molecule tests passed.
• postgres_config
• postgres_security
• postgres_start
  • molecule for centos7 system
  • molecule for centos7 pg_ctl
  • molecule for centos8 system
  • molecule for centos8 pg_ctl
• postgres_powa
  • molecule tests
    • testinfra tests
• postgres_pgbouncer
• postgres_mamonsu. Probably dont need it since zabbix 5(and zabbix-agent 2) migration already have postgresql built-in template.
• postgres_backrest

postgresql installation dependecy not resolved

(item=[u'postgresql95', u'postgresql95-server', u'postgresql95-contrib', u'postgresql95-libs', u'python-psycopg2']) => {"changed": true, "failed": true, "item": ["postgresql95", "postgresql95-server", "postgresql95-contrib", "postgresql95-libs", "python-psycopg2"], "msg": "Error: Package: postgresql95-contrib-9.5.6-1PGDG.rhel7.x86_64 (pgdg95)\n Requires: libxslt.so.1(LIBXML2_1.0.22)(64bit)\nError: Package: postgresql95-contrib-9.5.6-1PGDG.rhel7.x86_64 (pgdg95)\n Requires: libxslt.so.1()(64bit)\nError: Package: postgresql95-contrib-9.5.6-1PGDG.rhel7.x86_64 (pgdg95)\n Requires: libxslt.so.1(LIBXML2_1.0.18)(64bit)\nError: Package: postgresql95-contrib-9.5.6-1PGDG.rhel7.x86_64 (pgdg95)\n Requires: libxslt.so.1(LIBXML2_1.0.11)(64bit)\n", "rc": 1, "results": ["Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\nResolving Dependencies\n--> Running transaction check\n---> Package postgresql95.x86_64 0:9.5.6-1PGDG.rhel7 will be installed\n---> Package postgresql95-contrib.x86_64 0:9.5.6-1PGDG.rhel7 will be installed\n--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.22)(64bit) for package: postgresql95-contrib-9.5.6-1PGDG.rhel7.x86_64\n--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18)(64bit) for package: postgresql95-contrib-9.5.6-1PGDG.rhel7.x86_64\n--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11)(64bit) for package: postgresql95-contrib-9.5.6-1PGDG.rhel7.x86_64\n--> Processing Dependency: libxslt.so.1()(64bit) for package: postgresql95-contrib-9.5.6-1PGDG.rhel7.x86_64\n---> Package postgresql95-libs.x86_64 0:9.5.6-1PGDG.rhel7 will be installed\n---> Package postgresql95-server.x86_64 0:9.5.6-1PGDG.rhel7 will be installed\n---> Package python-psycopg2.x86_64 0:2.6.2-3.rhel7 will be installed\n--> Finished Dependency Resolution\n You could try using --skip-broken to work around the problem\n You could try running: rpm -Va --nofiles --nodigest\n"]}

Ensure molecule test coverage. Including Centos 8.

postgres-pro installation

I really dont like postgres-pro namings and stuff ((

• in 96 it was postgrespro-96
• in 10 is is postgrespro-std-10
• wired additional components installation (ie postgis goes to /var/lib/pgsql, while pgpro goes to /var/lib/pgpro). Makes updates more complex.

Add UseDNS no to sshd?

Check best practices before...

redo mamonsu installation with pip

seems to be much simplier!

yum-cron OEL install

hint: enable optional repo to install yum-cron.

Remove my_ansible_user from roles.

see https://habr.com/ru/post/509938/ for details

wrong url fro zabbix repository

that is

move proxy settings to play level

And completely discard proxy roles.
Also check plays with not proxy specified.

pg_badger postgres reload on non yum installed postgres

Find way to dynamically find and reload postgresql, even if it was not installed by yum, works with corosync pacemaker(not via systemctl).
One way to do it - locate propper pg_ctl and issue reload command in handler instead of servise reload.

template for zabbix agent

add template and configuration variables to zabbix agent role.