Unable to make changes to .xdb hosted on network share with linux client

[mattjudson]

I have long used XCA on windows and for safety and secure purposed our .xdb database is hosted on a network share.

Recently I install Linux mint and then installed XCA ....then I was able to open our .xdb XCA Database hosted on my network shar. I was not able to do any work like import CSR's or delete CSR's or make any changes to the database. Attempting to import a CSR allows to choose the file then while it appears to work nothing was actaully imported.....Oddly No error or message is ever shown, it just doens't do anything. At first i thought it was a refresh issue so i closed and opened XCA but still no CSR.

I was able to Copy the .XDB DB file from the network share to my desktop and then open that locally and then that allowed me to import the CSR in XCA to the DB.... Then I copied the .XDB back to the Server/Share. but this extra copy paste behaviour to and from the network share is not ideal on linux and is definitely not required in the windows version of the SW

This appears to show that for some reason the linux XCA application isn't able to navigate/handle change to a .XDB database that is hosted on a network share. There also appears to be no error indication of a problem leaving the user hanging like what happened.

[Wernfried]

See SQLite Over a Network, Caveats and Considerations

Summary
Choose the technology that is right for you and your customers. If your data lives on a different machine from your application, then you should consider a client/server database. SQLite is designed for situations where the data and application coexist on the same machine. SQLite can still be made to work in many remote database situations, but a client/server solution will usually work better in that scenario.

In your case it would be better to switch to a MySQL database.