Knowledge Base: 2009, 8.0.x
Results
Known issues for Asset Trustee 8.0.4 and older
Asset Trustee Inventory 8.0.4
December 18, 2008
Upgrading to OSX 10.5.6 breaks the Asset Trustee PHP scripts on G5 Macs
Workaround: after upgrading to 10.5.6, re-run the AT Inventory installer.
Inventory DB Import/Export
Export
Download and double-click on this tool to copy (export) your Asset Trustee database manually.
Import
Download and double-click on this tool to import an exported .sql file into your AT Database. This will replace the current database.
How to uninstall Asset Trustee
To uninstall Asset Trustee, delete the following files/folders associated per component.
Asset Trustee Inventory
Folders:
/Asset Trustee DataFolder
/Library/Reiceipts/AssetTrusteeInvenotory.pkg
/Library/WebServer/Documents
/Library/WebServer/imports
/Library/WebServer/ioncube
/Library/WebServer/lib
/Library/WebServer/logs
/Library/WebServer/prefs
/Library/WebServer/reports
/Library/WebServer/scans
Reset MySQL root password
For instructions on how to reset the MySQL root password, please see:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Access the Inventory database through ODBC (Excel, Crystal Reports, etc.)
Configuring Inventory for OBDC queries.
In order to access your mySQL Inventory database through OBDC, you'll have to configure both the Inventory computer and the accessing (client) computer.
On the Inventory computer, configure mySQL for remote access. By default, mySQL will only allow the root@localhost user to access the mySQL database. To allow remote access to a user, do the following.
Asset Trustee automated database backup
The Asset Trustee database contains valuable information, is easy to back up, and takes very little space. In short, there's virtually no reason not to back up your AT database periodically. This article will describe the steps to create an automated Asset Trustee database backup solution.
First, download this Script.
Migrating from MySQL 4.x to 5.x
If you have MySQL 4.x from a previous version of Inventory, you must upgrade to MySql 5.x.
