Hello Thomas, have a look at https://bitbucket.org/nikratio/s3ql/src/default/src/s3ql/backends/comprenc.py?fileviewer=file-view-default – that's where compression and encryption is done.
Looks like each block has its own encryption key (derived from the backend passphrase – can be reconstructed with the "nonce" metadata of the block) and encryption happens in chunks (in Counter Mode https://pythonhosted.org/pycrypto/Crypto.Cipher.blockalgo-module.html#MODE_CTR each block resets the counter). You cannot decrypt that easily with openssl. Your best option would be to make a modified version of S3QL (stripped by all the FUSE parts that only is a data downloader and decrypter/decompresser) > thomas denimal <mailto:[email protected]> > 31. August 2016 um 11:53 > Sqlite query > > SELECT datetime(i.mtime_ns / 1E9 , 'unixepoch', 'localtime'),n.name, > 'sql_data_'||b.obj_id FROM contents c > JOIN names n ON n.id = c.name_id > JOIN inodes i ON i.id=c.inode > JOIN inode_blocks ib ON ib.inode=i.id > JOIN blocks b ON b.id=ib.block_id > order by i.mtime_ns; > > => > > return for each file the corresponding sql_data_xxx files. > > Le mardi 30 août 2016 09:31:52 UTC+2, thomas denimal a écrit : > -- > You received this message because you are subscribed to the Google > Groups "s3ql" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "s3ql" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
