Jarlco, You are not alone. there were and are many others like you. BTW, thanks for looking in the archives.
I will make it as simple as i can. To send SMS, you call /cgi-bin/sendsms?to=568574&text=testing To send SMS with DLR, you call /cgi-bin/sendsms?to=568574&text=testing&dlrmask=31&dlrurl=some-http-url where 31 is bit-ORing of 1 (DELIVERED t PHONE),2 (NOT DELIVERED to PHONE),4,8,16. more meanings of them can be found in Kannel docs. IT is this variable, dlrmask a. that cause the msg-id to be stored in mysql table. b. that keeps kannel in waiting mode till it gets the DLR from SMSC and update the value in mysql. c. that makes kannel trigger a request to dlr-url. For MORE info, PLEASE follow my posts on mysql+dlr, you will get clear picture. HTH Navjot Singh >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of >Jarlco >Sent: Monday, November 10, 2003 5:40 AM >To: [EMAIL PROTECTED] >Subject: Re: 0 queued, using mysql storage (PLEASE Check this thread >again) > > >I've found an old post by "Navjot Singh", in the thead at: > http://www.mail-archive.com/[EMAIL PROTECTED]/msg00909.html > >Now this is very interesting, however I've got some questions after reading >up on all this mysql stuff... > >Navjot said: >" >You need to set 1 variable dlrmask (another is optional). You just need to >append &dlrmask=31 and send the request. >See in the dlr table and you will find one row. >" >Now for every message I send do I always have to add: &dlrmask=31 to my >message command? >Then, what does that mean exactly? what's 31? and why the command? can you >make sure any automated replies etc gets stored in the mysql database as >well? > >Thanks a lot for any replies, (a little alone in this converstion) > >/Jarl > >"Jarlco" <[EMAIL PROTECTED]> wrote in message >news:[EMAIL PROTECTED] >> Hmm fear maybe not a lot of people actually use mysql to store >messages... >> my earlier post, details the problem... however I've now got a >question in >> order to be able to work on the problem unless someone figures it out.... >> >> (old message below as well) >> (using gentoo linux with kannel-cvs with mysql built in) >> >> What triggers storing of messages? Is it when you send one? Recieve one? >> have one on hold? anything in the config file(that I didn't have in >there)? >> or all of them? or none...? >> >> any ideas? >> >> Any help is greatly appreciated, I've gone so far, just need to >be able to >> store messages properly and my project is more than halfway :p >> >> Thanks a lot in advance, >> Jarl >> >> >> "Jarlco" <[EMAIL PROTECTED]> wrote in message >> news:[EMAIL PROTECTED] >> > >> > Got a strange problem on my hands that I can't seem to figure out... >I've >> > got mysql and would like to store any messages coming in our out in my >> > database, the database is set up with: >> > #CREATE TABLE SmsEvent ( >> > #smsc VARCHAR(255), >> > #ts VARCHAR(255), >> > #destination VARCHAR(255), >> > #service VARCHAR(255), >> > #url VARCHAR(255), >> > #mask VARCHAR(255), >> > #status VARCHAR(255), >> > #boxc VARCHAR(255), >> > #source VARCHAR(255), >> > #PRIMARY KEY(smsc) ) >> > #; >> > >> > However when I check the actual database after sending/recieving >messages >> > there is nothing in it.... >> > The status of the boxes looks like this: >> > >> > >> > Kannel bearerbox version `cvs-20031101'. System Linux, release >> > 2.4.20-gentoo-r6, version #1 Fri Sep 26 23:43:56 BST 2003, >machine i686. >> > Hostname jarlco, IP 192.168.0.10. Libxml version 20508. Using OpenSSL >> 0.9.6k >> > 30 Sep 2003. Using MySQL 4.0.14. Using native malloc. >> > Status: running, uptime 0d 0h 22m 7s >> > WDP: received 0 (0 queued), sent 0 (0 queued) >> > SMS: received 0 (0 queued), sent 3 (0 queued), store size 0 >> > SMS: inbound 0.00 msg/sec, outbound 0.00 msg/sec >> > DLR: 0 queued, using mysql storage >> > Box connections: >> > smsbox:(none), IP 127.0.0.1 (0 queued), (on-line 0d 0h 14m 6s) >> > SMSC connections: >> > wavecom_1 AT2[wavecom_1] (online 1327s, rcvd 0, sent 3, >failed 0, >> > queued 0 msgs) >> > >> > >> > and my config file looks like this: >> > ------------------------------------------ >> > group = core >> > admin-port = 13000 >> > admin-password = bar >> > smsbox-port = 13001 >> > store-file = "/tmp/kannel.store" >> > log-level = 2 >> > log-file = "/tmp/kannel.log" >> > access-log = /tmp/kannel.access >> > dlr-storage = mysql >> > >> > # SMSC CONNECTIONS >> > >> > group = smsc >> > smsc = at >> > smsc-id = wavecom_1 >> > allowed-smsc-id = wavecom_1 >> > modemtype = wavecom >> > device = /dev/ttyS0 >> > speed = 9600 >> > >> > >> > # MODEM GROUP >> > >> > group = modems >> > id = wavecom >> > name = Wavecom >> > detect-string = "WAVECOM" >> > >> > # SMSBOX SETUP >> > >> > group = smsbox >> > bearerbox-host = localhost >> > sendsms-port = 13013 >> > sendsms-url = "/cgi-bin/sendsms" >> > sendota-url = "/cgi-bin/sendota" >> > sendsms-chars = "0123456789 +-" >> > global-sender = 079 >> > reply-couldnotfetch = "Sorry, service was unable to fetch content..." >> > reply-couldnotrepresent = "Sorry, real message could not be represented >as >> > SMS" >> > reply-requestfailed = "Sorry, the request failed" >> > reply-emptymessage = "Empty SMS was recieved" >> > log-file = "/tmp/smsbox.log" >> > access-log = "/tmp/kannel.access" >> > log-level = 3 >> > >> > # SEND SMS USER CONFIG >> > >> > group = sendsms-user >> > username = jarl >> > password = cornell >> > >> > group = sendsms-user >> > username = tester >> > password = foobar >> > >> > # SMS SERVICE >> > >> > group = sms-service >> > keyword = xxx >> > aliases = "af;ta;argh;tsk" >> > name = test1 >> > header = Jarl's SMS Service >> > footer = J.C >> > text = xxx service >> > >> > group = sms-service >> > keyword = www >> > get-url = "http://%S"; >> > >> > group = sms-service >> > keyword = vote >> > text = "Thank you for your vote it will now be processed" >> > >> > group = sms-service >> > keyword = nop >> > text = "service" >> > >> > # DEFAULT SERVICE >> > >> > group = sms-service >> > keyword = default >> > text = "default" >> > >> > >> > # MYSQL CONFIGURATION >> > >> > group = mysql-connection >> > id = mydlr1 >> > host = localhost >> > mysql-username = jarl >> > mysql-password = xxx >> > database = kannel >> > >> > # STORAGE GROUP >> > >> > group = dlr-db >> > id = mydlr1 >> > table = SmsEvent >> > field-smsc = smsc >> > field-timestamp = ts >> > field-destination = destination >> > field-service = service >> > field-url = url >> > field-mask = mask >> > field-status = status >> > field-boxc-id = boxc >> > field-source = source >> > >> > >> > >> > Cheers a lot for any help in this matter, I'm sure i'm just not >> > understanding this properly, which is why I'm hoping someone here will >> > maybe.. >> > /Jarl >> > >> > >> > >> > >> > >> >> >> >> >> > > > > >
