sqlbox sits inbetween smsbox and bearerbox, and catches all traffic going in and out. If you queue a message using the HTTP interface on smsbox, it will overgone the same DLR methods as before (if you use sql storage it will write an entry there and wait for the answer to update it).
I'm not sure about MT enqueuing directly on sqlbox, never tried it that way with DLR's. Regarding scheduling, that would require a "WHERE" on the sql (eg, compare the "time" field with the local timestamp and only select messages where time >= timestamp). The way it is now (one query per message) could be overkill on large volumes, but with the patch for group selects and adding an index on the field could be easily implemented. Regards, Alejandro On Tue, Mar 4, 2008 at 3:52 PM, akif dinc <[EMAIL PROTECTED]> wrote: > > the idea with scheduling was having the message send at a given time/date. > like send message on the 12. of october 2008. > also one question i would like to ask is if how to find the relation > between the sent message and the delivery report to it. i've a smpp > connection and use sqlbox, it works for testing at the moment very well. > before using sqlbox i updated via a self written php file a databasetable > with the delivery report status. > after using sqlbox do i have to keep track of the send messages or can > sqlbox somehow do this for me? > i wonder if there is still need for futher db tables or if i can handle > all with the existing sent_sms. where my needs would be restricted to know > what status the message at the moment has (like delivered, pending, etc.) > > thank you very much in advance, > > ------------------------------ > Date: Tue, 4 Mar 2008 12:26:34 -0200 > From: [EMAIL PROTECTED] > To: [email protected] > Subject: Re: sqlbox kannel and scheduling > > > >From what I've learned from the source code, no, sqlbox reads messages > one by one (I've made a patch to retrieve batches of messages) without any > kind of sorting or scheduling. > > So, if you insert 100K messages at once, they will be retrieved one by one > and not necessarily on the same order of insertion. > > The only scheduling you'll get is when messages are on the kannel's store > (that's when sqlbox insert the messages to bearerbox). > > Hope it helps, > > Alejandro > > 2008/3/4 akif dinc <[EMAIL PROTECTED]>: > > hello, > > does sqlbox support sheduling? > > > > ------------------------------ > Direkter Zugriff zu Hotmail und Messenger! Kostenloses Update für Ihren > Internet > Explorer!<http://redirect.gimas.net/?cat=hmtl&n=M1207IE&d=http://optimize.de.msn.com/default.aspx?mkt=de-de> > > > > > -- > Alejandro Guerrieri > Magicom > http://www.magicom-bcn.net/ > LinkedIn: http://www.linkedin.com/in/aguerrieri > > > ------------------------------ > Mit Live Search: Ihre Stadt in der Vogelperspektive! Erleben Sie neue > Blickwinkel!<http://redirect.gimas.net/?cat=hmtl&n=M1207Maps&d=http://maps.live.de> > -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/ LinkedIn: http://www.linkedin.com/in/aguerrieri
