error: pysqlcipher3.dbapi2.DatabaseError: file is not a database

[ChristopherA]

I have already done

brew install sqlcipher
pip3 install pysqlcipher3 --user

However, when I cd to the directory with config.json and run python3 ../scab.py I get:

Traceback (most recent call last):
  File "../scab.py", line 41, in <module>
    c.execute("SELECT json, id, name, profileName, type, members FROM conversations")
pysqlcipher3.dbapi2.DatabaseError: file is not a database

Any suggestions?

[ekkis]

ugh. I just posted about this. should have checked the history. I have the same issue

[ekkis]

the problem is with this compatibility update: https://github.com/mattsta/signal-backup/pull/3 -- if you comment out lines 29-33 of the scab.py it should work. it did for me

[tkrunning]

Thanks @ekkis! That worked for me too, although I had to comment out line 30-33, not 29.

[brummski]

hi! did not work for me, any suggestions? thx

[lol-fi]

@brummski did you try commenting out 30-33 as @tkrunning mentioned? 29-33 for me still caused the error, but 30-33 and it ran perfectly

[ryanpcmcquen]

@mattsta, can we get these permanently commented out?

[lol-fi]

@mattsta, can we get these permanently commented out?

why not make a pull request?

[501st-alpha1]

I just posted in #13 about why this happens; this is probably a SQLCipher version mismatch, and I presume commenting out those lines causes the library to fall back to the default of version 4, which is now what Signal requires.