Problem:
What's causing this database creation error when I try to log into LANrev via the admin console?
Solution:
For performance reasons the LANrev admin console keeps a local copy of the LANrev databases and regularly synchronizes with the LANrev server when there are changes on the server.
This can cause problems if you are using a Mac OS X network account. The admin console is unable to log you in because it is unable to create the databases for the admin console on the file server where your network user account's home folder resides. AFP servers/network volumes do not support some of the file operations that SQLite (the embedded database used by LANrev) needs.
To be able to log into the LANrev admin console with a network account you must redirect where the admin console stores its databases to a local path. Edit the "~/Library/Preferences/com.poleposition-sw.lanrev_admin.plist" file in your network home folder and add the following key.
DatabaseDirectory - String - <path_on_local_hard_disk>
Where <path_on_local_hard_disk> is something like "/Users/<short_username>/Library/Application Support/LANrev Admin/Database".
Replace <short_username> with the short user name for your account. If the folder doesn't exist it will be created by the LANrev admin console. Also remember to set the correct access permissions for the /Users/<short_username> directory so that only the intended user has access to this folder.
In some configurations the /Users folder may actually point to a network volume. If that's the case you will need to point DatabaseDirectory to some other custom local path such as "/LANrev users/<short_username>/LANrev Admin/Database". You may receive the following error message if the current user account does not have sufficient access to create the specified folder at that location - "Internal LANrev Error. An exception of type CP_OSErrorException occurred. {-5000}". In this case you need to either give the user sufficient access privileges to create the folder at that path or create it for them ahead of time and give them read/write access.
Future versions of LANrev will automatically detect if you are using a network account and prompt you to pick a different database location on the local hard disk.
Date: 9 Apr 2008
Revised: 30 Sep 2008
Components: Admin
Version: All Versions
