There are problems with Cacti 8.8f in Ubuntu 16.04. It doesn't set the proper permissions and settings.
You will find a few things broken but can be fixed/worked around. I do have Cacti working fine under Ubuntu 16.04 but not the Network Weathermap plugin. It doesn't work.
Some plugins and such will need PHP 5.6 while Ubuntu 16.04 had PHP 7.0. You will probably need to run these commands:
sudo add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get install php7.0 php5.6 php5.6-mysql php-gettext php5.6-mbstring php-xdebug libapache2-mod-php5.6 libapache2-mod-php7.0 php5.6-gd
Switch PHP version ( Apache ) from php7.0 to php5.6:
sudo a2dismod php7.0 ; sudo a2enmod php5.6 ; sudo service apache2 restart
(reverse a2dismod and a2enmod to switch back)
(From
http://askubuntu.com/questions/761713/h ... untu-16-04)
It will allow you to run both php 7.0 and 5.6 side by side. But some plugins run command line php commands and will run them as php 7.0 unless you "flip" that as well.
Under /etc/alternatives, create a new symlink for php to /usr/bin/php5.6.
cd /etc/alternatives
sudo rm php
sudo ln -s /usr/bin/php5.6 php
(change php5.6 or php7.0 to switch back)
That will fix some issues.
There are other issues with mysql as well. For example:
CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"SELECT count(*) FROM poller_time WHERE poller_id=0 AND end_time>'0000-00-00 00:00:00'"
I had to edit:
/etc/mysql/mysql.conf.d/mysql.cnf
And add the line at the bottom:
sql-mode="ALLOW_INVALID_DATES"
Then run:
sudo service mysql restart
As for the templates/data sources issue you are having, I'm trying to remember if these fix it or not. If they don't, let me know. I will try to get back to you.