Cannot submit file: table tasks has no column named file_path

[thevidocq]

Hi, I have this error:

Dec 2 09:43:31 xx postfix/smtpd[2686]: connect from mail-ot0-f178.google.com[74.125.82.178] Dec 2 09:43:31 xx postfix/smtpd[2686]: 716AEFEE25: client=mail-ot0-f178.google.com[74.125.82.178] Dec 2 09:43:31 xx postfix/cleanup[2692]: 716AEFEE25: message-id=CALHN9jeBkhFGpvS_5pJZJj_+rORAAvJqitFHikyZVrsspXKrhg@mail.gmail.com Dec 2 09:43:31 xx postfix/qmgr[2684]: 716AEFEE25: from=[email protected], size=18741, nrcpt=1 (queue active) Dec 2 09:43:31 xx postfix/smtpd[2686]: disconnect from mail-ot0-f178.google.com[74.125.82.178] Dec 2 09:43:32 xx cuckoomx[2731]: Processing mail from: [email protected]> (asd) Dec 2 09:43:32 xx cuckoomx[2731]: DEBUG: processURLs(/home/cuckoo/quarantine/2731/content.tmp) Dec 2 09:43:32 xx cuckoomx[2731]: Dumped: "/home/cuckoo/quarantine/2731/msg-2731-1.txt" (text/plain) Dec 2 09:43:32 xx cuckoomx[2731]: Dumped: "/home/cuckoo/quarantine/2731/msg-2731-2.html" (text/html) Dec 2 09:43:32 xx cuckoomx[2731]: Dumped: "/home/cuckoo/quarantine/2731/doc.docx" (application/vnd.openxmlformats-officedocument.wordprocessingml.document) Dec 2 09:43:32 xx cuckoomx[2731]: Files to process: 1 Dec 2 09:43:32 xx cuckoomx[2731]: Cannot submit file: table tasks has no column named file_path Dec 2 09:43:32 xx postfix/pipe[2693]: 716AEFEE25: to=[email protected], relay=cuckoomx, delay=1.1, delays=0.14/0/0/0.95, dsn=4.3.0, status=deferred (temporary failure. Command output: DBD::SQLite::db selectrow_arrayref failed: no such column: md5 at /home/cuckoo/cuckoomx/cuckoomx.pl line 325. DBD::SQLite::db do failed: table tasks has no column named file_path at /home/cuckoo/cuckoomx/cuckoomx.pl line 331. )

can you help me? Cuckoo Version | 2.0.4

Thanks!

[icepaule]

Hi Xavier (@xme ) , in the meanwhile I've tried to adopt the setup for postgres but it just throws an equal error message. I assume cuckoo has changed the DB setup since you created this cool tool.

Is ist still working at your end anyway? If not and if you'd be interested on getting it to work again, I'd go through the proggi and check if I could adopt the new DB schema for it.

Cheers Marcus

[FK79]

Hi,

a little late response here. I'm working with Cuckoo for a few weeks now and wanted to get CuckooMX working with 2.0.7 It seems that the database tables at Cuckoo 2.0.7 are totally different to the older, with CuckooMX working versions. I changed the perlscript. Now the files are submited to the API and not directly in the database. So Cuckoo API server has to be running. In line 317 you have to change the password for your API server.

It was the first time for me to program something in perl, so maybe it can be optimized :-) But for me the script is working now.

cuckoomx.zip