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 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 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 >> >> > >
