Unofficial, Unsupported Cacti Install Guide



  • I just posted this:
    http://chrisbuechler.com/papers/pfsense/cacti/

    Check it out and let me know what you think.  Let me know if you have any problems, I might have missed a step or something.



  • 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!



  • 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 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!



  • @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.... :(



  • @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?



  • 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….  :(



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



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


  • 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



  • @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?



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

    pkg_add -r mysql41-server
    


  • @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:

    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
    #
    
    


  • No news?



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



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


Locked