# readceb
A C program and a perl script to extract logs from a CEB backup file
from conversations.

## How-To
Compile `readceb.c` with OpenSSL, and run it with the first parameter
the CEB file and the 2nd parameter the output sqlgz file.

```
./readceb backup.ceb backup.sqlgz
```

It will prompt you for the account password. Then, you can use `gz` to
uncompress the file.

## Converting to TXT
You can use `sqlite3` to create a db:
```
$ sqlite3 backup.db
> .read schema.sql
(if using Cheogram)
> attach database 'backup-cheogram.db' as cheogram;
> .read cheogram.sql
> .read backup.sql
```

Then, you can use the Perl script to create a hierarchy of
date-organized logs:

```
$ perl sql2txt.pl backup.db
```

# Caveats
The C program is rough around the edges. The gz file will come with some
corruption on the end that doesn't seem to affect the resultant file.

Also, the perl program doesn't handle special cases like incoming or
outgoing calls. Nevertheless, this is a useful tool if ceb2txt has not
been working for you.

The perl program uses DBD::Sqlite, DBI, Modern::Perl, and DateTime.