Nagios Support Forum

Code: Select all

SQL Error [nagiosxi] : ERROR:  function unix_timestamp(timestamp without time zone) does not exist
LINE 1: SELECT *, UNIX_TIMESTAMP(auth_valid_until) as valid_until_ts...
                  ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Code: Select all

Rapid Response
Error: This rapid response URL has alread been used.
You must login to view this object.

Code: Select all

grep response /usr/local/nagiosxi/html/config.inc.php

Code: Select all

[root@nagios ~]# grep response /usr/local/nagiosxi/html/config.inc.php
// Secure notification %responseurl%
// setting this to 1 will force users to login in the response URL
// $cfg['secure_response_url']=1;

Code: Select all

cp -p /usr/local/nagiosxi/html/includes/utils-users.inc.php /usr/local/nagiosxi/html/includes/utils-users.inc.php.original

Code: Select all

Rapid Response
Error: This rapid response URL has alread been used.
You must login to view this object.

Why am I getting this error?
Verify the rapid response URL is the exact same as in the notifiction. Possible reasons for error include:
The single use URL has already been used
The URL has expired
Invalid or no auth token given in URL

Code: Select all

ls -la /usr/local/nagiosxi/html/includes/utils-users*

Code: Select all

sed -n 1894,1908p /usr/local/nagiosxi/html/includes/utils-users.inc.php

Code: Select all

[root@nagios ~]# ls -la /usr/local/nagiosxi/html/includes/utils-users*
-rw-r----- 1 nagios nagios 68564 Jul 10 09:16 /usr/local/nagiosxi/html/includes/utils-users.inc.php

Code: Select all

[root@nagios ~]# sed -n 1894,1908p /usr/local/nagiosxi/html/includes/utils-users.inc.php
    global $db_tables;

    $sql = "SELECT * FROM ".$db_tables[DB_NAGIOSXI]['auth_tokens']." WHERE auth_token = ".escape_sql_param($auth_token, DB_NAGIOSXI, true);
    if (!($rs = exec_sql_query(DB_NAGIOSXI, $sql))) {
        return false;
    }

    $arr = $rs->GetArray();
    if (!empty($arr)) {
        $arr = $arr[0];

        // Convert valid until to timestamp
        $arr['valid_until_ts'] = strtotime($arr['auth_valid_until']);
        return $arr;
    }

Code: Select all

chmod 750 /usr/local/nagiosxi/html/includes/utils-users.inc.php
chown nagios:nagios /usr/local/nagiosxi/html/includes/utils-users.inc.php

Code: Select all

[root@nagios ~]# ll /usr/local/nagiosxi/html/includes/ | grep utils-users.inc
-rwxr-x---   1 nagios nagios  68564 Jul  6 23:50 utils-users.inc.php
-rwxr-x---   1 nagios nagios  68480 Jun 29 12:10 utils-users.inc.php.original