Tools

Cannot create a file sharing link in Serv-U with error "SQLite error encountered: attempt to write a readonly database"

This article shows how to resolve an issue where a Serv-U user is not able to create a file sharing link. The attempt instead results in the following error: "SQLite error encountered: attempt to write a readonly database"

First published date

7/22/2020 2:23 PM

Last published date

10/1/2020 7:03 AM

Overview


Serv-U user cannot create a file sharing link, either through Request File or Send File.
The Serv-U logs will show entry below: 
File sharing maintenance (expire): SQLite error encountered: attempt to write a readonly database
SQLlite error encountered during command HTTP_CREATE_FILE_SHARE; error string: "attempt to write a readonly database"

Product section

Serv-U Managed File Transfer & Serv-U FTP Server

Cause

  • There's some corrupt data in the file sharing database.
  • Service account permission

Resolution

There are 2 options: 
  1. Add the Service account into the Local admin group
  2. Delete the current file sharing database.
For Windows:
  • Go to C:\ProgramData\RhinoSoft\Serv-U\Shares folder and delete all three files.
  • Restart the Serv-U service.
For Linux:
  • Go to /usr/local/Serv-U/Shares folder and delete all three files.
  • Restart the Serv-U service.
Note: This will delete all the current file sharing links and history for all Serv-U users.