It seems to be an sqlbox problem, crashing for some reason or another.
From: cgchen [mailto:cgch...@yahoo.com.au] Sent: zaterdag 5 januari 2013 17:50 To: Rene Kluwen; devel@kannel.org Subject: Re: mysql support for kannel 1.5.0 from DEB packages sorry, I cut that bit out. See blow. This should be straight forward. Along with the settings below, I created a db and granted all privileges to the db user. Am I missing something? or the DEB package simply doesn't support mysql group = mysql-connection id = mydlr host = localhost username = foo password = bar database = dlr max-connections = 1 group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc _____ From: Rene Kluwen <rene.klu...@chimit.nl> To: 'cgchen' <cgch...@yahoo.com.au>; devel@kannel.org Sent: Sunday, 6 January 2013 3:40 AM Subject: RE: mysql support for kannel 1.5.0 from DEB packages In your previous email with your configuration files, there’s a group = dlr-db missing. Possibly that’s your problem. From: cgchen [mailto:cgch...@yahoo.com.au] Sent: zaterdag 5 januari 2013 17:06 To: Rene Kluwen; devel@kannel.org Subject: Re: mysql support for kannel 1.5.0 from DEB packages there's nothing in bearerbox.log nor access.log within kannel. smsbox.log is the only one that shows anything. I've tested the mysql credentials so it's not that. 2013-01-06 02:03:12 [27121] [0] DEBUG: Kannel smsbox version 1.5.0 starting 2013-01-06 02:03:12 [27121] [0] DEBUG: dumping group (sendsms-user): 2013-01-06 02:03:12 [27121] [0] DEBUG: <group> = <sendsms-user> 2013-01-06 02:03:12 [27121] [0] DEBUG: <username> = <?????> 2013-01-06 02:03:12 [27121] [0] DEBUG: <password> = <?????> 2013-01-06 02:03:12 [27121] [0] DEBUG: Started thread 4 (gw/smsbox.c:obey_request_thread) 2013-01-06 02:03:12 [27121] [0] DEBUG: Started thread 5 (gw/smsbox.c:url_result_thread) 2013-01-06 02:03:12 [27121] [0] DEBUG: Started thread 6 (gw/smsbox.c:http_queue_thread) 2013-01-06 02:03:12 [27121] [0] DEBUG: Connecting to <127.0.0.1> 2013-01-06 02:03:12 [27121] [0] ERROR: connect to <127.0.0.1> failed 2013-01-06 02:03:12 [27121] [0] ERROR: System error 111: Connection refused 2013-01-06 02:03:12 [27121] [0] ERROR: error connecting to server `127.0.0.1' at port `13001' 2013-01-06 02:03:12 [27121] [0] PANIC: Couldn't connect to the bearerbox. 2013-01-06 02:03:12 [27121] [0] PANIC: /usr/sbin/smsbox(gw_panic+0x147) [0x43fd97] 2013-01-06 02:03:12 [27121] [0] PANIC: /usr/sbin/smsbox(main+0xcc5) [0x40ff45] 2013-01-06 02:03:12 [27121] [0] PANIC: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f92e6324c8d] 2013-01-06 02:03:12 [27121] [0] PANIC: /usr/sbin/smsbox() [0x40ebf9] 2013-01-06 02:03:24 [27203] [0] INFO: Added logfile `/var/log/kannel/smsbox.log' with level `0'. 2013-01-06 02:03:24 [27203] [0] INFO: Logging accesses to '/var/log/kannel/access.log'. 2013-01-06 02:03:24 [27203] [0] INFO: Started access logfile `/var/log/kannel/access.log'. 2013-01-06 02:03:24 [27203] [0] INFO: HTTP: Opening server at port 13013. 2013-01-06 02:03:24 [27203] [0] DEBUG: Started thread 1 (gwlib/fdset.c:poller) 2013-01-06 02:03:24 [27203] [0] DEBUG: Started thread 2 (gwlib/http.c:server_thread) 2013-01-06 02:03:24 [27203] [0] INFO: Set up send sms service at port 13013 2013-01-06 02:03:24 [27203] [0] DEBUG: Started thread 3 (gw/smsbox.c:sendsms_thread) _____ From: Rene Kluwen <rene.klu...@chimit.nl> To: 'cgchen' <cgch...@yahoo.com.au>; devel@kannel.org Sent: Sunday, 6 January 2013 2:55 AM Subject: RE: mysql support for kannel 1.5.0 from DEB packages What do your logs have to say about it? From: devel-boun...@kannel.org [mailto:devel-boun...@kannel.org] On Behalf Of cgchen Sent: zaterdag 5 januari 2013 16:27 To: devel@kannel.org Subject: mysql support for kannel 1.5.0 from DEB packages Hi, Can someone please confirm that kannel 1.5.0 from deb package comes with mysql support. The reason I asked is because as soon as I changed dlr-storage to mysql with mysql connection settings from the user guide, I'm not able to start kannel back up Thanks.