Problem using alprvideocli (forensic linux) with image files


#1

Hello,

As indicated in your documentation, we try to use the forensic plate finder with command line, to decode image file.

We tried with the windows GUI client, it was successful (.jpg image file).

But we want to implement it with linux command lines, for webservice implementation. So we followed your documentation : http://doc.openalpr.com/on_premises.html#command-line-usage

Unfortunatly, we can’t process image files. Here is the debug output. Could you please help us ?

Best regards,

alprvideocli --output_dir ./tmp/photos -c eu --threads 1 --save_frames --debug 1.jpg

frame count 1
Video is 1 total frames
DB Response: 0
Opened database
executing query: BEGIN TRANSACTION
Tables created successfully
executing query: DROP TABLE IF EXISTS info;
Tables created successfully
executing query: DROP TABLE IF EXISTS plate;
Tables created successfully
executing query: DROP TABLE IF EXISTS candidate;
Tables created successfully
executing query: DROP TABLE IF EXISTS plate_group;
Tables created successfully
executing query: CREATE TABLE info(version INTEGER, video_name TEXT, fps INTEGER, num_threads INTEGER, topn INTEGER, processing_time_s NUMBER, time_start_epoch_ms INTEGER, time_end_epoch_ms INTEGER);
Tables created successfully
executing query: CREATE TABLE plate(id INTEGER PRIMARY KEY NOT NULL, group_id INTEGER, country VARCHAR(8), plate_number TEXT, confidence NUMBER, frame_num INTEGER, video_time_s NUMBER, matches_pattern INTEGER, tracking_hash VARCHAR(14), x1 INTEGER, y1 INTEGER, x2 INTEGER, y2 INTEGER, x3 INTEGER, y3 INTEGER, x4 INTEGER, y4 INTEGER, img_name TEXT, region VARCHAR(2), region_confidence NUMBER);
Tables created successfully
executing query: CREATE INDEX plate_frame_num ON plate(frame_num ASC);
Tables created successfully
executing query: CREATE INDEX plate_group_id ON plate(group_id ASC);
Tables created successfully
executing query: CREATE TABLE candidate(id INTEGER PRIMARY KEY NOT NULL, plate_number TEXT, confidence NUMBER, matches_pattern INTEGER, plate_id INTEGER);
Tables created successfully
executing query: CREATE INDEX candidate_plate_id ON candidate(plate_id ASC);
Tables created successfully
executing query: CREATE TABLE plate_group(id INTEGER PRIMARY KEY NOT NULL, country VARCHAR(8), plate_number TEXT, matches_pattern INTEGER, plate_count INTEGER, frame_start INTEGER, frame_end INTEGER, video_time_start_s NUMBER, video_time_end_s NUMBER, best_plate_id INTEGER, confidence NUMBER, region VARCHAR(2), region_confidence NUMBER);
Tables created successfully
executing query: CREATE INDEX group_frame_start ON plate_group(frame_start ASC);
Tables created successfully
executing query: END TRANSACTION
Tables created successfully
Processing 1 video frames (0 total seconds)
Initializing analysis thread # 0
Thread 0 starting processing frames 0 - 0
SQL: INSERT INTO info (version, video_name, fps, num_threads, topn, processing_time_s, time_start_epoch_ms, time_end_epoch_ms) VALUES( 1, '1.jpg', 25, 1, 10, 0.341, 1558268805169, 1558268805510);
Closing database
Error, could not load video file
Done CLI