debian wheezy kannel 1.5.0 with kannel-sqlbox 0.7.2.-3
Hi I've been trying to integrate sqlbox with kannel. Kannel 1.5.0 is installed through the downloaded deb package as per installation guide and kannel-sqlbox 0.7.2-3 is installed through apt-get install on Debian Wheezy. My problem is that when smsbox is connected directly to the bearerbox, everything works fine but when I added sqlbox in the middle of the 2, all the processes starts up fine as usual but as soon as I send a msg, both the smsbox and sqlbox processes crashes instantly. Please see below for sqlbox logs: 2013-01-05 22:38:18 [8658] [0] INFO: Added logfile `/var/log/kannel/kannel-sqlbox.log' with level `0'. 2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: Connected to server at localhost. 2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: server version 5.1.66-0+squeeze1, client version 5.1.66. 2013-01-05 22:38:18 [8658] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2013-01-05 22:38:18 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 8658. 2013-01-05 22:38:18 [8658] [1] INFO: Connected to bearerbox at 127.0.0.1 port 13001. 2013-01-05 22:38:18 [8658] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2013-01-05 22:38:18 [8658] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 8658. 2013-01-05 22:38:19 [8658] [0] DEBUG: Started thread 3 (sqlbox.c:function) 2013-01-05 22:38:19 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) maps to pid 8658. 2013-01-05 22:38:19 [8658] [3] INFO: Client connected from <127.0.0.1> 2013-01-05 22:38:19 [8658] [3] INFO: Connected to bearerbox at 127.0.0.1 port 13001. 2013-01-05 22:38:19 [8658] [3] DEBUG: Started thread 4 (sqlbox.c:bearerbox_to_smsbox) 2013-01-05 22:38:19 [8658] [3] DEBUG: smsbox_to_bearerbox: got boxc_id from <127.0.0.1> 2013-01-05 22:38:19 [8658] [4] DEBUG: Thread 4 (sqlbox.c:bearerbox_to_smsbox) maps to pid 8658. 2013-01-05 22:38:53 [8658] [3] DEBUG: smsbox_to_bearerbox: sms received 2013-01-05 22:38:53 [8658] [4] INFO: Connection closed by the box <127.0.0.1> 2013-01-05 22:38:53 [8658] [4] DEBUG: bearerbox_to_smsbox: connection to bearerbox died. 2013-01-05 22:38:53 [8658] [4] DEBUG: Thread 4 (sqlbox.c:bearerbox_to_smsbox) terminates. 2013-01-05 22:38:53 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) terminates. 2013-01-05 22:38:53 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) terminates. 2013-01-05 22:39:03 [8658] [0] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) still running 2013-01-05 22:39:03 [8658] [0] DEBUG: Immutable octet strings: 62. Does anybody know why this is happening or had any success with such setup and could provide any assistance is much appreciated. Thanks in advance. Here is my complete setup: group = core dlr-storage = internal admin-port = 13000 admin-password = abcabc status-password = abcabc admin-deny-ip = "*.*.*.*" admin-allow-ip = "127.0.0.1;192.168.1.*" smsbox-port = 13001 log-level = 0 log-file = "/var/log/kannel/bearerbox.log" box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1;192.168.1.*" group = smsbox smsbox-id = smsbox1 bearerbox-host = 127.0.0.1 bearerbox-port = 13003 sendsms-port = 13013 log-file = "/var/log/kannel/smsbox.log" log-level = 0 access-log = "/var/log/kannel/access.log" group = sendsms-user username = abcabc password = abcabc group = smsc smsc = smpp smsc-id = SMSC1 host = 1 port = 1 smsc-username = abcabc smsc-password = abcabc address-range = "" system-type = "" transceiver-mode = true group = sms-service keyword = default accept-x-kannel-headers = true max-messages = 100 assume-plain-text = true catch-all = true ##sqlbox group = sqlbox id = sqlbox-db smsbox-id = smsbox1 #smsbox-id = sqlbox #global-sender = "" bearerbox-host = 127.0.0.1 bearerbox-port = 13001 smsbox-port = 13003 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 #ssl-client-certkey-file = "" #ssl-server-cert-file = "" #ssl-server-key-file = "" #ssl-trusted-ca-file = "" # Database connection examples. Please uncomment as needed # Example MYSQL Connection group = mysql-connection id = sqlbox-db host = localhostusername = abcabcpassword = abcabcdatabase = abcabc
RE: debian wheezy kannel 1.5.0 with kannel-sqlbox 0.7.2.-3
Usually this is due to a version mismatch. Try to install the same version of smsbox that comes with kannel in the addons folder. == Rene From: devel-boun...@kannel.org [mailto:devel-boun...@kannel.org] On Behalf Of cgchen Sent: zaterdag 5 januari 2013 14:58 To: devel@kannel.org Subject: debian wheezy kannel 1.5.0 with kannel-sqlbox 0.7.2.-3 Hi I've been trying to integrate sqlbox with kannel. Kannel 1.5.0 is installed through the downloaded deb package as per installation guide and kannel-sqlbox 0.7.2-3 is installed through apt-get install on Debian Wheezy. My problem is that when smsbox is connected directly to the bearerbox, everything works fine but when I added sqlbox in the middle of the 2, all the processes starts up fine as usual but as soon as I send a msg, both the smsbox and sqlbox processes crashes instantly. Please see below for sqlbox logs: 2013-01-05 22:38:18 [8658] [0] INFO: Added logfile `/var/log/kannel/kannel-sqlbox.log' with level `0'. 2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: Connected to server at localhost. 2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: server version 5.1.66-0+squeeze1, client version 5.1.66. 2013-01-05 22:38:18 [8658] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2013-01-05 22:38:18 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 8658. 2013-01-05 22:38:18 [8658] [1] INFO: Connected to bearerbox at 127.0.0.1 port 13001. 2013-01-05 22:38:18 [8658] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2013-01-05 22:38:18 [8658] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 8658. 2013-01-05 22:38:19 [8658] [0] DEBUG: Started thread 3 (sqlbox.c:function) 2013-01-05 22:38:19 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) maps to pid 8658. 2013-01-05 22:38:19 [8658] [3] INFO: Client connected from <127.0.0.1> 2013-01-05 22:38:19 [8658] [3] INFO: Connected to bearerbox at 127.0.0.1 port 13001. 2013-01-05 22:38:19 [8658] [3] DEBUG: Started thread 4 (sqlbox.c:bearerbox_to_smsbox) 2013-01-05 22:38:19 [8658] [3] DEBUG: smsbox_to_bearerbox: got boxc_id from <127.0.0.1> 2013-01-05 22:38:19 [8658] [4] DEBUG: Thread 4 (sqlbox.c:bearerbox_to_smsbox) maps to pid 8658. 2013-01-05 22:38:53 [8658] [3] DEBUG: smsbox_to_bearerbox: sms received 2013-01-05 22:38:53 [8658] [4] INFO: Connection closed by the box <127.0.0.1> 2013-01-05 22:38:53 [8658] [4] DEBUG: bearerbox_to_smsbox: connection to bearerbox died. 2013-01-05 22:38:53 [8658] [4] DEBUG: Thread 4 (sqlbox.c:bearerbox_to_smsbox) terminates. 2013-01-05 22:38:53 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) terminates. 2013-01-05 22:38:53 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) terminates. 2013-01-05 22:39:03 [8658] [0] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) still running 2013-01-05 22:39:03 [8658] [0] DEBUG: Immutable octet strings: 62. Does anybody know why this is happening or had any success with such setup and could provide any assistance is much appreciated. Thanks in advance. Here is my complete setup: group = core dlr-storage = internal admin-port = 13000 admin-password = abcabc status-password = abcabc admin-deny-ip = "*.*.*.*" admin-allow-ip = "127.0.0.1;192.168.1.*" smsbox-port = 13001 log-level = 0 log-file = "/var/log/kannel/bearerbox.log" box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1;192.168.1.*" group = smsbox smsbox-id = smsbox1 bearerbox-host = 127.0.0.1 bearerbox-port = 13003 sendsms-port = 13013 log-file = "/var/log/kannel/smsbox.log" log-level = 0 access-log = "/var/log/kannel/access.log" group = sendsms-user username = abcabc password = abcabc group = smsc smsc = smpp smsc-id = SMSC1 host = 1 port = 1 smsc-username = abcabc smsc-password = abcabc address-range = "" system-type = "" transceiver-mode = true group = sms-service keyword = default accept-x-kannel-headers = true max-messages = 100 assume-plain-text = true catch-all = true ##sqlbox group = sqlbox id = sqlbox-db smsbox-id = smsbox1 #smsbox-id = sqlbox #global-sender = "" bearerbox-host = 127.0.0.1 bearerbox-port = 13001 smsbox-port = 13003 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 #ssl-client-certkey-file = "" #ssl-server-cert-file = "" #ssl-server-key-file = "" #ssl-trusted-ca-file = "" # Database connection examples. Please uncomment as needed # Example MYSQL Connection group = mysql-connection id = sqlbox-db host = localhost username = abcabc password = abcabc database = abcabc
Re: debian wheezy kannel 1.5.0 with kannel-sqlbox 0.7.2.-3
On Sat, 2013-01-05 at 05:57, cgchen wrote: > Hi > > I've been trying to integrate sqlbox with kannel. Kannel 1.5.0 is installed > through the downloaded deb package as per installation guide and > kannel-sqlbox 0.7.2-3 is installed through apt-get install on Debian Wheezy. Kannel 1.5.0 is not in official Debian repository, AFAIK. Where from you downloaded deb packages? If you downloaded deb packages from Kannel site (https://redmine.kannel.org/projects/kannel/files) then you cannot use kannel-sqlbox from Debian repository because it is not compatible with Kannel 1.5.0 version from the Kannel site. I built kannel-sqlbox-1.5.0 (for amd64 arch only) which is compatible with above mentioned Kannel but I didn't uploaded it because I didn't tested it (I don't use sqlbox so I couldn't test it). If you installed Kannel deb packages from Kannel site send me i private mail and I will post sqlbox deb package to you if you are brave to test it. > My problem is that when smsbox is connected directly to the bearerbox, > everything works fine but when I added sqlbox in the middle of the 2, all the > processes starts up fine as usual but as soon as I send a msg, both the > smsbox and sqlbox processes crashes instantly. Please see below for sqlbox > logs: > > 2013-01-05 22:38:18 [8658] [0] INFO: Added logfile > `/var/log/kannel/kannel-sqlbox.log' with level `0'. > 2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: Connected to server at localhost. > 2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: server version 5.1.66-0+squeeze1, > client version 5.1.66. > 2013-01-05 22:38:18 [8658] [0] DEBUG: Started thread 1 > (sqlbox.c:sql_to_bearerbox) > 2013-01-05 22:38:18 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) > maps to pid 8658. > 2013-01-05 22:38:18 [8658] [1] INFO: Connected to bearerbox at 127.0.0.1 port > 13001. > 2013-01-05 22:38:18 [8658] [1] DEBUG: Started thread 2 > (sqlbox.c:bearerbox_to_sql) > 2013-01-05 22:38:18 [8658] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) > maps to pid 8658. > 2013-01-05 22:38:19 [8658] [0] DEBUG: Started thread 3 (sqlbox.c:function) > 2013-01-05 22:38:19 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) maps to > pid 8658. > 2013-01-05 22:38:19 [8658] [3] INFO: Client connected from <127.0.0.1> > 2013-01-05 22:38:19 [8658] [3] INFO: Connected to bearerbox at 127.0.0.1 port > 13001. > 2013-01-05 22:38:19 [8658] [3] DEBUG: Started thread 4 > (sqlbox.c:bearerbox_to_smsbox) > 2013-01-05 22:38:19 [8658] [3] DEBUG: smsbox_to_bearerbox: got boxc_id > from <127.0.0.1> > 2013-01-05 22:38:19 [8658] [4] DEBUG: Thread 4 (sqlbox.c:bearerbox_to_smsbox) > maps to pid 8658. > 2013-01-05 22:38:53 [8658] [3] DEBUG: smsbox_to_bearerbox: sms received > 2013-01-05 22:38:53 [8658] [4] INFO: Connection closed by the box <127.0.0.1> > 2013-01-05 22:38:53 [8658] [4] DEBUG: bearerbox_to_smsbox: connection to > bearerbox died. > 2013-01-05 22:38:53 [8658] [4] DEBUG: Thread 4 (sqlbox.c:bearerbox_to_smsbox) > terminates. > 2013-01-05 22:38:53 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) terminates. > 2013-01-05 22:38:53 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) > terminates. > 2013-01-05 22:39:03 [8658] [0] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) > still running > 2013-01-05 22:39:03 [8658] [0] DEBUG: Immutable octet strings: 62. > > > Does anybody know why this is happening or had any success with such setup > and could provide any assistance is much appreciated. > > Thanks in advance. > > Here is my complete setup: > > group = core > dlr-storage = internal > admin-port = 13000 > admin-password = abcabc > status-password = abcabc > admin-deny-ip = "*.*.*.*" > admin-allow-ip = "127.0.0.1;192.168.1.*" > smsbox-port = 13001 > log-level = 0 > log-file = "/var/log/kannel/bearerbox.log" > box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1;192.168.1.*" > > group = smsbox > smsbox-id = smsbox1 > bearerbox-host = 127.0.0.1 > bearerbox-port = 13003 > sendsms-port = 13013 > log-file = "/var/log/kannel/smsbox.log" > log-level = 0 > access-log = "/var/log/kannel/access.log" > > group = sendsms-user > username = abcabc > password = abcabc > > group = smsc > smsc = smpp > smsc-id = SMSC1 > host = 1 > port = 1 > smsc-username = abcabc > smsc-password = abcabc > address-range = "" > system-type = "" > transceiver-mode = true > > group = sms-service > keyword = default > accept-x-kannel-headers = true > max-messages = 100 > assume-plain-text = true > catch-all = true > > ##sqlbox > group = sqlbox > id = sqlbox-db > smsbox-id = smsbox1 > #smsbox-id = sqlbox > #global-sender = "" > bearerbox-host = 127.0.0.1 > bearerbox-port = 13001 > smsbox-port = 13003 > smsbox-port-ssl = false > sql-log-table = sent_sms > sql-insert-table = send_sms > log-file = "/var/log/kannel/kannel-sqlbox.log" > log-level = 0 > #ssl-client-certkey-file = "" > #ssl-server-cert-file = "" > #ssl-server-key-file = "" > #ssl-trusted-ca-file = "" > > # Database connection examples. Please uncomment a
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
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: = 2013-01-06 02:03:12 [27121] [0] DEBUG: = 2013-01-06 02:03:12 [27121] [0] DEBUG: = 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 To: 'cgchen' ; 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: = 2013-01-06 02:03:12 [27121] [0] DEBUG: = 2013-01-06 02:03:12 [27121] [0] DEBUG: = 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 To: 'cgchen' ; 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 To: 'cgchen' ; 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: = 2013-01-06 02:03:12 [27121] [0] DEBUG: = 2013-01-06 02:03:12 [27121] [0] DEBUG: = 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 To: 'cgchen' ; 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 To: 'cgchen' ; 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: = 2013-01-06 02:03:12 [27121] [0] DEBUG: = 2013-01-06 02:03:12 [27121] [0] DEBUG: = 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 To: 'cgchen' ; 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)
Re: debian wheezy kannel 1.5.0 with kannel-sqlbox 0.7.2.-3
1st DO NOT post to the devel list, it's only for developers! use us...@kannel.org for all your questions. 2nd DO NOT use 3rd party .deb packages, because they can contain backdoor or anything, always USE official (from debian repositories) and NEVER install different versions (one from subversion, one from repository), they can only work together if they are from the same source 3rd use subversion and install kannel like that: svn co https://svn.kannel.org/gateway/trunk kannel-1.5 cd kannel-1.5 ./configure --with-mysql --prefix=/usr/local make make install cd addons/sqlbox ./configure --prefix=/usr/local make make install this way you'd have both kannel-1.5 and sqlbox installed into /usr/local directory, DO NOT forget to remove ALL packages related to kannel kannel-sqlbox kannel* from your system BEFORE doing any of these actions! also I'd suggest building actually a .deb package, you'd need to make some scripts for that read this if you want http://www.debian.org/doc/manuals/maint-guide/build.en.html or use checkinstall. you might need as well libxml2 and a bunch of other dependencies for kannel's compilation 2013/1/5 cgchen : > Hi > > I've been trying to integrate sqlbox with kannel. Kannel 1.5.0 is installed > through the downloaded deb package as per installation guide and > kannel-sqlbox 0.7.2-3 is installed through apt-get install on Debian Wheezy. > > My problem is that when smsbox is connected directly to the bearerbox, > everything works fine but when I added sqlbox in the middle of the 2, all > the processes starts up fine as usual but as soon as I send a msg, both the > smsbox and sqlbox processes crashes instantly. Please see below for sqlbox > logs: > > 2013-01-05 22:38:18 [8658] [0] INFO: Added logfile > `/var/log/kannel/kannel-sqlbox.log' with level `0'. > 2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: Connected to server at > localhost. > 2013-01-05 22:38:18 [8658] [0] INFO: MYSQL: server version > 5.1.66-0+squeeze1, client version 5.1.66. > 2013-01-05 22:38:18 [8658] [0] DEBUG: Started thread 1 > (sqlbox.c:sql_to_bearerbox) > 2013-01-05 22:38:18 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) > maps to pid 8658. > 2013-01-05 22:38:18 [8658] [1] INFO: Connected to bearerbox at 127.0.0.1 > port 13001. > 2013-01-05 22:38:18 [8658] [1] DEBUG: Started thread 2 > (sqlbox.c:bearerbox_to_sql) > 2013-01-05 22:38:18 [8658] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) > maps to pid 8658. > 2013-01-05 22:38:19 [8658] [0] DEBUG: Started thread 3 (sqlbox.c:function) > 2013-01-05 22:38:19 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) maps to > pid 8658. > 2013-01-05 22:38:19 [8658] [3] INFO: Client connected from <127.0.0.1> > 2013-01-05 22:38:19 [8658] [3] INFO: Connected to bearerbox at 127.0.0.1 > port 13001. > 2013-01-05 22:38:19 [8658] [3] DEBUG: Started thread 4 > (sqlbox.c:bearerbox_to_smsbox) > 2013-01-05 22:38:19 [8658] [3] DEBUG: smsbox_to_bearerbox: got boxc_id > from <127.0.0.1> > 2013-01-05 22:38:19 [8658] [4] DEBUG: Thread 4 > (sqlbox.c:bearerbox_to_smsbox) maps to pid 8658. > 2013-01-05 22:38:53 [8658] [3] DEBUG: smsbox_to_bearerbox: sms received > 2013-01-05 22:38:53 [8658] [4] INFO: Connection closed by the box > <127.0.0.1> > 2013-01-05 22:38:53 [8658] [4] DEBUG: bearerbox_to_smsbox: connection to > bearerbox died. > 2013-01-05 22:38:53 [8658] [4] DEBUG: Thread 4 > (sqlbox.c:bearerbox_to_smsbox) terminates. > 2013-01-05 22:38:53 [8658] [3] DEBUG: Thread 3 (sqlbox.c:function) > terminates. > 2013-01-05 22:38:53 [8658] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) > terminates. > 2013-01-05 22:39:03 [8658] [0] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) > still running > 2013-01-05 22:39:03 [8658] [0] DEBUG: Immutable octet strings: 62. > > > Does anybody know why this is happening or had any success with such setup > and could provide any assistance is much appreciated. > > Thanks in advance. > > Here is my complete setup: > > group = core > dlr-storage = internal > admin-port = 13000 > admin-password = abcabc > status-password = abcabc > admin-deny-ip = "*.*.*.*" > admin-allow-ip = "127.0.0.1;192.168.1.*" > smsbox-port = 13001 > log-level = 0 > log-file = "/var/log/kannel/bearerbox.log" > box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1;192.168.1.*" > > group = smsbox > smsbox-id = smsbox1 > bearerbox-host = 127.0.0.1 > bearerbox-port = 13003 > sendsms-port = 13013 > log-file = "/var/log/kannel/smsbox.log" > log-level = 0 > access-log = "/var/log/kannel/access.log" > > group = sendsms-user > username = abcabc > password = abcabc > > group = smsc > smsc = smpp > smsc-id = SMSC1 > host = 1 > port = 1 > smsc-username = abcabc > smsc-password = abcabc > address-range = "" > system-type = "" > transceiver-mode = true > > group = sms-service > keyword = default > accept-x-kannel-headers = true > max-messages = 100 > assume-plain-text = true > catch-all = true > > ##sqlbox > group = sqlbox > id = sqlbox-db > smsbox-id = smsbox1 > #smsbox-id = sqlbox > #global-send