KREST api gives blank page, Rewrite tested, works

Timo12357 · February 15, 2017, 9:24am

Hi
We are using SuiteCRM 7.8.1 on a Ubuntu 12.04 LTS server.

Installing Kreporter fails at the KREST api install:SuiteCRM/KREST/sysinfo returns a blank page.

mod_rewrite works, tested it like this: http://old.webasyst.net/support/help/general-modrewrite-test.html
set folder permissions according to http://support.sugarcrm.com/Knowledge_Base/Platform_Management/Required_File_System_Permissions_on_Linux/index.html

What next?
Timo

maretval · February 15, 2017, 10:43am

Hi Timo, which php version do run on Ubuntu 12.04? The php 5.3 included in Ubuntu 12.04 package is too old for KREST. An Upgrade to php 5.6 would be best.

Timo12357 · February 15, 2017, 1:44pm

Maretval,
we used to run php 5.3, but I upgraded as per your kind instructions. Now the server runs php 5.6. I am sorry to inform, that KREST still gives a blank page

Timo

maretval · February 15, 2017, 2:29pm

Timo, please check

php.ini settings: display_errors should be set to Off
httpd.conf or any subconfiguration for your webserver shall AllowOverride All
Example:
DocumentRoot “C:/htdocs”
<Directory “C:/htdocs”>
Options Indexes FollowSymLinks Includes ExecCGI
AllowOverride All
Require all granted
</Directory>

Timo12357 · February 15, 2017, 3:03pm

I think they are in order, below snippets from the configuration files:

/etc/php5/apache2/php.ini

; Possible Values:
; Off = Do not display any errors
; stderr = Display errors to STDERR (affects only CGI/CLI binaries!)
; On or stdout = Display errors to STDOUT
; Default Value: On
; Development Value: On
; Production Value: Off
; http://php.net/display-errors
display_errors = Off

/etc/apache2/sites-enabled/000-default

<VirtualHost *:80>
ServerAdmin webmaster@localhost

    DocumentRoot /var/www
    <Directory />
            Options FollowSymLinks
            AllowOverride All
    </Directory>
    <Directory /var/www/>
            Options Indexes FollowSymLinks MultiViews
            AllowOverride All
            Order allow,deny
            allow from all
    </Directory>

maretval · February 15, 2017, 3:41pm

Assuming your CRM install is directly under /var/www httpd.conf looks ok.
Next step is checking apache error log and php error log

Timo12357 · February 15, 2017, 8:16pm

Maretval,

yes indeed, the CRM install is under /var/www

No new errors are generated into /var/log/apache2/error.log when trying to create a new report in kreporter.

Timo

maretval · February 16, 2017, 12:00pm

Timo, anything in the apache access log? Let say to make sure file permissions are set correctly?
Valérie

Timo12357 · March 27, 2017, 5:25am

Here is the tail of the server access log when I start Kreports. Server and client ip:s removed:

[27/Mar/2017:08:20:34 +0300] “GET /SuiteCRM/KREST/metadata/modules?_dc=1490592034355&session_id=&page=1&start=0&limit=25 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”

