Create pdf file from report

5 posts by 3 authors in: Forums > CMS Builder
Last Post: July 1, 2021   (RSS)

By andreasml - June 29, 2021

Hi

I would like to create a pdf from a report. I have installed the Create PDF plugin, but I do not know how to proceed. Could you give some advice?


Kind regards

Andreas Lazaris

By gkornbluth - June 30, 2021

Hi Andreas,

The readme.txt file and example files that came with the plugin should give you all the information that you need to get started.

There's also a recipe with some troubleshooting tips as well as a downloadable test page in my cmsbcookbook that might help.

http://www.thecmsbcookbook.com/recipedetail.php?THE-CREATEPDF-PLUGIN-339

Hope that gets you going.

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By andreasml - July 1, 2021

Hi Jerry

Thank for your response. 

It seems that there is a problem of installation. When I run the Test Server Requirements, the test does not pass and a lot of errors appear as following: 

  • PDF Conversion ProgramThis plugin is using: /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/wkhtmltopdf/wkhtmltopdf-0.12.5-1.ubuntu18.04_bionic_amd64
    Plugins settings: CREATEPDF_BINARY_FILE: auto-detected
    If all the test below don't pass you can try: download updated binaries and testing all binaries
Warning: shell_exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF_pluginsMenu.php on line 176
  • Failed! Run external program on serverTesting shell_exec() with command: pwd
    Result:
    Error: No output returned from command!
Warning: exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF_pluginsMenu.php on line 107 Warning: join(): Invalid arguments passed in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF_pluginsMenu.php on line 108
  • Failed! Test running PDF conversion program on serverTesting pdf binary with command: /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/wkhtmltopdf/wkhtmltopdf-0.12.5-1.ubuntu18.04_bionic_amd64 -V
    Result: 0 bytes returned
    Output:
    Error: No output returned from command! (Exit code: -1)
  • Passed! Create and remove temp file on serverCreating temp file: /var/www/vhosts/vascularregistry.gr/httpdocs/registry/createPDF_e6fcfc357a8e945b8caa03022a2ac06e.tmp
    Removing temp file: /var/www/vhosts/vascularregistry.gr/httpdocs/registry/createPDF_e6fcfc357a8e945b8caa03022a2ac06e.tmp
  • Passed! Test downloading content from remote URLDownloading content from url with: getPage('http://www.google.com/');
    Result: HTTP status code 302 (view source, html)
  • Passed! Test downloading content from this serverDownloading content from url with: getPage('http://vascularregistry.gr/');
    Resolve hostname 'vascularregistry.gr' to IP address: 185.138.42.30
    Result: HTTP status code 301 (view source, html)
    Check that this is returning your website's homepage!
Warning: shell_exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 169 Notice: Undefined variable: outputArray in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Notice: Undefined variable: returnCode in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Warning: exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Notice: Undefined variable: outputArray in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 171 Notice: Undefined variable: returnCode in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 175
  • Failed! Test converting a web page to a PDFCreated PDF with: HTML from: https://www.google.com/
    Result: 0 byte PDF returned
    Error: Conversion program returned errors:
    Temp file didn't get created, check for: 1) wkhtmltopdf errors and 2) make sure server is able to connect to itself internally!
  • Visually review PDF output (link)Visually inspect the PDF below, correct any error message, then make sure the graphics and fonts display as expected:

Warning: shell_exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 169 Notice: Undefined variable: outputArray in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Notice: Undefined variable: returnCode in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Warning: exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Notice: Undefined variable: outputArray in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 171 Notice: Undefined variable: returnCode in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 175 Temp file didn't get created, check for: 1) wkhtmltopdf errors and 2) make sure server is able to connect to itself internally!

Then, I try the Test all binaries and again all binaries fail. The message I get for every binary is about the same and it is as following:

Warning: exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF_pluginsMenu.php on line 107 Warning: join(): Invalid arguments passed in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF_pluginsMenu.php on line 108 Warning: shell_exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 169 Notice: Undefined variable: outputArray in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Notice: Undefined variable: returnCode in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Warning: exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Notice: Undefined variable: outputArray in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 171 Notice: Undefined variable: returnCode in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 175 Warning: shell_exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 169 Notice: Undefined variable: outputArray in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Notice: Undefined variable: returnCode in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Warning: exec() has been disabled for security reasons in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 170 Notice: Undefined variable: outputArray in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 171 Notice: Undefined variable: returnCode in /var/www/vhosts/vascularregistry.gr/httpdocs/registry/plugins/createPDF/createPDF.php on line 175

  • Failed! wkhtmltopdf-0.12.6-1.centos8.x86_64
  • Program version reported: (Error: Exit code -1)
  • Create PDF of non-secure page http://www.example.com/ - Errors: Temp file didn't get created, check for: 1) wkhtmltopdf errors and 2) make sure server is able to connect to itself internally!
  • Create PDF of secure page https://www.google.com/ - Errors: Temp file didn't get created, check for: 1) wkhtmltopdf errors and 2) make sure server is able to connect to itself internally!

Any ideas on how to carry on?

Kind regards, 

Andreas Lazaris

By daniel - July 1, 2021

Hi Andreas,

The createPDF plugin uses some PHP functions (exec() and shell_exec()) that are disabled on some hosts/installations as a security measure - that appears to be the case here. Depending on your host and setup you may be able to re-enable them; here are some instructions if you have access to php.ini: https://www.cyberciti.biz/faq/linux-unix-apache-lighttpd-phpini-disable-functions/ (these instructions are to disable the functions, but can be used to reverse the process)

Let me know if that helps!

Thanks,`

Daniel
Technical Lead
interactivetools.com