dj-wasabi / ansible-zabbix-proxy Goto Github PK

Describe the bug

- downloading role 'zabbix-proxy', owned by dj-wasabi
- downloading role from https://github.com/dj-wasabi/ansible-zabbix-proxy/archive/1.4.0.tar.gz
- extracting dj-wasabi.zabbix-proxy to /usr/share/ansible/roles/dj-wasabi.zabbix-proxy
- dj-wasabi.zabbix-proxy (1.4.0) was installed successfully

TASK [dj-wasabi.zabbix-proxy : Get the file for schema.sql] **********************************************************************************
[DEPRECATION WARNING]: evaluating zabbix_database_sqlload as a bare variable, this behaviour will go away and you might need to add |bool to 
the expression in the future. Also see CONDITIONAL_BARE_VARS configuration toggle.. This feature will be removed in version 2.12. Deprecation
 warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.
fatal: [server001.dc03.xrow.net]: FAILED! => {"changed": false, "cmd": "ls -1 /usr/share/doc/zabbix-proxy-mysql-4.2*/schema.sq*", "delta": "0:00:00.012031", "end": "2019-06-27 23:57:04.219409", "msg": "non-zero return code", "rc": 2, "start": "2019-06-27 23:57:04.207378", "stderr": "ls: cannot access /usr/share/doc/zabbix-proxy-mysql-4.2*/schema.sq*: No such file or directory", "stderr_lines": ["ls: cannot access /usr/share/doc/zabbix-proxy-mysql-4.2*/schema.sq*: No such file or directory"], "stdout": "", "stdout_lines": []}

Installation method/version

- hosts: router
  roles:
     - role: dj-wasabi.zabbix-proxy

• Ansible Galaxy / latest

Ansible Version

ansible-playbook 2.8.1
  config file = /scm/hostway.infrastructure/ansible.cfg
  configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python2.7/site-packages/ansible
  executable location = /bin/ansible-playbook
  python version = 2.7.5 (default, Apr  9 2019, 14:30:50) [GCC 4.8.5 20150623 (Red Hat 4.8.5-36)]```

Targetted hosts
Concerns the following OS(es):

• CentOS

Expected behavior
playbook runs through

Additional context

zabbix_server_host: 90.xx
zabbix_proxy_install_database_client: true
zabbix_agent_server: 90.xx
zabbix_agent_serveractive: 90.xx
zabbix_url: https://xxx.xxx.xxx
zabbix_create_host: present
zabbix_api_use: true
zabbix_api_user: Admin
zabbix_api_pass: xxxx
zabbix_host_groups:
  - dc03
zabbix_link_templates:
  - Template OS Linux

TASK [dj-wasabi.zabbix-proxy : MySQL | Create database] ************************
11:03:18
task path: /var/lib/awx/projects/zabbixproxy/roles/dj-wasabi.zabbix-proxy/tasks/mysql.yml:7
11:03:18
fatal: [localhost -> localhost]: FAILED! => {"changed": false, "module_stderr": "sudo: effective uid is not 0, is /usr/bin/sudo on a file system with the 'nosuid' option set or an NFS file system without root privileges?\n", "module_stdout": "", "msg": "MODULE FAILURE", "rc": 1}

Hello dj-wasabi,

When i want to use mysql database, i have an error :

TASK [dj-wasabi.zabbix-proxy : MySQL | Create database] **************************************************************************
fatal: [proxy04-prd.test.net -> proxy04-prd.test.net]: FAILED! => {"changed": false, "failed": true, "msg": "unable to find /root/.my.cnf. Exception message: (2002, \"Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)\")"}
        to retry, use: --limit @.....

Am I the only one ?

Regards,
zab35

Hi dj-wasabi

First of all, thanks for your great work!
Is it planned to support zabbix proxy with sqlite3 backend? We are only using sqlite backend on our proxies because of less dependencies.

Thanks in advance & best regards
Remo

Hello,

Cans you add 4.2 version ?

Thanks

Currently the latest version available in galaxy is version 0.4, but quite a lot of commits have been made since that version.

Can we get a newer release in galaxy?

Hello

Configuration template https://github.com/dj-wasabi/ansible-zabbix-proxy/blob/master/templates/zabbix_proxy.conf.j2#L246 has misspelling

Current: ListenIp
Correct: ListenIP

Example of error:

fatal: [somehost]: FAILED! => {"changed": false, "failed": true, "msg": "zabbix_proxy [27861]: unknown parameter "ListenIp" in config file "/etc/zabbix/zabbix_proxy.conf", line 208\n"}

Hello dj-wasabi,

Is there a problem in the version comparison ?

{% if zabbix_version | version_compare('2.4', '<') %}
### Option: StartVMwareCollectors
StartVMwareCollectors={{ zabbix_proxy_startvmwarecollector }}

I think the comparator must be >

{% if zabbix_version | version_compare('2.4', '>') %}

Best regards,
zab35

Describe the bug
MySQL schema import fails when database server is installed on dedicated host other then proxy itself. The reason seems to be lack of schema file on database host linked with delegation of schema import task to database host.

Installation method/version
1.6.0 installed by ansible-galaxy over git+ssh

Ansible Version

ansible 2.8.5

Targetted hosts
Concerns the following OS(es):

• Ubuntu

Expected behavior

Schema creation should be executed on zabbix-proxy host by mysql_db module against remote MySQL server over MySQL protocol.

OR

There should be additional step of shipping schema file when schema creation is delegated to MySQL host.

Hi,

first of all - thanks for all the great work on these roles! 😄

Trying to install Zabbix proxy 3 using version 0.3.0 of your role, and I get this, when the service is trying to restart:

unknown parameter "HistoryTextCacheSize" in config file "/etc/zabbix/zabbix_proxy.conf", line 236

According to this spec:

HistoryTextCacheSize configuration parameter must be removed.

Hello,
I do use both your proxy and agent roles on same host (centos 6, if that matters), and I get "changed" status of that host on the every ansible-playbook run due to yum repo file being changed by proxy and also proxy roles. could this be remedied? I think that root cause is difference between .repo templates...
Thank you...
JN

The zabbix proxy role unfortunately doesn't include the TLS features introduced in 3.x