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 -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/ LinkedIn: http://www.linkedin.com/in/aguerrieri
