Unofficial, Unsupported Cacti Install Guide

[Emab]

My pfSense test machine become unusable…

Where is the problem in the procedure?

[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....