Hi Ahmad, Please, read sqlbox userguide (here for example: http://www.blogalex.com/wp-content/uploads/2008/11/userguide.html#AEN478 ) Specifically, see "Inserting MT messages by SQL" section
Regards, Konstantin On Mon, Jun 28, 2010 at 3:52 PM, ahmad aburass <ahmad1985_2...@yahoo.com>wrote: > Hi Nikos, > > Unfortunately I'm not using sendsms-user to push the MT's, I have sqlbox > and the backend application posts the MT's to a cgi that inserts them in > sqlbox send_sms table. please advise. > > > Regards, > Ahmad. > > > ------------------------------ > *From:* Nikos Balkanas <nbalka...@gmail.com> > *To:* ahmad aburass <ahmad1985_2...@yahoo.com> > *Cc:* users@kannel.org > *Sent:* Mon, June 28, 2010 3:04:24 PM > > *Subject:* Re: Kannel drop MT's when bearerbox is stopped. > > Hi, > > (2) Yes. You can have 2 sendsms-user accounts within the same smsbox. > Additionally you can specify smsc=<smsc-id> in your push URL, plus there are > several options in you sendsms-user configuration such as default-smsc, > forced-smsc, etc. Read User's guide about them. > > BR, > Nikos > ----- Original Message ----- From: ahmad aburass > To: Nikos Balkanas > Cc: users@kannel.org > Sent: Sunday, June 27, 2010 5:26 PM > Subject: Re: Kannel drop MT's when bearerbox is stopped. > > > Hello Nikos, > > Your assumption is correct, the "*" is not in the included config file its > just in the email :). For your second point, when I deployed Kannel I wanted > to have a distinct smsbox for each operator so that each operator MT's will > be routed to its smsbox and smsc, and i searched the internet and found that > its possible to do it this way, is there any other way to configure Kannel > to achieve this approach. > > > Regards, > Ahmad. > > > > > > From: Nikos Balkanas <nbalka...@gmail.com> > To: ahmad aburass <ahmad1985_2...@yahoo.com>; users@kannel.org > Sent: Wed, June 23, 2010 7:04:40 PM > Subject: Re: Kannel drop MT's when bearerbox is stopped. > > Hi, > > What is your included operator1.conf file? > Is this your: > > *** operator1 smsbox config file > > I am surprised this thing works at all. > > 1) Comments are specified by "#", not "*". I presume this is just in the > email. > 2) If the included file is the operator1.conf you post, then you end up > with a configuration with 2 core groups! It should panic. > > BR, > Nikos > > > ----- Original Message ----- From: ahmad aburass > To: users@kannel.org > Sent: Wednesday, June 23, 2010 3:20 PM > Subject: Kannel drop MT's when bearerbox is stopped. > > > Hello All, > > I know that there is a lot of links indicating that Kannel doesnt do it, > but i face it in my deployment, so I thought maybe its something wrong in my > configuration. I'm using bearerbox with multiple smsboxes attached to it, > along side with sqlbox. I have configured store subsystem as well. Whenever > i stop bearerbox, all the queued MT's are dropped from the store and i get a > delivery report (NACK/no SMSC) in the access log: > > 2010-03-27 11:33:15 Receive DLR [SMSC:op1smsc] [SVC:] [ACT:] [BINF:] [FID:] > [from:999] [to:9647809863597] [flags:-1:-1:-1:-1:16] [msg:12:NACK/no SMSC] > [udh:0:] > 2010-03-27 11:34:55 Receive DLR [SMSC:op1smsc] [SVC:] [ACT:] [BINF:] [FID:] > [from:999] [to:9647807102585] [flags:-1:-1:-1:-1:16] [msg:12:NACK/no SMSC] > [udh:0:] > > Below is the config I made, PS: Kannel version 1.4.3, sqlbox version 0.7.2: > > ***smskannel.conf: > group = core > admin-port = 1500 > smsbox-port = 13001 > dlr-storage = mysql > sms-resend-retry = 9 > store-location = "/var/spool/kannel/kannel_mt.store" > store-type = file > store-dump-freq = 600 > > include = "/usr/local/kannel/etc/smsc_connections/operator1.conf" > > group = smsbox > bearerbox-host = 127.0.0.1 > bearerbox-port = 13002 > http-request-retry = 600 > http-queue-delay = 60 > smsbox-id = smsbox > > group = smsbox-route > smsbox-id = smsbox > smsc-id = "op" > > group = smsbox-route > smsbox-id = operator1smsbox > smsc-id = "op1smsc" > shortcode = "999" > > > ***sqlbox configuration > group = sqlbox > id = compsqlbox > smsbox-id = sqlbox > bearerbox-host = localhost > bearerbox-port = 13001 > smsbox-port = 13002 > sql-log-table = sent_sms > sql-insert-table = send_sms > > > ***operator1 smsbox config file > group = core > admin-port = 1500 > smsbox-port = 13001 > dlr-storage = mysql > sms-resend-retry = 9 > store-location = "/var/spool/kannel/kannel_mt.store" > store-type = file > store-dump-freq = 600 > > group = smsbox > bearerbox-host = 127.0.0.1 > bearerbox-port = 13002 > http-request-retry = 600 > http-queue-delay = 60 > smsbox-id = operator1smsbox > > group = smsbox-route > smsbox-id = smsbox > smsc-id = "op" > > group = smsbox-route > smsbox-id = operator1smsbox > smsc-id = "op1smsc" > shortcode = "999" > > > > Appreciate your help. > > > > > Ahmad Aburass, > >