i'm trying to track the injected messages to sqlbox, but i just realized when inserting messages to send_sms the tablefield id, which i fill with uniq ids (in order to be able to track this entry and update later the dlr status) are not inserted into the sent_sms table field called id. does someone see a mistake in the idea?
Date: Tue, 4 Mar 2008 16:18:55 -0200 From: [EMAIL PROTECTED] To: [email protected] Subject: Re: sqlbox kannel and scheduling 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! -- 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! -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/ LinkedIn: http://www.linkedin.com/in/aguerrieri _________________________________________________________________ Windows Live Fotogalerie: So einfach organisieren Sie Ihre Fotos! http://get.live.com/photogallery/overview
