Unofficial, Unsupported Cacti Install Guide

sullrich

That was fixed yesterday. The next testing version will include this lib.

Emab

I haven't read all the guide….

Libraries Fix

pfSense has stripped many of the FreeBSD libraries for size reasons, and because they aren't necessary for the firewall to function. For MySQL to work, you'll need the libstdc++.so.5 library file from a FreeBSD 6.0 box. If you don't have a FreeBSD 6 box, I have made this library available for download. Just run the following:

cd /usr/lib && fetch http://chrisbuechler.com/papers/pfsense/cacti/libstdc++.so.5

If you have a FreeBSD 6.0 box, you can copy this file from /usr/lib over to /usr/lib on your pfSense box.

So I go ahead…
But I stop here:

> ps ax | grep mysql
 2429  p0  I      0:00.06 /bin/sh /usr/local/etc/rc.d/mysql-server.sh start
 2436  p0  I      0:00.06 su -m mysql -c sh -c "/usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql -
 2437  p0  I      0:00.04 /bin/sh /etc/rc.initial -c sh -c "/usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/va
 2508  p0  R+     0:00.00 grep mysql
> mysqladmin create cacti
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

And I have alway the same corrupted pfSense menu…

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