RE: sqlbox greek gsm-7

2011-05-13 Thread Rene Kluwen
Typical software engineering schedule. You spent 80% of time whilst doing 20% of the code. From: Mike Nakos [mailto:mike.na...@gmail.com] Sent: Friday, 13 May, 2011 23:49 To: Tania Petsouka Cc: Rene Kluwen; users@kannel.org Subject: Re: sqlbox greek gsm-7 u welcome! After Rene last rep

Re: sqlbox greek gsm-7

2011-05-13 Thread Mike Nakos
u welcome! After Rene last reply I was going to tell you to check if you are running ver 1.4 which doesn't do any url-decoding. Typical error. I guess you have installed debian package before you make the svn revision and after machine's reboot wrong version was running. In advance, please don't

Re: sqlbox greek gsm-7

2011-05-13 Thread Tania Petsouka
Oh My God... That's it. Wrong version! I spent 16 hours on it... Guys, you are really helpful, thank you so much. On Sat, May 14, 2011 at 12:03 AM, Rene Kluwen wrote: > Yes, it gives an info. > > > > I just now downloaded 1.5.0 as well to see if there are any differences. > > And it seems that

RE: sqlbox greek gsm-7

2011-05-13 Thread Rene Kluwen
Yes, it gives an info. I just now downloaded 1.5.0 as well to see if there are any differences. And it seems that url-decoding the msgdata field was introduced after that version. So try to use svn trunk revision. == Rene From: Tania Petsouka [mailto:ta...@tessera.gr] Sent: Frida

RE: sqlbox greek gsm-7

2011-05-13 Thread Rene Kluwen
This is weird, when I do the same, I get a string of 5 characters on my phone. What version of sqlbox are you using? I supposed svn trunk? == Rene From: Tania Petsouka [mailto:ta...@tessera.gr] Sent: Friday, 13 May, 2011 22:43 To: Rene Kluwen Cc: Mike Nakos; users@kannel.org Subject: R

Re: sqlbox greek gsm-7

2011-05-13 Thread Tania Petsouka
I use Dev version, 1.5, - sqlbox included. If it gives an info.. On Fri, May 13, 2011 at 11:43 PM, Tania Petsouka wrote: > Last time, i copied it to be sure.. > > > INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask, > coding) > VALUES('MT', 'tan', '306937078135', '%00%10%

Re: sqlbox greek gsm-7

2011-05-13 Thread Tania Petsouka
Last time, i copied it to be sure.. INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask, coding) VALUES('MT', 'tan', '306937078135', '%00%10%12%13%14', 2, 31, 0); And i did it directly to the database.. On Fri, May 13, 2011 at 11:40 PM, Rene Kluwen wrote: > Could you disp

RE: sqlbox greek gsm-7

2011-05-13 Thread Rene Kluwen
Could you display the insert statement that you are using? It must be similar to the one that Mike suggested. =-= Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Tania Petsouka Sent: Friday, 13 May, 2011 22:02 To: Mike Nakos Cc: users@kannel.org Subje

Invitation to connect on LinkedIn

2011-05-13 Thread Jose Mario Trujillo via LinkedIn
LinkedIn Jose Mario Trujillo requested to add you as a connection on LinkedIn: -- Tapan, I'd like to add you to my professional network on LinkedIn. - Jose Mario Accept invitation from Jose Mario Trujillo http://www.linkedin.com/e/-dnyjyt-gnn

Re: sqlbox greek gsm-7

2011-05-13 Thread Tania Petsouka
If i send url encoded chars like %00%10%12%13%14' from url , http request, there is no problem at all. The issue occurs only with sql box. So.. i tried to change table send_sms to utf8, no luck. I turned it back to latin. Did you change default settings of send_sms table? 2011/5/13 Tania Petsouka

Re: sqlbox greek gsm-7

