Hi, and thanks for answering. I also run sqlbox for MT traffic on the same machine as bearerbox with no problems so far. My setup is quite similar to yours.
The remote box runs smsbox and also a (local to it) sqlbox with no problems. I've tried running a local (I mean, on the same host as sqlbox) smsbox, but after connecting it tries to fetch MO messages from the remote bearerbox and dies after fetching the first message. I don't want it to fetch MO traffic anyway (I think I can fix that by configuring it) but the question remaining is why it dies. Regards, Alejandro On 10/3/07, seik <[EMAIL PROTECTED]> wrote: > 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 > > -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/ LinkedIn: http://www.linkedin.com/in/aguerrieri
