No data is being graphed, and also in the dashboard it is not showing the correct number of open tickets by department, agent or anything. Dashboard is completely non-functional.I have checked the cron.php and personally setup a cron-job to run it every 5 minutes, and have activated my apache rewrite module as well. This was working on php5.6 running osTicket v.9.16blankGoing to have to downgrade back to php5.6 and previous version as that one was an easy setup and work flawlessly.

PHP errors?MySQL Errors?

@[deleted]Yea, PHP 7.0+ has been known to be weird and funky. It should work on PHP 5.6 though, I'm running v1.10.1 and PHP 5.6 with no issues (see image below). Re-test this with PHP 5.6 and post the results.blankCheers.

Screen Shot 2018-03-28 at 14.15.03.png

I was able to get this back up and running with 9.16 right out of the box.I am going to copy over a bare Ubuntu 16.04 VM and try to get it up and running. I unfortunately deleted my previous build so I can't send you any error logs. But I will rebuild and send logs.If interested, I am utilizing this script I wrote to install/setup osTicket on Ubuntu 16.04:apt-get purge `dpkg -l | grep php| awk '{print $2}' |tr "\n" " "`add-apt-repository ppa/php -yapt-get updateapt-get install php5.6 php5.6-cli php5.6-mysql php-gettext php5.6-mbstring php-xdebug libapache2-mod-php5.6 php5.6-gd php5.6-imap php5.6-xml -yapt-get install php5.6-apcu -yapt-get install php5.6-intl -yphp -vread -p "Press enter to continue"echoapt-get install phpmyadmin -yapt-get install gitapt-get install unzipmkdir /var/www/html/osticketcd /var/www/html/osticketwget https://github.com/osTicket/osTicket/releases/download/v1.10.2/osTicket-v1.10.2.zipwget https://github.com/osTicket/osTicket/releases/download/v1.9.16/osTicket-v1.9.16.zipunzip osTicket-v1.10.2.zipchown -R www-data-data /var/www/htmlcp /var/www/html/osticket/upload/include/ost-sampleconfig.php /root/mv /var/www/html/osticket/upload/include/ost-sampleconfig.php /var/www/html/osticket/upload/include/ost-config.phpchmod 666 /var/www/html/osticket/upload/include/ost-config.phpchmod -R g+s /var/www/htmlfind /var/www/html -type d -exec chmod 0755 {} \;find /var/www/html -type f -exec chmod 0644 {} \;cp -a /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/osticket.confcd /root/ln -s /etc/php/5.6/cli/php.ini cli_php.iniln -s /etc/php/5.6/apache2/php.ini apache_php.iniln -s /etc/apache2/ apache2_confln -s /var/www/html/osticket osticket_htmla2enmod rewriteecho "Please modify the virtual-host in sites-available for Apache2 called osticket.conf"echo "Once you have modified it to your liking, please restart Apache2; service apache2 restart".echo "Then navigate to your server's phpmyadmin, http://youraddress/phpmyadmin"echo "Login and create a user called osticket and a database named the same; grant all privileges to it."echo "Now navigate to your webserver address and configure the osTicket setup."

OK. Same setup, but this time installed PHP5.6 on Ubuntu 16.04 with osTicket version 1.10.2.blankLOGSMYSQL: Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2018-03-28T21.877182Z 0 Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2018-03-28T21.024149Z 0 Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2018-03-28T21.728196Z 0 Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2018-03-28T17.850162Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-03-28T17.383001Z 0 InnoDB: New log files created, LSN=457902018-03-28T17.477175Z 0 InnoDB: Creating foreign key constraint system tables.2018-03-28T17.544778Z 0 No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 33dbdd55-32b1-11e8-85f9-00155d019a40.2018-03-28T17.549291Z 0 Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2018-03-28T17.551495Z 1 root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.2018-03-28T18.072412Z 0 Changed limits: max_open_files: 1024 (requested 5000)2018-03-28T18.218295Z 0 Changed limits: table_open_cache: 431 (requested 2000)2018-03-28T18.296534Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-03-28T18.424751Z 0 Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2018-03-28T21.021447Z 0 Changed limits: max_open_files: 1024 (requested 5000)2018-03-28T21.185134Z 0 Changed limits: table_open_cache: 431 (requested 2000)2018-03-28T21.402667Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-03-28T21.877182Z 0 Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2018-03-28T21.766204Z 0 Changed limits: max_open_files: 1024 (requested 5000)2018-03-28T21.808687Z 0 Changed limits: table_open_cache: 431 (requested 2000)2018-03-28T21.046271Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-03-28T21.024149Z 0 Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key2018-03-28T21.810939Z 0 Changed limits: max_open_files: 1024 (requested 5000)2018-03-28T21.814483Z 0 Changed limits: table_open_cache: 431 (requested 2000)2018-03-28T21.277827Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-03-28T21.728196Z 0 Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private keyAPACHE:No PHP Errors or anything related to the dashboard.Same issue ensues, dashboard displays nothing, and I created 1 test ticket, and it does not show up under the "AGENT" tab in dashboard.

Dashboard stats are not real time, they are a day behind usually.

Oops I didn't hit submit.1.10.2 hasn't been released yet for reasons.  I would not run this version until it is.

Sorry! Ok, I wiped the database, wiped the 1.10.2 version and re-installed 1.10.1 with a new fresh database. it is setup; however still have the NaN graph.Should I've generated two test tickets; you're saying this will take 24 hours before it will demonstrate anything on the graph or dashboard?Is there anyways to force it to look up the values and display the statistics?Maybe changing the servers date/time?

This can be closed. My solution was downgrading to php 5.6, wiping the database, rebuilding the database, deleting osTicket 1.10.2 and installing 1.10.1. Now the dashboard is functioning properly, it just took some time to generate after having created some test tickets.My script above has been tested on Ubuntu 16.04 and works. It should work just as well on most Debian 7 and above.However for the time being, make sure to modify the "wget" command to pull down the correct version of osTicket you desire. The script as is will download 1.9.16 and 1.10.2, just change the version number in the script, and add the same version number to the "unzip" command and you are good to go.Also you will have to manually adjust your Apache config files for your server/virtual host in /etc/apache2/It will also install PHPMyAdmin for you for database management; get rid of the appropriate line if you do not wish to install it.If you have trouble with the script, you can contact me directly on here!Grazie!

Write a Reply...