hello, if you use smsbox-port = 13011 in [core] group then you shoud use the same port as bearerbox-port = 13011 in sqlbox.conf Also smsbox-port in sqlbox.conf should be the same as bearerbox-port in [smsbox] group smsbox--->sqlbox:13012--->bearerbox:13011 Regards, C.
_____ From: Jins [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 12:50 PM To: [email protected]; [EMAIL PROTECTED] Cc: Kenney Jacob; Sanil S Subject: SQL BOX: sqlbox.c Connection closed by the box <(null)> Some one please help me..... when i update the send_sms table,the entered field will be transferred to sent_sms table but my sqlbox is getting terminated giving a log as below... 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard, client version 4.1.22. 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at localhost. 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard, client version 4.1.22. 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at localhost. 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard, client version 4.1.22. 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at localhost. 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard, client version 4.1.22 . 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at localhost. 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard, client version 4.1.22 . 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: Connected to server at localhost. 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-standard, client version 4.1.22. 2007-09-18 03:52:48 [23846] [0] DEBUG: Started thread 1 ( sqlbox.c:sql_to_bearerbox) 2007-09-18 03:52:48 [23846] [1] DEBUG: Thread 1 ( sqlbox.c:sql_to_bearerbox) maps to pid 23846. 2007-09-18 03:52:48 [23846] [1] INFO: Connected to bearerbox at localhost port 13010. 2007-09-18 03:52:48 [23846] [1] DEBUG: Started thread 2 ( sqlbox.c:bearerbox_to_sql ) 2007-09-18 03:52:48 [23846] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 23846. 2007-09-18 03:53:48 [23846] [2] INFO: Connection closed by the box <(null)> 2007-09-18 03:53:48 [23846] [2] DEBUG: bearerbox_to_sql: connection to bearerbox died. 2007-09-18 03:53:48 [23846] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) terminates. 2007-09-18 03:53:48 [23846] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) terminates. 2007-09-18 03:53:58 [23846] [0] DEBUG: Immutable octet strings: 65. Here is my conf files SQLBOX CONF group = sqlbox id = sqlbox-db smsbox-id = smsbox bearerbox-host = "xxx.xxx.xxx" bearerbox-port = 13010 smsbox-port = 13012 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel- sqlbox.log" log-level = 1 group = mysql-connection id = sqlbox-db host = localhost username = xxxxx password = xxxxx database = xxxxx max-connections = 10 KANNEL.CONF group = core admin-port = 13010 admin-password = "xxxxxx" status-password = "xxxxxx" admin-deny-ip = "*.*.*.*" admin-allow-ip = " 127.0.0.1 <http://127.0.0.1/> " smsbox-port = 13011 #wapbox-port = 13002 smsbox-port-ssl = no box-deny-ip = "*.*.*.*" box-allow-ip = "xx.xxx.xxxxxx" #wdp-interface-name = "*" dlr-storage = mysql log-file = "/var/log/kannel/kannel-core.log" log-level = 1 group = smsbox bearerbox-host = "xxx.xx.xxx.xxx" smsbox-id = smsbox #bearerbox-port = 13010 sendsms-port = 14001 #global-sender = 1234456 #sendsms-chars = "," access-log = "/var/log/kannel/kannel.smsbox.access-log" log-file = "/var/log/kannel/kannel.smsbox.log" log-level = 0 group = smsc smsc = smpp host = " xxx.xxx.xxx.xxx" port = 7677 receive-port = 7677 #service-type = smpp smsc-id = test transceiver-mode = true smsc-username = "zxxxxx" smsc-password = xxxxxx system-type = "" group = sendsms-user username = xxxx password = xxxxx concatenation = true max-messages = 100 group = mysql-connection id = mydlr host =localhost username = xxxxx password =xxxxx database = xxxxxx max-connections = 1
