Knowledge Base: 9.0.x
Results
FileWave Default TCP Listening Port Usage
FileWave TCP/IP Port Usage
By default the FileWave software listens on the TCP/IP ports listed below. These are the defaults and they can be configured to listen on different ports if required.
FileWave Client Ports
20010 TCP/IP for monitor-client communication
FileWave Server Ports
20015 TCP/IP for server-client communication
20017 TCP/IP for server-client secure (SSL) communication
20016 TCP/IP for admin-server communication
Inventory Snow Leopard Compatibility Issues
FileWave Inventory
The current release of FileWave Inventory will not work on a default install of OS X Snow Leopard. This reason for this is that the Inventory component uses the default OS X PHP library. Snow Leopard ships with PHP version 5.3. IonCube in turn has not released a loader for this paticular PHP version.
A workaround would be to downgrade the PHP library to 5.2.6 but it's recomended to simply wait until a new release of Inventory is published which will use a MAMP style server install.
Leopard PHP causes Apache to crash resulting in a number of Inventory UI glitches
During a Leopard 10.5.6 OSX update, a newer version of PHP was installed to the system. Because Inventory 9 uses the OSX version of PHP, a number of things break due to this bug. The fix is to downgrade the PHP library on the server back to what it origionaly was until Apple updates the PHP library to fix the bug.
This issue only affects Leopard users. Tiger users are not effected.
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.
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.