SQLBox Question
In the sms-service we have a directive 'name', 'keyword-regex', 'aliases'. How to grab this value with SQLBox and store it as service in the database? TIA Willy
Re: SQLBox Question
Alejandro, Many thanks for the reply and I am looking forward for the patch. BTW, if it is possible please also grab Kannel's internal message ID into your patch. It will be very helpful for other users also I guess ;) Willy "What's this? Trix? Aunt! Trix? You? You're after the prize! What is it?" He picked up the box and studied the back. "A glow-in-the-dark squid! Have you got it out of there yet?" He tilted the box, angling the little colored balls of cereal so as to see the bottom, and nearly spilling them onto the table top. "Here it is!" He hauled out a little cream-colored, glitter-sprinkled squid, three-inches long and made out of rubbery plastic. -- James P. Blaylock, "The Last Coin" -Original Message- From: Alejandro Guerrieri To: sangprabv Cc: Kannel User Subject: Re: SQLBox Question Date: Thu, 25 Dec 2008 14:32:10 +0100 Willy, The SMSC message id issue was not a limitation on SQLBox, but on Kannel itself. It was fixed on CVS a few weeks ago. SQLBox is still lacking the extra field needed to carry the info, I'll fix that as soon as I settle up (I've recently moved to Barcelona and I'm still a little overwhelmed :P). Regards, Alejandro On Thu, Dec 25, 2008 at 12:19 PM, sangprabv wrote: Hi, Im using SQLBox to handle MO, MT, DLR and use MySQL as the DB engine. Why if we use SMPP it can't grab the message id (MO and DLR) sent by telco? I see the id/binfo field is always empty. How to enable it? So we can analyze our traffic report using SQLBox? Is it considered to be an RFC? Please help and TIA. Willy Q: Why do firemen wear red suspenders? A: To conform with departmental regulations concerning uniform dress.
Re: SQLBox Question
Willy, The SMSC message id issue was not a limitation on SQLBox, but on Kannel itself. It was fixed on CVS a few weeks ago. SQLBox is still lacking the extra field needed to carry the info, I'll fix that as soon as I settle up (I've recently moved to Barcelona and I'm still a little overwhelmed :P). Regards, Alejandro On Thu, Dec 25, 2008 at 12:19 PM, sangprabv wrote: > Hi, > Im using SQLBox to handle MO, MT, DLR and use MySQL as the DB engine. > Why if we use SMPP it can't grab the message id (MO and DLR) sent by > telco? I see the id/binfo field is always empty. How to enable it? So we > can analyze our traffic report using SQLBox? Is it considered to be an > RFC? Please help and TIA. > > > Willy > Q: Why do firemen wear red suspenders? A: To conform with departmental > regulations concerning uniform dress. > > > >
SQLBox Question
Hi, Im using SQLBox to handle MO, MT, DLR and use MySQL as the DB engine. Why if we use SMPP it can't grab the message id (MO and DLR) sent by telco? I see the id/binfo field is always empty. How to enable it? So we can analyze our traffic report using SQLBox? Is it considered to be an RFC? Please help and TIA. Willy Q: Why do firemen wear red suspenders? A: To conform with departmental regulations concerning uniform dress.
Re: SQLBox Question
The connection sequence is bearerbox-sqlbox-smsbox. When you send a MT response from a sms-service reply, it will get stored in SQL box's sent sms table. I fact, all MO' and MT's passed through this model will get stored by SQL box. It may be used as a simple CDR solution. Eduardo On 11/20/08, sangprabv <[EMAIL PROTECTED]> wrote: > Hi, > I read some threads in the archives about how to reply MT using SQLBox. > AFAIK it can be done by injecting manually the MT to the send table. > What I confuse here is, what about if the MT is expected as the HTTP > Response. How does SQLBox treat and serve this? And does the sequence is > bearerbox-sqlbox-smsbox? Or bearerbox-smsbox-sqlbox? How to configure > the latter? TIA. > > > Willy > > > -- Sent from my mobile device Eduardo Raad Gerente General Metromovil móvil + 593 9397 oficina + 593 42329455 x 1099 Av. 10 de Agosto 511 y Chimborazo Edificio Equinoxcorp, Piso 3 Guayaquil, Ecuador
SQLBox Question
Hi, I read some threads in the archives about how to reply MT using SQLBox. AFAIK it can be done by injecting manually the MT to the send table. What I confuse here is, what about if the MT is expected as the HTTP Response. How does SQLBox treat and serve this? And does the sequence is bearerbox-sqlbox-smsbox? Or bearerbox-smsbox-sqlbox? How to configure the latter? TIA. Willy
Re: SQLBOX Question
Yep. You'll have to fill relevant fields. After sending the row will be moved to sent_sms. Regards, Alex 2008/10/17 James Mutuku <[EMAIL PROTECTED]> > Hello list, > > I have a small beginner question on sql box --- to be able send sms using > sqlbox, do I insert the SMS into the send_sms table for sqlbox? > > James >
SQLBOX Question
Hello list, I have a small beginner question on sql box --- to be able send sms using sqlbox, do I insert the SMS into the send_sms table for sqlbox? James begin:vcard fn:James Mutuku n:Mutuku;James org:Agile Systems Limited;Technical Department adr:;;P.O Box 55686-00200;Nairobi;Kenya;00200;Kenya email;internet:[EMAIL PROTECTED] title:Lead Consultant tel;work:+254-722-490994 tel;home:+254-722-490994 tel;cell:+254-722-490994 note;quoted-printable:This email may be confidential. Any distribution, use or copying of thise= mail or the information it contains by other than an intended recipientsi= s unauthorized. If you received this email in error, please advise me(by= return email or otherwise) immediately.=0D=0A= =0D=0A= Ce courriel est confidentiel. Toute diffusion, utilisation ou copie decem= essage ou des renseignements qu'il contient par une personne autrequeles= destinataires d=C3=A9sign=C3=A9s est interdite. Si vous recevezcecourrie= l par erreur, veuillez m'en aviser imm=C3=A9diatement, par retourde courr= iel ou par un autre moyen. = =0D=0A= =0D=0A= Este mensaje es confidencial. Cualquier distribuci=C3=B3n, uso o copiadel= mensaje o de la informaci=C3=B3n en el contenido por otras personasdistin= tas de los destinatarios esta prohibida. Si usted recibe este mensajepor= error, por favor comun=C3=ADquemelo inmediatamente mediante reenv=C3=ADo= del mensaje o por otro medio.=0D=0A= =0D=0A= url:www.agile.co.ke version:2.1 end:vcard
SQLBox Question and Performance
Hi, I am a new user of great Kannel SQLBox, but I have some problem when integrate it with Kannel. I have configured the kannel and sqlbox configuration (referred to this thread http://www.mail-archive.com/users@kannel.org/msg08736.html) and daemonized them, everything is ok here. And when I try to manually insert a record to the send_sms table the SQLBox sucessfully detect it and it moved to sent_sms, the problem is why it doesn't sent actually send the SMS? I check kannel's logfile and there is no SMS sent. And the other problem is, after sometime (maybe it's about a minute) the SQLBox suddenly stop by itself and I must restart it manually, what's the problem here? Is it caused by miss configuration? The other question is it's performance, is it stable to handle thousand SMS/minute or millions SMS/day? Please guide me how to configure this great SQLBox and tuning it to be able to handle high load SMS traffic. Many thanks for your kind help and support. Regards Willy
Re: SQLBOX question
This is because smsbox is not connected to sqlbox. Attach your last config file please. M On 7/14/06, Fourat Zouari <[EMAIL PROTECTED]> wrote: ok it's working ! thank you I've tryed to send an MO with smscfake and i got this in bearerbox.log : 2006-07-14 17:37:42 [10645] [6] DEBUG: smsc_fake: new message received 2006-07-14 17:37:42 [10645] [6] WARNING: smsbox_list empty! 2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty! 2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty! 2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty! 2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty! 2006-07-14 17:38:01 [10645] [13] DEBUG: Dumping 1 messages to store and i got nothing in sent_sms and send_sms tables On 7/14/06, Humberto Figuera <[EMAIL PROTECTED]> wrote: > Hi Fourat, > > please test add the line "port=5432" or "port=the_port_of_postgres" in > the pgsql-connection group. > > ;p > > On 7/14/06, Fourat Zouari <[EMAIL PROTECTED]> wrote: > > It's ok, i got the sqlbox working > > But still have one problem : > > I have PGSQL going on the server, created a user owning a database and > > configured my db group to fit that, the db connexion is ok, but sqlbox throw > > an error in sqlbox.log : > > - > > 2006-07-14 16:19:16 [7744] [0] INFO: Added logfile > > `/var/log/smgs/sqlbox.log' with level `0'. > > 2006-07-14 16:19:16 [7744] [0] ERROR: PGSQL: connection to database > > 'smgstest' failed! > > 2006-07-14 16:19:16 [7744] [0] PANIC: PGSQL: could not connect to server: > > Connection refused > > Is the server running on host "localhost" and accepting > > TCP/IP connections on port 1735355439? > > > > 2006-07-14 16:19:16 [7744] [0] PANIC: > > /usr/local/sbin/sqlbox(gw_panic+0xe1) [0x806c030] > > 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox [0x8060731] > > 2006-07-14 16:19:16 [7744] [0] PANIC: > > /usr/local/sbin/sqlbox(dbpool_increase+0xe1) [0x8060cf0] > > 2006-07-14 16:19:16 [7744] [0] PANIC: > > /usr/local/sbin/sqlbox(dbpool_create+0x79) [0x8060dba] > > 2006-07-14 16:19:16 [7744] [0] PANIC: > > /usr/local/sbin/sqlbox(sqlbox_init_pgsql+0x2f4) [0x80538b5] > > 2006-07-14 16:19:16 [7744] [0] PANIC: > > /usr/local/sbin/sqlbox(main+0x379) [0x805087f] > > 2006-07-14 16:19:16 [7744] [0] PANIC: > > /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xd2) > > [0xb7b39ea2] > > 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox [0x804f911] > > - > > > > Verifying with netstat, postgresql is listening, and i can log into db and > > create any table i want. > > here's my conf : > > > > --SQLBOX-- > > group = sqlbox > > # id corresponds to id in group = mysql-connection. > > # this is analogous to id in group = dlr-db > > id = dlr-01-db > > # smsbox-id indicates the box where SQL-injected messages appear to be > > coming from > > smsbox-id = smsbox-01 > > # bearerbox host to connect to > > bearerbox-host = "127.0.0.1" > > # smsbox port to be listening on > > smsbox-port = 13002 > > smsbox-port-ssl = false > > # sql-log-table is the table used to log all sent messages > > sql-log-table = sent_sms > > # sql-insert-table is the table that is monitored for new messages to send > > sql-insert-table = send_sms > > # global sender: If no sender is specified in sql-insert-table then this > > # value is used. > > global-sender = 06121 > > log-file = "/var/log/smgs/sqlbox.log" > > log-level = 0 > > # ssl-client-certkey-file = "" > > # ssl-server-cert-file = "" > > # ssl-server-key-file = "" > > # ssl-trusted-ca-file = "" > > --SQLBOX-- > > > > --SMSBOX-- > > smsbox.conf smsc.conf smsc-fake.conf > > [EMAIL PROTECTED]:/etc/smgs# cat smsbox.conf > > group = smsbox > > bearerbox-host = "localhost" > > log-file = "/var/log/kannel/smsbox.log" > > log-level = 0 > > mo-recode = true > > http-request-retry = 10 > > http-queue-delay = 60 > > smsbox-id = smsbox-01 > > sendsms-port = 13002 > > bearerbox-is-sqlbox=true > > --SMSBOX-- > > > > --BEARERBOX-- > > group = core > > admin-port = 13000 > > admin-password = fxxbar > > status-password = sTtx > > admin-deny-ip = "*.*.*.*" > > admin-allow-ip = 127.0.0.1 > > box-deny-ip = "*.*.*.*" > > box-allow-ip = 127.0.0.1 > > wdp-interface-name = "*" > > log-file = "/var/log/kannel/bearerbox.log" > > log-level = 0 > > access-log = "/var/log/kannel/access.log" > > smsbox-port = 13001 > > store-file = "/var/log/kannel/store" > > dlr-storage = pgsql > > --BEARERBOX---
Re: SQLBOX question
ok it's working ! thank youI've tryed to send an MO with smscfake and i got this in bearerbox.log :2006-07-14 17:37:42 [10645] [6] DEBUG: smsc_fake: new message received 2006-07-14 17:37:42 [10645] [6] WARNING: smsbox_list empty!2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty!2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty!2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty! 2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty!2006-07-14 17:38:01 [10645] [13] DEBUG: Dumping 1 messages to store and i got nothing in sent_sms and send_sms tablesOn 7/14/06, Humberto Figuera <[EMAIL PROTECTED]> wrote: Hi Fourat,please test add the line "port=5432" or "port=the_port_of_postgres" in the pgsql-connection group.;pOn 7/14/06, Fourat Zouari <[EMAIL PROTECTED]> wrote:> It's ok, i got the sqlbox working> But still have one problem : > I have PGSQL going on the server, created a user owning a database and> configured my db group to fit that, the db connexion is ok, but sqlbox throw> an error in sqlbox.log :> - > 2006-07-14 16:19:16 [7744] [0] INFO: Added logfile> `/var/log/smgs/sqlbox.log' with level `0'.> 2006-07-14 16:19:16 [7744] [0] ERROR: PGSQL: connection to database> 'smgstest' failed!> 2006-07-14 16:19:16 [7744] [0] PANIC: PGSQL: could not connect to server: > Connection refused> Is the server running on host "localhost" and accepting> TCP/IP connections on port 1735355439?>> 2006-07-14 16:19:16 [7744] [0] PANIC: > /usr/local/sbin/sqlbox(gw_panic+0xe1) [0x806c030]> 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox [0x8060731]> 2006-07-14 16:19:16 [7744] [0] PANIC:> /usr/local/sbin/sqlbox(dbpool_increase+0xe1) [0x8060cf0] > 2006-07-14 16:19:16 [7744] [0] PANIC:> /usr/local/sbin/sqlbox(dbpool_create+0x79) [0x8060dba]> 2006-07-14 16:19:16 [7744] [0] PANIC:> /usr/local/sbin/sqlbox(sqlbox_init_pgsql+0x2f4) [0x80538b5] > 2006-07-14 16:19:16 [7744] [0] PANIC:> /usr/local/sbin/sqlbox(main+0x379) [0x805087f]> 2006-07-14 16:19:16 [7744] [0] PANIC:> /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xd2)> [0xb7b39ea2] > 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox [0x804f911]> ->> Verifying with netstat, postgresql is listening, and i can log into db and > create any table i want.> here's my conf :>> --SQLBOX--> group = sqlbox> # id corresponds to id in group = mysql-connection. > # this is analogous to id in group = dlr-db> id = dlr-01-db> # smsbox-id indicates the box where SQL-injected messages appear to be> coming from> smsbox-id = smsbox-01> # bearerbox host to connect to > bearerbox-host = "127.0.0.1"> # smsbox port to be listening on> smsbox-port = 13002> smsbox-port-ssl = false> # sql-log-table is the table used to log all sent messages > sql-log-table = sent_sms> # sql-insert-table is the table that is monitored for new messages to send> sql-insert-table = send_sms> # global sender: If no sender is specified in sql-insert-table then this > # value is used.> global-sender = 06121> log-file = "/var/log/smgs/sqlbox.log"> log-level = 0> # ssl-client-certkey-file = ""> # ssl-server-cert-file = "" > # ssl-server-key-file = ""> # ssl-trusted-ca-file = ""> --SQLBOX-->> --SMSBOX-- > smsbox.conf smsc.conf smsc-fake.conf> [EMAIL PROTECTED]:/etc/smgs# cat smsbox.conf> group = smsbox> bearerbox-host = "localhost"> log-file = "/var/log/kannel/smsbox.log" > log-level = 0> mo-recode = true> http-request-retry = 10> http-queue-delay = 60> smsbox-id = smsbox-01> sendsms-port = 13002> bearerbox-is-sqlbox=true> --SMSBOX-- >> --BEARERBOX--> group = core> admin-port = 13000> admin-password = fxxbar> status-password = sTtx> admin-deny-ip = "*.*.*.*" > admin-allow-ip = 127.0.0.1> box-deny-ip = "*.*.*.*"> box-allow-ip = 127.0.0.1> wdp-interface-name = "*"> log-file = "/var/log/kannel/bearerbox.log" > log-level = 0> access-log = "/var/log/kannel/access.log"> smsbox-port = 13001> store-file = "/var/log/kannel/store"> dlr-storage = pgsql> --BEARERBOX-- >> --SMSC--> group = smsc> smsc = fake> smsc-id = SMPP-01-FAKE> port = 1> connect-allow-ip = 127.0.0.1> --SMSC-->> --PGSQLCONNEXION--> group = pgsql-connection > id = dlr-
Re: SQLBOX question
Hi Fourat, please test add the line "port=5432" or "port=the_port_of_postgres" in the pgsql-connection group. ;p On 7/14/06, Fourat Zouari <[EMAIL PROTECTED]> wrote: It's ok, i got the sqlbox working But still have one problem : I have PGSQL going on the server, created a user owning a database and configured my db group to fit that, the db connexion is ok, but sqlbox throw an error in sqlbox.log : - 2006-07-14 16:19:16 [7744] [0] INFO: Added logfile `/var/log/smgs/sqlbox.log' with level `0'. 2006-07-14 16:19:16 [7744] [0] ERROR: PGSQL: connection to database 'smgstest' failed! 2006-07-14 16:19:16 [7744] [0] PANIC: PGSQL: could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 1735355439? 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox(gw_panic+0xe1) [0x806c030] 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox [0x8060731] 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox(dbpool_increase+0xe1) [0x8060cf0] 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox(dbpool_create+0x79) [0x8060dba] 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox(sqlbox_init_pgsql+0x2f4) [0x80538b5] 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox(main+0x379) [0x805087f] 2006-07-14 16:19:16 [7744] [0] PANIC: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xd2) [0xb7b39ea2] 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox [0x804f911] - Verifying with netstat, postgresql is listening, and i can log into db and create any table i want. here's my conf : --SQLBOX-- group = sqlbox # id corresponds to id in group = mysql-connection. # this is analogous to id in group = dlr-db id = dlr-01-db # smsbox-id indicates the box where SQL-injected messages appear to be coming from smsbox-id = smsbox-01 # bearerbox host to connect to bearerbox-host = "127.0.0.1" # smsbox port to be listening on smsbox-port = 13002 smsbox-port-ssl = false # sql-log-table is the table used to log all sent messages sql-log-table = sent_sms # sql-insert-table is the table that is monitored for new messages to send sql-insert-table = send_sms # global sender: If no sender is specified in sql-insert-table then this # value is used. global-sender = 06121 log-file = "/var/log/smgs/sqlbox.log" log-level = 0 # ssl-client-certkey-file = "" # ssl-server-cert-file = "" # ssl-server-key-file = "" # ssl-trusted-ca-file = "" --SQLBOX-- --SMSBOX-- smsbox.conf smsc.conf smsc-fake.conf [EMAIL PROTECTED]:/etc/smgs# cat smsbox.conf group = smsbox bearerbox-host = "localhost" log-file = "/var/log/kannel/smsbox.log" log-level = 0 mo-recode = true http-request-retry = 10 http-queue-delay = 60 smsbox-id = smsbox-01 sendsms-port = 13002 bearerbox-is-sqlbox=true --SMSBOX-- --BEARERBOX-- group = core admin-port = 13000 admin-password = fxxbar status-password = sTtx admin-deny-ip = "*.*.*.*" admin-allow-ip = 127.0.0.1 box-deny-ip = "*.*.*.*" box-allow-ip = 127.0.0.1 wdp-interface-name = "*" log-file = "/var/log/kannel/bearerbox.log" log-level = 0 access-log = "/var/log/kannel/access.log" smsbox-port = 13001 store-file = "/var/log/kannel/store" dlr-storage = pgsql --BEARERBOX-- --SMSC-- group = smsc smsc = fake smsc-id = SMPP-01-FAKE port = 1 connect-allow-ip = 127.0.0.1 --SMSC-- --PGSQLCONNEXION-- group = pgsql-connection id = dlr-01-db host = localhost username = test password = test database = test max-connections = 6 --PGSQLCONNEXION-- --DLR-DB-- group = dlr-db id = dlr-01-db table = dlr field-smsc = smsc field-timestamp = date field-destination = da field-source = soa field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxcid --DLR-DB-- -- Humberto Figuera - Using Linux 2.6.17 Usuario GNU/Linux 369709 Caracas - Venezuela GPG Key Fingerprint = 5AAC DF0C 00F4 2834 28BA 37AD 3364 01D1 74CA 0603
Re: SQLBOX question
rtinOn 6/30/06, Fourat Zouari <[EMAIL PROTECTED]> wrote:> Thanks for your help,> I got it, but not working ... > I downloaded the latest snapshot of kannel> untared the kannel-snapshot, renamed the folder to gateway/> downloaded sqlbox from cvs, moved it to the same folder where gateway/> exists.> Did this : >> BEGIN> tux:~/kannel/sqlbox# make patch> patch -p0 -d ../gateway < sqlbox.patch> patching file Makefile.in > patching file configure> Hunk #1 FAILED at 10880.> Hunk #2 FAILED at 10957.> Hunk #3 succeeded at 6250 with fuzz 1 (offset -6630 lines).> 2 out of 3 hunks FAILED -- saving rejects to file configure.rej> patching file configure.in> Hunk #1 succeeded at 913 (offset -23 lines).> Hunk #2 succeeded at 980 (offset -23 lines).> patching file gw/smsbox.c > Hunk #2 succeeded at 3365 with fuzz 2.> patching file gwlib/cfg.def> make: *** [patch] Erreur 1> END>> for informations, here's a snapshot from kannel/ folder listing : >> BEGIN> tux:~/kannel# ll> total 4,9M> drwxr-xr-x 16 1013 1013 4,0K 2006-06-30 21:55 gateway> -rw-r--r-- 1 root root 2,4M 2006-06-28 15:25 gateway-1.4.0.tar.gz> -rw-r--r-- 1 root root 2,5M 2006-05-25 14:38 kannel-snapshot.tar.gz> drwxr-xr-x 5 root root 4,0K 2006-06-30 17:41 sqlbox> -rw-r--r-- 1 root root 19K 2006-06-30 21:45 sqlbox.tgz > END>> Thanks for your help>>>> On 6/30/06, Rene Kluwen <[EMAIL PROTECTED] > wrote:> >> >> >> > After you check out sqlbox from CVS, there is a readme.> > It has some (rudimentary, admitted) documentation.> >> >> > Rene Kluwen > > Chimit> >> >> >> > -Original Message-> > From: Fourat Zouari [mailto:[EMAIL PROTECTED]]> > Sent: vrijdag 30 juni 2006 17:10 > > To: Mi Reflejo> > Cc: Rene Kluwen; Nikola Goran Cutura; users@kannel.org> > Subject: Re: SQLBOX question> >> > ok thanks for helping, > > is there any document, tutorial that can help in implementing this box in> kannel ?> >> >> > On 6/30/06, Mi Reflejo < [EMAIL PROTECTED] > wrote:> > > sqlbox is a external module. It is in kannel cvs but in different> project.> > >> > > You can get it doing:> > >> > > # cvs -d:pserver:[EMAIL PROTECTED] :/home/cvs co> sqlbox> > >> > > M.> > >> > > On 6/30/06, Fourat Zouari <[EMAIL PROTECTED]> wrote:> > > > hello all, > > > > I have kannel installed from CVS snapshot and i did not see any> mention of> > > > sqlbox there (in docs and in application)> > > > How can i implement this module in ? > > > > thanks> > > >> > > >> > > > On 5/10/06, Rene Kluwen < [EMAIL PROTECTED]> wrote:> > > > > The sent_sms and send_sms tables are NOT used by any other module > but> > > > sqlbox> > > > > itself.> > > > > If you want to send messages by sqlbox, you will have to manually> insert> > > > > them in the send_sms table. > > > > >> > > > > The sent_sms table is used (indeed) to store outgoing & incoming> messages> > > > as> > > > > well as DLR's.> > > > > This is just a "log". > > > > >> > > > > The smsbox_list empty! error message can possibly be fixed by an> > > > > smsbox-route section in your kannel.conf.> > > > > > > > > > Rene Kluwen> > > > > Chimit> > > > >> > > > >> > > > > -Original Message-> > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On> > > > > Behalf Of Nikola Goran Cutura> > > > > Sent: woensdag 10 mei 2006 0:46 > > > > > To: Mi Reflejo> > > > > Cc: users@kannel.org> > > > > Subject: Re: SQLBOX question> > > > >> > > > > > > > > > Thanks for the prompt answer!> > > > >> > > > > I read the sqlbox FAQ but my understanding was that sqlbox sits in> the> > > > > middle so that bearerbox and smsbox don't see each other. What > confuses me> > > > > is sqlbox insert table. It is supposed to contain messages (MO/MT)> not yet> > > > > processed by their destination handlers (bearerbox for MT, smsbox > for
RE: SQLBOX question
The sent_sms and send_sms tables are NOT used by any other module but sqlbox itself. If you want to send messages by sqlbox, you will have to manually insert them in the send_sms table. The sent_sms table is used (indeed) to store outgoing & incoming messages as well as DLR's. This is just a "log". The smsbox_list empty! error message can possibly be fixed by an smsbox-route section in your kannel.conf. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nikola Goran Cutura Sent: woensdag 10 mei 2006 0:46 To: Mi Reflejo Cc: users@kannel.org Subject: Re: SQLBOX question Thanks for the prompt answer! I read the sqlbox FAQ but my understanding was that sqlbox sits in the middle so that bearerbox and smsbox don't see each other. What confuses me is sqlbox insert table. It is supposed to contain messages (MO/MT) not yet processed by their destination handlers (bearerbox for MT, smsbox for MO). So I realized that having beaerbox running with sqlbox connected to it would accumulate MO messages until smsbox is started. Is sqlbox insert table used only for manual inserts? E.g. if I want to bypass http sendsms and insert sms directly into insert table? Does smsbox use insert table? Does bearerbox? Regards, NGC - Original Message - From: "Mi Reflejo" <[EMAIL PROTECTED]> To: "Nikola Goran Cutura" <[EMAIL PROTECTED]> Sent: Wednesday, May 10, 2006 12:26 AM Subject: Re: SQLBOX question yes, there is an understanding problem. from sqlbox FAQ: Q. Does sqlbox replace sms box or is It an additional module that must be run? A. sqlbox is an additional module. You now have to start kannel in the following manner: 1st: bearerbox 2nd: sqlbox 3rd: smsbox and wapbox A picture of the new situation (with sqlbox included is as follows): http request <--> [ smsbox ] <--> [ sqlbox ] <--> [ bearerbox ] <--> sms gateway I hope this picture make things clear. In text: sqlbox is sitting in between smsbox and bearerbox, passing all messages back and forth between the two. As a side-effect, also the messages that are passed back and forth are logged in the sent_sms table. SMS routing can't be done without SMSBOX. Regards, Anselmo
Re: SQLBOX question
Thanks for the prompt answer! I read the sqlbox FAQ but my understanding was that sqlbox sits in the middle so that bearerbox and smsbox don't see each other. What confuses me is sqlbox insert table. It is supposed to contain messages (MO/MT) not yet processed by their destination handlers (bearerbox for MT, smsbox for MO). So I realized that having beaerbox running with sqlbox connected to it would accumulate MO messages until smsbox is started. Is sqlbox insert table used only for manual inserts? E.g. if I want to bypass http sendsms and insert sms directly into insert table? Does smsbox use insert table? Does bearerbox? Regards, NGC - Original Message - From: "Mi Reflejo" <[EMAIL PROTECTED]> To: "Nikola Goran Cutura" <[EMAIL PROTECTED]> Sent: Wednesday, May 10, 2006 12:26 AM Subject: Re: SQLBOX question yes, there is an understanding problem. from sqlbox FAQ: Q. Does sqlbox replace sms box or is It an additional module that must be run? A. sqlbox is an additional module. You now have to start kannel in the following manner: 1st: bearerbox 2nd: sqlbox 3rd: smsbox and wapbox A picture of the new situation (with sqlbox included is as follows): http request <--> [ smsbox ] <--> [ sqlbox ] <--> [ bearerbox ] <--> sms gateway I hope this picture make things clear. In text: sqlbox is sitting in between smsbox and bearerbox, passing all messages back and forth between the two. As a side-effect, also the messages that are passed back and forth are logged in the sent_sms table. SMS routing can't be done without SMSBOX. Regards, Anselmo
SQLBOX question
Hi all, I have bearerbox running and connected to SMSCs. I have sqlbox running. I have NO smsbox running. I expect that in this configuration, sqlbox stores all incoming messages. However, when I send a message from smsc to bearerbox, I get warning: WARNING: smsbox_list empty! and NO message is inserted in sqlbox table. Do I have wrong expectations or wrong configuration? My configuration is attached. It is customized sample that comes with Kannel. Regards, NGC smskannel.conf Description: Binary data
Re: SQLBOX question
Hi, Basically SQLBOX watches the send_sms table for changes and when some row is inserted into that table it will inject the message into the bearerbox. All you have to do to send a message is to insert a row into that table and SQLBOX does the rest. However; some time ago there was a problem with binary messages (with UDH); I don't know if it's fixed or not. Catalin info.ubichip IMAP wrote: > > > Hello, > > I'm using kannel with sqlbox. I well understand the table sent_sms but I > don't have any documentation regarding send_sms table. Do someone could > please give me some information and example to use it ? > > Regards > > >
SQLBOX question
Hello, I'm using kannel with sqlbox. I well understand the table sent_sms but I don't have any documentation regarding send_sms table. Do someone could please give me some information and example to use it ? Regards