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('secret') 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.
   
   Note: OCS stores them in plaintext in /var/lib/ocsinventory-server/config/dbconfig.inc.php and the symlinks in /usr/share/ocsinventory-server/ocsreports/ and /etc/ocsinventory.

3. Test Web Interface

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

   You can modify many of the defaults by editing /usr/share/ocsinventory-server/ocsreports/preferences.php. Here are some examples:

   getBrowserLang didn't seem to be working so we hard coded it to use english (the original line followed by change): $_SESSION["fichLang"] = new FichierConf(DEFAULT_LANGUAGE?DEFAULT_LANGUAGE:getBrowserLang()); $_SESSION["fichLang"] = new FichierConf(english); You can change the default columns and labels by editing the currentFieldList array: $_SESSION["currentFieldList"] = array ( "a.".TAG_NAME=>TAG_LBL,"h.name"=>$l->g(23), "a.employee"=>"Employee","h.ipaddr"=>$l->g(34), ...);

   The 23 in "h.name"=>$l->g(23) represents number 23 in /usr/share/ocsinventory-server/ocsreports/languages/languagefile.txt. You can also statically define the column heading as in "a.employee"=>"Employee".

   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 on OCS Server

   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 user -h localhost -psecret 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

5. Install Windows Agents

   The windows executable (.EXE file) is available from the OCS website. OCSPackager can be used to create ocspackage.exe which will run OcsAgentSetup.exe with predefined installation options so that no user interaction is required for the install.
   
   OcsAgentSetup.exe /S /server:myserver /now

   I used a logon script to deploy this but you could also use psexec to push it to one or all the PC's on the LAN using a wildcard:

   psexec \\PC1 -c \\Server1\Netlogon\ocspackage.exe psexec \\* -c \\Server1\Netlogon\ocspackage.exe

   Links:
   www.ocsinventory-ng.org - 1.02.1 Download Page
   wiki.ocsinventory-ng.org - ocsPackager Instructions