Error: 'Operation not permitted' | 'You don’t have permission to save the file “Applications” '

[aljrico]

Hi! Excuse me if this something too simple to ask. I'm setting up a simple database with GRDB and I'm faced with the error Operation not permitted.

I think the error is triggered when I try to use the FileManager.default.url. I'm aware this might not be specific to GRDB, but I thought perhaps some of you have encountered this issue and know of a solution.

For context, this is the full error message:

🆘 DATABASE ERROR
Error Domain=NSCocoaErrorDomain Code=513 "You don’t have permission to save the file “Applications” in the folder “C870658A-6366-4C37-BD8E-A6146B4F09DF”." UserInfo={NSURL=file:///var/mobile/Containers/Data/Application/C870658A-6366-4C37-BD8E-A6146B4F09DF/Applications, NSFilePath=/var/mobile/Containers/Data/Application/C870658A-6366-4C37-BD8E-A6146B4F09DF/Applications, NSUnderlyingError=0x1026e44c0 {Error Domain=NSPOSIXErrorDomain Code=1 "Operation not permitted"}}

And the piece of code I'm using to trigger the error

    var migrator: DatabaseMigrator {
        var migrator = DatabaseMigrator()
        migrator.registerMigration("upgrades") { db in
            try db.create(table: "upgradeData") { t in
                t.primaryKey("uuid", .text).notNull()
                t.column("buildingName", .text).notNull()
                t.column("upgradeType", .text).notNull()
                t.column("upgradeTier", .integer).notNull()
                t.column("owned", .boolean).notNull()
                t.column("building", .text).notNull()
            }
        }
        
#if DEBUG
        migrator.eraseDatabaseOnSchemaChange = true
#endif
        return migrator
    }
    
    func setup() throws {
        let databasePath: String = "upgradesTest.sqlite"
        let url = try FileManager.default
            .url(
                for: .applicationDirectory,
                in: .userDomainMask,
                appropriateFor: nil,
                create: true
            )
            .appendingPathComponent(databasePath)
        let databaseQueue = try DatabaseQueue(path: url.path())
        try migrator.migrate(databaseQueue)
        self.db = databaseQueue
    }
    init() {
        do {
            try self.setup()
        } catch {
            print("🆘 DATABASE ERROR")
            print(error)
        }
    }

[groue]

Hello @aljrico,

I'm aware this might not be specific to GRDB

Indeed.

You have to pick a permitted location. There are many. You'll find guidance and recommendations in the documentation for Database Connections, or the demo app.