Motion - Bug Report 2007x 09x 18x 184851
You are here: Foswiki>Motion Web>BugReports>BugReport2007x09x18x184851 (25 Sep 2007, AngelCarpintero)Edit Attach

BUG: config-option sql_query only accept on normal mode, not on daemon

i use the "sql_query"-option. In normal mode its running and motion write to mysql, but if i used "daemon on" its written in syslog mysql error occured.

On starting( only on daemon mode) motion writes: [0] Unknown config option "sql_query" : Success

On starting( only on daemon mode) motion writes:
[0] Unknown config option "sql_query" : Success

Environment

Motion version: 3.2.3
ffmpeg version: 0d.49.0.0 - 0d.51.11.0
Shared libraries: ffmpeg, mysql,
Server OS: UBUNTU

-- PatrickSchreck - 18 Sep 2007

Follow up

Current version is 3.2.8

I bet you have more than one config and does not know which you load. But please upgrade.

God I hate those outdated Debian packages. Why are they not updated???

-- KennethLavrsen - 18 Sep 2007

NEW Environment

Motion version: 3.2.8.0
ffmpeg version: 0d.49.0.0 - 0d.51.11.0
Shared libraries: ffmpeg, mysql,
Server OS: UBUNTU

-- PatrickSchreck - 25 Sep 2007

Follow up

After update to version 3.2.8 i have much more Problems. First, after update to 3.2.8 (ubuntu) the motion config have nearly all activate (all open) Second, on start motion i became now much more "Unknown config options"

/etc/motion# motion

[0] Processing thread 0 - config file motion.conf

[0] Unknown config option "sql_log_image"

[0] Unknown config option "sql_log_snapshot"

[0] Unknown config option "sql_log_mpeg"

[0] Unknown config option "sql_log_timelapse"

[0] Unknown config option "sql_query"

[0] Unknown config option "mysql_db"

[0] Unknown config option "mysql_host"

[0] Unknown config option "mysql_user"

[0] Unknown config option "mysql_password"

[0] Processing config file /etc/motion/eingang.conf

[0] Unknown config option "sql_log_image"

[0] Unknown config option "sql_log_snapshot"

[0] Unknown config option "sql_log_mpeg"

[0] Unknown config option "sql_log_timelapse"

[0] Unknown config option "sql_query"

[0] Thread 1 is from /etc/motion/eingang.conf

[1] Thread started

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

motion.conf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

#Prozess Konfig.

daemon off

process_id_file /var/run/motion.pid

setup_mode off

#Aufloesung, Farbe, Helligkeit etc...

rotate 0

width 320

height 240

auto_brightness off

brightness 0

contrast 0

saturation 0

hue 0

# Frameraten etc.

framerate 10

minimum_frame_time 0

roundrobin_frames 1

roundrobin_skip 1

switchfilter off

threshold 1500

threshold_tune off

noise_level 32

noise_tune on

night_compensate off

#despeckle EedDl

smart_mask_speed 0

lightswitch 0

minimum_motion_frames 5

pre_capture 10

post_capture 10

gap 160

max_mpeg_time 0

low_cpu 0

# Ausgabe AN/AUS

output_all off

output_normal on

output_motion off

quality 75

ppm off

# Video Aufnahmeeinstellungen

ffmpeg_cap_new off

ffmpeg_cap_motion off

ffmpeg_timelapse 0

ffmpeg_timelapse_mode daily

ffmpeg_bps 400000

ffmpeg_variable_bitrate 0

ffmpeg_video_codec msmpeg4

#ffmpeg_video_codec mpeg4

ffmpeg_deinterlace off

# Texte

snapshot_interval 0

locate off

text_right %Y-%m-%d\n%T-%q

text_left CAM

text_changes off

text_event DONEm%dHELPM%S

text_double off

#Dateinamen

target_dir /var/lib/motion/snapshots

snapshot_filename %v-DONEm%dHELPM%S-snapshot

jpeg_filename %v-DONEm%dHELPM%S-%q

movie_filename %v-DONEm%dHELPM%S

timelapse_filename DONEm%d-timelapse

# HTTP Server

webcam_port 0

webcam_quality 50

webcam_motion off

webcam_maxrate 1

webcam_localhost on

webcam_limit 0

control_port 0

control_localhost on

control_html_output on

; control_authentication username:password

# CAM Bewegen

track_type 0

track_auto off

track_motorx -1

track_motory -1

track_maxx 0

track_maxy 0

track_iomojo_id 0

track_step_angle_x 10

track_step_angle_y 10

track_move_wait 10

track_speed 255

track_stepsize 40

# EVENTS

quiet on

; on_event_start value

; on_event_end value

; on_picture_save value

; on_motion_detected value

; on_movie_start value

; on_movie_end value

# SQL

sql_log_image on

sql_log_snapshot on

sql_log_mpeg on

sql_log_timelapse off

sql_query insert into security(id, camera, filename, frame, file_type, time_stamp, event_time_stamp, text_event, text_left, t ext_right) values(null, '%t', '%f', '%q', '%n', '%Y-%m-%d %T', '%C', 'EVENT', 'LEFT','RIGTH')

mysql_db dbname

mysql_host localhost

mysql_user dbuser

mysql_password dbpasswd

# THREADS thread /etc/motion/eingang.conf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

eingang.conf

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

#Einstellung fuer IP CAM im Eingang

netcam_url http://myip/still.jpg

netcam_userpass guest:guest

# Frameraten etc.

framerate 10

threshold 1500

threshold_tune off

noise_level 32

noise_tune on

lightswitch 60

minimum_motion_frames 10

pre_capture 18

post_capture 18

gap 160

max_mpeg_time 900

# Ausgabe AN/AUS

output_all off

output_normal off

output_motion on

quality 75

ppm off

# Video Aufnahmeeinstellungen

ffmpeg_cap_new off

ffmpeg_cap_motion on

ffmpeg_timelapse 0

ffmpeg_timelapse_mode daily

ffmpeg_bps 500000

ffmpeg_variable_bitrate 0

ffmpeg_video_codec msmpeg4

#ffmpeg_video_codec mpeg4

ffmpeg_deinterlace off

# Texte

snapshot_interval 0

locate off

text_right %d-%m-%Y\n%T-%q

text_left AJW9-Eingang

text_changes off

text_event DONEm%dHELPM%S

text_double off

#Dateinamen

target_dir /var/lib/motion/snapshots/cam1

movie_filename %v-DONEm%dHELPM%S

# EVENTS

quiet on

# SQL

sql_log_image off

sql_log_snapshot off

sql_log_mpeg on

sql_log_timelapse off

sql_query insert into security(id, camera, filename, frame, file_type, time_stamp, event_time_stamp, text_event, text_left, t ext_right) values(null, '%t', '%f', '%q', '%n', '%Y-%m-%d %T', '%C', 'EVENT', 'AJW9-Eingang','RIGTH')

Fix record

Motion ubuntu package 3.2.8 , is build without DB support , that's because you got those messages.

-- AngelCarpintero - 25 Sep 2007

BugReportForm edit

TopicTitle config-option sql_query only accept on normal mode, not on daemon!!
BugStatus Rejected
AssignedBugTo
SubmittedBy Patrick Schreck
Topic revision: r5 - 25 Sep 2007, AngelCarpintero
Copyright © 1999-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Please do not email Kenneth for support questions (read why). Use the Support Requests page or join the Mailing List.
This website only use harmless session cookies. See Cookie Policy for details. By using this website you accept the use of these cookies.