SQLbox, dlr-url and smsbox-route

2011-05-17 Thread Andreas Bergman
Hi, I know that this issue/problem has been discussed before, but i can't get a grip on if it is a feature or a bug. What i want to achieve: * Add msg to send_sms * The msg is sent * The SMPP module receives the status report * The report is sent to the smsbox and the dlr-url invoked. Wh

Re: SQLbox, dlr-url and smsbox-route

2011-05-17 Thread Andreas Bergman
r previous problem, but you may come up against other issues with that version) - Original Message - From: Andreas Bergman To: users@kannel.org Sent: Tuesday, May 17, 2011 12:26 PM Subject: SQLbox, dlr-url and smsbox-route Hi, I know that this issue/problem has been discussed before,

Re: SQLbox, dlr-url and smsbox-route

2011-05-17 Thread Andreas Bergman
he DLR, with ts and smsc-values. I think that WHERE `smsc`=? AND `ts`=? is the problem, but how do I change that? /A - Ursprungligt meddelande - Från: "Πετσούκα Τάνια" Till: "Andreas Bergman" Kopia: users@kannel.org Skickat: tisdag, 17 maj 2011 13:54:09 Ämne: Re: SQ

sqlbox and åäö

2011-05-22 Thread Andreas Bergman
Hi! When sending åäö in messages thrugh sqlbox they are changed to ?? i assume this has something to do with unicode chars? The system is en_EN.UTF-8 and in the database it looks correct, is Stipes unicodepatch the solution or? Br Andreas -- Andreas Bergman www.abergman.se 0708-768300 andr

Re: sqlbox and åäö

2011-05-22 Thread Andreas Bergman
to bearerbox correctly? /A 2011/5/22 Nikos Balkanas > Hi, > > there was a long discussion about it in the list for the past 2 weeks. I > believe Renee mentioned that sqlbox was patched. Please download latest > sqlbox and retry. > > BR, > Nikos > - Original Message

Re: sqlbox and åäö

2011-05-22 Thread Andreas Bergman
I tried that using the php urlencode function but i only got the urlencoded message sent to me. 2011/5/22 Rene Kluwen > Try to urlencode the message before inserting. > > > > *From:* users-boun...@kannel.org [mailto:users-boun...@kannel.org] *On > Behalf Of *Andreas Bergma

Re: sqlbox and åäö

2011-05-22 Thread Andreas Bergman
rs where distorted. /Andreas 2011/5/22 Nikos Balkanas > Hi, > > Depends on the flow: > > sqlbox -> smsbox -> bb ->smsc > > needs urlencoding > > sqlbox -> bb ->smsc > > doesn't. Which version do you use? > > > BR, > Nikos >

Re: gsm7 send messages > 140 <=160 chars length

2011-05-23 Thread Andreas Bergman
sendsms?text=%40%C3%B1%C3%A9&coding=0 >>> >>> on the debug logs I see the following: >>> Ξ β EURO (tm) [12] DEBUG: Ξ β EURO (tm) Ξ β EURO (tm) Octet string at >>> 0x801ef4e60: >>> Ξ β EURO (tm) [12] DEBUG: Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) len: Ξ >>> β EURO (tm) 3 >>> Ξ β EURO (tm) [12] DEBUG: Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) size: 6 >>> Ξ β EURO (tm) [12] DEBUG: Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) >>> immutable: 0 >>> Ξ β EURO (tm) [12] DEBUG: Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) data: >>> 00 7d 05 .}. >>> Ξ β EURO (tm) [12] DEBUG: Ξ β EURO (tm) Ξ β EURO (tm) Octet string dump >>> ends. >>> >>> >>> where seems that kannel is properly converting from UTF-8 go the GSM 7 >>> bit charset >>> DEBUG: Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) data: 00 7d 05 >>> >>> >>> but later on the bearerbox (access.log) I get something like this: >>> >>> [msg:5:@] [udh:0:] >>> >>> If I am right, it means it is using 5 characters to send the @Ξ Β Ξ Β Ξ >>> β EURO ° >>> >>> Now If I add to the Ξ β EURO (tm) smsc this: >>> >>> alt-charset = "UTF-8" >>> >>> the debug output is: >>> DEBUG: Ξ β EURO (tm) data: 40 c3 b1 c3 a9 Ξ β EURO (tm) Ξ β EURO (tm) Ξ β >>> EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) Ξ >>> β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) Ξ β >>> EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) >>> Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) Ξ β EURO (tm) @ >>> >>> >>> and the bearerbox (access.log) is the same: >>> [msg:5:@] [udh:0:] >>> >>> But in this time the txt messages was Ξ β EURO (tm) properly delivering to >>> the >>> users displaying the chars @Ξ Β Ξ Β Ξ β EURO ° instead of just ??? but the >>> size of >>> >>> the >>> sent messages was again 5 instead of 3. >>> >>> So my question is how to properly code or send the message to use only >>> 3 chars instead of 5 when sending only gsm-7 chars. >>> >>> I have also try using this: >>> >>> text=%00%7D%05&coding=0&alt-dcs=1 >>> >>> of >>> >>> text=007D05&coding=0&alt-dsc=1 >>> >>> but the message received by the phone din't display the chars. also >>> changing mo-encode true/false din't help. >>> >>> When using UCS-2 and coding=2 the chars are displayed on the mobile >>> but I can only send a max of 70 chars. and I would like to send 160. >>> >>> Any idea of how to do it? >>> >>> thanks in advance. >>> >>> >>> >> >> > > > > > > -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se

Outlook mobile services

2011-05-28 Thread Andreas Bergman
Hi! Do you guys know of any Outlook mobile services server/interface that you would like to recomend? Br Andreas -- Andreas Bergman www.abergman.se 0708-768300 andr...@abergman.se

Wrong timezone BB and Smsbox

2011-05-28 Thread Andreas Bergman
ELIVRD+err%3A000+Text %3Atest The dlrDate is 20:14 (%t) but the reply from the SMSC still says 22:14. Which means that the dlrDate is formated as GMT (Sweden is GMT+2). Kannel is compiled with --enable-localtime and the machine runs on CEST (GMT+2). Any ideas on whats wrong here? /Andreas --

Re: Wifi and CDMA

2011-07-30 Thread Andreas Bergman
You need some kind of connection to the mobile network, via gsm or tcp/ip. Skickat från min iPhone 30 jul 2011 kl. 16:34 skrev Daniel Abebe : > Dear All, > > Thank you for your attention! > > Does the Kannel work with Wifi Internet without GSM modem? > Also does it work with CDMA wireless mod

Re: is it possible to make kannel pass custom data

2011-08-18 Thread Andreas Bergman
If the provider is passed as data on incoming messages, then yes you can. Otherwise you will have to make that lookup in a separate script. I think HLR could do that for you. Andreas 19 aug 2011 kl. 01:33 skrev Ahmed AL-Tahami: > Hi , > > Is it possible to make kannel pass custom data to my j

Re: DLR and sqlbox

2011-08-18 Thread Andreas Bergman
create a column called sql_id and make it primary key and auto_increment. CREATE TABLE IF NOT EXISTS `send_sms` ( `sql_id` bigint(20) NOT NULL auto_increment, `momt` enum('MO','MT') default NULL, `sender` varchar(20) default NULL, `receiver` varchar(20) default NULL, `udhdata` blob, `m

Re: Prefix DB

2011-11-20 Thread Andreas Bergman
HI, We're doing our routing via an external HLR-database accessed through an API, then saving the results for X days and the updating it. Works pretty good. Br Andreas -- Andreas Bergman On söndag 20 november 2011 at 09:57, JAmes wrote: > Hi, > > Anyone know where

Re: Prefix DB

2011-11-20 Thread Andreas Bergman
Never used operator prefix dbs, unfortunately. Do you have your own HLR or are you buying from someone? /A -- Andreas Bergman On söndag 20 november 2011 at 10:14, JAmes wrote: > Sounds like a good idea. I am currently routing via HLR and want to have a > prefix db as backup fo