Ad Widget

**martinm_76** · 19-05-2015, 16:53

PDF report array debugging script (mostly for 1.8.x installations)

Originally posted by waardd

My PHP has the same values (except for up and download size, its higher then yours.
I tried the direct URL and got the same result on multiple browsers.

=====
HostID: 10348
Report Type: host
Time Period: 3600
Temp image path: /appl/mcv/html/zabbix/frontends/php/report/tmp/zabbix_report_u5HpkO

(id

jk-8009 worker threads(id:372)
http-8080 worker threads(id:373)
http-8443 worker threads(id:374)
sessions /(id:375)
3150-cpu(id:387)
3150-load(id:391)
3148-cpu(id:392)
3148-load(id:393)
Space in Queue(id:437)
Space in Queue(id:438)
Space in Queue(id:439)
and so on
=====

The selection list for Hosts is filled but with blanks.
The selectioon list for HostGroups is filled and readable but has the same effect when creating a report:

====
GroupID: 53
Report Type: hostgroup
Time Period: 3600
Temp image path: /appl/mcv/html/zabbix/frontends/php/report/tmp/zabbix_report_qqbyT7

(id

jk-8009 worker threads(id:372)
http-8080 worker threads(id:373)
http-8443 worker threads(id:374)
sessions /(id:375)
3150-cpu(id:387)
3150-load(id:391)
3148-cpu(id:392)
3148-load(id:393)
Space in Queue(id:437)
Space in Queue(id:438)
Space in Queue(id:439)
MySQL Threads(id:470)
MySQL Questions(id:471)
MySQL slow queries(id:472)
and so on
====

Waardd, could you make a file called chooser.debug.php with this contents:

Code:

<?php
///////////
//
// DEBUG VERSON OF CHOOSER. ONLY SHOWS HOST AND
// HOST GROUPS ARRAYS, THEN EXITS.
// YOU MAY NEED TO COMMENT THE LOGOUT PART ON Zabbix 1.8.x
//
///////////

include("config.inc.php");

if ( $user_login == 1 ) {
session_start();
//print_r($_SESSION);
$z_user=$_SESSION['username'];
$z_pass=$_SESSION['password'];

if ( $z_user == "" ) {
  header("Location: index.php");
}

$z_login_data	= "name=" .$z_user ."&password=" .$z_pass ."&autologin=1&enter=Sign+in";
}

global $z_user, $z_pass, $z_login_data;

require_once("inc/ZabbixAPI.class.php");
include("inc/index.functions.php");

header( 'Content-type: text/html; charset=utf-8' );
?>
<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="X-UA-Compatible" content="IE=Edge"/>
	<title>Zabbix Dynamic PDF Report</title>
	<meta charset="utf-8" />
</head>
<body>
<?php
// ERROR REPORTING
error_reporting(E_ALL);
set_time_limit(60);

echo "<pre>\n";
// ZabbixAPI Connection
ZabbixAPI::debugEnabled(TRUE);
ZabbixAPI::login($z_server,$z_user,$z_pass)
	or die('Unable to login: '.print_r(ZabbixAPI::getLastError(),true));
//fetch graph data host
$hosts       = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','name','host'),'sortfield'=>'host','with_graphs'=>'1'))
	or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));

echo "Hosts array:\n";
print_r($hosts);

$host_groups = ZabbixAPI::fetch_array('hostgroup','get', array('output'=>array('groupid','name'),'real_hosts'=>'1','with_graphs'=>'1','sortfield'=>'name') )
	or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));

echo "Host Groups Array:\n";
print_r($host_groups);

ZabbixAPI::logout($z_server,$z_user,$z_pass)
	or die('Unable to logout: '.print_r(ZabbixAPI::getLastError(),true));

//var_dump($hosts);
//var_dump($host_group);
?>
</pre>
</html></body>

Then, after you have validated your credentials, or if $user_login is zero, point to chooser.debug.php in stead of chooser.php and see what results you get. If you don't see the hosts here, then the API must be incompatible in some way.

I am thinking you'll get a value in the 'host' column, but a blank in the 'name' column. If so, you need to alter the occurences of 'name' to be 'host' wherever calls to the host method is made. Host groups have only 'name' so be carefull not to alter 'name' there.

That ought to do it, or at least get you further.
The easy solution, though (easy for me to say), is to upgrade Zabbix to at least 2.0

Regards,

/Martin.

**waardd** · 20-05-2015, 08:54

**martinm_76** · 20-05-2015, 09:33

Ah. waardd, could you try removing 'name' from the selection in the hosts array so we only choose hostid and host? If that doesn't produce a working host array, I am not sure I can figure out what will (other than upgrading Zabbix).

**waardd** · 20-05-2015, 10:57

Originally posted by martinm_76

Ah. waardd, could you try removing 'name' from the selection in the hosts array so we only choose hostid and host? If that doesn't produce a working host array, I am not sure I can figure out what will (other than upgrading Zabbix).

Did that and now i get a listing:

Hosts array:
Array
(
[0] => Array
(
[hostid] => 10348
[host] => Aggr_ABPM
)

[1] => Array
(
[hostid] => 10248
[host] => Aggr_ABPX
)

[2] => Array
(
[hostid] => 10161
[host] => Aggr_CIV
)

[3] => Array
(
[hostid] => 10211
[host] => Aggr_ERR_APPLOG
)

[4] => Array
(
[hostid] => 10162
[host] => Aggr_LOGFREE
)

[5] => Array
(
[hostid] => 10296
[host] => Aggr_ORCO
---> and so on

But still a error at the end

Unable to logout: Array
(
[code] => -32400
[message] => System error.
[data] => JSON-rpc error generation failed. No such error:
)

The $hosts fetch line in chooser.debug.php is the same as th line in my index.php. So the blanks are created after this....
And again one step closer (i think)

Whtas the next move?

**martinm_76** · 21-05-2015, 12:44

Well, if you're lucky, then changing these occurences to use 'host' in stead of 'name' will give you the graphs you're looking for:

Code:

[### report.org]# grep -r '$hosts' * | grep ZabbixAPI
createpdf.php:	$hosts  = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','name'),'with_graphs'=>'true','hostids'=>$hostid))
createpdf.php:	$hosts  = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','name'),'with_graphs'=>'true','groupids'=>$groupid))
index.php:$hosts       = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','name'),'sortfield'=>'host','with_graphs'=>'1','sortfield'=>'name'))

So, both in the array and the sortfield, replace 'name' with 'host'.

**waardd** · 26-05-2015, 08:44

Code:

createpdf.php:  $hosts  = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','host'),'with_graphs'=>'true','hostids'=>$hostid))
createpdf.php:          or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
createpdf.php:  //var_dump($hosts);
createpdf.php:  $name = $hosts[0]['name'];
createpdf.php:  CreatePDF($hosts);
createpdf.php:  $hosts  = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','host'),'with_graphs'=>'true','groupids'=>$groupid))
createpdf.php:          or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
createpdf.php:  //var_dump($hosts);
createpdf.php:  CreatePDF($hosts);
index.php://$hosts       = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','host'),'sortfield'=>'host','with_graphs'=>'1','sortfield'=>'host') )
index.php://$hosts       = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','host'),'sortfield'=>'host','with_graphs'=>'1') )
index.php://$hosts       = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','host'),'sortfield'=>'name','with_graphs'=>'1'))
index.php://    or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
index.php:$hosts       = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','host'),'with_graphs'=>'1','sortfield'=>'host'))
index.php:      or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
index.php:$host_groups = ZabbixAPI::fetch_array('hostgroup','get', array('output'=>array('groupid','host'),'real_hosts'=>'1','with_graphs'=>'1','sortfield'=>'name') )
index.php:      or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
index.php://var_dump($hosts);
index.php:ReadArray($hosts);

This is what i have now.

Reports seem to be made OK but i still dont see the hosts in the pulldown menu.
They are all white (blank)

Hostgroups are shown good.

On the report i sometimes miss the graphs while they are present in zabbix. I just get a grey titlebar with the title of the graph where the graph should appear on the pdf document.

Extra info

=============
Foutdetails webpagina

Gebruikersagent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E; Tablet PC 2.0)
Tijdstempel: Tue, 26 May 2015 07:03:20 UTC

Bericht: Deze eigenschap of methode wordt niet ondersteund door dit object
Regel: 2
Teken: 29694
Code: 0
URI: http://<zabbix_server>/zabbix/frontends/php/report/js/jquery-2.1.1.min.js

Bericht: 'jQuery' is niet gedefinieerd
Regel: 6
Teken: 1
Code: 0
URI: http://<zabbix_server>/zabbix/frontends/php/report/js/jquery.datetimepicker.js

Bericht: 'jQuery' is niet gedefinieerd
Regel: 4
Teken: 14
Code: 0
URI: http://<zabbix_server>/zabbix/frontends/php/report/js/jquery.validate.min.js

Bericht: 'jQuery' is niet gedefinieerd
Regel: 2
Teken: 1
Code: 0
URI: http://<zabbix_server>/zabbix/frontends/php/report/js/jquery.tablesorter.min.js

Bericht: 'jQuery' is niet gedefinieerd
Regel: 21
Teken: 1
Code: 0
URI: http://<zabbix_server>/zabbix/frontends/php/report/js/select2.min.js

Bericht: Object wordt verwacht
Regel: 20
Teken: 3
Code: 0
URI: http://<zabbix_server>/zabbix/frontends/php/report/

Bericht: Object wordt verwacht
Regel: 353
Teken: 1
Code: 0
URI: http://<zabbix_server>/zabbix/frontends/php/report/

=================

**martinm_76** · 26-05-2015, 10:02

Hmm.. I wonder why you have jQuery errors, but this ought to fix the hostnames not showing:

Change

Code:

createpdf.php:  $name = $hosts[0]['name'];

to:

Code:

createpdf.php:  $name = $hosts[0]['host'];

I can't help you about the graphs. It may be an incompatibility in the API.

**waardd** · 27-05-2015, 09:43

Originally posted by martinm_76

Hmm.. I wonder why you have jQuery errors, but this ought to fix the hostnames not showing:

Change

Code:

createpdf.php:  $name = $hosts[0]['name'];

to:

Code:

createpdf.php:  $name = $hosts[0]['host'];

I can't help you about the graphs. It may be an incompatibility in the API.

This doesnt do the trick. It also creates a file called .pdf instead of <hostname>.pdf

**martinm_76** · 27-05-2015, 10:33

... Do you have this in createpdf.php? If not, try it.

Code:

if ($reporttype == 'host') {
        if (!is_numeric($hostid)) { echo "ERROR: Need hostid for host report!</br>\n"; exit; }
        $hosts  = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','host'),'with_graphs'=>'true','hostids'=>$hostid))
                or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
        //var_dump($hosts);
        // Get name to be used in PLACEHOLDER-part of filename
        $name = $hosts[0]['host'];
        $reportname=str_replace(" ", "_",$name);
        CreatePDF($hosts);
}

**701054** · 27-05-2015, 11:18

How to make Cyrilic fonts readable instead

ÐšÐ¾Ð»Ð ̧Ñ‡ÐμÑ•Ð²Ð¾ Ð¾Ñ‚Ð¿ÐμÑ‡Ð°Ñ‚ÐºÐ¾Ð² Ð ̧ Ñ‚Ð¾Ð½ÐμÑ€Ð°

?

**waardd** · 28-05-2015, 08:18

Originally posted by martinm_76

... Do you have this in createpdf.php? If not, try it.

Code:

if ($reporttype == 'host') {
        if (!is_numeric($hostid)) { echo "ERROR: Need hostid for host report!</br>\n"; exit; }
        $hosts  = ZabbixAPI::fetch_array('host','get',array('output'=>array('hostid','host'),'with_graphs'=>'true','hostids'=>$hostid))
                or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
        //var_dump($hosts);
        // Get name to be used in PLACEHOLDER-part of filename
        $name = $hosts[0]['host'];
        $reportname=str_replace(" ", "_",$name);
        CreatePDF($hosts);
}

=====================================
In my createpdf.php
=====================================

if ($reporttype == 'host') {
if (!is_numeric($hostid)) { echo "ERROR: Need hostid for host report!</br>\n"; exit; }
$hosts = ZabbixAPI::fetch_array('host','get',array('output' =>array('hostid','host'),'with_graphs'=>'true','ho stids'=>$hostid))
or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
//var_dump($hosts);
// Get name to be used in PLACEHOLDER-part of filename
$name = $hosts[0]['name'];
$reportname=str_replace(" ", "_",$name);
CreatePDF($hosts);
}
=====================================
from your message
=====================================

if ($reporttype == 'host') {
if (!is_numeric($hostid)) { echo "ERROR: Need hostid for host report!</br>\n"; exit; }
$hosts = ZabbixAPI::fetch_array('host','get',array('output' =>array('hostid','host'),'with_graphs'=>'true','ho stids'=>$hostid))
or die('Unable to get hosts: '.print_r(ZabbixAPI::getLastError(),true));
//var_dump($hosts);
// Get name to be used in PLACEHOLDER-part of filename
$name = $hosts[0]['host'];
$reportname=str_replace(" ", "_",$name);
CreatePDF($hosts);
}
=====================================
Difference:
=====================================

mine: $name = $hosts[0]['name'];
yours: $name = $hosts[0]['host'];

But when i change it my report is called .pdf instead of <host>.pdf

And still i cant see my hosts in the index.php dropdown menu.

**martinm_76** · 28-05-2015, 10:52

So, waardd, are you saying that in both cases you get a report called '.pdf'?
It seems like that is what you are saying.

And apparently you have 'name' somewhere else still if your host list is blank...

Okay, in inc/index.functions.php, you need to change ReadArray as well:

Code:

function ReadArray($array) {
        foreach($array as $key=>$value) {
                $name = $array[$key]['name'];
/* Added for 1.8.x - MMO */
                if ( $name == "" ) {
                    $name = $array[$key]['host'];
                }
/* End Add */
                if (isset($array[$key]['hostid'])) {
                        $id   = $array[$key]['hostid'];
                }
                elseif (isset($array[$key]['groupid'])) {
                        $id   = $array[$key]['groupid'];
                }
                else {
                        $id   = $name;
                }
                echo "<option value=\"$id\">$name</option>\n";
        }
}

If your report is still saved as .pdf after this, you have to do some debugging yourself, such as parsing over createpdf.php and do some extra echos of things that include 'host' to see where you loose it. You should probably use the 'if ($debug) ' wrapper like seen elsewhere, otherwise the PDF output will get garbled (when not choosing the debug option).

**waardd** · 28-05-2015, 16:27

@martinm_76

First of i want to thank you for all the help so far

Oke i'm at the point where for HOSTS

hosts are visible in dropdown
host report has host.pdf filename
on the host report the hostname is in the title
host repoprt seems to work good

And for HOSTGROUPS

hostgroups are visible in dropdown
host report DOES NOT have hostgroup.pdf filename but just .pdf
on the host report the hostgroupname is in NOT the title
hostgroup report seems to work almost good

So it seems to be juyst a small step to perfection

**logix88** · 29-05-2015, 10:51

Availability Report

Has anyone managed to get IT Services SLA figures included as part of this?

We measure Availability by measuring how long agent (in extension the server) was offline during any given period, days/hours, etc. and this is visible in the IT services GUI and worked out for each platform , i.e. Availability of Linux servers was 99% for Last 30 days, etc.

Can someone suggest a way we could go around doing this or if you have already done it?

Thanks in advance...

**sheh1000** · 30-07-2015, 06:08

Originally posted by logix88

Has anyone managed to get IT Services SLA figures included as part of this?

The only way I found is to use Zabbix API

service.getsla

https://www.zabbix.com/documentation/2.4/manual/api/reference/service/getsla

Ad Widget

Zabbix Dynamic PDF Report Generation

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment