reporter on grafana 7.1.5

[wasykp]

I'm trying to set the Reporter tool on the latest fresh Grafana 7.1.5 installation. After some tests, I stuck with the error shown on the screenshot.

Could anyone give me some advice or just confirm that the Reporter works with Grafana 7.1.5 version. OS is CentOS8 w/o Selinux and with Firewalld disabled. The reporter is on the same VM as Grafana

[jagaboom]

I can confirm that everything (except for rendering a "text" panel - which I've logged under ticket #249 ) works on the following:

# cat /etc/lsb-release |grep DESC && zabbix_server -V | grep ^zabbix && mysql -V && grafana-server -v
DISTRIB_DESCRIPTION="Ubuntu 18.04.5 LTS"
zabbix_server (Zabbix) 4.4.10
mysql  Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Version 7.1.5 (commit: 9893b8c53d, branch: HEAD)

The version of Grafana-Reporter I'm using is:

2020/08/29 16:44:19 grafana reporter, version: 2.3-0 hash: 124b9a35302b3e9d4746ec0cf643abfecda8c21d

I'm pretty new to Grafana - and Grafana-reporter, and I'm a Unix/AIX/Linux sysadmin so please don't ask me about how the Grafana* apps work :-)

[razzrsi]

I am also getting same issue with Grafana from 7.1 version. Not working as well despite of installing "grafana-image-renderer" Plugin. In my another setup with 5.0 version it is working fine without installing the same plugin.

[jagaboom]

I managed to do a (clunky) workaround, as my requirement was to display a logo and some text (using markdown) and include graphs on the rendered PDF.

So - I then looked at another plugin called “Dynamic Text for Grafana” (By Marcus Olsson ).

I changed the data source to “Grafana” and modified the “Query Options” as below:

I then changed the “Display” markdown to say:

…and the result, when rendering a dashboard which contains a panel from: • Zabbix data source • Grafana data source with Dynamic Text Panel …it looks like this – which is exactly what I’m trying to achieve for my customer reports 😊 (obviously not this particular content though 😉)

[razzrsi]

Not worked for me either "grafana-image-renderer" or "Dynamic Text for Grafana". Is it a bug for latest Grafana or anything else?? because Grafana older version it is working fine.

[jagaboom]

I've read a lot of related issues, and think it's become more apparent since the removal of Phantom.JS.

As I'm brand-new to Grafana, I've only ever used the very latest release.

This is a quick list of things I did yesterday to get a vanilla Ubuntu 20.04 system running, installed from "ubuntu-20.04.1-live-server-amd64.iso" - and I didn't install any additional packages during installation other than OpenSSH Server.

My notes only go up to the point where I added the Zabbix plugin - so don't include any notes for when I added the "Dynamic Text" plugin - but that's covered in my previous comments :-)

Hopefully there's something in this checklist that you may have missed or done differently that will allow you to at least use the Dynamic Text panel...

Hope it helps !

Pre-Reqs
	LatEX - required for grafana-reporter
1	apt install texlive-base
2	apt install texlive-latex-recommended
3	apt install texlive
4	apt install texlive-latex-extra
GoLANG - required for grafaner-reporter
5	apt install golang
Install Grafana-Server  assisted from guide here https://computingforgeeks.com/how-to-install-grafana-on-ubuntu-debian/
6	apt-get install -y gnupg2 curl  software-properties-common
7	curl https://packages.grafana.com/gpg.key | sudo apt-key add -
8	add-apt-repository "deb https://packages.grafana.com/oss/deb stable main"
9	apt-get -y update
10	apt-get -y install grafana
Start daemon
11	/bin/systemctl daemon-reload
12	/bin/systemctl enable grafana-server
13	/bin/systemctl start grafana-server
Setup Firewall
14	apt -y install ufw
15	ufw enable
Restrict IP address range(s) and port(s)
16	ufw allow from 192.168.1.0/24 to any port 3000
17	ufw allow from 192.168.1.0/24 to any port 22
Add the grafana-renderer
18	grafana-cli plugins install grafana-image-renderer
	** may need the following:    libx11-6 libx11-xcb1 libxcomposite1 libxcursor1 libxdamage1 libxext6 libxfixes3 libxi6 libxrender1 libxtst6 libglib2.0-0 libnss3 libcups2  libdbus-1-3 libxss1 libxrandr2 libgtk-3-0 libgtk-3-0 libasound2
