mattsta / signal-backup

Archive your Signal conversations to immutable storage (project abandoned, but feel free to use as reference if it helps)
71 stars 58 forks source link

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

Open ChristopherA opened 4 years ago

ChristopherA commented 4 years ago

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 commented 4 years ago

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

ekkis commented 4 years ago

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 commented 4 years ago

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

brummski commented 4 years ago

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

lol-fi commented 4 years ago

@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 commented 4 years ago

@mattsta, can we get these permanently commented out?

lol-fi commented 4 years ago

@mattsta, can we get these permanently commented out?

why not make a pull request?

501st-alpha1 commented 3 years ago

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.