Cacti missing all device templates in drop-down

[TheSwede86]

OS: Win 10 Pro x64 Ver: 21H2 (Build: 19043.1706)
Running Cacti v.1.2.22 on my Windows "WSL2" Ubuntu 20.04 distribution (GNU/Linux 5.10.16.3-microsoft-standard-WSL2 x86_64)

Hello,

I just setup Cacti using these instructions;
https://www.how2shout.com/linux/how-to- ... -04-20-04/
The instructions worked fine except I had to replace the "systemctl"-commands with "service" instead since Ubuntu on WSL(2) does not contain "systemctl".

I have a working installation and corrected all the issues in the wizard and am in the main web-interface and successfully added an SNMP device.
I can see that the device in question is responding using the "SNMP Information" but when I check the "Device Template" drop-down it is empty.
Likewise if I go into "Templates" > "Device" and "Graph" both of these does not contain any templates at all.

Checking the "Utilities" > "System Utilities" > "Log Administration" for "Errors" I can see the following:
INSTALL: always: WARNING: Device Template for your Operating System Not Found. You will need to import Device Templates or Cacti Packages to monitor your Cacti server.
IMPORT ERROR: 0103 Current Cacti Version does not exist!

Checking the "Utilities" > "System Utilities" > "Technical Support [Summary]" I can find the following errors;
Data Sources 0
Items No items to poll

Checking the "Utilities" > "System Utilities" > "Technical Support [Database]" I can find what I believe are empty tables (since they don't contain any rows) in the database;

Code: Select all

data_template_rrd	InnoDB	0	0	16,384	49,152	utf8mb4_unicode_ci	Dynamic
host_template_graph	InnoDB	0	0	16,384	0	utf8mb4_unicode_ci	Dynamic	
graph_templates	InnoDB	0	0	16,384	32,768	utf8mb4_unicode_ci	Dynamic	Contains each graph template name.
graph_templates_graph	InnoDB	0	0	16,384	49,152	utf8mb4_unicode_ci	Dynamic	Stores the actual graph data.
host_template	InnoDB	0	0	16,384	16,384	utf8mb4_unicode_ci	Dynamic	
data_template_data	InnoDB	0	0	16,384	65,536	utf8mb4_unicode_ci	Dynamic	

Checking the database itself;

Code: Select all

MariaDB [cacti]> SELECT * FROM host_template;
Empty set (0.003 sec)

this indeed seems to be the case.

So I guess I need to copy the necessary data from the vanilla Cacti DB to the tables that contain missing data, any idea on how to do a full replace so I'm not missing anything else?

Not fluent in Linux and MariaDB / MySQL and don't really understand why these tables does not contain any data, it's a totally fresh install.

Best Regards - Karl

[TheWitness]

1.2.22 has not been released, but update you global_arrays.php and I updated what may have been bothering you. However, if these are newly developed templates, you will need some surgery.

[TheSwede86]

I think I understand why I was able to pull 1.2.22, I ran the following command;

Code: Select all

git clone -b 1.2.x https://github.com/Cacti/cacti.git

And I guess it pulled 1.2.22.

I believe I have the same issue as https://github.com/Cacti/cacti/issues/4830

Still wondering how I might fix it, reinstalling / wiping the installation and running 1.2.21 might be the easiest option for a non-linux native?

[TheWitness]

You have to switch all your Graph Templates from SVG to PNG.

[TheWitness]

Oh wait, this appears to be something else. You say you are running Ubuntu under Windows. Never played with that. You will have to keep digging.