motion package - No support for SQL

[douglagm]

Hi,

Not sure if this is the correct sub-forum ?

I installed motion on my Raspberry PI, I have connected it to a IP camera for motion detection, so far I have manage to get it all working except for the logging to SQL. It looks like the motion package from the official repo does not support SQL. Is this correct, if so how can I add SQL support ?

Please see versions, code extract, etc. below.

Regards
Gregg
$this->bbcode_second_pass_code('', '
motion -c /etc/motion/motion.conf
[0] Processing thread 0 - config file /etc/motion/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] Motion 3.2.12 Started
[0] ffmpeg LIBAVCODEC_BUILD 3489124 LIBAVFORMAT_BUILD 3481700
[0] Thread 1 is from /etc/motion/motion.conf
[0] motion-httpd/3.2.12 running, accepting connections
[1] Thread 1 started
')
$this->bbcode_second_pass_code('', '
pacman -Ss maria
extra/libmariadbclient 5.5.30-2 [installed]
MariaDB client libraries
extra/mariadb 5.5.30-2 [installed]
Fast SQL database server, drop-in replacement for MySQL
extra/mariadb-clients 5.5.30-2 [installed]
MariaDB client tools
')
$this->bbcode_second_pass_code('', '
uname -a
Linux gmdRPI 3.6.11-9-ARCH+ #1 PREEMPT Sat Mar 30 02:38:20 UTC 2013 armv6l GNU/Linux
')
$this->bbcode_second_pass_code('', '
pacman -Ss motion
community/motion 3.2.12-8 [installed]
A software motion detector which grabs images from video4linux devices and/or from webcams
')

[hydro]

You could rebuild the package using ABS. Change configure options in the PKGBUILD. Or build the git package from AUR (motion.service file is missing and makedepends should be 'git' instead of 'subversion').