- [27/Mar/2017:08:20:34 +0300] “GET /SuiteCRM/KREST/KReporter/core/layouts?_dc=1490592034358&page=1&start=0&limit=25 HTTP/1.1” 500 287 “http:/[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - - [27/Mar/2017:08:20:34 +0300] “GET /SuiteCRM/KREST/metadata/modules?_dc=1490592034353&session_id=&page=1&start=0&limit=25 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - - [27/Mar/2017:08:20:34 +0300] “GET /SuiteCRM/KREST/KReporter/bucketmanager/groupings?_dc=1490592034348&page=1&start=0&limit=25 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - - [27/Mar/2017:08:20:34 +0300] “GET /SuiteCRM/KREST/KReporter/core/config?_dc=1490592034467 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - - [27/Mar/2017:08:20:34 +0300] “GET /SuiteCRM/KREST/KReporter/bucketmanager/groupings?_dc=1490592034410&page=1&start=0&limit=25 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - - [27/Mar/2017:08:20:35 +0300] “GET /SuiteCRM/KREST/KReporter/core/whereinitialize?_dc=1490592035451 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - - [27/Mar/2017:08:20:35 +0300] “GET /SuiteCRM/KREST/KReporter/core/vizcolors?_dc=1490592035716&nodeid=&page=1&start=0&limit=25 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - - [27/Mar/2017:08:20:35 +0300] “GET /SuiteCRM/KREST/KReporter/dlistmanager/dlists?_dc=1490592035720&page=1&start=0&limit=25 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - - [27/Mar/2017:08:20:35 +0300] “GET /SuiteCRM/KREST/KReporter/core/wherefunctions?_dc=1490592035725&page=1&start=0&limit=25 HTTP/1.1” 500 287 “http://[my.host.ip]/SuiteCRM/index.php?module=KReports&action=EditView&return_module=KReports&return_action=DetailView” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0”
  [my.client.ip] - -

Timo12357 · August 17, 2017, 10:01am

Any ideas what could be wrong?

maretval · August 17, 2017, 10:16am

Timo,
how are file permissions set for SuiteCRM and underlying folders/files? Does the webuser have permission to execute?

Val

Timo12357 · August 18, 2017, 6:44am

Val,
our SuiteCRM is located in /var/www/SuiteCRM:

/var/www/SuiteCRM# ls -la
total 73876
drwxr-xr-x 23 www-data www-data 4096 Jun 26 13:34 .
drwx–x--x 9 root root 4096 Jun 26 12:49 …
drwxr-xr-x 2 www-data www-data 4096 Oct 19 2016 .github
-rwxr-xr-x 1 www-data www-data 1273 Oct 19 2016 .gitignore
-rwxr-xr-x 1 www-data www-data 1716 Feb 15 2017 .htaccess
-rwxr-xr-x 1 www-data www-data 501 Oct 19 2016 .travis.yml
-rwxr-xr-x 1 www-data www-data 2811 Oct 19 2016 HandleAjaxCall.php
drwxr-sr-x 5 www-data www-data 4096 Feb 13 2017 KREST
-rwxr-xr-x 1 www-data www-data 34539 Oct 19 2016 LICENSE.txt
drwxr-xr-x 3 www-data www-data 4096 Oct 19 2016 ModuleInstall
-rwxr-xr-x 1 www-data www-data 2659 Jun 26 13:34 README.md
-rwxr-xr-x 1 www-data www-data 5327 Oct 19 2016 SugarSecurity.php
-rwxr-xr-x 1 www-data www-data 52389380 Nov 16 2016 SuiteCRM.sql
-rwxr-xr-x 1 www-data www-data 5843 Oct 19 2016 TreeData.php
drwxr-xr-x 2 www-data www-data 4096 Oct 19 2016 XTemplate
drwxr-xr-x 8 www-data www-data 4096 Oct 19 2016 Zend
drwxrwxr-x 14 www-data www-data 4096 May 18 16:39 cache
-rwxr-xr-x 1 www-data www-data 3590 Oct 19 2016 campaign_tracker.php
-rwxr-xr-x 1 www-data www-data 430 Oct 19 2016 composer.json
-rwxr-xr-x 1 www-data www-data 16167 Oct 19 2016 composer.lock
-rwxr-xr-x 1 www-data www-data 10644 Jun 26 13:35 config.php
-rwxrwxr-x 1 www-data www-data 1691 May 11 22:54 config_override.php
-rwxr-xr-x 1 www-data www-data 5052 Jun 26 13:34 cron.php
-rwxr-xr-x 1 www-data www-data 2446 Oct 19 2016 crossdomain.xml
drwxrwxr-x 11 www-data www-data 4096 Feb 13 2017 custom
drwxrwxr-x 3 www-data www-data 4096 Oct 19 2016 data
-rwxr-xr-x 1 www-data www-data 2388 Oct 19 2016 dictionary.php
-rwxr-xr-x 1 www-data www-data 12541 Jun 26 13:34 download.php
-rwxr-xr-x 1 www-data www-data 2392 Oct 19 2016 emailmandelivery.php
-rwxr-xr-x 1 www-data www-data 4912 Oct 19 2016 export.php
-rwxr-xr-x 1 www-data www-data 967627 Oct 19 2016 files.md5
-rwxr-xr-x 1 www-data www-data 2371 Oct 19 2016 ical_server.php
drwxr-xr-x 56 www-data www-data 4096 Oct 19 2016 include
-rwxr-xr-x 1 www-data www-data 2374 Oct 19 2016 index.php
-rwxr-xr-x 1 www-data www-data 21 Mar 28 13:38 info.php
drwxr-xr-x 6 www-data www-data 4096 Jun 26 13:34 install
-rwxr-xr-x 1 www-data www-data 20113 Nov 2 2016 install.log
-rwxr-xr-x 1 www-data www-data 32077 Jun 26 13:34 install.php
-rwxr-xr-x 1 www-data www-data 13373 Oct 19 2016 json_server.php
drwxr-xr-x 3 www-data www-data 4096 Oct 19 2016 jssource
-rwxr-xr-x 1 www-data www-data 2313 Oct 19 2016 log_file_restricted.html
-rwxr-xr-x 1 www-data www-data 2376 Oct 19 2016 maintenance.php
drwxr-xr-x 2 www-data www-data 4096 Oct 19 2016 metadata
drwxrwxr-x 113 www-data www-data 4096 Feb 13 2017 modules
-rwxr-xr-x 1 www-data www-data 2 Mar 29 08:50 n???
drwxr-xr-x 2 www-data www-data 4096 Mar 29 08:31 old
-rwxr-xr-x 1 www-data www-data 2890 Oct 19 2016 pdf.php
-rwxr-xr-x 1 www-data www-data 306 Jun 26 13:34 php_version.php
drwxr-sr-x 2 www-data www-data 4096 Jan 4 2017 public
-rwxr-xr-x 1 www-data www-data 73 Oct 19 2016 robots.txt
-rwxr-xr-x 1 www-data www-data 3588 Oct 19 2016 run_job.php
drwxr-xr-x 11 www-data www-data 4096 Oct 19 2016 service
drwxr-xr-x 2 www-data www-data 4096 Oct 19 2016 soap
-rwxr-xr-x 1 www-data www-data 4091 Oct 19 2016 soap.php
-rwxr-xr-x 1 www-data www-data 154 Oct 19 2016 sugar_version.json
-rwxr-xr-x 1 www-data www-data 2263 Oct 19 2016 sugar_version.php
-rwxr-xr-x 1 www-data www-data 126131 Nov 2 2016 sugarcrm.log
-rwxr-xr-x 1 www-data www-data 8210124 Jul 24 14:46 suitecrm.log
-rwxr-xr-x 1 www-data www-data 10485815 Feb 26 13:09 suitecrm_1.log
-rwxr-xr-x 1 www-data www-data 168 Jun 26 13:34 suitecrm_version.php
drwxr-xr-x 3 www-data www-data 4096 Oct 19 2016 tests
drwxrwxr-x 6 www-data www-data 4096 Oct 19 2016 themes
-rwxr-xr-x 1 www-data www-data 3021385 Jun 26 13:35 upgradeWizard.log
drwxrwxr-x 6 www-data www-data 20480 Aug 17 09:44 upload
-rwxr-xr-x 1 www-data www-data 2980 Oct 19 2016 vCard.php
-rwxr-xr-x 1 www-data www-data 2707 Oct 19 2016 vcal_server.php
drwxr-sr-x 3 www-data www-data 4096 Feb 13 2017 vendor

Timo

maretval · August 18, 2017, 1:47pm

What do you get when your call http://yourcrmurl/KREST/sysinfo in browser?

Timo12357 · August 18, 2017, 5:31pm

I get a blank page.
The same happens with http://mycrmurl/KREST/[anything]

Timo

spicecrm · August 22, 2017, 7:59pm

then you shoudl check your php error log. Most likely there is another error.

Timo12357 · August 29, 2017, 5:29am

I enabled php_errors.log according to: https://askubuntu.com/questions/14763/where-are-the-apache-and-php-log-files
When calling KREST no errors are added to the file.
Any more ideas?

Timo12357 · August 30, 2017, 6:08am

Anyone with a similar problem? Anything?

maretval · August 30, 2017, 8:17am

Open KREST/index.php, comment first line containing error reporting setting. Then try again and check php error log.

Topic		Replies	Views
After Installation I get a blank page for Kreport 4.2 KReporter	21	4549	November 17, 2023
KReporter on SuiteCRM 7.8.5 403 error KReporter	12	1936	August 16, 2017
KREST - KReportor (SuiteCRM)/SpiceCRM - blank screen on test KReporter	1	851	November 9, 2018
Can't get KReporter (Slim) to work KReporter	18	2418	August 30, 2019
KREST 2.2 install cancelled functional URL rewrite Installation	8	746	October 9, 2018

KREST api gives blank page, Rewrite tested, works

/etc/php5/apache2/php.ini

; Possible Values: ; Off = Do not display any errors ; stderr = Display errors to STDERR (affects only CGI/CLI binaries!) ; On or stdout = Display errors to STDOUT ; Default Value: On ; Development Value: On ; Production Value: Off ; http://php.net/display-errors display_errors = Off

/etc/apache2/sites-enabled/000-default

Here is the tail of the server access log when I start Kreports. Server and client ip:s removed:

Related topics

; Possible Values:
; Off = Do not display any errors
; stderr = Display errors to STDERR (affects only CGI/CLI binaries!)
; On or stdout = Display errors to STDOUT
; Default Value: On
; Development Value: On
; Production Value: Off
; http://php.net/display-errors
display_errors = Off