You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.

Forum Discussion

rjkg's avatar
rjkg
Explorer | Level 4
2 years ago

iCloud blocking file in Dropbox

An app that I wrote for our club accesses an SQLite DB file in our Dropbox.

Most members have no trouble.

One member uses iCloud and gets "permission denied ' when he tries to access this DB.

The DB file sometimes has a small cloud symbol next to it. Hovering on this pops up a "file not downloaded" message. Clicking on it frees up the DB file for use by the app.

 

The info on the file shows it is actually  in : ~user/Library/CloudStorage/....

 

There is no reference to Dropbox in the Settings->iCloud->Applications using iCloud  section of settings (as shown in the iOS discussion re iCloud and Dropbox) .

How can I stop iCloud interfering with this file as Dropbox is already an adequate backup?

 

  • Hey rjkg, sorry to jump in, but I just wanted to mention that 'available offline' files will still sync normally. 

     

    For more information about online only and available offline files, you can take a look here.

     

    As for the user who's getting the error, could you check if they've granted Dropbox full disk access as outlined here

  • Hannah's avatar
    Hannah
    Icon for Dropbox Staff rankDropbox Staff

    Hey rjkg, thanks for reaching out to us.

     

    Can you send us a screenshot of the error message this member is receiving?

     

    Is this an API app that you've created?

     

    Also, what's the Dropbox version and the OS version of this person's computer?

     

    Let me know and we'll go from there.

    • rjkg's avatar
      rjkg
      Explorer | Level 4

      The error message is (error caught by my code within Tcl) :

      authorization denied

      authorization denied

          while executing

      "sqlite3 dbcmd $SQLITEDB  -create 0"

          (procedure "login_ok" line 45)

          invoked from within ....

       

      Dropbox version: 178.4.4811

      MacOS : Ventura 13.4.1 

       

      This is what he sees in Settings - no mention of Dropbox - 2 screenshots as the list goes to 2 screens :

      The app is a user interface to a membership management database. The database itself is a single SQLite file, in Dropbox.

      Sorry about the delay I had to wait for the member to reply with the details.

       

      rjkg

       

       

      • Megan's avatar
        Megan
        Icon for Dropbox Staff rankDropbox Staff

        Hi rjkg, sorry to jump in here! 

         

        Can you let me know the file path of the SQLite file? 

About Apps and Installations

Have a question about a Dropbox app or installation? Reach out to the Dropbox Community and get solutions, help, and advice from members.

Need more support

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!