Firewall open?
Mysql server actually running?
Configured mysql server to use tcp/ip socket and not unix socket only?
Created mysql user that is allowed to connect from the cacti machine?
Allowed the httpd daemon to create tcp/ip connections with selinux? (setsebool)
Search found 82 matches
- Sat Aug 29, 2020 9:42 am
- Forum: Help: Linux/Unix Specific
- Topic: FATAL: Connection to Cacti database failed
- Replies: 5
- Views: 2666
- Wed Aug 12, 2020 7:39 am
- Forum: Help: General
- Topic: Automation give device and matching object but don't work
- Replies: 6
- Views: 727
Re: Automation give device and matching object but don't work
Automation was written by one of the retired Cacti dev's so it's older code that's being brought forward and maintained but not the easiest to read. People will likely say the same thing about my installer class. While you mention it, a small remark from me. No offense meant or complaint, a mere co...
- Fri Jul 03, 2020 9:18 am
- Forum: Help: General
- Topic: cacti backup
- Replies: 1
- Views: 2457
Re: cacti backup
The mysql database contains cacti configuration info. Machine info, definition of data sources and graphs. The *.rrd files contain the actual data collected. This is the "real" database. Configuration can be reentered into a fresh instance, but if you lose the *.rrd files, you lose all his...
- Thu Jun 18, 2020 8:23 pm
- Forum: Informational/HOWTO's
- Topic: Improve my charts obtained by OID
- Replies: 6
- Views: 6734
Re: Improve my charts obtained by OID
If you change a data source type of an existing data source with an existing *.rrd file, you need to delete the corresponding *.rrd file and let cacti create a new one. The type cannot be changed on the fly for an existing *.rrd file.
- Thu Jun 18, 2020 9:27 am
- Forum: Informational/HOWTO's
- Topic: Improve my charts obtained by OID
- Replies: 6
- Views: 6734
Re: Improve my charts obtained by OID
Your image is broken, so nothing to see. You seem to choose the wrong data source type. You have an application with a counter that constantly increases, but you don't want to visualize the total counter value but the difference between each query. The correct data source type for this kind of data ...
- Tue Mar 10, 2020 6:06 am
- Forum: Help: General
- Topic: Need help to define a REGEXP - locate a SubString
- Replies: 9
- Views: 948
Re: Need help to define a REGEXP - locate a SubString
Regular expressions have their own science. If you google for regex, you will find hundredths of thousands of hits. In general, a regular expression defines a pattern for string matching. If a regular expression matches, it matches a part of a longer string. In a programming language, this is can be...
- Fri Mar 06, 2020 9:09 pm
- Forum: Help: General
- Topic: Need help to define a REGEXP - locate a SubString
- Replies: 9
- Views: 948
Re: Need help to define a REGEXP - locate a SubString
As far as I understand the cacti documentation, the first submatch is used as return value. You defined 2 submatches, the first is the data captured before the . and the second is the data captured after it. You capture a substring by putting () around the expression, so remove the first () and only...
- Mon Jan 13, 2020 3:08 pm
- Forum: Help: General
- Topic: Issues creating data source profile
- Replies: 3
- Views: 2504
Re: Issues creating data source profile
It seems you don't have the complete picture on the matter. You have a device, which is queried repeatedly. The timespan between queries is called step. The object in cacti that represents the queried values from the device is a data source. A data source may query one or more values, for example up...
- Sat Jan 11, 2020 2:35 pm
- Forum: Help: General
- Topic: Issues creating data source profile
- Replies: 3
- Views: 2504
Re: Issues creating data source profile
It's not "step", it's "steps" - the number of primary data points consolidated to one that's stored in that rra. It's not clear what you mean with "...over 4 weeks". Is this the maximum timespan you want to store for the rra with the primary data points? Or for the most...
- Sat Dec 21, 2019 12:56 pm
- Forum: Help: General
- Topic: Holes in graphs
- Replies: 6
- Views: 1389
Re: Holes in graphs
the not-NaN values are near to 2^31 (maximum signed 32-bit integer), and no value is bigger than 2^31, so it seems you're using 32-bit counter for query. Use 64-bit snmp counters instead. It also may be that you set an upper limit of 2^31 (2147483648) in the corresponding data sources, so that highe...
- Thu Dec 05, 2019 12:30 pm
- Forum: Help: Linux/Unix Specific
- Topic: Total novice initial install issue.
- Replies: 13
- Views: 1411
Re: Total novice initial install issue.
It makes no sense to install a new cacti onto an obsolete operating system base (Redhat 6). You should install at least on RHEL 7, if not RHEL 8. With both, you just need to add the EPEL repository to yum/dnf, and install cacti with "yum install cacti". Required dependencies are pulled aut...
- Wed Jul 24, 2019 1:56 pm
- Forum: Help: General
- Topic: How to recreate High Collection Rate Collector
- Replies: 2
- Views: 814
Re: How to recreate High Collection Rate Collector
Install the same version of cacti fresh and empty on a test machine. Get it up and running. On it, create a throwaway data template that uses the lost 1 minute data source profile. Export this template, include dependencies. Import this in your real cacti. The lost data source profile will come back...
- Wed Jul 17, 2019 8:18 am
- Forum: Help: General
- Topic: How to install cacti configuration on centos
- Replies: 4
- Views: 1013
Re: How to install cacti configuration on centos
The above will work if you add the EPEL repository to your machine.
- Wed Jul 17, 2019 8:15 am
- Forum: Help: General
- Topic: I cannot get mysql settings correct - [SOLVED}
- Replies: 4
- Views: 10377
Re: I cannot get mysql settings correct - [SOLVED}
You should practice more careful proof-reading. You first updated the section from [mysq] to [mysqd], but it should read [mysqld]. Only when you inserted the entries in a pre-existing correctly named section you succeeded.
- Tue Jul 16, 2019 5:52 pm
- Forum: Help: General
- Topic: I cannot get mysql settings correct - [SOLVED}
- Replies: 4
- Views: 10377
Re: I cannot get mysql settings correct
The settings must be in the [mysqld] section. You put them into some "[mysq]" section, which is unknown.