KREST api gives blank page, Rewrite tested, works


#1

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.

What next?
Timo


#2

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.


#3

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 :disappointed:

Timo


#4

Timo, please check

  1. php.ini settings: display_errors should be set to Off
  2. 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>

#5

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>


#6

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


#7

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


#8

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


#9

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] - -

#10

Any ideas what could be wrong?


#11

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

Val


#12

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


#13

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


#14

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

Timo


#15

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


#16

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?


#17

Anyone with a similar problem? Anything?


#18

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