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 m%dM%S

text_double off

#Dateinamen

target_dir /var/lib/motion/snapshots

snapshot_filename %v-m%dM%S-snapshot

jpeg_filename %v-m%dM%S-%q

movie_filename %v-m%dM%S

timelapse_filename m%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 m%dM%S

text_double off

#Dateinamen

target_dir /var/lib/motion/snapshots/cam1

movie_filename %v-m%dM%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