Monday, March 27, 2006

FOSS Inventory tool for Windows -- OCS

Debian and Ubuntu installation walk-through of ocsinventory. My contribution is to use 'sudo cpan -i XML::Simple Compress::Zlib DBI DBD::mysql DBD::mysql Apache::DBI'

OCSInstallation - Tomas3 - Trac

This is the errors that I received when I didn't have the cpan modules installed:
MySql config file successfully written
ERROR: query failed
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP,
PRIMARY KEY (MAC),
INDEX IP (IP),
(err:1064)

ERROR: query failed
mysql error: Specified key was too long. Max key length is 500 (err:1071)

ERROR: query failed
mysql error: Specified key was too long. Max key length is 500 (err:1071)

ERROR: query failed
mysql error: Table 'ocsweb.netmap' doesn't exist (err:1146)

ERROR: query failed
mysql error: Table 'ocsweb.netmap' doesn't exist (err:1146)

ERROR: query failed
mysql error: Table 'ocsweb.netmap' doesn't exist (err:1146)

ERROR: query failed
mysql error: Table 'ocsweb.netmap' doesn't exist (err:1146)

Updating existing database
ERROR: The installer ended unsuccessfully, rerun install.php once problems are corrected

F/OSS Lessons:

Let this be another lesson for open source evangelism: Don't ever allow someone to install an older version of a product.

I was asked to install the older version of ocsinventory because the original version used all Microsoft products, MSsql server and built using Visual Basic. This worked pretty well for us but gave everybody the impression that the product sucked. It was difficult to convince my team to upgrade to the LAMP stack version (called ocsinventory-ng) because it wasn't worth putting more time into inventory. In fact, we ended up purchasing Microsoft's SMS 2003 license to replace the ocsinventory product.