Help! error on any Script on Cacti 1.1.28

[hyrule20]

Hello everyone first, i explain my case:
I'm learn how to use cacti, i install devices and plugins but, the scripts don't work or i don't know how put in the server.
Use Cacti 1.1.28 on ubuntu server 16.04 for the most easy use and the directory is on /opt/cacti/scripts.
The question, i need monitoring a services, exactly Apache and mysql, i try installing templates and script but doesn't work all, maybe the scripts what i found be obsolete? there are some script for the 1.1.28 version? this project is for my final grade.
Apreciatte the help.
Greetings.

[netniV]

If you are on ubuntu, have you checked out paulgevers signatures as it has links to support for cacti on ubuntu which would be the best way to install it.

If you have performed a manual installation, be sure to check against the Installation and Linux Installation wiki pages.

When you first launch cacti, it should take you to <cacti site>/install/ which does all the pre-checks it needs. As long as you have satisfied these checks, you should be OK.

[hyrule20]

Yeah, i install cacty manually and works fine i have 2 host monitoring processes and interfaces correctly but only need the Apache and mysql monitoring, i can't find these two and i can't work properly this scripts.
Thanks for the answer, i see now for more info!

[netniV]

What you may need is the process monitoring part then. Although that really depends on what you define as monitoring apache/mysql?

[hyrule20]

Yeah, First, sorry for my bad english, i'm Spanish with low knowledge of this language;
Really, i need monitoring only status of service of apache/mysql with a graph, they ask me that moment for have the approved.
Where i find a Template and script for this services working for the 1.1.28 version?
Thanks for your answer!

[netniV]

Is this on the same host, or a different server?

[hyrule20]

Well, if ot's possible in both is better, mainly in other;
i have a Cacti in ubuntu server 16.04 and one Ubuntu Desktop 16.04 for monitoring, it's possible monitoring apache and mysql from cacti to ubuntu?¿

[netniV]

If you google for this, there are a number of solutions. One such open source solution is:
https://github.com/percona/percona-monitoring-plugins

if you need 1 minute polling instead of 5, try following this afterwards:
https://kovyrin.net/2013/06/26/mysql-pe ... us+Blog%29

Other solutions are:
https://www.pitt-pladdy.com/blog/_20120 ... _via_SNMP/
viewtopic.php?f=12&t=50815

Bare in mind, that most of these will show you how to connect to mysql from the local host. If you are doing it remotely, you need to check the 'localhost' to the IP or hostname of the machine you are connecting from when you create your monitoring users.

[hyrule20]

Wow, thanks for all!, i try all and answer if it's works!
A several dumb question, if i put a script of mysql, i need create a template of this sql script for work or just put in a folder of cacti?, when i put xml need put script too?

Well, thanks a lot for the answers, merry christmas and happy new year!.

[netniV]

The /resource/ folder has three subfolders, script_queries, script_server and snmp_queries.

Whether your XML requires a separate script all depends on the type of data query you build.