There's a lot of info on the archives of this very same list, even a
tutorial if I'm not wrong.

The database fields are the same as kannel parameters. You just have
to fill the relevant ones on the send_sms table and kannel will queue
that to the outgoing queue as if it came from a sendsms HTTP request,
only a lot faster.

A sample insert could be:

INSERT DELAYED INTO send_sms (
momt, sender, receiver, msgdata, ".
time, smsc_id, service,.
)VALUES ( ".
'MT', '1234', '9876543210', 'This is a test',
UNIX_TIMESTAMP(), 'mysmsc', 'myservice',
)

I use INSERT DELAYED to improve performance on large inserts.

You can add account, binfo and any other fields you may need, but you
can leave them empty if you're not using those fields on your sendsms
requests.

In short, use this as a model, filling the same fields you're using in
your sendsms deliveries.

Hope it helps,
On 5/17/06, Fourat Zouari <[EMAIL PROTECTED]> wrote:
Hello Alejandro,
How to use it ? is there a conceptual model for the database ? is there any
tutorial talking about that ?
thanks


On 5/17/06, Alejandro Guerrieri <[EMAIL PROTECTED]> wrote:
> Use sqlbox for bulk sms. It _flies_ comparing to opening an http
> connection for each message you sent. You just have to insert the
> messages to send in an sql table and the module makes the job for you,
> fast and reliably.
>
> Hope it helps,
> --
> Alejandro Guerrieri
> Magicom
> http://www.magicom-bcn.net/
> LinkedIn: http://www.linkedin.com/in/aguerrieri
>
> On 5/13/06, Fourat Zouari <[EMAIL PROTECTED]> wrote:
> > Am doing bulk sms, attacking kannel '/cgi-bin/sendsms' url, and it's
going
> > very slowly, when debugging, i see this line in the bearerbox log
repeating
> > each 60 MT messages :
> >
> > 2006-05-13 16:38:58 [4556] [8] DEBUG: sms_router: time to sleep 30.00
secs.
> >
> > Am using SMS-C connexion.
> > Anyone can help ?
> > how to increase/decrease this sleep time value ?
> >
>
>




--
Alejandro Guerrieri
Magicom
http://www.magicom-bcn.net/
LinkedIn: http://www.linkedin.com/in/aguerrieri

Reply via email to