Unofficial, Unsupported Cacti Install Guide

Emab · Jan 22, 2006, 9:23 PM

Hi,
I start ti test, but I stop the install procedure here:

# mysql_install_db
Installing all prepared tables
/libexec/ld-elf.so.1: Shared object "libstdc++.so.5" not found, required by "mysqld"
Installation of system tables failed!

Examine the logs in /var/db/mysql for more information.
You can also try to start the mysqld daemon with:
/usr/local/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/local/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/db/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/local/bin/mysqlbug script!
#  /usr/local/bin/mysql -u root mysql
/libexec/ld-elf.so.1: Shared object "libstdc++.so.5" not found, required by "mysql"

And the pfSense get corrupted:

Warning: main(config.inc): failed to open stream: No such file or directory in /etc/rc.banner on line 34

Fatal error: main(): Failed opening required 'config.inc' (include_path='.:') in /etc/rc.banner on line 34

 pfSense console setup
***********************
 0)  Logout (SSH only)
 1)  Assign Interfaces
 2)  Set LAN IP address
 3)  Reset webGUI password
 4)  Reset to factory defaults
 5)  Reboot system
 6)  Halt system
 7)  Ping host
 8)  Shell
 9)  PFtop
10)  Traffic Logs
11)  Restart webConfigurator

Enter an option:

And the webgui is not running:

Warning: main(auth.inc): failed to open stream: No such file or directory in /usr/local/www/guiconfig.inc on line 45

Fatal error: main(): Failed opening required 'auth.inc' (include_path='.:') in /usr/local/www/guiconfig.inc on line 45

Could you help me?

Thanks!

sullrich · Jan 22, 2006, 9:34 PM

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

Emab · Jan 22, 2006, 10:02 PM

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 · Jan 22, 2006, 10:51 PM

My pfSense test machine become unusable…

Where is the problem in the procedure?

cmb · Jan 23, 2006, 12:50 AM

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 · Jan 23, 2006, 1:48 AM

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 · Jan 23, 2006, 10:23 AM

@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 · Jan 23, 2006, 10:24 AM

@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 · Jan 24, 2006, 4:19 AM

@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 · Jan 24, 2006, 3:49 PM

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 · Jan 24, 2006, 10:30 PM

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 · Jan 24, 2006, 10:59 PM

@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 · Jan 24, 2006, 11:54 PM

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 · Jan 25, 2006, 12:07 AM

@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 · Jan 25, 2006, 12:27 AM

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

pkg_add -r mysql41-server

cmb · Jan 25, 2006, 12:39 AM

@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 · Jan 25, 2006, 9:26 AM

@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 · Jan 26, 2006, 6:29 PM

No news?

sullrich · Jan 26, 2006, 8:54 PM

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

Emab · Jan 26, 2006, 10:14 PM

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