CactiEZ 0.7 Released

[sicay]

Please make CactiEZ next version can boot on flash drive (usb drive).

Tony

[HQuest]

CactiEZ's backup script has a *huge* flaw.

It begins cleaning stuff not used for the past 2 days. That is nice, if you don't use structured folders. If you do, the folder date may not be updated and, hey presto, your rrd files are wiped with the folder before they ever have a chance on being backed up.

It also has a small bug whereas it can't get database dumps because the script doesn't know the database password for any account, root or cacti, since they are auto-generated during the install.

The fixes themselves are quite easy to be applied on backup.sh script (yep, I'm too lazy to create a .patch file since I already modifyed mine):

# Get database password
DBPWD=`grep "root" ~/mysqlpass.txt | awk '{ print $3 }'`

# Dump the MySQL Database
mysqldump -uroot -p${DBPWD} --opt cacti> /var/www/html/cacti-backup.sql
mysqldump -uroot -p${DBPWD} --opt syslog> /var/www/html/syslog.sql

And move+change the above to the very bottom of the script. Since this is an automatic backup, it is better to backup *everything* before automatically clean things up, just in case you clean wrong files =)

# Remove old RRAs (usually means the datasource is deleted)
find /var/www/html/rra/* -mtime +2 -type f -exec rm -fr {} \; > /dev/null 2>&1

Keep up the good work.

[sindaco]

is there problem with cactiz repo?

Code: Select all

[root@localhost ~]# yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.prometeus.net
 * extras: mirrors.prometeus.net
 * updates: mirrors.prometeus.net
http://mirror.cactiusers.org/RPMS/CentOS/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 403 Forbidden"
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: CactiEZ. Please verify its path and try again

Code: Select all

[root@localhost ~]# wget http://mirror.cactiusers.org/RPMS/CentOS/x86_64/repodata/repomd.xml
--2013-09-06 14:21:53--  http://mirror.cactiusers.org/RPMS/CentOS/x86_64/repodata/repomd.xml
Resolving mirror.cactiusers.org... 209.189.228.151
Connecting to mirror.cactiusers.org|209.189.228.151|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2990 (2.9K) [text/xml]
Saving to: “repomd.xmlâ€

100%[==================================================================================================================================================================================>] 2,990       --.-K/s   in 0s

2013-09-06 14:21:54 (153 MB/s) - “repomd.xml†saved [2990/2990]

Code: Select all

[root@localhost ~]# cat repomd.xml
<?xml version="1.0" encoding="UTF-8"?>
<repomd xmlns="http://linux.duke.edu/metadata/repo" xmlns:rpm="http://linux.duke.edu/metadata/rpm">
 <revision>1378307488</revision>
<data type="filelists">
  <checksum type="sha256">63ac227e65f04ed403d54c4732712b096b0635996ad976f0a8082c581357a845</checksum>
  <open-checksum type="sha256">58f9d07fb31edf233b4789953d4a33a0a8db88b40272ef001b77c7182b8befc2</open-checksum>
  <location href="repodata/63ac227e65f04ed403d54c4732712b096b0635996ad976f0a8082c581357a845-filelists.xml.gz"/>
  <timestamp>1378307490</timestamp>
  <size>111667</size>
  <open-size>1694681</open-size>
</data>
<data type="primary">
  <checksum type="sha256">76eb15903f839a85da987e9bcd4bc9f4a03ead00c27ba6d4b30f22c6c9cbc826</checksum>
  <open-checksum type="sha256">5bdf247aefc9e949e255d647604b62c5dd84b2a737ab76a4366c530eca2a2351</open-checksum>
  <location href="repodata/76eb15903f839a85da987e9bcd4bc9f4a03ead00c27ba6d4b30f22c6c9cbc826-primary.xml.gz"/>
  <timestamp>1378307490</timestamp>
  <size>5564</size>
  <open-size>44573</open-size>
</data>
<data type="primary_db">
  <checksum type="sha256">205eac411a1dba2236cd119fa8764acd936d56246ded00554fc062f21f9dfde2</checksum>
  <open-checksum type="sha256">529fa01e6b779327c479c5672ef5f772cf74a1ed41248d96656b71727a78de28</open-checksum>
  <location href="repodata/205eac411a1dba2236cd119fa8764acd936d56246ded00554fc062f21f9dfde2-primary.sqlite.bz2"/>
  <timestamp>1378307491.49</timestamp>
  <database_version>10</database_version>
  <size>13388</size>
  <open-size>60416</open-size>
</data>
<data type="other_db">
  <checksum type="sha256">aafe995e1b43bab0e31c9e3ac18e7c19c135b8fb7e610fd2bc4e373fca1b9b0d</checksum>
  <open-checksum type="sha256">67ff18ce997ae28ce8a37f02690335f9b4a2cbb2b15a04e2445c57c083ebae86</open-checksum>
  <location href="repodata/aafe995e1b43bab0e31c9e3ac18e7c19c135b8fb7e610fd2bc4e373fca1b9b0d-other.sqlite.bz2"/>
  <timestamp>1378307491.09</timestamp>
  <database_version>10</database_version>
  <size>3434</size>
  <open-size>12288</open-size>
</data>
<data type="other">
  <checksum type="sha256">56acb6bf37342b128d978cd212b5c53971171f4fc4131835c1e83dc0e2739d37</checksum>
  <open-checksum type="sha256">5744768fe6e9da28da15d8a6c16e0a8fe81814841cbd8e5558df4d20fa17eb7c</open-checksum>
  <location href="repodata/56acb6bf37342b128d978cd212b5c53971171f4fc4131835c1e83dc0e2739d37-other.xml.gz"/>
  <timestamp>1378307490</timestamp>
  <size>2123</size>
  <open-size>7205</open-size>
</data>
<data type="filelists_db">
  <checksum type="sha256">d4df097584a4eeaa78a0b058034712afa8c14159cfd23eaba91eddab7b5cf5d2</checksum>
  <open-checksum type="sha256">af9ebb16774de006562ddb5dbdde930bbae2292c3bfd865cb25b2b3767b2dd0b</open-checksum>
  <location href="repodata/d4df097584a4eeaa78a0b058034712afa8c14159cfd23eaba91eddab7b5cf5d2-filelists.sqlite.bz2"/>
  <timestamp>1378307491.44</timestamp>
  <database_version>10</database_version>
  <size>96152</size>
  <open-size>678912</open-size>
</data>
</repomd>
[root@localhost ~]#

[joeainsworth]

I have the same problem.

is there problem with cactiz repo?

Code: Select all

[root@localhost ~]# yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.prometeus.net
 * extras: mirrors.prometeus.net
 * updates: mirrors.prometeus.net
http://mirror.cactiusers.org/RPMS/CentOS/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 403 Forbidden"
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: CactiEZ. Please verify its path and try again

Code: Select all

[root@localhost ~]# wget http://mirror.cactiusers.org/RPMS/CentOS/x86_64/repodata/repomd.xml
--2013-09-06 14:21:53--  http://mirror.cactiusers.org/RPMS/CentOS/x86_64/repodata/repomd.xml
Resolving mirror.cactiusers.org... 209.189.228.151
Connecting to mirror.cactiusers.org|209.189.228.151|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2990 (2.9K) [text/xml]
Saving to: “repomd.xmlâ€

100%[==================================================================================================================================================================================>] 2,990       --.-K/s   in 0s

2013-09-06 14:21:54 (153 MB/s) - “repomd.xml†saved [2990/2990]

Code: Select all

[root@localhost ~]# cat repomd.xml
<?xml version="1.0" encoding="UTF-8"?>
<repomd xmlns="http://linux.duke.edu/metadata/repo" xmlns:rpm="http://linux.duke.edu/metadata/rpm">
 <revision>1378307488</revision>
<data type="filelists">
  <checksum type="sha256">63ac227e65f04ed403d54c4732712b096b0635996ad976f0a8082c581357a845</checksum>
  <open-checksum type="sha256">58f9d07fb31edf233b4789953d4a33a0a8db88b40272ef001b77c7182b8befc2</open-checksum>
  <location href="repodata/63ac227e65f04ed403d54c4732712b096b0635996ad976f0a8082c581357a845-filelists.xml.gz"/>
  <timestamp>1378307490</timestamp>
  <size>111667</size>
  <open-size>1694681</open-size>
</data>
<data type="primary">
  <checksum type="sha256">76eb15903f839a85da987e9bcd4bc9f4a03ead00c27ba6d4b30f22c6c9cbc826</checksum>
  <open-checksum type="sha256">5bdf247aefc9e949e255d647604b62c5dd84b2a737ab76a4366c530eca2a2351</open-checksum>
  <location href="repodata/76eb15903f839a85da987e9bcd4bc9f4a03ead00c27ba6d4b30f22c6c9cbc826-primary.xml.gz"/>
  <timestamp>1378307490</timestamp>
  <size>5564</size>
  <open-size>44573</open-size>
</data>
<data type="primary_db">
  <checksum type="sha256">205eac411a1dba2236cd119fa8764acd936d56246ded00554fc062f21f9dfde2</checksum>
  <open-checksum type="sha256">529fa01e6b779327c479c5672ef5f772cf74a1ed41248d96656b71727a78de28</open-checksum>
  <location href="repodata/205eac411a1dba2236cd119fa8764acd936d56246ded00554fc062f21f9dfde2-primary.sqlite.bz2"/>
  <timestamp>1378307491.49</timestamp>
  <database_version>10</database_version>
  <size>13388</size>
  <open-size>60416</open-size>
</data>
<data type="other_db">
  <checksum type="sha256">aafe995e1b43bab0e31c9e3ac18e7c19c135b8fb7e610fd2bc4e373fca1b9b0d</checksum>
  <open-checksum type="sha256">67ff18ce997ae28ce8a37f02690335f9b4a2cbb2b15a04e2445c57c083ebae86</open-checksum>
  <location href="repodata/aafe995e1b43bab0e31c9e3ac18e7c19c135b8fb7e610fd2bc4e373fca1b9b0d-other.sqlite.bz2"/>
  <timestamp>1378307491.09</timestamp>
  <database_version>10</database_version>
  <size>3434</size>
  <open-size>12288</open-size>
</data>
<data type="other">
  <checksum type="sha256">56acb6bf37342b128d978cd212b5c53971171f4fc4131835c1e83dc0e2739d37</checksum>
  <open-checksum type="sha256">5744768fe6e9da28da15d8a6c16e0a8fe81814841cbd8e5558df4d20fa17eb7c</open-checksum>
  <location href="repodata/56acb6bf37342b128d978cd212b5c53971171f4fc4131835c1e83dc0e2739d37-other.xml.gz"/>
  <timestamp>1378307490</timestamp>
  <size>2123</size>
  <open-size>7205</open-size>
</data>
<data type="filelists_db">
  <checksum type="sha256">d4df097584a4eeaa78a0b058034712afa8c14159cfd23eaba91eddab7b5cf5d2</checksum>
  <open-checksum type="sha256">af9ebb16774de006562ddb5dbdde930bbae2292c3bfd865cb25b2b3767b2dd0b</open-checksum>
  <location href="repodata/d4df097584a4eeaa78a0b058034712afa8c14159cfd23eaba91eddab7b5cf5d2-filelists.sqlite.bz2"/>
  <timestamp>1378307491.44</timestamp>
  <database_version>10</database_version>
  <size>96152</size>
  <open-size>678912</open-size>
</data>
</repomd>
[root@localhost ~]#

[techextras]

{edit} - moving to it's own topic

[thanhd]

I've just registered so I can post this!

For those of you who have the problem with

I did a fresh install and found that the username and password was not correct for cactiuser.
Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'cactiuser'@'localhost' (using password: YES) in /var/www/html/lib/adodb/drivers/adodb-mysqli.inc.php on line 83 Can not connect

This is how to fix!

USing webmin fix up the permission for the cactiuser so it has access to the cacti database database (SELECT, UPDATE, INSERT, DELETE).

Then edit ALL the below files and make sure the username and password for the cacti use is correct. I have no idea why the password needs to be in so many places!!!

include/config.php & include/global.php

$database_username = "cactiuser";
$database_password = "password goes here";

plugins/syslog/config.php

if (!$use_cacti_db) {
$syslogdb_type = 'mysql';
$syslogdb_default = 'syslog';
$syslogdb_hostname = 'localhost';
$syslogdb_username = 'cactiuser';
$syslogdb_password = 'password goes here';
$syslogdb_port = 3306;
}else{

Hope this helps!

[nandoskid]

So i installed the new version for the first time, and it is fantastic. However i stumbled on a big issue for me, and that is i am seeing ping graphs, but no information is being put on them. I know the box can ping because if i ssh into it, i can ping the destination.

So then i tried to run the below commands, and after doing that it destroyed my whole setup in a way that i am not able to see any graphs at all. You get graph titles and all that, but no graphs.

Please help.

==============================
Several fixes have already been issued for the current CactiEZ. You can ensure that you are up to date by issuing these commands from the command line.

Code: Select all

yum clean all
yum install cactiez-0.7-fixes
yum update

Known Issues:

• resource/script_server/win_services.xml is missing - Fixed in package cactiez-0.7-fixes
• In certain instances, the randomized cactiuser mysql password may not be applied correctly to mysql - Not Verified

[golyaht]

To everyone having this annoying issue with the cacti password:

I had the same issue on my install. After reading the helpful threads on here, there are actually _TWO_ issues (althought I suspect the root cause is the same).

First, the config files seem to revert to cactiuser/cactiuser as the username/pass in the config files. Please follow thanhd's excellent post to clean that up:

I've just registered so I can post this!

For those of you who have the problem with

I did a fresh install and found that the username and password was not correct for cactiuser.
Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'cactiuser'@'localhost' (using password: YES) in /var/www/html/lib/adodb/drivers/adodb-mysqli.inc.php on line 83 Can not connect

This is how to fix!

USing webmin fix up the permission for the cactiuser so it has access to the cacti database database (SELECT, UPDATE, INSERT, DELETE).

Then edit ALL the below files and make sure the username and password for the cacti use is correct. I have no idea why the password needs to be in so many places!!!

include/config.php & include/global.php

$database_username = "cactiuser";
$database_password = "password goes here";

plugins/syslog/config.php

if (!$use_cacti_db) {
$syslogdb_type = 'mysql';
$syslogdb_default = 'syslog';
$syslogdb_hostname = 'localhost';
$syslogdb_username = 'cactiuser';
$syslogdb_password = 'password goes here';
$syslogdb_port = 3306;
}else{

The second step:

Now, when I did step one, it did not resolve the issue. However, here is the password I had in my /root/mysqlpass.txt:

cactiuser : /2HNV1j4


As is the case in a couple previous posts, the password has a '/' in it, which based on the errors I've seen appears to be escaping the PHP scripts. I went back in through webmin and changed the cactiuser password to a password without the '/' in it. (e.g. password). The new password I created I had to go back in to step 1 and modify those files again with this new password. After this was done, a simple /etc/init.d/httpd restart and I was good to go. Restarting the service may not be necessary, but it made me feel good.

Hope this helps everyone!

_G

[vikino]

Hi all,
i've been googling and searching a lot, but no answer...
Where is the Scripts folder placed? I cant find it anywhere, but need to place php in there for Advanced Ping...

Thank you

[HQuest]

Hi all,
i've been googling and searching a lot, but no answer...
Where is the Scripts folder placed? I cant find it anywhere, but need to place php in there for Advanced Ping...

Thank you

/var/www/html/scripts/

[stevenF]

Hi all

bit of a silly question but from a windows person where is the editor.php file kept? looking to create my own weather map and need to enable it.

Thanks

[PacoSS]

Now, when I did step one, it did not resolve the issue. However, here is the password I had in my /root/mysqlpass.txt:

cactiuser : /2HNV1j4


As is the case in a couple previous posts, the password has a '/' in it, which based on the errors I've seen appears to be escaping the PHP scripts. I went back in through webmin and changed the cactiuser password to a password without the '/' in it. (e.g. password). The new password I created I had to go back in to step 1 and modify those files again with this new password. After this was done, a simple /etc/init.d/httpd restart and I was good to go. Restarting the service may not be necessary, but it made me feel good.

Hope this helps everyone!

That was! The auto-generated password of my THREE fresh installs in a virtual machine have it.

Big thanks!

[wesleyw]

How would I go about upgrading to 0.8.8b is this possible with your CactiEZ installed with all the plugins?

Thanks,

Wes

[bangolio]

My server doesn't have Internet access, any chance to get a fixes tarball?

Thanks in advance!

[v101]

CactiEZ users.
Has anyone done an upgrade of network weathermap to ver. 0.97c ?
if so can you post some instructions on how you did it and got it working?

It would help out