Ad Widget

Collapse

Password for user zbx_monitor: psql: fe_sendauth: no password supplied

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • hernan
    replied
    Hello guys, I solve this problem using the following example: PGPASSWORD=YOUR_PASSRORD psql -h YOUR_PG_HOST -U YOUR_USER_NAME

    You can ran the psql command for example: PGPASSWORD=<YOUR_PASSRORD> psql -qtAX -h "127.0.0.1" -p "5432" -U "zbx_monitor" -d "postgres" -c "SELECT count(*) FROM pg_stat_replication"

    After that I change all my scripts using the above example.

    Thanks for your help.

    Regards.

      Leave a comment:

    • hernan
      replied
      Originally posted by Atsushi
      Since the version is 4.4.1 Zabbix agent on CentOS 7, isn't the environment variable HOME not set? If you are using an official package, try upgrading Zabbix agent to version 4.4.3.

      If the upgrade is difficult, try changing the Zabbix agent service startup file so that the daemon starts by explicitly specifying the user and group.

      file: /usr/lib/systemd/system/zabbix-agent.service
      Code:
      [Unit]
Description=Zabbix Agent
After=syslog.target
After=network.target

[Service]
Environment="CONFFILE=/etc/zabbix/zabbix_agentd.conf"
EnvironmentFile=-/etc/sysconfig/zabbix-agent
Type=forking
Restart=on-failure
PIDFile=/run/zabbix/zabbix_agentd.pid
KillMode=control-group
ExecStart=/usr/sbin/zabbix_agentd -c $CONFFILE
ExecStop=/bin/kill -SIGTERM $MAINPID
RestartSec=10s
User=zabbix
Group=zabbix

[Install]
WantedBy=multi-user.target
      After commnds:
      Code:
      # systemctl daemon-reload
# systemctl restart zabbix-agent
      Thank you Atsushi for your update !!!

      The problem persist. I upgraded the Zabbix Agent to 4.4.3 and I could't find the problem:

      1) Here you have the error message with debug level 4 on the zabbix_agentd.log:

      *************
      14406:20191206:090914.001 zbx_setproctitle() title:'listener #1 [processing request]'
      14406:20191206:090914.002 Requested [pgsql.replication.count["127.0.0.1","5432","zbx_monitor","postgres"]]
      14406:20191206:090914.002 In zbx_popen() command:' psql -qtAX -h "127.0.0.1" -p "5432" -U "zbx_monitor" -d "postgres" -c "SELECT count(*) FROM pg_stat_replication"'
      14406:20191206:090914.047 End of zbx_popen():7
      14496:20191206:090914.047 zbx_popen(): executing script
      14406:20191206:090914.061 In zbx_waitpid()
      14406:20191206:090914.061 zbx_waitpid() exited, status:2
      14406:20191206:090914.061 End of zbx_waitpid():14496
      14406:20191206:090914.061 EXECUTE_STR() command:' psql -qtAX -h "127.0.0.1" -p "5432" -U "zbx_monitor" -d "postgres" -c "SELECT count(*) FROM pg_stat_replication"' len:71 cmd_result:'Password for user zb'
      14406:20191206:090914.061 Sending back [Password for user zbx_monitor:
      psql: fe_sendauth: no password supplied]
      14406:20191206:090914.061 zbx_setproctitle() title:'listener #1 [waiting for connection]'
      14405:20191206:090914.167 zbx_setproctitle() title:'collector [processing data]'
      **************

      2) After that If I switch on the machine with the user zabbix I can run the same command without problem:
      ****************
      Last login: Fri Dec 6 09:06:26 -05 2019 on pts/4
      -bash-4.2$ whoami
      zabbix
      -bash-4.2$ pwd
      /var/lib/zabbix
      -bash-4.2$ echo $HOME
      /var/lib/zabbix
      -bash-4.2$ psql -qtAX -h "127.0.0.1" -p "5432" -U "zbx_monitor" -d "postgres" -c "SELECT count(*) FROM pg_stat_replication"
      4
      -bash-4.2$
      *****************

      3) The /var/lib/zabbix directory contain the .pgpass there:
      *****************
      -bash-4.2$ pwd
      /var/lib/zabbix
      -bash-4.2$ ls -la
      total 28
      drwxr-xr-x. 3 zabbix zabbix 116 Dec 6 08:59 .
      drwxr-xr-x. 33 root root 4096 Dec 6 08:42 ..
      -rw-------. 1 zabbix zabbix 3673 Dec 6 08:59 .bash_history
      -rw-------. 1 zabbix zabbix 39 Dec 6 08:59 .pgpass
      -rw-------. 1 zabbix zabbix 39 Dec 5 15:07 .pgpass.old
      drwxrwxrwx. 2 zabbix zabbix 4096 Dec 5 10:50 postgresql
      -rw-------. 1 zabbix zabbix 133 Nov 28 09:10 .psql_history
      -rw-------. 1 zabbix zabbix 652 Dec 6 08:59 .viminfo
      -bash-4.2$
      *******************

      4) AS youi can see on theb zabbix-agent.service now I have the User and Group variable:
      *******************
      [zavatec@zabbix]$ more /usr/lib/systemd/system/zabbix-agent.service
      [Unit]
      Description=Zabbix Agent
      After=syslog.target
      After=network.target

      [Service]
      Environment="CONFFILE=/etc/zabbix/zabbix_agentd.conf"
      EnvironmentFile=-/etc/sysconfig/zabbix-agent
      Type=forking
      Restart=on-failure
      PIDFile=/run/zabbix/zabbix_agentd.pid
      KillMode=control-group
      ExecStart=/usr/sbin/zabbix_agentd -c $CONFFILE
      ExecStop=/bin/kill -SIGTERM $MAINPID
      RestartSec=10s
      User=zabbix
      Group=zabbix

      [Install]
      WantedBy=multi-user.target
      [zavatec@zabbix]$

      ********************

      Do you know why is the problem here?

      Thanks for your help.

      Regards.


        Leave a comment:

      • Atsushi
        replied
        Since the version is 4.4.1 Zabbix agent on CentOS 7, isn't the environment variable HOME not set? If you are using an official package, try upgrading Zabbix agent to version 4.4.3.

        If the upgrade is difficult, try changing the Zabbix agent service startup file so that the daemon starts by explicitly specifying the user and group.

        file: /usr/lib/systemd/system/zabbix-agent.service
        Code:
        [Unit]
