OCS Inventory NG

www.ocsinventory-ng.org
Open source network and asset management tracking software with remote agents. I particularly wanted to accurately know what software was currently installed at any given time on the laptops in the checkout pool. Adding all the computers has become extremely useful.

Installation based on RedHat instructions on
http://blog.famillecollet.com/pages/OCS-GLPI-en

1. Install MySQL Server apt-get install mysql-server Change the root password: # mysql --user root mysql> UPDATE mysql.user SET Password = PASSWORD('rootsecret') WHERE User = 'root'; mysql> FLUSH PRIVILEGES; mysql> exit
2. Install OCSInventory apt-get install ocsinventory-server Recommended running apt-get autoremove
   

   Gave DB password and set OCS user DB password via install

3. Open up a browser to http://myOCSserver/ocsreports/install.php
   Make sure that you click on a language icon!
   
   

   Links:
   blog.famillecollet.com - OCS and GLPI installation guide
   www.ocsinventory-ng.org - Agent does not send inventory to server!
   blog.famillecollet.com - Better English Icon?
   

4. Backup mySQL database
   Use mysqldump to create a dump file that will contain all the SQL statements needed to create the table and populate the table in a new database server. $ mysqldump -u root -h localhost -pmypassword ocsweb | gzip -9 > ocsweb-db.sql.gz Restore with mysql ocsweb < ocsweb-db.sql

   Links:
   How to backup MySQL databases, web server files to a FTP server automatically