Motion - Support Question 2007x 11x 27x 093818

Cannot connect to MySQL database

Question

I would like to use with Motion MySql. Motion works perfectly, but I need to put the records on a Mysql Database outside. Using the commands in webcam1.conf or motion.conf:

sql_log_image on sql_log_snapshot on sql_log_mpeg off sql_log_timelapse off

sql_query insert into security(camera, filename, frame, file_type, time_stamp, event_time_stamp) values('%t', '%f', '%q', '%n', '%Y-%m-%d %T','%C')

mysql_db my_db_name mysql_host host_ip_address mysql_user my_username mysql_password my_password

When I run motion, the output is this:

[0] Processing thread 0 - config file motion.conf
[0] Processing config file /usr/local/etc/webcam1.conf
[0] Processing config file /usr/local/etc/webcam2.conf
[0] Thread 1 is from /usr/local/etc/webcam1.conf
[0] Thread 2 is from /usr/local/etc/webcam2.conf
[1] Thread started
[2] Thread started
[0] motion-httpd/3.2.8 running, accepting connections
[0] motion-httpd: waiting for data on port TCP 8080
[1] Not a V4L2 device?
[1] Using VIDEO_PALETTE_YUV420P palette
[1] Using V4L1
[2] Not a V4L2 device?
[2] Using VIDEO_PALETTE_YUV420P palette
[2] Using V4L1
[2] Started stream webcam server in port 8888
[1] Cannot connect to MySQL database my_db_name on host host_ip_address with user my_username
[1] MySQL error was Can't connect to MySQL server on 'host_ip_address' (110)
[1] Thread finishing...

Environment

Motion version: 3.2.8
ffmpeg version: 0.4.9pre1
Libraries: ffmpeg, mysql, postgresql
Server OS: Kubuntu 7.10, kernel 2.6.22-14-generic

-- StefanoAprile - 27 Nov 2007

Answer

It seems that is a problem of timeout :

110: Connection timed out

So verify that connection to your mysql it's ok. FYI Mysql 5.x supports automatic reconnection , so if you have this kind of problem is better that you upgrade your mysql server to 5.x version and recompile motion wth mysql client library for 5.x

-- AngelCarpintero - 02 Dec 2007
Topic revision: r2 - 02 Dec 2007, AngelCarpintero
Copyright © 1999-2024 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.