Unofficial, Unsupported Cacti Install Guide
-
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 45Could you help me?
Thanks!
-
That was fixed yesterday. The next testing version will include this lib.
-
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…
-
My pfSense test machine become unusable…
Where is the problem in the procedure?
-
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
-
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
-
@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 81to 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!
-
@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.... :(
-
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?
-
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 URLWhy?
PS: I try to connect with an FTP client, but I can't find CACTI on that server…. :(
-
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'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 -
-
-
I tried to go ahead…but I can't download MySQL server:
pkg_add -r mysql41-server -
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.
-
I tried to go ahead…but I can't download MySQL server:
pkg_add -r mysql41-serverI 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 # -
No news?
-
This REALLY is not a priority for us. Atleast it isn't for me.
-
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....