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)