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.
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.
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.
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.
RE: mysql support for kannel 1.5.0 from DEB packages
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.
Re: mysql support for kannel 1.5.0 from DEB packages
On Sat, 2013-01-05 at 07:26, cgchen wrote: 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 My bad. Despite the fact I put in description file that the deb package is compiled with 'sqlite3, MySQL, Postgresql' support, it is compiled with sqlite3 support only. This weekend I'll try to build it according to the description file. -- Kind regards, Milan -- Arvanta,http://www.arvanta.net Please do not send me e-mail containing HTML code or documents in proprietary format (word, excel, pps and so on)