Unofficial, Unsupported Cacti Install Guide

cmb

This is why it says "UNOFFICIAL, UNSUPPORTED". It could break stuff. It worked for me, but YMMV.

I noticed that I put the library fix at the wrong spot (which is why you had issues with mysql_install_db). It needs to be done earlier in the process. That's fixed now.

Did you properly configure Apache to listen on a different port? check the Listen line in /usr/local/etc/apache/httpd.conf

cmb

I just realized this doesn't fully work. The GUI works, but the graphs don't get created due to a PHP/MySQL issue. Looking at it now. You should still be able to make it through the guide, the graphs just won't be created

Emab

@cmb:

This is why it says "UNOFFICIAL, UNSUPPORTED". It could break stuff. It worked for me, but YMMV.

I know… :) infact I test CACTI on my test virtual machine… ;)

@cmb:

I noticed that I put the library fix at the wrong spot (which is why you had issues with mysql_install_db). It needs to be done earlier in the process. That's fixed now.

Ok I've alredy found that, and just correct done the correct procedure…but sothing else is wrong on a clean pfSense installation...

@cmb:

Did you properly configure Apache to listen on a different port? check the Listen line in /usr/local/etc/apache/httpd.conf

I've checked but I think that should be ok… I also tried to chage

#
# Port: The port to which the standalone server listens. For
# ports < 1023, you will need httpd to be run as root initially.
#
Port 81

to be sure that Apache listen to a different port…

This is correct?

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <virtualhost># directive.
#
#Listen 3000
#Listen 12.34.56.78:80
Listen 10.0.0.7:81</virtualhost>

Why is pfSense broken?

Thanks for help!

Emab

@cmb:

I just realized this doesn't fully work. The GUI works, but the graphs don't get created due to a PHP/MySQL issue. Looking at it now. You should still be able to make it through the guide, the graphs just won't be created

As I told before…my problem is before the Graph creation.... :(

cmb

@Emab:

to be sure that Apache listen to a different port…

This is correct?

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <virtualhost># directive.
#
#Listen 3000
#Listen 12.34.56.78:80
Listen 10.0.0.7:81</virtualhost>

yeah, that looks fine. not sure why it's blowing up. Does it work with apache stopped?

Emab

I want to do some more test to identify the problem….but CACTI is no longher downloadable:

# pkg_add -r cacti
Error: FTP Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6-stable/Latest/cacti.tbz: File unavailable (e.g., file not found, no access)
pkg_add: unable to fetch 'ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6-stable/Latest/cacti.tbz' by URL

Why?

PS: I try to connect with an FTP client, but I can't find CACTI on that server…. :(

sullrich

I've been building a package set for cacti and will upload soon.

Please note that it builds a custom php! This WILL wipe out pfSense.

So you need to backup /usr/local/bin/php /root/php and restore after pkg_add -r.

Will post a url to pacjkage set shortly when the build is done and copied up.

Emab

@sullrich:

I've been building a package set for cacti and will upload soon.

Please note that it builds a custom php! This WILL wipe out pfSense.

So you need to backup /usr/local/bin/php /root/php and restore after pkg_add -r.

Will post a url to pacjkage set shortly when the build is done and copied up.

I tried to back up the file before load cacti, but I can't find /root/php…

And I get always this:

# pkg_add -r cacti
Error: FTP Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6-stable/Latest/cacti.tbz: File unavailable (e.g., file not found, no access)
pkg_add: unable to fetch 'ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6-stable/Latest/cacti.tbz' by URL

sullrich

From a shell:

Back up file

cp /usr/local/bin/php /root/

Install CACTI

pkg_add -r http://www.pfsense.org/packages/All/cacti-0.8.6h_4.tbz

Restore file

cp /root/php /usr/local/bin/php

Emab

@sullrich:

From a shell:

Back up file

cp /usr/local/bin/php /root/

Install CACTI

pkg_add -r http://www.pfsense.org/packages/All/cacti-0.8.6h_4.tbz

Restore file

cp /root/php /usr/local/bin/php

This procedure replace all the procedure posted before?

Emab

I tried to go ahead…but I can't download MySQL server:

pkg_add -r mysql41-server

cmb

@sullrich:

Please note that it builds a custom php! This WILL wipe out pfSense.

I was wondering if that was a possiblity, but doing exactly as I described in that document, my pfsense box is still working several days later. My cacti isn't though. :) PHP is acting like it doesn't have MySQL support, but it should.

I'll start from scratch and try the pkg Scott uploaded later and will update the documentation accordingly.

Emab

@Emab:

I tried to go ahead…but I can't download MySQL server:
pkg_add -r mysql41-server

I want to go ahead with the installation…but I get:

# pkg_add -r mysql41-server
Error: FTP Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6-stable/Latest/mysql41-server.tbz: File unavailable (e.g., file not found, no access)
pkg_add: unable to fetch 'ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6-stable/Latest/mysql41-server.tbz' by URL
#

Emab

No news?

sullrich

This REALLY is not a priority for us. Atleast it isn't for me.

Emab

@sullrich:

This REALLY is not a priority for us. Atleast it isn't for me.

Yes I know that this is not a priority for the pfSense team… No problem...

I ask only why I can't download mySQL serve package....