2011-05-13 Thread Tania Petsouka
I tried it, but i receive the exact string i insert to the database: %00%10%12%13%14. short_message: "%00%10%12%13%14" Obviously, i have wrong settings somewhere... but my config is like yours.. Have you got any idea? 2011/5/13 Mike Nakos > You are wrong when you put to DB value 0x00 because

Re: Silent SMS

2011-05-13 Thread Milan P. Stanic
Hi Nikos, [ You should use mailer which support mailing lists ] On Fri, 2011-05-13 at 18:37, Nikos Balkanas wrote: > Hi Milan, > > I did submit a patch a while ago to use relative instead of absolute > time, but was rejected, since a lot of SMScs do not support relative > time, only absolute. I

Re: sqlbox greek gsm-7

2011-05-13 Thread Mike Nakos
You are wrong when you put to DB value 0x00 because this indicates the end of the string. You see, null terminated string. You did also misunderstand the purpose of php hexdec() function. To make this function work you should use it this way: hexdec('00') But this is not the point. D O N ' T

Re: sqlbox greek gsm-7

2011-05-13 Thread Πετσούκα Τάνια
In sent_sms table it appears truncated. (I insert it complete in send_sms.) - Original Message - From: "Rene Kluwen" To: "'Πετσούκα Τάνια'" ; "'Richard Crawshaw'" ; "'Mike Nakos'" Cc: Sent: Friday, May 13, 2011 7:15 PM Subject: RE: sqlbox greek gsm-7 How does the message appear in

RE: sqlbox greek gsm-7

2011-05-13 Thread Rene Kluwen
How does the message appear in the sent_sms table? Truncated or complete? Kannel code does not truncate at a '\0' byte. So I wonder if your insert statement is complete. == Rene -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of ?ets???a ???

Re: Silent SMS

2011-05-13 Thread Nikos Balkanas
Hi Milan, I did submit a patch a while ago to use relative instead of absolute time, but was rejected, since a lot of SMScs do not support relative time, only absolute. 2 solutions to this: Calculate the remote time from the application and use this validity for kannel (may not always work i

RE: sqlbox greek gsm-7

2011-05-13 Thread Richard Crawshaw
Tania The problem we had was that our SMSC was expecting one encoding and our Kannel instance was providing a different one. Our solution was for our SMSC to re-configure the bind to so that it used the same encoding that we were using; I see no reason to why it shouldn't be possible to change

Re: sqlbox greek gsm-7

2011-05-13 Thread Πετσούκα Τάνια
I don't understand exactly what you mean. Message doesn't reach the smsc complete. Kannel code truncates it. It thinks that '0x00' is the end of the message. That's the problem. Smsc cannot setup custom character translations for us, so i could send '0x040' and they give me @. - Original

RE: sqlbox greek gsm-7

2011-05-13 Thread Richard Crawshaw
I understand that '@' should be URL encoded (char code 40, which is the ASCII code for '@'). We've had similar problems where the bind was expecting GSM encoding but our Kannel instance was using UTF-8 (which appears to be Kannel's default). The solution that was implemented was that our SMSC

Re: sqlbox greek gsm-7

2011-05-13 Thread Πετσούκα Τάνια
From U.G : "Since @ is translated into 0x00 which will break the SMPP PDU..." So, maybe the question is " Is there a way to escape 0x00 in message data?? How do you others, send '@' with utf8 and gsm 7bit? - Original Message - From: "Πετσούκα Τάνια" To: "Mike Nakos" Cc: Sent:

Re: Silent SMS

2011-05-13 Thread Milan P. Stanic
On Fri, 2011-05-13 at 16:10, ha...@aeon.pk wrote: > If you could tell me the steps, I could change and recompile and test. Am > not a programmer so would need external help. I don't have enough time to write a howto guide about compiling Kannel. It is described in userguide. But it looks like the

Re: Silent SMS

