Title: error importing the photoDNA database - IPED 4.1.5

[danpos]

Good afternoon, I was trying to import the PhotoDNA database into the IPED 4.15 hash base, according to the instructions on the Wiki, but the following error occurred:

ERROR: File PATH-TO-FILE\FILE.txt header must contain at least one hash column.

As I haven't found any additional information about the error and how to fix it, I'm asking how to proceed.

Thank you in advance for your attention.

[wladimirleite]

Hello @danpos!
The way IPED 4 hash database was designed, there must be at least one hash column (MD5, SHA1, SHA256, SHA512 or EDONKEY).
Below is an example of a PhotoDNA file (MD5 was the used hash).

MD5,photoDna,status,set
77AD07C2DA59E42BE3DD868A1429088F,WhY9ONov7S0ppb2WI8WXMw0tQgQiAyUF0Sl0OpTQUv9EmiSvSZMjWBk6IBs4BTgIRGFNRBacDJVGKg6gN0wYey4wFyVaAwwxF/Q1dwOdES8hUg5KXwwIcCkVDkpNCQY3HG4sTxOPUxMDUy8EGAkVGh0LD1oiEQRhEzkwCRZcNRcEaVsDCx1tAwIaWggGEUYU,pedo,LED
14B8602C506A76B4BE04DE8784C920DD,AgERAAcDJwAaBGoANR6uEAFARQgABwMAIwEcALQU6AlTNvwVNpi0QgidTyMADQYAbAMUAu5EOVhdNC5nH4d3OgX3MTAADAcAbAgzBm11K2HHRhGdOq8SkwCRDj8ABBYAZh9ODzB0G0OMNnU0JqREbwAfDgwOAw4AmWl/NCKHGS+FFz2eIaVtjAAnEgdFAg4G,pedo,LED

Also note that PhotoDNALookup task use the "status" column.
It matches only PhotoDNAs which status are defined in parameter "statusHashDBFilter" defined in "PhotoDNALookupConfig.txt".
The default configuration is "pedo".

[wladimirleite]

Exactly! It should be enough.
Other than that, you probably will need to set status="pedo" for all lines. It is possible to do that without modifying the CSV file, with a command line parameter.

[danpos]

The PhotoDNA database has been imported.
As for the status, according to your first reply, I understood that it wasn't necessary to do this in the file, as the default is already set to

status=pedo

Now that the import is done, when running iped, should I pass this parameter on the command line? If so, how?

[wladimirleite]

The default in PhotoDNALookup is to match only if status ="pedo".
I am not in the PC right now, but if you run the import tool without argument it should show a parameter the allowing setting a property for the whole file.

[danpos]

I did what you suggested and the option is as follows:

-addCol
Add a fixed column (for all imported lines), with a given name and value.

I'm redoing the import so that I have the database correctly configured for production.

Thanks again for your patience and support.

[danpos]

The job was done again and everything went well.
Thanks again for your help.
Question resolved, we can close the discussion.