Insert Page Break after title #141

pteratech · 2019-07-17T16:13:26Z

Would like to insert page break after title so the first page is the title page and the graphs start displaying on the second page. Thanks

IzakMarais · 2019-07-17T17:28:17Z

You can achieve this using a custom latex template.

…

________________________________ From: pteratech <[email protected]> Sent: Wednesday, 17 July 2019 18:13 To: IzakMarais/reporter Cc: Subscribed Subject: [IzakMarais/reporter] Insert Page Break after title (#141) Would like to insert page break after title so the first page is the title page and the graphs start displaying on the second page. Thanks — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

pteratech · 2019-07-17T17:38:23Z

OK Looks like I will need to spend some time to learn how to do that. Thanks

…

On Wed, Jul 17, 2019 at 10:28 AM Izak Marais ***@***.***> wrote: You can achieve this using a custom latex template. ________________________________ From: pteratech ***@***.***> Sent: Wednesday, 17 July 2019 18:13 To: IzakMarais/reporter Cc: Subscribed Subject: [IzakMarais/reporter] Insert Page Break after title (#141) Would like to insert page break after title so the first page is the title page and the graphs start displaying on the second page. Thanks — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#141?email_source=notifications&email_token=AFMZURLDJFHXLHYUA743PJLP75JDFA5CNFSM4IESDJGKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD2FT5BQ#issuecomment-512441990>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFMZURIM4B2YWY72DKZXHFTP75JDFANCNFSM4IESDJGA> .

-- Arthur Stephens Senior Network Administrator Ptera Inc. PO Box 135 24001 E Mission Suite 50 Liberty Lake, WA 99019 509-927-7837 ptera.com | facebook.com/PteraInc | twitter.com/Ptera ----------------------------------------------------------------------------- "This message may contain confidential and/or propriety information, and is intended for the person/entity to whom it was originally addressed. Any use by others is strictly prohibited. Please note that any views or opinions presented in this email are solely those of the author and are not intended to represent those of the company."

pteratech · 2019-07-17T23:16:53Z

I am assuming that it is ignoring my template and using a default.
I created a templates directory /go/bin/templates and placed the template there
I added the command -templates texTemplate.tex (The file says too instead of to on the timeSpan section)
\date{[[.FromFormatted]]\too\[[.ToFormatted]]}
But the pdf output still says to

IzakMarais · 2019-07-18T06:03:58Z

Yes, maybe the readme could be clearer. Reviewing it now, there are two things you need to do:1. Put your template in a directory `templates` relative to the location of the reporter binary. Alternatively you could use any directory you please and specify the directory path (abosolute or relative) as a command line parameter to the reporter. Use --help on the binary to see the specific commandline flag required. 2. Add a `template` query parameter to the HTTP request when you call the reporter to generate the pdf. This specifies the template filename (without extension) to use for that report. This is explained in the readme. A detailed example is available here: #50

pteratech · 2019-07-18T20:46:11Z

Here is my command.

sudo /home/zabbixcnr/go/bin/grafana-reporter -cmd_enable=1 -cmd_apiKey "APIKEY" -ip localhost:3000 -cmd_dashboard g08CgnSWz -cmd_ts from=now-1d -templates=/home/zabbixcnr/go/bin/templates -cmd_o testout.pdf

It generates the PDF but not from the template in the templates directory.

ls /home/zabbixcnr/go/bin/templates
texTemplate.tex

I changed this line in the template to see if it is working.
\date{[[.FromFormatted]]\\too\\[[.ToFormatted]]}
Attached result...
testout (5).pdf

pteratech · 2019-07-18T20:48:45Z

Oh maybe it won't work from the command line.

pteratech · 2019-07-18T20:56:23Z

http://x.x.x.x/api/v5/report/g08CgnSWz?apitoken="APIKEY"?template=texTemplate

This yeilds

Unauthorized, message: {"message":"Invalid API key"}

If I remove the

?template=texTemplate

it generates the PDF but not with the change I made.

Sorry - I feel really dumb right now.

pteratech · 2019-07-19T04:19:50Z

I am sorry but it just ignores my templates= command - the results has the apikey removed.

zabbixcnr@zabbixcnr:~/go/bin$ ./grafana-reporter -cmd_enable=1 -cmd_apiKey "APIKEY" -ip localhost:3000 -cmd_dashboard g08CgnSWz -cmd_ts from=now-1d -cmd_o testout.pdf -templates=/home/zabbixcnr/go/bin/templates/

2019/07/18 21:15:29 grafana reporter, version: 2.1-0 hash:
2019/07/18 21:15:29 serving at ':8686' and using grafana at 'localhost:3000'
2019/07/18 21:15:29 Called with command line mode enabled, will save report to file and exit.
2019/07/18 21:15:29 Called with command line mode 'dashboard' 'g08CgnSWz'
2019/07/18 21:15:29 Called with command line mode 'apiKey'
2019/07/18 21:15:29 Called with command line mode 'apiVersion' 'v5'
2019/07/18 21:15:29 Called with command line mode 'outputFile' 'testout.pdf'
2019/07/18 21:15:29 Called with command line mode 'timeSpan' 'from=now-1d'
2019/07/18 21:15:29 Reporter called
2019/07/18 21:15:29 Called with api Token:
2019/07/18 21:15:29 Called without variable
2019/07/18 21:15:29 Called with dashboard: g08CgnSWz
2019/07/18 21:15:29 Called with time range: {now-1d now}
2019/07/18 21:15:29 Connecting to dashboard at http://localhost:3000/api/dashboards/uid/g08CgnSWz
2019/07/18 21:15:29 Populated dashboard datastructure: {Title:Huntwood Connections Report Description: VariableValues: Rows:[] Panels:[{Id:6 Type:graph Title:Fiber Link Traffic} {Id:4 Type:graph Title:Wireless Link Traffic} {Id:8 Type:graph Title:Fiber Link Uptime} {Id:2 Type:graph Title:Wireless Link UpTime}]}
2019/07/18 21:15:29 Downloading image 6 http://localhost:3000/render/d-solo/g08CgnSWz/_?from=now-1d&height=500&panelId=6&theme=light&to=now&width=1000
2019/07/18 21:15:29 Downloading image 8 http://localhost:3000/render/d-solo/g08CgnSWz/_?from=now-1d&height=500&panelId=8&theme=light&to=now&width=1000
2019/07/18 21:15:29 Downloading image 4 http://localhost:3000/render/d-solo/g08CgnSWz/_?from=now-1d&height=500&panelId=4&theme=light&to=now&width=1000
2019/07/18 21:15:29 Downloading image 2 http://localhost:3000/render/d-solo/g08CgnSWz/_?from=now-1d&height=500&panelId=2&theme=light&to=now&width=1000
2019/07/18 21:15:34 Calling LaTeX - preprocessing
2019/07/18 21:15:35 Calling LaTeX and building PDF
2019/07/18 21:15:35 Extracted filename from dashboard title: Huntwood Connections Report.pdf
2019/07/18 21:15:35 Report generated correctly

IzakMarais · 2019-07-19T05:37:38Z

Oh maybe it won't work from the command line.

After reading through the source code I can confirm that this is a bug. The command line mode feature is very new.

http://x.x.x.x/api/v5/report/g08CgnSWz?apitoken="APIKEY"?template=texTemplate

When passing multiple query parameters in a URL, you should have one ? and then the rest be separated by &.

http://x.x.x.x/api/v5/report/g08CgnSWz?apitoken="APIKEY"&template=texTemplate

If successful, you would expect Called with template:... to appear in the logs.

pteratech · 2019-07-19T15:37:02Z

I am looking in syslog and grafana log and do not see this. How do I determine where the log file is?
After making the change to the URL it still uses the default template.

IzakMarais · 2019-07-22T06:05:47Z

How do I determine where the log file is?
The reporter just logs to std out. It is the log you already posted in this comment.

Let's first confirm that you see the expected message in the log.
From the source code here and here you can see that it should be printing that message after successfully extracting the "template" URL query parameter.

pteratech · 2019-07-22T15:36:41Z

Ahh there's the catch. That is not from a log file. That is from my console screen when I run the command from the command line. I did a copy and paste of my console screen.
Here is what is in syslog

Jul 22 08:30:41 zabbixcnr grafana-server[958]: t=2019-07-22T08:30:41-0700 lvl=info msg=Rendering logger=rendering path="d-solo/g08CgnSWz/?from=now-1d&height=500&panelId=6&theme=light&to=now&width=1000"
Jul 22 08:30:41 zabbixcnr grafana-server[958]: t=2019-07-22T08:30:41-0700 lvl=info msg=Rendering logger=rendering path="d-solo/g08CgnSWz/?from=now-1d&height=500&panelId=4&theme=light&to=now&width=1000"
Jul 22 08:30:41 zabbixcnr grafana-server[958]: t=2019-07-22T08:30:41-0700 lvl=info msg=Rendering logger=rendering path="d-solo/g08CgnSWz/?from=now-1d&height=500&panelId=2&theme=light&to=now&width=1000"
Jul 22 08:30:41 zabbixcnr grafana-server[958]: t=2019-07-22T08:30:41-0700 lvl=info msg=Rendering logger=rendering path="d-solo/g08CgnSWz/?from=now-1d&height=500&panelId=8&theme=light&to=now&width=1000"

Here is what is in grafana log

t=2019-07-22T08:30:41-0700 lvl=info msg=Rendering logger=rendering path="d-solo/g08CgnSWz/?from=now-1d&height=500&panelId=6&theme=light&to=now&width=1000"
t=2019-07-22T08:30:41-0700 lvl=info msg=Rendering logger=rendering path="d-solo/g08CgnSWz/?from=now-1d&height=500&panelId=4&theme=light&to=now&width=1000"
t=2019-07-22T08:30:41-0700 lvl=info msg=Rendering logger=rendering path="d-solo/g08CgnSWz/?from=now-1d&height=500&panelId=2&theme=light&to=now&width=1000"
t=2019-07-22T08:30:41-0700 lvl=info msg=Rendering logger=rendering path="d-solo/g08CgnSWz/?from=now-1d&height=500&panelId=8&theme=light&to=now&width=1000"

Here is my console (APIKEY deleted)

zabbixcnr@zabbixcnr:~/go/bin$ ./grafana-reporter -cmd_enable=1 -cmd_apiKey "APIKEY" -ip localhost:3000 -cmd_dashboard g08CgnSWz -cmd_ts from=now-1d  -cmd_o testout.pdf -templates=/home/zabbixcnr/go/bin/
2019/07/22 08:30:41 grafana reporter, version: 2.1-0 hash: 
2019/07/22 08:30:41 serving at ':8686' and using grafana at 'localhost:3000'
2019/07/22 08:30:41 Called with command line mode enabled, will save report to file and exit.
2019/07/22 08:30:41 Called with command line mode 'dashboard' 'g08CgnSWz'
2019/07/22 08:30:41 Called with command line mode 'apiKey' 
2019/07/22 08:30:41 Called with command line mode 'apiVersion' 'v5'
2019/07/22 08:30:41 Called with command line mode 'outputFile' 'testout.pdf'
2019/07/22 08:30:41 Called with command line mode 'timeSpan' 'from=now-1d'
2019/07/22 08:30:41 Reporter called
2019/07/22 08:30:41 Called with api Token: 
2019/07/22 08:30:41 Called without variable
2019/07/22 08:30:41 Called with dashboard: g08CgnSWz
2019/07/22 08:30:41 Called with time range: {now-1d now}
2019/07/22 08:30:41 Connecting to dashboard at http://localhost:3000/api/dashboards/uid/g08CgnSWz
2019/07/22 08:30:41 Populated dashboard datastructure: {Title:Huntwood Connections Report Description: VariableValues: Rows:[] Panels:[{Id:6 Type:graph Title:Fiber Link Traffic} {Id:4 Type:graph Title:Wireless Link Traffic} {Id:8 Type:graph Title:Fiber Link Uptime} {Id:2 Type:graph Title:Wireless Link UpTime}]}
2019/07/22 08:30:41 Downloading image  6 http://localhost:3000/render/d-solo/g08CgnSWz/_?from=now-1d&height=500&panelId=6&theme=light&to=now&width=1000
2019/07/22 08:30:41 Downloading image  8 http://localhost:3000/render/d-solo/g08CgnSWz/_?from=now-1d&height=500&panelId=8&theme=light&to=now&width=1000
2019/07/22 08:30:41 Downloading image  4 http://localhost:3000/render/d-solo/g08CgnSWz/_?from=now-1d&height=500&panelId=4&theme=light&to=now&width=1000
2019/07/22 08:30:41 Downloading image  2 http://localhost:3000/render/d-solo/g08CgnSWz/_?from=now-1d&height=500&panelId=2&theme=light&to=now&width=1000
2019/07/22 08:30:46 Calling LaTeX - preprocessing
2019/07/22 08:30:47 Calling LaTeX and building PDF
2019/07/22 08:30:47 Extracted filename from dashboard title:  Huntwood Connections Report.pdf
2019/07/22 08:30:47 Report generated correctly
zabbixcnr@zabbixcnr:~/go/bin$

IzakMarais · 2019-07-25T13:21:41Z

OK, I think the new cmd_line mode option was confusing the issue here. Even when using the default web-server mode, the log files are still just sent to std out. If you run the service inside some service manager, like systemd, you should see all those same logs appearing in your journal that you saw when you ran from the commandline.

Be that as it may, after #143 has been fixed, this should be easier for you using only the command line mode. See this test I did as an example: #145 (comment).

pteratech · 2019-07-25T16:57:29Z

Well then you must have a different version than I do.

zabbixcnr@zabbixcnr:~/go/bin$ ./grafana-reporter -cmd_enable=1 -cmd_apiKey -ip localhost:3000 -cmd_dashboard g08CgnSWz -cmd_ts from=now-1d -cmd_o testout.pdf
-cmd_template Commercial

flag provided but not defined: -cmd_template
Is my directory structure wrong?

IzakMarais · 2019-07-26T05:11:51Z

You need to use the new v2.2.1 release I made yesterday. Or just pull from master and rebuild the reporter.

pteratech · 2019-07-29T23:17:52Z

OK now I get ---

This is pdfTeX, Version 3.14159265-2.6-1.40.18 (TeX Live 2017/Debian) (preloaded format=pdflatex 2019.7.16) 29 JUL 2019 15:51
entering extended mode
restricted \write18 enabled.
%&-line parsing enabled.
**report.tex
(./report.tex
LaTeX2e <2017-04-15>
Babel <3.18> and hyphenation patterns for 84 language(s) loaded.

! LaTeX Error: Missing \begin{document}.

See the LaTeX manual or LaTeX Companion for explanation.
Type H for immediate help.
...

l.1 /
*
Here is how much of TeX's memory you used:
6 strings out of 492982
263 string characters out of 6134896
54077 words of memory out of 5000000
3671 multiletter control sequences out of 15000+600000
3640 words of font info for 14 fonts, out of 8000000 for 9000
1141 hyphenation exceptions out of 8191
5i,0n,4p,15b,14s stack positions out of 5000i,500n,10000p,200000b,80000s

! ==> Fatal error occurred, no output PDF file produced!

I looked at Commercial and it the line in it
\begin{document}
Not sure what or where ./report.tex is

pteratech · 2019-07-29T23:28:28Z

Here is report.tex

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

   http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/

package report

const defaultTemplate = `
%Commercial.tex
%use square brackets as golang text templating delimiters
\documentclass{article}
\usepackage{graphicx}
\usepackage[margin=1in]{geometry}

\graphicspath{ {images/} }
\begin{document}
...

pteratech · 2019-07-30T17:26:36Z

Even this template yields the same error

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

   http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/

package report

const defaultTemplate = `
%Commercial.tex
%use square brackets as golang text templating delimiters
\documentclass{article}

\begin{document}

\end{document}
`

pteratech · 2019-07-30T17:41:27Z

Removed the following and now it works.

/*
   Copyright 2016 Vastech SA (PTY) LTD
   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
*/

package report

const defaultTemplate = `

and the ` at the end

IzakMarais mentioned this issue Jul 18, 2019

Can you provide more help in Command line mode #137

Closed

IzakMarais mentioned this issue Jul 19, 2019

Missing -cmd_template flag for command line report generation #143

Closed

pteratech closed this as completed Jul 30, 2019

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Insert Page Break after title #141

Insert Page Break after title #141

pteratech commented Jul 17, 2019

IzakMarais commented Jul 17, 2019 via email

pteratech commented Jul 17, 2019 via email

pteratech commented Jul 17, 2019

IzakMarais commented Jul 18, 2019 via email •

edited

Loading

pteratech commented Jul 18, 2019

pteratech commented Jul 18, 2019

pteratech commented Jul 18, 2019

pteratech commented Jul 19, 2019

IzakMarais commented Jul 19, 2019 •

edited

Loading

pteratech commented Jul 19, 2019

IzakMarais commented Jul 22, 2019

pteratech commented Jul 22, 2019

IzakMarais commented Jul 25, 2019

pteratech commented Jul 25, 2019

IzakMarais commented Jul 26, 2019

pteratech commented Jul 29, 2019

pteratech commented Jul 29, 2019

pteratech commented Jul 30, 2019

pteratech commented Jul 30, 2019

Insert Page Break after title #141

Insert Page Break after title #141

Comments

pteratech commented Jul 17, 2019

IzakMarais commented Jul 17, 2019 via email

pteratech commented Jul 17, 2019 via email

pteratech commented Jul 17, 2019

IzakMarais commented Jul 18, 2019 via email • edited Loading

pteratech commented Jul 18, 2019

pteratech commented Jul 18, 2019

pteratech commented Jul 18, 2019

pteratech commented Jul 19, 2019

IzakMarais commented Jul 19, 2019 • edited Loading

pteratech commented Jul 19, 2019

IzakMarais commented Jul 22, 2019

pteratech commented Jul 22, 2019

IzakMarais commented Jul 25, 2019

pteratech commented Jul 25, 2019

IzakMarais commented Jul 26, 2019

pteratech commented Jul 29, 2019

pteratech commented Jul 29, 2019

pteratech commented Jul 30, 2019

pteratech commented Jul 30, 2019

IzakMarais commented Jul 18, 2019 via email •

edited

Loading

IzakMarais commented Jul 19, 2019 •

edited

Loading