I just put it there as an example of custom query, you can use any
filtering, like:
and time <= UNIX_TIMESTAMP('2012-09-21 00:00') and time >=
UNIX_TIMESTAMP('2012-09-21 01:00')
etc..
2012/9/21 Primoxz Zonome <[email protected]>
> Thank you all for your reply.
>
> It does not have SQLBox.
> Through Navicat, I can see all the messages.
>
> Please regarding your suggestion, could you kindly complete the sample
> code...
>
> INSERT INTO send_sms SELECT * FROM sent_sms WHERE momt='MT' and <....>;
>
> What is here: <....>; ?
>
> I will read all manuals when this is over, but tonight I'm in a fix, so
> please pardon the totally noob questions,
>
> ------------------------------
> *De la:* spameden <[email protected]>
> *Către:* Alvaro Cornejo <[email protected]>
> *Cc:* Primoxz Zonome <[email protected]>; users <[email protected]>
> *Trimis:* Vineri, 21 Septembrie 2012 3:01:49
> *Subiect:* Re: Răspuns: How to resend messages in Kannel
>
> If you're using SQLBox you can resend all failed messages via simple
> query, i.e:
>
> INSERT INTO send_sms SELECT * FROM sent_sms WHERE momt='MT' and <....>;
>
> 2012/9/21 Alvaro Cornejo <[email protected]>
>
> Hi
>
>
> First of all ALWAYS CC kannel list so anyone can answer and everyone
> profits from knowledge.
>
> About your question, you need to study kannel architecture. Check
> manuals for that.
>
> I suspect that your client´s messages never reached kannel and should
> be stored somewhere in your db.
>
> Definetly you need to check your own application to see where they are
> stored before being passed to kannel and to know how/where to trick it
> to have the messages being resent.
>
> Note that there is a component (box) called sqlbox that reads a db and
> passes its messages to bearerbox (another kannel component) that send
> the message to the carrier. But it moves the message records from
> "send" table to "sent" table once they are sent to kannel for
> processing.
>
>
> Regards
>
> Alvaro
>
>
>
>
>
>
>
> |-----------------------------------------------------------------------------------------------------------------|
> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> celular y Nextel
> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
> SMS y GPRS online
> Visitenos en www.perusms.NET <http://www.perusms.net/>
> www.smsglobal.com.mx y
> www.pravcom.com
>
>
> On Thu, Sep 20, 2012 at 8:27 PM, Primoxz Zonome <[email protected]> wrote:
> > Hello Alvaro,
> >
> > You're very kind for replying.
> >
> > My confession is that I took over as sysadmin but still learning my way
> > through Kannel.
> > I didn't build the app. The GUI I've been used to does not have a
> message
> > resend, although I do have access to the database and there I can see all
> > the unsent messages stored in db.
> > Would you know mysql way I can use to send the messages? I heard
> somewhere
> > that if you change the status from 1 to 0 it will resend them.
> >
> > This is my core config
> >
> > group = core
> > admin-port = 13000
> > smsbox-port = 13001
> > admin-password = kannel
> > #status-password = foo
> > admin-deny-ip = "*.*.*.*"
> > admin-allow-ip = "127.0.0.1"
> > log-file = "logs/b.log"
> > log-level = 2
> > box-deny-ip = "*.*.*.*"
> > box-allow-ip = "127.0.0.1"
> > access-log = "logs/b-access.log"
> > dlr-storage = mysql
> >
> > Many thanks,
> >
> > primox
> >
> > ________________________________
> > De la: Alvaro Cornejo <[email protected]>
> > Către: Primoxz Zonome <[email protected]>
> > Cc: "[email protected]" <[email protected]>
> > Trimis: Vineri, 21 Septembrie 2012 2:08:27
> > Subiect: Re: How to resend messages in Kannel
> >
> > You should check your app. Kannel has no way to block messages if your
> > client has not paid his bill.
> >
> > Kannel only queue/store messages in case it found problems with an
> > smsc where it has to route the sms. It will automatically retry at
> > defined intervals and for a defined number of triesñ the it will give
> > up and discard the message...
> >
> > Regards
> >
> > Alvaro
> >
> >
> >
> |-----------------------------------------------------------------------------------------------------------------|
> > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> > celular y Nextel
> > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
> > SMS y GPRS online
> > Visitenos en www.perusms.NET <http://www.perusms.net/>
> www.smsglobal.com.mx y
> > www.pravcom.com
> >
> >
> > On Thu, Sep 20, 2012 at 7:32 PM, Primoxz Zonome <[email protected]>
> wrote:
> >> Greetings everyone,
> >>
> >> Please I need your help.
> >> I have a client who ran out of credits and during that period, all his
> >> messages were received by my Kannel installation but were not sent out.
> >> Now the client has paid and want me to send out all his messages.
> >>
> >> I cannot for the life of me figure out how to do this.
> >> Any help will be appreciated.
> >>
> >> Thanks guys!
> >>
> >> Primox
> >
> >
>
>
>
>
>
