[PLEASE DISREGARD PREVIOUS MESSAGE] Re: new sqlbox patch

	Sorry for the message! I did not see the typo; it took me quite a while
to notice it ;-)

Catalin

Catalin Trifu wrote:
>     Hi,
> 
> 
>    The compilation goes fine but when i try to run the beast here's what 
> i get
> when starting the bearerbox:
> 
> 2004-11-06 17:01:22 [5812] [0] INFO: Debug_lvl = 0, log_file = <none>, 
> log_lvl = 0
> 2004-11-06 17:01:22 [5812] [0] ERROR: Group 'sqlbox' may not contain 
> field 'sql_insert_table'.
> 2004-11-06 17:01:22 [5812] [0] ERROR: Error found on line 69 of file 
> `/etc/kannel/kannel.conf'.
> 2004-11-06 17:01:22 [5812] [0] PANIC: Couldn't read configuration from 
> `/etc/kannel/kannel.conf'.
> 2004-11-06 17:01:22 [5812] [0] PANIC: 
> /usr/sbin/bearerbox(gw_panic+0x175) [0x80ca9ba]
> 2004-11-06 17:01:22 [5812] [0] PANIC: /usr/sbin/bearerbox(main+0x171) 
> [0x8051e54]
> 2004-11-06 17:01:22 [5812] [0] PANIC: 
> /lib/libc.so.6(__libc_start_main+0xbb) [0x4025892b]
> 2004-11-06 17:01:22 [5812] [0] PANIC: /usr/sbin/bearerbox(strcpy+0x39) 
> [0x8050fc1]
> 
> Thanks,
> Catalin
> 
> 
> Rene Kluwen wrote:
> 
>> The sqlbox programming has been a little bit behind on the kannel 
>> mainline
>> development.
>> Business is going well, but unfortunately it means that open source 
>> projects
>> need a little more time to catch up.
>>
>> Either way, here is a link to the new patch that patches cleanly against
>> current HEAD version.
>> It is made available on the web because (luckily) the list doesnt 
>> allow big
>> emails.
>> The link: http://www.chimit.nl/kannel/sqlbox_patch-20041012.tar
>>
>> Apart from a few compilation warnings, this is the same version as 
>> before.
>> Please email all experiences (good or bad) to the list or directly to 
>> me, so
>> that appropriate action can be undertaken.
>>
>> Cheers!
>>
>> Rene Kluwen
>> Chimit
>>
>> p.d.: I forget to include the FAQ, so that why it was attached 
>> seperately. A
>> section about how-to-compile has been included.
>>
>>
>> ------------------------------------------------------------------------
>>
>> This is the SQLBOX FAQ.
>> It's function is to help people going, at least before there is a 
>> proper documentation patch.
>>
>> Q.
>> How do I compile sqlbox support into Kannel?
>>
>> A.
>> untar sqlbox_patch.tar in the main Kannel source folder (the one where 
>> configure, Makefile, etc. reside).
>> Then type: 'patch -p0 < sqlbox.patch' (without the single quotes)
>> Then (as usual): make distclean; ./configure --your-options; make
>>
>>
>> Q.
>> Is there any documentation that could help in setting it up and gain a 
>> better understanding of it?
>>
>> A.
>> When runnig for the first time, sqlbox creates automatically 2 tables, 
>> called send_sms and sent_sms (configurable).
>>
>> In the first table, you can insert SMS messages that will be sent out 
>> (MT). In the second table, all SMS traffic from and to
>>
>> smsbox is logged.
>>
>> In kannel.conf, the following options are added:
>>
>>  
>>
>> The patch includes Postgres, MySQL and MS-SQL support (also for DLR's) 
>> for anybody that feels the need to use it.
>> MS-SQL client libraries are either sybase or free-tds (./configure 
>> autodetects).
>>
>>  
>>
>> Here follows some documentation that in fact (I admit) should be 
>> included in the patch against the doc tree:
>> There is one extra configure option in group = smsbox, which is:
>>
>> # bearerbox-is-sqlbox indicates if the smsbox is connected to the 
>> bearerbox or an sql box
>> bearerbox-is-sqlbox = true/false
>>
>> For the rest, the group = sqlbox contains the following options:
>>
>> group = sqlbox
>> # id corresponds to id in group = mysql-connection.
>> # this is analogous to id in group = dlr-db
>> id = dlr-db2
>> # smsbox-id indicates the box where SQL-injected messages appear to be 
>> coming fr
>> om
>> smsbox-id = sqlbox2
>> # bearerbox host to connect to
>> bearerbox-host = "127.0.0.1"
>> # smsbox port to be listening on
>> smsbox-port = 13005
>> smsbox-port-ssl = false
>> # sql-log-table is the table used to log all sent messages
>> sql-log-table = sent_sms
>> # sql-insert-table is the table that is monitored for new messages to 
>> send
>> sql-insert-table = send_sms
>> # global sender: If no sender is specified in sql-insert-table then this
>> # value is used.
>> global-sender = 06121
>> # log-file = ""
>> # log-level = 10
>> # ssl-client-certkey-file = ""
>> # ssl-server-cert-file = ""
>> # ssl-server-key-file = ""
>> # ssl-trusted-ca-file = ""
>>
>> Q.
>> Does sqlbox replace sms box or is It an additional module that must be 
>> run?
>>
>> A.
>> sqlbox is an additional module. You now have to start kannel in the 
>> following manner:
>>
>> 1st: bearerbox <conf-file>
>> 2nd: sqlbox <conf-file>
>> 3rd: smsbox <conf-file> and wapbox <conf-file>
>>
>> A picture of the new situation (with sqlbox included is as follows):
>>
>> http request <--> [ smsbox ] <--> [ sqlbox ] <--> [ bearerbox ] <--> 
>> sms gateway
>>
>> I hope this picture make things clear. In text: sqlbox is sitting in 
>> between smsbox and bearerbox, passing all messages back and forth 
>> between the two. As a side-effect, also the messages that are passed 
>> back and forth are logged in the sent_sms table.
>>
>> Q.
>> Can you use http requests or posting messages to the send_sms table to 
>> send messages?
>>
>> A.
>> You can use both http requests to the smsbox, as usual (nothing 
>> changes here), as well as insert messages in send_sms. SQL Box checks 
>> the records in send_sms every so many seconds and posts them to the 
>> bearerbox to be delivered to the SMSC. After that, the entry in 
>> send_sms is deleted.
>>
>> Q. (Configuration options part #1)
>> bearerbox-is-sqlbox = true/false If this value is set to true would 
>> you not have to run the sqlbox as the bearerbox should function as the 
>> sqlbox?
>>
>> A.
>> It is as follows: if this value is set to true then smsbox connects to 
>> sqlbox, rather than the bearerbox.
>> (see the previous picture)
>>
>> Q. (Configuration options part #2)
>> smsbox-id = sqlbox2 -> Can this be any unique string?
>>
>> A.
>> Yes, exactly.
>>
>> Q. (Configuration options part #3)
>> # smsbox port to be listening on
>> smsbox-port = 13005 -> must this value be the same as the 
>> send-sms-port value in the smsbox?
>>
>> A.
>> Nopes. This smsbox-port is the port that the bearerbox or sqlbox 
>> listen on to connections from smsbox.
>> send-sms-port is a different port. It is the port that smsbox listens 
>> on to http requests to receive messages.
> 
> 
> 
>