Hi Alejandro, the idea is interesting one, i will set up test install with remote sqlbox for my clickatell account till the end of the week. hope to have time to do that tomorrow :) will keep you informed.
Regards. -----Original Message----- From: Alejandro Guerrieri [EMAIL PROTECTED] Sent: 03 ???????? 2007 ?. To: seik Subject:sqlbox on a different maching > 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 >> >>