Description=Zabbix Agent
After=syslog.target
After=network.target

[Service]
Environment="CONFFILE=/etc/zabbix/zabbix_agentd.conf"
EnvironmentFile=-/etc/sysconfig/zabbix-agent
Type=forking
Restart=on-failure
PIDFile=/run/zabbix/zabbix_agentd.pid
KillMode=control-group
ExecStart=/usr/sbin/zabbix_agentd -c $CONFFILE
ExecStop=/bin/kill -SIGTERM $MAINPID
RestartSec=10s
User=zabbix
Group=zabbix

[Install]
WantedBy=multi-user.target
        After commnds:
        Code:
        # systemctl daemon-reload
# systemctl restart zabbix-agent

          Leave a comment:

        • hernan
          replied
          Originally posted by hernan
          Hello Guys, I have the following problem:

          Environment: Zabbix Server: CentOS Linux 7 / Zabbix 4.4.3 / MySQL
          Zabbix Agent: CentOS Linux 7 / Zabbix 4. 4.1 / PostgreSQL

          I installed the PostgreSQL template provided for the zabbix.com page:

          Postgresql monitoring and integration with Zabbix
          https://www.zabbix.com/integrations/postgresql


          After that I received the following error message:
          2019-12-04 09:35:22 Password for user zbx_monitor: psql: fe_sendauth: no password supplied

          I checked the zabbix.log and I received the following error message:

          30268:20191204:080038.911 Failed to execute command " psql -qtAX -h "127.0.0.1" -p "5432" -U "zbx_monitor" -d "postgres" -f "/var/lib/zabbix/postgresql/pgsql.replication.lag.sql"": Timeout while executing a shell script.

          After that I tested the command and I received the following output:

          ******************************
          [zavatec@linuxzabbix]$ psql -qtAX -h "127.0.0.1" -p "5432" -U "zbx_monitor" -d "postgres" -f "/var/lib/zabbix/postgresql/pgsql.replication.lag.sql"
          Password for user zbx_monitor:
          1271135
          [zavatec@VM-EMSSANAR-DBMASTER-IFX zabbix]$
          *******************************
          Nota: I think that the command couldn't find the .pgpass on the server. ( The file was created on the /var/lib/zabbix directory)

          Can you help me with this issue?

          Thanks in advance.

          Regards.
          I debugged the zabbix_agent.log and I found that the process didn't find the .pgpass file on the /var/lib/zabbix. I have it there with the following attributes:

          ********************
          [zavatec@zabbix]$ pwd
          /var/lib/zabbix
          [zavatec@zabbix]$ ls -la
          total 24
          drwxr-xr-x. 3 zabbix zabbix 97 Dec 5 15:07 .
          drwxr-xr-x. 33 root root 4096 Dec 3 08:56 ..
          -rw-------. 1 zabbix zabbix 3243 Dec 5 15:26 .bash_history
          -rw-------. 1 zabbix zabbix 39 Dec 5 15:07 .pgpass
          drwxrwxrwx. 2 zabbix zabbix 4096 Dec 5 10:50 postgresql
          -rw-------. 1 zabbix zabbix 133 Nov 28 09:10 .psql_history
          -rw-------. 1 zabbix zabbix 652 Dec 5 15:07 .viminfo
          [zavatec@zabbix]$

          *********************

          Can you help zabbix ?

          Thanks in advance.

          Regards.

            Leave a comment:

          • hernan
            started a topic Password for user zbx_monitor: psql: fe_sendauth: no password supplied

            Password for user zbx_monitor: psql: fe_sendauth: no password supplied

            Hello Guys, I have the following problem:

            Environment: Zabbix Server: CentOS Linux 7 / Zabbix 4.4.3 / MySQL
            Zabbix Agent: CentOS Linux 7 / Zabbix 4. 4.1 / PostgreSQL

            I installed the PostgreSQL template provided for the zabbix.com page:

            Postgresql monitoring and integration with Zabbix
            https://www.zabbix.com/integrations/postgresql


            After that I received the following error message:
            2019-12-04 09:35:22 Password for user zbx_monitor: psql: fe_sendauth: no password supplied

            I checked the zabbix.log and I received the following error message:

            30268:20191204:080038.911 Failed to execute command " psql -qtAX -h "127.0.0.1" -p "5432" -U "zbx_monitor" -d "postgres" -f "/var/lib/zabbix/postgresql/pgsql.replication.lag.sql"": Timeout while executing a shell script.

            After that I tested the command and I received the following output:

            ******************************
            [zavatec@linuxzabbix]$ psql -qtAX -h "127.0.0.1" -p "5432" -U "zbx_monitor" -d "postgres" -f "/var/lib/zabbix/postgresql/pgsql.replication.lag.sql"
            Password for user zbx_monitor:
            1271135
            [zavatec@VM-EMSSANAR-DBMASTER-IFX zabbix]$
            *******************************
            Nota: I think that the command couldn't find the .pgpass on the server. ( The file was created on the /var/lib/zabbix directory)

            Can you help me with this issue?

            Thanks in advance.

            Regards.

            Tags: None
            Previous template Next
            Working...