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 <smsbox1> 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 = 11111
> port = 11111
> 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

-- 
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)