Hi all Maybe my question was incomplete
The IMSI structure has 15 digits: - the first 3 digits as country id - the 4th and 5th digit operator id - the 6th and 7th the home HLR of the terminal - the last 8 digits in conjunction whit the 6th and 7th digits are the MSIN We need to change the 6th and 7th because we have a second HLR on our network, we can make the changes on the SIM whit SIMs card readers, but we have a huge quantity of terminals on the market Thanks cidar -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de [EMAIL PROTECTED] Enviado el: Monday, November 10, 2003 3:58 AM Para: [EMAIL PROTECTED] Asunto: users digest, Vol 1 #924 - 7 msgs Send users mailing list submissions to [EMAIL PROTECTED] To subscribe or unsubscribe via the World Wide Web, visit http://www.kannel.org/mailman/listinfo/users or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of users digest..." Today's Topics: 1. Re: 0 queued, using mysql storage (PLEASE Check this thread again) (Jarlco) 2. RE: 0 queued, using mysql storage (PLEASE Check this thread again) (Navjot Singh) 3. RE: How change IMSI via OTA (sunil baburaoji) 4. RE: How change IMSI via OTA (Navjot Singh) 5. RE: How change IMSI via OTA (sunil baburaoji) 6. dlr question (Chris Botor) 7. Re: 0 queued, using mysql storage (PLEASE Check this thread again) (rudy) --__--__-- Message: 1 To: [EMAIL PROTECTED] From: "Jarlco" <[EMAIL PROTECTED]> Subject: Re: 0 queued, using mysql storage (PLEASE Check this thread again) Date: Mon, 10 Nov 2003 00:10:14 -0000 Reply-To: "Jarlco" <[EMAIL PROTECTED]> 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 > > > > > > > > > > > > > > > --__--__-- Message: 2 From: "Navjot Singh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: RE: 0 queued, using mysql storage (PLEASE Check this thread again) Date: Mon, 10 Nov 2003 11:29:50 +0530 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 >> > >> > >> > >> > >> > >> >> >> >> >> > > > > > --__--__-- Message: 3 Subject: RE: How change IMSI via OTA Date: Mon, 10 Nov 2003 12:55:33 +0530 From: "sunil baburaoji" <[EMAIL PROTECTED]> To: "Jacques Caron" <[EMAIL PROTECTED]>, "Cidar Ramirez" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Hi, You can't change IMSI (International Mobile Subscriber Identity) of SIM, as IMSI is unique for particular SIM throughout life. TMSI (Temporary Mobile Subscriber Identity) & PTMSI (Packet TMSI) you=20 can change through some GMS or GPRS procedure. But it's totally out of=20 question for WAP protocol. - sunil -----Original Message----- From: Jacques Caron [mailto:[EMAIL PROTECTED] Sent: 08 November 2003 06:12 To: Cidar Ramirez Cc: [EMAIL PROTECTED] Subject: Re: How change IMSI via OTA Hi, At 01:36 08/11/2003, Cidar Ramirez wrote: >Did anybody work on change some parameters of the SIM, for example the = IMSI >file using kannel ? I may have missed something, but I believe the IMSI is clearly a=20 factory-programmed parameter of the SIM and is not writable (a bit like = a=20 ROM). And even if it was, you would also need to get the associated = private=20 key to be able to do anything with it. Jacques. -- Interactive Media Factory SARL SMS, SMS+, IVR & WAP development and services http://www.imfeurope.com/ --__--__-- Message: 4 From: "Navjot Singh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: RE: How change IMSI via OTA Date: Mon, 10 Nov 2003 12:53:17 +0530 i know something about TMSI but what the hell is PTMSI? Any sort of description or just pointers will be appreciated. navjot >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of >sunil baburaoji >Sent: Monday, November 10, 2003 12:56 PM >To: Jacques Caron; Cidar Ramirez >Cc: [EMAIL PROTECTED] >Subject: RE: How change IMSI via OTA > > >Hi, > >You can't change IMSI (International Mobile Subscriber Identity) of SIM, >as IMSI is unique for particular SIM throughout life. >TMSI (Temporary Mobile Subscriber Identity) & PTMSI (Packet TMSI) you >can change through some GMS or GPRS procedure. But it's totally out of >question for WAP protocol. > >- sunil > >-----Original Message----- >From: Jacques Caron [mailto:[EMAIL PROTECTED] >Sent: 08 November 2003 06:12 >To: Cidar Ramirez >Cc: [EMAIL PROTECTED] >Subject: Re: How change IMSI via OTA > > >Hi, > >At 01:36 08/11/2003, Cidar Ramirez wrote: >>Did anybody work on change some parameters of the SIM, for >example the IMSI >>file using kannel ? > >I may have missed something, but I believe the IMSI is clearly a >factory-programmed parameter of the SIM and is not writable (a bit like a >ROM). And even if it was, you would also need to get the >associated private >key to be able to do anything with it. > >Jacques. > > >-- Interactive Media Factory SARL > SMS, SMS+, IVR & WAP development and services > http://www.imfeurope.com/ > > > > > --__--__-- Message: 5 Subject: RE: How change IMSI via OTA Date: Mon, 10 Nov 2003 13:04:37 +0530 From: "sunil baburaoji" <[EMAIL PROTECTED]> To: "Navjot Singh" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> TMSI & P-TMSI both are mobile identity. TMSI is used in GSM Network whereas P-TMSI is used in GPRS Network (Reference 24.008 version 3.11).=20 - sunil -----Original Message----- From: Navjot Singh [mailto:[EMAIL PROTECTED] Sent: 10 November 2003 12:53 To: [EMAIL PROTECTED] Subject: RE: How change IMSI via OTA i know something about TMSI but what the hell is PTMSI? Any sort of description or just pointers will be appreciated. navjot >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf = Of >sunil baburaoji >Sent: Monday, November 10, 2003 12:56 PM >To: Jacques Caron; Cidar Ramirez >Cc: [EMAIL PROTECTED] >Subject: RE: How change IMSI via OTA > > >Hi, > >You can't change IMSI (International Mobile Subscriber Identity) of = SIM, >as IMSI is unique for particular SIM throughout life. >TMSI (Temporary Mobile Subscriber Identity) & PTMSI (Packet TMSI) you=20 >can change through some GMS or GPRS procedure. But it's totally out of=20 >question for WAP protocol. > >- sunil > >-----Original Message----- >From: Jacques Caron [mailto:[EMAIL PROTECTED] >Sent: 08 November 2003 06:12 >To: Cidar Ramirez >Cc: [EMAIL PROTECTED] >Subject: Re: How change IMSI via OTA > > >Hi, > >At 01:36 08/11/2003, Cidar Ramirez wrote: >>Did anybody work on change some parameters of the SIM, for=20 >example the IMSI >>file using kannel ? > >I may have missed something, but I believe the IMSI is clearly a=20 >factory-programmed parameter of the SIM and is not writable (a bit like = a=20 >ROM). And even if it was, you would also need to get the=20 >associated private=20 >key to be able to do anything with it. > >Jacques. > > >-- Interactive Media Factory SARL > SMS, SMS+, IVR & WAP development and services > http://www.imfeurope.com/ > > > > > --__--__-- Message: 6 Reply-To: <[EMAIL PROTECTED]> From: "Chris Botor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: dlr question Date: Mon, 10 Nov 2003 15:42:44 +0800 hello users and good day I have a question regarding dlr with mysql, I am planning to use postgres as the database storage of the message, is it possible? and please help me on how to create the url could I use a script instead of url because I have no idea in making url. Thanks in Advance, Chris Botor --__--__-- Message: 7 From: rudy <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: 0 queued, using mysql storage (PLEASE Check this thread again) Date: Mon, 10 Nov 2003 15:03:05 +0700 Hi Jarl, 1) Explanation about dlrmask=3D31 is in chapter 9 of user guide. 2) Rather than requesting Kannel to store the delivery report in its buil= t-in=20 (mysql) database (with "group =3D dlr-db" and so on), the other way is to= make=20 our own database to store outgoing sms with delivery report status. We ne= ed=20 to create the database and write scripts which will write to and update t= he=20 delivery report status. =20 Let's use the following mysql table, named "sms", as an example:=20 create table sms ( id int unsigned primary key not null, date timestamp, dest char(16), message char(160), status tinyint null ); "date", "dest" and "message" is to store date-time, destination phone num= ber=20 and the sms message, respectively. The "id" field is an incrementing numb= er=20 starting from "1" (not sure why I didn't use auto_increment) to give a un= ique=20 id number for each outgoing SMS. This "id" is very important as, later, i= t =20 keeps track of which messages get delivered. The "status" field is where = I=20 keep the delivery report status ("16" for smsc reject, "8" for smsc submi= t=20 and "1" for delivery success. In my case "2" and "4" is not supported by = the=20 smsc). =20 For sending SMS, I have a script which do the following: (a) Get the variables (destination number and the SMS itself) from HTML F= orm. =20 (b) Store those variables in above mysql table and keep note of the id nu= mber=20 of the particular record/row it writes to (say we store the value of "id"= of=20 that particular record in variable named "$id" and for that particular=20 record, say the "id" has a value of "1", for it is the first message stor= e in=20 the table).=20 (c) Call /cgi-bin/sendsms function to send SMS, appending=20 "&dlrmask=3D31&dlrurl=3Dhttp://localhost/dlr.php?type=3D%d&id=3D$id"; Later, upon receiving delivery report status, Kannel will call the script= we=20 put in dlrurl (the "htpp://...." parts pointed by dlrurl needs to be =20 urlencoded). For example, when Kannel successfully submitted a message to SMSC, Kannel= =20 will call "http://localhost/dlr.php?type=3D8&id=3D1";, which means status = is "8"=20 for message with id number "1". And when the destination has received the= =20 SMS, Kannel call the dlrurl again. But this time with different value of=20 type: "http://localhost/dlr.php?type=3D1&id=3D1"; which means message wit= h id=20 number "1" has been successfully delivered to destination (represented by= =20 type=3D1).=20 It is dlr.php which should update the "status" field according to the "t= ype"=20 value send back by Kannel. And with "id" number as parameter, the script=20 knows the delivery report status is for which particular record.=20 Hope this helps, P.S. I also got a better understanding about dlr after reading Navjot's p= ost.=20 Thanks to Navjot. Regards, Rudy =20 On Monday 10 November 2003 07:10, Jarlco wrote: > 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 rea= ding > up on all this mysql stuff... > > Navjot said: > " > You need to set 1 variable dlrmask (another is optional). You just need= to > append &dlrmask=3D31 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=3D31 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 a= s > 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 o= ne? > > 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 ab= le > > 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..= =2E > > 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, fail= ed > > > 0, queued 0 msgs) > > > > > > > > > and my config file looks like this: > > > ------------------------------------------ > > > group =3D core > > > admin-port =3D 13000 > > > admin-password =3D bar > > > smsbox-port =3D 13001 > > > store-file =3D "/tmp/kannel.store" > > > log-level =3D 2 > > > log-file =3D "/tmp/kannel.log" > > > access-log =3D /tmp/kannel.access > > > dlr-storage =3D mysql > > > > > > # SMSC CONNECTIONS > > > > > > group =3D smsc > > > smsc =3D at > > > smsc-id =3D wavecom_1 > > > allowed-smsc-id =3D wavecom_1 > > > modemtype =3D wavecom > > > device =3D /dev/ttyS0 > > > speed =3D 9600 > > > > > > > > > # MODEM GROUP > > > > > > group =3D modems > > > id =3D wavecom > > > name =3D Wavecom > > > detect-string =3D "WAVECOM" > > > > > > # SMSBOX SETUP > > > > > > group =3D smsbox > > > bearerbox-host =3D localhost > > > sendsms-port =3D 13013 > > > sendsms-url =3D "/cgi-bin/sendsms" > > > sendota-url =3D "/cgi-bin/sendota" > > > sendsms-chars =3D "0123456789 +-" > > > global-sender =3D 079 > > > reply-couldnotfetch =3D "Sorry, service was unable to fetch content= =2E.." > > > reply-couldnotrepresent =3D "Sorry, real message could not be repre= sented > > as > > > > SMS" > > > reply-requestfailed =3D "Sorry, the request failed" > > > reply-emptymessage =3D "Empty SMS was recieved" > > > log-file =3D "/tmp/smsbox.log" > > > access-log =3D "/tmp/kannel.access" > > > log-level =3D 3 > > > > > > # SEND SMS USER CONFIG > > > > > > group =3D sendsms-user > > > username =3D jarl > > > password =3D cornell > > > > > > group =3D sendsms-user > > > username =3D tester > > > password =3D foobar > > > > > > # SMS SERVICE > > > > > > group =3D sms-service > > > keyword =3D xxx > > > aliases =3D "af;ta;argh;tsk" > > > name =3D test1 > > > header =3D Jarl's SMS Service > > > footer =3D J.C > > > text =3D xxx service > > > > > > group =3D sms-service > > > keyword =3D www > > > get-url =3D "http://%S"; > > > > > > group =3D sms-service > > > keyword =3D vote > > > text =3D "Thank you for your vote it will now be processed" > > > > > > group =3D sms-service > > > keyword =3D nop > > > text =3D "service" > > > > > > # DEFAULT SERVICE > > > > > > group =3D sms-service > > > keyword =3D default > > > text =3D "default" > > > > > > > > > # MYSQL CONFIGURATION > > > > > > group =3D mysql-connection > > > id =3D mydlr1 > > > host =3D localhost > > > mysql-username =3D jarl > > > mysql-password =3D xxx > > > database =3D kannel > > > > > > # STORAGE GROUP > > > > > > group =3D dlr-db > > > id =3D mydlr1 > > > table =3D SmsEvent > > > field-smsc =3D smsc > > > field-timestamp =3D ts > > > field-destination =3D destination > > > field-service =3D service > > > field-url =3D url > > > field-mask =3D mask > > > field-status =3D status > > > field-boxc-id =3D boxc > > > field-source =3D 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 w= ill > > > maybe.. > > > /Jarl --__--__-- _______________________________________________ users mailing list [EMAIL PROTECTED] http://www.kannel.org/mailman/listinfo/users End of users Digest
