- Where is UPM's Config File
- Database Syncing
- Export to CSV
- Import from CSV
- How to Add a Trusted HTTPS Certificate
- Problem Running UPM on OS X
Where is UPM's Config File
UPM's configuration file is named upm.properties. It's location it dependant on the version of UPM you're using.
In UPM 1.9 and earlier it's located in your home directory.
In UPM 1.10 and later it's location is dependant on your operating system.
- On Windows it remains in the same location as before, your home directory.
- On OS X it's located in <HOME DIR>/Library/Preferenecs/.
- On Linux it's located in $XDG_CONFIG_HOME/.config. If you've not explicity configured XDG_CONFIG_HOME them it defaults to your home directory so the full path is <HOME DIR>/.config/.
See Database Syncing for an overview of this feature.
To sync from one computer to another save your database file in your Dropbox folder. If you plan to sync to an Android device create the folder
Using a HTTP Server
See Sync Using HTTP for instructions on how to prepare your HTTP server.
There are generally two scenarios you can find yourself in terms of syncing. The first is where you have a password database on your PC that you'd like to upload to your server and make available for syncing to other devices. The second is where there's a password database already on your server and you'd like to sync it to your PC.1. Uploading a database
- Open your database, Database -> Open Database
- Select Database -> Database Properties
- In the URL field enter the URL of your remote location. If you put the upload.php file at http://www.mydomain.com/upm/upload.php then enter http://www.mydomain.com/upm in the URL field. If this URL is password protected with basic authentication then select the account in your database that has the relevant username and password.
- Select Database -> Open Database from URL
- Enter the URL of your database, e.g. http://www.mydomain.com/upm/upm.db. If the URL is protected with basic authentication enter the username and password. When all relevant fields are populated click OK
- The next dialog is titled Save Database As... and is asking where you'd like to save the downloaded database to. Select a dir, enter a file name and click Save.
- Finally, to open the downloaded database you'll be prompted to enter it's master password.
When the text "Revision x - Unsynchronised" appears in red in the status bar this means that your local and remote databases may by out of sync. To synchronise them press the Synchronise button or the select the menu item Database -> Sync with Remote Database. When the databases are in sync the status bar will read "Revision x - Synchronised".
Export to CSVWARNING: Be extremely careful with your exported CSV file. It contains the entire contents of encrypted database in plain text.
- Select Database -> Export
- Enter the name of the file you want to
Import from CSV
The UPM import CSV should be structured as follows,
account name,user id,password,url,notesExample:
flickr,testuser,testpassword,http://www.flickr.com,some test notes
- Open the database you'd like to import the CSV file into
- Select Database -> Import
- Select the CSV file to import and click Open
How to Add a Trusted HTTPS Certificate
NOTE:Since 1.12 you can choose to trust all self signed certificates rather than updating your keystore. While this is a much easier option it's not enabled by default as some may not like the security implications. To enable this setting use the "Accept Self-Signed Certificates" checkbox in the options dialog.
If you use a HTTPS URL for your remote database and the server is using a self signed certificate you may get this error when you try and sync,
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.
What you need to do is add the server's certificate to your trusted certificate keystore. Here's how,
- Open a command prompt and cd to the directory where UPM is installed (on OS X this will be something like <install dir>/UPM.app/Contents/Resources/Java).
- Execute java -classpath upm.jar InstallCert <hostname>. hostname is the host where your database is hosted. e.g. if your db is at https://www.mydomain.com/dir1/upm.db then the hostname is www.mydomain.com
- When prompted hit enter (to accept the default option)
There should now be a file called jssecacerts in the current directory. Move this file into the ./lib/security/ directory of your Java runtime environment. e.g. sudo mv jssecacerts <jre_dir>/lib/security/
On OS X your JRE will be located somewhere like /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home.
On Ubuntu enter update-alternatives --display java to return the full path to your JRE.
Problem Running UPM on OS X
On downloading and running UPM on OS X you may get this error "UPM is damaged and can't be opened. You should move it to trash". There isn't a problem with UPM. It's just OS X's security settings.
There are two ways to resolve this problem.
Option 1: Via System Preferences.
- Open System Preferences
- Open Security & Privacy
- If the lock in the bottom left of this window is closed click it to unlock the settings
- Under "Allow applications downloaded from" select "Anywhere"
- Try opening the version of UPM that was failing previously. If all goes well it should work now.
Option 2: By updating the application's extended attributes directly.
- Open a command window and run,
sudo xattr -d -r com.apple.quarantine /Applications/UPM.app