Add grafana-reporter:   https://github.com/IzakMarais/reporter
19	go get github.com/IzakMarais/reporter/...
20	echo 'PATH=$PATH:/root/go/bin/' >> ~/.bashrc
21	/etc/init.d/grafana-server stop
22	/etc/init.d/grafana-server start
23	grafana-reporter -grid-layout=1
24	these notes assume all OK to here, so hit [CTRL][C] to kill grafana-reporter
Now we want to run grafana-reporter at system startup, so we need to create a "service" definition
25	echo "[Install] WantedBy=multi-user.target [Unit] After=network.service [Service] ExecStart=/root/go/bin/grafana-reporter -grid-layout=1 [Install] WantedBy=default.target " > /lib/systemd/system/grafana-reporter.service
enable the reporter service
26	systemctl enable grafana-reporter
we need to lower the security of Grafana by changing the value of a variable in /etc/grafana/grafana.ini
27	disable_sanitize_html = true
Now we want to add the grafana-reporter dashboard
28	grafana-cli plugins install marcusolsson-dynamictext-panel
add zabbix data source
29	/etc/init.d/grafana-server stop
30	grafana-cli plugins install alexanderzobnin-zabbix-app
31	/etc/init.d/grafana-server start
32	grafana-reporter -grid-layout=1 &
In grafana	Select plugins and scroll down and click Zabbix
Select plugins and scroll down and click Zabbix
	vi /etc/grafana/grafana.ini change ;allow_loading_unsigned_plugins to allow_loading_unsigned_plugins = alexanderzobnin-zabbix-datasource
	/etc/init.d/grafana-server restart
back in the grafana application	Refresh the webpage and add the Zabbix datasource
Refresh the webpage and add the Zabbix datasource
Then configure data source with a name / path to the URL and login credentials

[IzakMarais]

@wasykp and @razzrsi : have you managed to get the dynamic text plugin working? If so, what where the steps needed?

You should be able to test this without the reporter from the Grafana UI directly by going Panel>SHare>direct link rendered image.

[onefourfive]

Do you know what type of panels the renderer is getting hung up on?

In my experience, in some recent versions of Grafana, some panels hang the renderer - alert lists, text panels, clocks to name a few.

I'm told these have been resolved in Grafana 7.3 but I haven't tested them yet.

[razzrsi]

Rendering issue resolved on CentOS 7 because few packages does not support in CentOS 6. Refer below link :

https://grafana.com/docs/grafana/latest/administration/image_rendering/

And majorly refer below section

Grafana image renderer plugin and remote rendering service

[mbuyukkarakas]

Totally agreed. It worked for me this solution on Centos7 / Grafana 7.x

https://grafana.com/docs/grafana/latest/administration/image_rendering/

yum install -y libXcomposite libXdamage libXtst cups libXScrnSaver pango atk adwaita-cursor-theme adwaita-icon-theme at at-spi2-atk at-spi2-core cairo-gobject colord-libs dconf desktop-file-utils ed emacs-filesystem gdk-pixbuf2 glib-networking gnutls gsettings-desktop-schemas gtk-update-icon-cache gtk3 hicolor-icon-theme jasper-libs json-glib libappindicator-gtk3 libdbusmenu libdbusmenu-gtk3 libepoxy liberation-fonts liberation-narrow-fonts liberation-sans-fonts liberation-serif-fonts libgusb libindicator-gtk3 libmodman libproxy libsoup libwayland-cursor libwayland-egl libxkbcommon m4 mailx nettle patch psmisc redhat-lsb-core redhat-lsb-submod-security rest spax time trousers xdg-utils xkeyboard-config