2011-05-13 Thread ha...@aeon.pk
If you could tell me the steps, I could change and recompile and test. Am not a programmer so would need external help. On Fri, May 13, 2011 at 3:58 PM, Milan P. Stanic wrote: > On Fri, 2011-05-13 at 15:38, ha...@aeon.pk wrote: > > Well, the validity parameter is another issue with me, since my

Re: Silent SMS

2011-05-13 Thread Milan P. Stanic
On Fri, 2011-05-13 at 15:38, ha...@aeon.pk wrote: > Well, the validity parameter is another issue with me, since my application > server is on different timezone, and kannel sends absolute timestamp > (2011-05-12 13:01:01) as validity parameter instead of relative timestamp > (expiry time = current

Re: Silent SMS

2011-05-13 Thread ha...@aeon.pk
Well, the validity parameter is another issue with me, since my application server is on different timezone, and kannel sends absolute timestamp (2011-05-12 13:01:01) as validity parameter instead of relative timestamp (expiry time = current/submission time+60 secs). I don't seem to find the resolu

Re: Silent SMS

2011-05-13 Thread Milan P. Stanic
On Fri, 2011-05-13 at 12:59, ha...@aeon.pk wrote: > Thanks Mads. I already tried this, but the problem that I am facing is that > the app needs to read the DLR sent by SMSC. SMSC sends 'DLR=Delivered' if > the handset is on. But SMSC does not send any DLR at all if the handset is > off or out of co

Re: sqlbox greek gsm-7

2011-05-13 Thread Πετσούκα Τάνια
It didn't work. i replace '@' with chr(hexdec( '%00' )) If i send a message with text " u...@dom.com" , I receive "user" . In kannel logs too : short_message: "user". I've tried to send all gsm charecters, but none turned to '@'. I guess it may be represented by two chars, like euro, but

Re: Silent SMS

2011-05-13 Thread ha...@aeon.pk
Yes, but my telecom is not providing access to HLR. So I am bound to do some trick via SMPP application sitting behind SMSC... On Fri, May 13, 2011 at 1:05 PM, Cezary Siwek wrote: > Hi, > > you should be able to identify whether the mobile is ON or OFF by doing HLR > lookup. it's usually cheaper

Re: Silent SMS

2011-05-13 Thread Cezary Siwek
Hi, you should be able to identify whether the mobile is ON or OFF by doing HLR lookup. it's usually cheaper than an SMS (0.002-0.02 euro depending on volumes) Regards, Cezary On 13/05/2011 08:51, ha...@aeon.pk wrote: Dear friends, How to send a silent SMS via kannel? My purpose is to ch

Re: Silent SMS

2011-05-13 Thread Mads N. Vestergaard
Hi Hamza, Either you need to look at dlr-mask as stated in the UG, if you do not get any DLRs other than delivered. If your dlr-mask is correct, you should talk to your gateway provider what DLRs they provide. There is some information about the PID here: http://www.dreamfabric.com/sms/pid.ht

Re: Silent SMS

2011-05-13 Thread ha...@aeon.pk
Thanks Mads. I already tried this, but the problem that I am facing is that the app needs to read the DLR sent by SMSC. SMSC sends 'DLR=Delivered' if the handset is on. But SMSC does not send any DLR at all if the handset is off or out of coverage. Thats the only issue I am having. Any solution for

Re: Silent SMS

2011-05-13 Thread Mads N. Vestergaard
Hi Hamza, You can send a SMS with a special PID to generate a silent SMS. We are adding pid=64 to the HTTP request, to do this. But please be aware that not all gateways supports this. Regards, Mads Den 13/05/2011 kl. 09.51 skrev ha...@aeon.pk: > Dear friends, > > How to send a silent SMS

Silent SMS

2011-05-13 Thread ha...@aeon.pk
Dear friends, How to send a silent SMS via kannel? My purpose is to check the status of the mobile (ON/OFF) without bothering the customer by any pop-up/SMS messages. Regards, Hamza