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 <cgch...@yahoo.com.au>: > 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 > <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 = localhost > username = abcabc > password = abcabc > database = abcabc > > >
