Technote 032

Database creation error when logging into admin console

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. Remember to set the correct access permissions for the the /Users/<short_username> directory so that only the intended user has access to this folder.

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: 2008 Apr 9
Revised: n/a
Components: Admin
Versions: All

Related Links

Technote 032

Database creation error when logging into admin console

Problem:

Solution: