Hi Alejandro, do you have smsbox running on the remote host ? ot local smsbox connected to the remote bearerbox .. ?
if not try to run smsbox either at the box running the sqlbox or at the bearerebox machine I run sqlbox-standalone in high load environment, its stable so far ... i run in in two different approaches - for the high loaded smpp connections i use sqlbox only to deal with MT traffic for the average and low peak loads i use sqlbox to serve MO traffic as well my MT serving sqlbox.conf group = sqlbox id = sqlbox-db smsbox-id = smsbox bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 5 group = pgsql-connection id = sqlbox-db host = localhost port = 5432 username = mtel password = database = mtel max-connections = 30 -----Original Message----- From: Alejandro Guerrieri [EMAIL PROTECTED] Sent: 03 ???????? 2007 ?. To: seik Subject:sqlbox on a different maching > Hi, > I'm trying to implement sqlbox on an independent server. The idea is > to have a dedicated server with an sqlbox instance connected to a > local mysql database. Applications will insert messages on the mysql > table and the sqlbox will deliver the messages to a kannel running on > a different machine. > So far, I've faced many problems: > * Kannel sqlbox patch didn't compile (I've fixed it and submitted the > patch against CVS). > * The bearerbox-host parameter wasn't honored (Idem, I've fixed it and > submitted the patch). > * The connection to bearerbox establishes, but after inserting a > single message all threads die. > I've tried with the sqlbox patch and also with the sqlbox-standalone > with identical results. > I don't know if I'm doing something wrong or if is it any issues > preventing me to achieve this. I only intend to use it to queue MT > messages, I don't need to receive messages this way. > Regarding configuration files, I've tried many options, this is a > typical I've tried: > group = sqlbox > id = myconn > smsbox-id = mybox > bearerbox-host = <remote ip of bearerbox> > bearerbox-port = 13001 > smsbox-port = 13005 > smsbox-port-ssl = false > bearerbox-is-sqlbox = false > sql-log-table = sent_sms > sql-insert-table = send_sms > log-file = "/var/log/kannel/sqlbox.log" > log-level = 0 > The connection gets established and shows on the kannel status page, > but it disconnects as soon as I insert a message on the send_sms > table. The message is moved to the sent_sms table, but sqlbox dies > inmediately. > 2007-10-03 11:05:12 [18890] [0] INFO: Starting to log to file > /var/log/kannel/sqlbox.log level 0 > 2007-10-03 11:05:12 [18890] [0] INFO: Added logfile > `/var/log/kannel/sqlbox.log' with level `0'. > 2007-10-03 11:05:12 [18890] [0] INFO: MYSQL: Connected to server at localhost. > 2007-10-03 11:05:12 [18890] [0] INFO: MYSQL: server version > 4.1.20-log, client version 4.1.20. > 2007-10-03 11:05:12 [18890] [0] DEBUG: Started thread 1 > (gw/sqlbox.c:sql_to_bearerbox) > 2007-10-03 11:05:12 [18890] [1] DEBUG: Thread 1 > (gw/sqlbox.c:sql_to_bearerbox) maps to pid 18890. > 2007-10-03 11:05:12 [18890] [1] INFO: Connected to bearerbox at > 200.68.65.90 port 13001. > 2007-10-03 11:05:12 [18890] [1] DEBUG: Started thread 2 > (gw/sqlbox.c:bearerbox_to_sql) > 2007-10-03 11:05:12 [18890] [2] DEBUG: Thread 2 > (gw/sqlbox.c:bearerbox_to_sql) maps to pid 18890. > <we insert a message here> > 2007-10-03 11:05:36 [18890] [2] DEBUG: bearerbox_to_sql: connection to > bearerbox died. > 2007-10-03 11:05:36 [18890] [2] DEBUG: Thread 2 > (gw/sqlbox.c:bearerbox_to_sql) terminates. > 2007-10-03 11:05:36 [18890] [1] DEBUG: Thread 1 > (gw/sqlbox.c:sql_to_bearerbox) terminates. > 2007-10-03 11:05:46 [18890] [0] DEBUG: Immutable octet strings: 108. > I don't know if I'm supposed to run a local smsbox maybe? > Any leads/hints? > Thank you in advance, > Alejandro
