Re: [bug] clickatell unicode HTTP code for Kannel

2011-03-21 Thread Alexander Malysh
Hi,

in order to send message as UCS2 you can try this:

http://localhost:13013/cgi-bin/sendsms?username=password=to=24492
347from=Companytext=Mr.+Joo+Seu+seguro+automvel+MM3A308720+caduca+hoje.+Contacte-nos+227280210%2F220+ou+visite-nos+numa+de+nossas+agncias+para+activar+a+nova+aplice.
coding=2charset=UTF-8smsc=clickatell

Thanks,
Alexander Malysh

Am 18.03.2011 um 17:13 schrieb Hillel:

 Hi,
 
 Our message is: 
 Mr. João Seu seguro automóvel MM3A308720 caduca hoje. Contacte-nos
 227280210/220 ou visite-nos numa de nossas agências para activar a nova
 apólice.  (147 characters)
 
 Our goal is to send it as concatenated Unicode and use UTF-8 as that is what
 Clickatell accepts.
 Questions - do we use padding?
 The only case of (Sent. Message splits: 3) is from Sending to Kannel not
 using padding, leave out charset below.  But it arrives *some text missing*
 2061206E6F7661206170C3B36C963652E and not a Unicode message.  
 Is there a bug in Kannel code for Clickatell or are we doing something
 incorrect?
 
 Result is: 
 4D722E204A6FC3A36F205365752073656775726F206175746F6DC3B376656C204D4D33413330
 383732302063616475636120686F6A652E20436F6E74616374652D6E6F732032323732383032
 31302F323230206F75207669736974652D6E6F73206E756D61206465206E6F73736173206167
 C3AA6E63696173207061726120616374697661722061206E6F7661206170C3B36C6963652E
 
 If we use padding:
 
 004d0072002e0020004a006f00e3006f0020005300650075002000730065006700750072006f
 0020006100750074006f006d00f300760065006c0020004d004d003300410033003000380037
 00320030002000630061006400750063006100200068006f006a0065002e00200043006f006e
 00740061006300740065002d006e006f00730020003200320037003200380030003200310030
 002f0032003200300020006f00750020007600690073006900740065002d006e006f00730020
 006e0075006d00610020006400650020006e006f007300730061007300200061006700ea006e
 0063006900610073002000700061007200610020006100630074006900760061007200200061
 0020006e006f0076006100200061007000f3006c006900630065002e
 
 Sending to Kannel not using padding, leave out charset:
 
 [root@messaging ~]# lynx -dump
 'http://localhost:13013/cgi-bin/sendsms?username=password=to=24492
 347from=Companytext=4D722E204A6FC3A36F205365752073656775726F206175746F
 6DC3B376656C204D4D33413330383732302063616475636120686F6A652E20436F6E74616374
 652D6E6F73203232373238303231302F323230206F75207669736974652D6E6F73206E756D61
 206465206E6F73736173206167C3AA6E63696173207061726120616374697661722061206E6F
 7661206170C3B36C6963652Ecoding=2smsc=clickatell'
 
   Sent. Message splits: 3
 
 Sending to Kannel not using padding, put in charset:
 
 [root@messaging ~]# lynx -dump
 'http://localhost:13013/cgi-bin/sendsms?username=password=to=24492
 347from=Companytext=4D722E204A6FC3A36F205365752073656775726F206175746F
 6DC3B376656C204D4D33413330383732302063616475636120686F6A652E20436F6E74616374
 652D6E6F73203232373238303231302F323230206F75207669736974652D6E6F73206E756D61
 206465206E6F73736173206167C3AA6E63696173207061726120616374697661722061206E6F
 7661206170C3B36C6963652Echarset=utf-8coding=2smsc=clickatell'
 
   Sent. Message splits: 5
 
 Sending to Kannel using padding, leave out charset:
 
 [root@messaging ~]# lynx -dump
 'http://localhost:13013/cgi-bin/sendsms?username=password=to=24492
 347from=Companytext=004d0072002e0020004a006f00e3006f002000530065007500
 2000730065006700750072006f0020006100750074006f006d00f300760065006c0020004d00
 4d00330041003300300038003700320030002000630061006400750063006100200068006f00
 6a0065002e00200043006f006e00740061006300740065002d006e006f007300200032003200
 37003200380030003200310030002f0032003200300020006f00750020007600690073006900
 740065002d006e006f00730020006e0075006d00610020006400650020006e006f0073007300
 61007300200061006700ea006e00630069006100730020007000610072006100200061006300
 740069007600610072002000610020006e006f0076006100200061007000f3006c0069006300
 65002ecoding=2smsc=clickatell'
 
   Sent. Message splits: 5
 
 Sending to Kannel using padding, include charset:
 
 [root@messaging ~]# lynx -dump
 'http://localhost:13013/cgi-bin/sendsms?username=password=to=24492
 347from=Companytext=004d0072002e0020004a006f00e3006f002000530065007500
 2000730065006700750072006f0020006100750074006f006d00f300760065006c0020004d00
 4d00330041003300300038003700320030002000630061006400750063006100200068006f00
 6a0065002e00200043006f006e00740061006300740065002d006e006f007300200032003200
 37003200380030003200310030002f0032003200300020006f00750020007600690073006900
 740065002d006e006f00730020006e0075006d00610020006400650020006e006f0073007300
 61007300200061006700ea006e00630069006100730020007000610072006100200061006300
 740069007600610072002000610020006e006f0076006100200061007000f3006c0069006300
 65002echarset=utf-8coding=2smsc=clickatell'
 
   Sent. Message splits: 9
 
 
 -Original Message-
 From: Alexander Malysh [mailto:malys...@googlemail.com] On Behalf Of
 Alexander Malysh
 Sent: 28 January 2011 11:01 AM
 To: Hillel
 Cc: 

Using SQLBOX - unix timestamp

2011-03-21 Thread ha...@aeon.pk
Hi,

While using sqlbox, the column 'time' in sent_sms column of kannel database
is having timestamp values in unix time. Is there a parameter in config by
which I could control it to paste values in normal timestamps in the table?

Thanks,
H


Re: Generic HTTP SMSC callback

2011-03-21 Thread Lee Vidor

I specify the following in the SMSC group in kannel.conf

# SMSC CONNECTIONS - GLOBAL FIELDS
group = smsc
smsc = http
smsc-id = MessageSphere
system-type = generic
port = 13014
send-url = 
http://173.1.59.211/smppApi.asmx/SendMT?SubAccountId=%nDestination=%pS

ource=%PEncoding=ASCIIBody=%aumid=%I
status-success-regex = RECEIVED
status-permfail-regex = failure
status-tempfail-regex = retry later
#denied-smsc-id = X;Y
#allowed-smsc-id = Z
#preferred-smsc-id = W
#allowed-prefix = 040;050
#denied-prefix = 060;070
#alt-charset =
connect-allow-ip = 173.1.59.211
reroute-dlr = true
transceiver-mode = true



Message gets sent from smpp box to opensmppbox with dlr-mask set to 31

logs on opensmppbox show the following :


2011-03-21 12:25:21 [23301] [271] DEBUG: SMPP[Account2_smpp]: Got PDU:
2011-03-21 12:25:21 [23301] [271] DEBUG: SMPP PDU 0x1737e0d0 dump:
2011-03-21 12:25:21 [23301] [271] DEBUG:   type_name: submit_sm
2011-03-21 12:25:21 [23301] [271] DEBUG:   command_id: 4 = 0x0004
2011-03-21 12:25:21 [23301] [271] DEBUG:   command_status: 0 = 
0x
2011-03-21 12:25:21 [23301] [271] DEBUG:   sequence_number: 620 = 
0x026c

2011-03-21 12:25:21 [23301] [271] DEBUG:   service_type: NULL
2011-03-21 12:25:21 [23301] [271] DEBUG:   source_addr_ton: 2 = 
0x0002
2011-03-21 12:25:21 [23301] [271] DEBUG:   source_addr_npi: 1 = 
0x0001

2011-03-21 12:25:21 [23301] [271] DEBUG:   source_addr: 
2011-03-21 12:25:21 [23301] [271] DEBUG:   dest_addr_ton: 2 = 0x0002
2011-03-21 12:25:21 [23301] [271] DEBUG:   dest_addr_npi: 1 = 0x0001
2011-03-21 12:25:21 [23301] [271] DEBUG:   destination_addr: 
447824662374

2011-03-21 12:25:21 [23301] [271] DEBUG:   esm_class: 3 = 0x0003
2011-03-21 12:25:21 [23301] [271] DEBUG:   protocol_id: 0 = 0x
2011-03-21 12:25:21 [23301] [271] DEBUG:   priority_flag: 0 = 0x
2011-03-21 12:25:21 [23301] [271] DEBUG:   schedule_delivery_time: NULL
2011-03-21 12:25:21 [23301] [271] DEBUG:   validity_period: NULL
2011-03-21 12:25:21 [23301] [271] DEBUG:   registered_delivery: 1 = 
0x0001
2011-03-21 12:25:21 [23301] [271] DEBUG:   replace_if_present_flag: 0 = 
0x

2011-03-21 12:25:21 [23301] [271] DEBUG:   data_coding: 0 = 0x
2011-03-21 12:25:21 [23301] [271] DEBUG:   sm_default_msg_id: 0 = 
0x

2011-03-21 12:25:21 [23301] [271] DEBUG:   sm_length: 11 = 0x000b
2011-03-21 12:25:21 [23301] [271] DEBUG:   short_message: dlr testing
2011-03-21 12:25:21 [23301] [271] DEBUG: SMPP PDU dump ends.
2011-03-21 12:25:21 [23301] [271] DEBUG: Msg object at 0x1737f4f0:
2011-03-21 12:25:21 [23301] [271] DEBUG:  type: sms
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.sender:
2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string at 0x1737e2d0:
2011-03-21 12:25:21 [23301] [271] DEBUG:len:  4
2011-03-21 12:25:21 [23301] [271] DEBUG:size: 5
2011-03-21 12:25:21 [23301] [271] DEBUG:immutable: 0
2011-03-21 12:25:21 [23301] [271] DEBUG:data: 31 31 31 31   
   

2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string dump ends.
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.receiver:
2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string at 0x1737e350:
2011-03-21 12:25:21 [23301] [271] DEBUG:len:  12
2011-03-21 12:25:21 [23301] [271] DEBUG:size: 13
2011-03-21 12:25:21 [23301] [271] DEBUG:immutable: 0
2011-03-21 12:25:21 [23301] [271] DEBUG:data: 34 34 37 38 32 34 36 
36 32 33 37 34   447824662374

2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string dump ends.
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.udhdata:
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.msgdata:
2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string at 0x1737e380:
2011-03-21 12:25:21 [23301] [271] DEBUG:len:  11
2011-03-21 12:25:21 [23301] [271] DEBUG:size: 12
2011-03-21 12:25:21 [23301] [271] DEBUG:immutable: 0
2011-03-21 12:25:21 [23301] [271] DEBUG:data: 64 6c 72 20 74 65 73 
74 69 6e 67  dlr testing

2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string dump ends.
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.time: 1300735521
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.smsc_id:
2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string at 0x1737f6a0:
2011-03-21 12:25:21 [23301] [271] DEBUG:len:  13
2011-03-21 12:25:21 [23301] [271] DEBUG:size: 14
2011-03-21 12:25:21 [23301] [271] DEBUG:immutable: 0
2011-03-21 12:25:21 [23301] [271] DEBUG:data: 4d 65 73 73 61 67 65 
53 70 68 65 72 65MessageSphere

2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string dump ends.
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.smsc_number:
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.foreign_id:
2011-03-21 12:25:21 [23301] [271] DEBUG:  sms.service:
2011-03-21 12:25:21 [23301] [271] DEBUG:  Octet string at 0x17371ad0:
2011-03-21 12:25:21 [23301] [271] DEBUG:len:  13
2011-03-21 12:25:21 [23301] [271] DEBUG:size: 14
2011-03-21 12:25:21 [23301] [271] 

GPRS MMS Settings

2011-03-21 Thread write2...@live.com

can we send GPRS / MMS settings via kannel and option to save when user
receive them.. what the format of that kind of transaction?
-- 
View this message in context: 
http://old.nabble.com/GPRS-MMS-Settings-tp31199505p31199505.html
Sent from the Kannel - User mailing list archive at Nabble.com.




Fwd: Generic HTTP SMSC callback

2011-03-21 Thread Lee Vidor

correction for previous post:

message gets sent from smpp CLIENT to opensmppbox



Generic HTTP SMSC callback

2011-03-21 Thread Lee Vidor



correction for previous post:message gets sent from smpp CLIENT to 
opensmppbox
 



unable to send sms with Sony Ericsson t637

2011-03-21 Thread Joey L
hi - all - I am unable to send a text with sony ericsoon t637 cellphone
connected via usb to a debian server.
my details are:

group = core
admin-port = 13000
admin-password = bar
admin-deny-ip = *.*.*.*
admin-allow-ip = 127.0.0.1
smsbox-port = 13003
wapbox-port = 13002
wdp-interface-name = *
log-file = /var/log/kannel/bearerbox.log
box-deny-ip = *.*.*.*
box-allow-ip = 192.168.2.22

group = wapbox
bearerbox-host = localhost
log-file = /var/log/kannel/wapbox.log

group = smsbox
bearerbox-host = 192.168.2.22
sendsms-port = 13005
global-sender = 917111
log-file = /var/log/kannel/smsbox.log
access-log = /var/log/kannel/smsbox.access.log
log-level = 1


group = sendsms-user
username=mike
password=joe
concatenation = true
max-messages = 10


group = smsc
smsc = at
throughput=1
modemtype = T630-T628
device = /dev/ttyUSB0
speed = 115200
sim-buffering=yes
keepalive=60


# group = smsc
# smsc = at
# throughput=1
# modemtype = auto
# modemtype = T630-T628
# speed = 115200
# device = /dev/rfcomm0
# device = /dev/ttyUSB0
# speed = 9600
# sim-buffering=true
# keepalive=60
# my-number = 19172398282
# sms-center = +13123149810
# flow-control = 1


# group = modems
# id = T630-T628
# name = T630-T628
# broken = true
# detect-string = T630-T628
# init-string = AT+CNMI=2,3,2,0,0;+CMGF=0
# keepalive-cmd = AT+CBC;+CSQ;+CMGF=0
# message-storage=ME

group = modems
id = T630-T628
name = T630-T628
broken = true
init-string = AT+CNMI=2,3,2,0,0;+CMGF=0
keepalive-cmd = AT+CBC;+CSQ;+CMGF=0
message-storage=ME


# SMS SERVICE Default
# there should be default always
group = sms-service
keyword = default
name = default
text = No service specified
concatenation = true
max-messages = 5


My startup for the bearerbox and smsbox are:
 /usr/sbin/bearerbox -v 1 /etc/kannel/kannel.conf
 /usr/sbin/smsbox -v 1 /etc/kannel/kannel.conf

My commands to send the sms are:

 lynx -dump http://localhost:13000/status?password=bar;

 lynx
http://192.168.2.22:13005/cgi-bin/sendsms?username=userpassword=passto=917111text=Hello+world


My startup logs for both bearerbox and smsbox are:

rider:/var/log/kannel# /usr/sbin/bearerbox -v 1 /etc/kannel/kannel.conf
2011-03-20 17:20:50 [8984] [0] INFO: Debug_lvl = 1, log_file = none,
log_lvl = 0
2011-03-20 17:20:50 [8984] [0] WARNING: DLR: using default 'internal' for
storage type.
2011-03-20 17:20:50 [8984] [0] INFO: DLR using storage type: internal
2011-03-20 17:20:50 [8984] [0] INFO: Added logfile
`/var/log/kannel/bearerbox.log'
with level `0'.
2011-03-20 17:20:50 [8984] [0] INFO: HTTP: Opening server at port 13000.
2011-03-20 17:20:50 [8984] [0] INFO: BOXC: 'smsbox-max-pending' not set,
using default (100).
2011-03-20 17:20:50 [8984] [0] INFO: Set SMS resend frequency to 60 seconds.
2011-03-20 17:20:50 [8984] [0] INFO: SMS resend retry set to unlimited.
2011-03-20 17:20:50 [8984] [0] INFO: Set throughput to 1.000 for smsc id
(null)
2011-03-20 17:20:50 [8984] [0] INFO: DLR rerouting for smsc id (null)
disabled.
2011-03-20 17:20:50 [8984] [0] INFO: AT2[/dev/ttyUSB0]: configuration shows
modemtype T630-T628
2011-03-20 17:20:50 [8984] [0] INFO: AT2[/dev/ttyUSB0]: read modem
definition for T630-T628
2011-03-20 17:20:51 [8984] [6] INFO: AT2[/dev/ttyUSB0]: opening device
2011-03-20 17:20:51 [8984] [0] INFO: Adding interface *
2011-03-20 17:20:51 [8984] [6] INFO: AT2[/dev/ttyUSB0]: init device
2011-03-20 17:20:51 [8984] [6] INFO: AT2[/dev/ttyUSB0]: speed set to 115200
2011-03-20 17:20:51 [8984] [0] INFO:

2011-03-20 17:20:51 [8984] [0] INFO: Kannel bearerbox II version 1.4.1
starting
2011-03-20 17:20:51 [8984] [0] INFO: MAIN: Start-up done, entering mainloop
2011-03-20 17:20:54 [8984] [6] INFO: AT2[/dev/ttyUSB0]: AT SMSC successfully
opened.



ider:/var/log/kannel# cat smsbox.log
2011-03-20 11:05:18 [32340] [0] INFO: Added logfile
`/var/log/kannel/smsbox.log'
with level `1'.
2011-03-20 11:05:18 [32340] [0] INFO: Service global sender set as
'9172398282'
2011-03-20 11:05:18 [32340] [0] INFO: Logging accesses to '/var/log/kannel
/smsbox.access.log'.
2011-03-20 11:05:18 [32340] [0] INFO: Started access logfile `/var/log/
kannel/smsbox.access.log'.
2011-03-20 11:05:18 [32340] [0] INFO: HTTP: Opening server at port 13005.
2011-03-20 11:05:18 [32340] [0] INFO: Set up send sms service at port 13005
2011-03-20 11:05:18 [32340] [0] INFO: Connected to bearerbox at 192.168.2.22
port 13003.
2011-03-20 11:24:24 [32340] [0] ERROR: SIGINT received, aborting program...
2011-03-20 11:24:24 [32340] [0] INFO: Received (and handled?) 0 requests in
1146 seconds (0.00 per second)
2011-03-20 11:24:24 [32340] [0] INFO: Kannel smsbox terminating.
2011-03-20 11:24:31 [394] [0] INFO: Added logfile `/var/log/kannel/smsbox.log'
with level `1'.
2011-03-20 11:24:31 [394] [0] INFO: Service global sender set as
'9172398282'
2011-03-20 11:24:31 [394] [0] INFO: Logging accesses to '/var/log/kannel
/smsbox.access.log'.
2011-03-20 11:24:31 [394] [0] INFO: Started access logfile `/var/log/kannel

Re: New to Kannel

2011-03-21 Thread Alvaro Cornejo
Hi

You just need to install the kannel sw -better from svn- and then
adjust the config file according to your needs.

After that, for running kannel you need to, at least, start bearerbox
and then smsbox. Something like

.../path/bearerbox v0 .../path/config-file
.../path/smsbox v0 .../path/config-file

The config file must be the same for both boxes.

Check the user guide for details in config

Regards

Alvaro




|-|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
              Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com



On Fri, Mar 18, 2011 at 1:03 PM, Adan Canales adan...@gmail.com wrote:
 Hello Friends:
 I´m new to Kannel and SMS and I have been trough the manual of Kannel and
 after a week or more of reading it I can find after install it, where to
 begin to configure my core, smsbox, and SMSservice, not to mention which
 fields to include in my MySql tables in order to get an external application
 to send and answer to SMS.
 If there is another manual as reference or better explanation on how to do
 it, I will highly appreciate it if someone could lead me to. I promise to
 write an step by step manual for newbies(if not against your rules) as soon
 as I a expertise this software, which I believe is awesome,  since the
 actual manual is not meant for us.
 Thank you in advance.
 Adan



Re: New to Kannel

2011-03-21 Thread Joey L
I am on debian - I would like to download the latest kannel from svn, do you
know how i can do this ???
I think i am on debian -
rider:~# cat /proc/version
Linux version 2.6.26-2-amd64 (Debian 2.6.26-26lenny2) (da...@debian.org)
(gcc version 4.1.3 20080704 (prerelease) (Debian 4.1.2-25)) #1 SMP Tue Jan
25 05:59:43 UTC 2011

thanks
mjh

On Mon, Mar 21, 2011 at 10:54 AM, Alvaro Cornejo
cornejo.alv...@gmail.comwrote:

 Hi

 You just need to install the kannel sw -better from svn- and then
 adjust the config file according to your needs.

 After that, for running kannel you need to, at least, start bearerbox
 and then smsbox. Something like

 .../path/bearerbox v0 .../path/config-file
 .../path/smsbox v0 .../path/config-file

 The config file must be the same for both boxes.

 Check the user guide for details in config

 Regards

 Alvaro





 |-|
 Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
 celular y Nextel
 en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
 SMS y GPRS online
   Visitenos en www.perusms.NET www.smsglobal.com.mx y
 www.pravcom.com



 On Fri, Mar 18, 2011 at 1:03 PM, Adan Canales adan...@gmail.com wrote:
  Hello Friends:
  I´m new to Kannel and SMS and I have been trough the manual of Kannel and
  after a week or more of reading it I can find after install it, where to
  begin to configure my core, smsbox, and SMSservice, not to mention which
  fields to include in my MySql tables in order to get an external
 application
  to send and answer to SMS.
  If there is another manual as reference or better explanation on how to
 do
  it, I will highly appreciate it if someone could lead me to. I promise to
  write an step by step manual for newbies(if not against your rules) as
 soon
  as I a expertise this software, which I believe is awesome,  since the
  actual manual is not meant for us.
  Thank you in advance.
  Adan




Re: New to Kannel

2011-03-21 Thread Nikos Balkanas

Hi,

Go to the site http://www.kannel.org and follow downloading instructions. 
You will need to install package svn. To check you can use:


ls $(which svn)

(I am sure there must be a better command to check packages in Debian)
and to install it:

apt-get svn.

BR,
Nikos


- Original Message - 
From: Joey L

To: Alvaro Cornejo
Cc: Adan Canales ; users@kannel.org
Sent: Monday, March 21, 2011 5:06 PM
Subject: Re: New to Kannel


I am on debian - I would like to download the latest kannel from svn, do you 
know how i can do this ???

I think i am on debian -

rider:~# cat /proc/version
Linux version 2.6.26-2-amd64 (Debian 2.6.26-26lenny2) (da...@debian.org) 
(gcc version 4.1.3 20080704 (prerelease) (Debian 4.1.2-25)) #1 SMP Tue Jan 
25 05:59:43 UTC 2011



thanks
mjh


On Mon, Mar 21, 2011 at 10:54 AM, Alvaro Cornejo cornejo.alv...@gmail.com 
wrote:


Hi

You just need to install the kannel sw -better from svn- and then
adjust the config file according to your needs.

After that, for running kannel you need to, at least, start bearerbox
and then smsbox. Something like

.../path/bearerbox v0 .../path/config-file
.../path/smsbox v0 .../path/config-file

The config file must be the same for both boxes.

Check the user guide for details in config

Regards

Alvaro




|-|
Envνe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perϊ, Mιxico y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
 Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com




On Fri, Mar 18, 2011 at 1:03 PM, Adan Canales adan...@gmail.com wrote:

Hello Friends:
I΄m new to Kannel and SMS and I have been trough the manual of Kannel and
after a week or more of reading it I can find after install it, where to
begin to configure my core, smsbox, and SMSservice, not to mention which
fields to include in my MySql tables in order to get an external 
application

to send and answer to SMS.
If there is another manual as reference or better explanation on how to do
it, I will highly appreciate it if someone could lead me to. I promise to
write an step by step manual for newbies(if not against your rules) as 
soon

as I a expertise this software, which I believe is awesome,  since the
actual manual is not meant for us.
Thank you in advance.
Adan 





Re: New to Kannel

2011-03-21 Thread Adan Canales
I quit on Debian, too dificult, instead on Ubuntu was easy to install.

I´m now working on configuring the boxes and then start testing. I wonder
how can I keep control of all my messages sent? is this in DLR? Once I have
say it to kannel thru the configuration that uses Mysql, it records
everything on it?

Regards

Adan

2011/3/18 Adan Canales adan...@gmail.com

 Hello Friends:

 I´m new to Kannel and SMS and I have been trough the manual of Kannel and
 after a week or more of reading it I can find after install it, where to
 begin to configure my core, smsbox, and SMSservice, not to mention which
 fields to include in my MySql tables in order to get an external application
 to send and answer to SMS.

 If there is another manual as reference or better explanation on how to do
 it, I will highly appreciate it if someone could lead me to. I promise to
 write an step by step manual for newbies(if not against your rules) as soon
 as I a expertise this software, which I believe is awesome,  since the
 actual manual is not meant for us.

 Thank you in advance.

 Adan



Re: New to Kannel

2011-03-21 Thread Komil Gulboev
debian and ubuntu one system only name is different. I think install 
from svn for new in linux and kannel it`s so difficult.


21.03.2011 21:48, Adan Canales ?:

I quit on Debian, too dificult, instead on Ubuntu was easy to install.

I´m now working on configuring the boxes and then start testing. I 
wonder how can I keep control of all my messages sent? is this in DLR? 
Once I have say it to kannel thru the configuration that uses Mysql, 
it records everything on it?


Regards

Adan

2011/3/18 Adan Canales adan...@gmail.com mailto:adan...@gmail.com

Hello Friends:

I´m new to Kannel and SMS and I have been trough the manual of
Kannel and after a week or more of reading it I can find after
install it, where to begin to configure my core, smsbox, and
SMSservice, not to mention which fields to include in my MySql
tables in order to get an external application to send and answer
to SMS.

If there is another manual as reference or better explanation on
how to do it, I will highly appreciate it if someone could lead me
to. I promise to write an step by step manual for newbies(if not
against your rules) as soon as I a expertise this software, which
I believe is awesome,  since the actual manual is not meant for us.

Thank you in advance.

Adan




--
Komil Gulboev

System Administrator
Automation Department
CJSC Babilon-Mobile Tajikistan
+992 91833 mobile
+992 44672 phone



Re: New to Kannel

2011-03-21 Thread Joey L
Nick - thanks again - but i already went to kannel.org and went to the
download section.
I am confused as to which one to download based upon what I have installed
on my box - I am looking for more guidance - then what you have provided -
that is why I had given the details. Do I download sid, sarge, or woody ???
Do I use which project name ?? I have debian -i can execute a dpkg -e kannel
, but how do i install new svn - thanks
thanks in advance for your help.

2011/3/21 Nikos Balkanas nbalka...@gmail.com

 Hi,

 Go to the site http://www.kannel.org and follow downloading instructions.
 You will need to install package svn. To check you can use:

 ls $(which svn)

 (I am sure there must be a better command to check packages in Debian)
 and to install it:

 apt-get svn.

 BR,
 Nikos


 - Original Message - From: Joey L
 To: Alvaro Cornejo
 Cc: Adan Canales ; users@kannel.org
 Sent: Monday, March 21, 2011 5:06 PM
 Subject: Re: New to Kannel



 I am on debian - I would like to download the latest kannel from svn, do
 you know how i can do this ???
 I think i am on debian -

 rider:~# cat /proc/version
 Linux version 2.6.26-2-amd64 (Debian 2.6.26-26lenny2) (da...@debian.org)
 (gcc version 4.1.3 20080704 (prerelease) (Debian 4.1.2-25)) #1 SMP Tue Jan
 25 05:59:43 UTC 2011


 thanks
 mjh


 On Mon, Mar 21, 2011 at 10:54 AM, Alvaro Cornejo cornejo.alv...@gmail.com
 wrote:

 Hi

 You just need to install the kannel sw -better from svn- and then
 adjust the config file according to your needs.

 After that, for running kannel you need to, at least, start bearerbox
 and then smsbox. Something like

 .../path/bearerbox v0 .../path/config-file
 .../path/smsbox v0 .../path/config-file

 The config file must be the same for both boxes.

 Check the user guide for details in config

 Regards

 Alvaro





 |-|
 Envνe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
 celular y Nextel
 en el Perϊ, Mιxico y en mas de 180 paises. Use aplicaciones 2 vias via

 SMS y GPRS online
 Visitenos en www.perusms.NET www.smsglobal.com.mx y
 www.pravcom.com




 On Fri, Mar 18, 2011 at 1:03 PM, Adan Canales adan...@gmail.com wrote:

 Hello Friends:
 I΄m new to Kannel and SMS and I have been trough the manual of Kannel and
 after a week or more of reading it I can find after install it, where to
 begin to configure my core, smsbox, and SMSservice, not to mention which
 fields to include in my MySql tables in order to get an external
 application
 to send and answer to SMS.
 If there is another manual as reference or better explanation on how to do
 it, I will highly appreciate it if someone could lead me to. I promise to
 write an step by step manual for newbies(if not against your rules) as
 soon
 as I a expertise this software, which I believe is awesome,  since the
 actual manual is not meant for us.
 Thank you in advance.
 Adan





Re: New to Kannel

2011-03-21 Thread Nikos Balkanas
If you scroll down a bit, you will see SVN access to source code. Don't 
settle for anything less. They are seriously outdated.


BR,
Nikos
- Original Message - 
From: Joey L

To: Nikos Balkanas
Cc: Alvaro Cornejo ; Adan Canales ; us...@vm1.kannel.org
Sent: Monday, March 21, 2011 6:58 PM
Subject: Re: New to Kannel


Nick - thanks again - but i already went to kannel.org and went to the 
download section.
I am confused as to which one to download based upon what I have installed 
on my box - I am looking for more guidance - then what you have provided - 
that is why I had given the details. Do I download sid, sarge, or woody ??? 
Do I use which project name ?? I have debian -i can execute a dpkg -e kannel 
, but how do i install new svn - thanks

thanks in advance for your help.


2011/3/21 Nikos Balkanas nbalka...@gmail.com

Hi,

Go to the site http://www.kannel.org and follow downloading instructions. 
You will need to install package svn. To check you can use:


ls $(which svn)

(I am sure there must be a better command to check packages in Debian)
and to install it:

apt-get svn.

BR,
Nikos


- Original Message - From: Joey L
To: Alvaro Cornejo
Cc: Adan Canales ; users@kannel.org
Sent: Monday, March 21, 2011 5:06 PM
Subject: Re: New to Kannel



I am on debian - I would like to download the latest kannel from svn, do you 
know how i can do this ???

I think i am on debian -

rider:~# cat /proc/version
Linux version 2.6.26-2-amd64 (Debian 2.6.26-26lenny2) (da...@debian.org) 
(gcc version 4.1.3 20080704 (prerelease) (Debian 4.1.2-25)) #1 SMP Tue Jan 
25 05:59:43 UTC 2011



thanks
mjh


On Mon, Mar 21, 2011 at 10:54 AM, Alvaro Cornejo cornejo.alv...@gmail.com 
wrote:


Hi

You just need to install the kannel sw -better from svn- and then
adjust the config file according to your needs.

After that, for running kannel you need to, at least, start bearerbox
and then smsbox. Something like

.../path/bearerbox v0 .../path/config-file
.../path/smsbox v0 .../path/config-file

The config file must be the same for both boxes.

Check the user guide for details in config

Regards

Alvaro




|-|

EnvΞ½e y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Per�, Mιxico y en mas de 180 paises. Use aplicaciones 2 vias via

SMS y GPRS online
Β  Β  Β  Β  Β  Β  Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com




On Fri, Mar 18, 2011 at 1:03 PM, Adan Canales adan...@gmail.com wrote:

Hello Friends:
IΞ„m new to Kannel and SMS and I have been trough the manual of Kannel and
after a week or more of reading it I can find after install it, where to
begin to configure my core, smsbox, and SMSservice, not to mention which
fields to include in my MySql tables in order to get an external application
to send and answer to SMS.
If there is another manual as reference or better explanation on how to do
it, I will highly appreciate it if someone could lead me to. I promise to
write an step by step manual for newbies(if not against your rules) as soon
as I a expertise this software, which I believe is awesome, Β since the
actual manual is not meant for us.
Thank you in advance.
Adan 





Re: New to Kannel

2011-03-21 Thread Alvaro Cornejo
Hi Adan

You need to handle that in your own app. Kannel uses mysql for its
OWN/Internal dlr tracking and deletes the dlr once it receives a final
confirmation. If you do want to keep track of your messages, you can
use your own development or use sqlbox included in kannel.

Regards

Alvaro
|-|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
              Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com



On Mon, Mar 21, 2011 at 11:48 AM, Adan Canales adan...@gmail.com wrote:
 I quit on Debian, too dificult, instead on Ubuntu was easy to install.
 I´m now working on configuring the boxes and then start testing. I wonder
 how can I keep control of all my messages sent? is this in DLR? Once I have
 say it to kannel thru the configuration that uses Mysql, it records
 everything on it?
 Regards
 Adan
 2011/3/18 Adan Canales adan...@gmail.com

 Hello Friends:
 I´m new to Kannel and SMS and I have been trough the manual of Kannel and
 after a week or more of reading it I can find after install it, where to
 begin to configure my core, smsbox, and SMSservice, not to mention which
 fields to include in my MySql tables in order to get an external application
 to send and answer to SMS.
 If there is another manual as reference or better explanation on how to do
 it, I will highly appreciate it if someone could lead me to. I promise to
 write an step by step manual for newbies(if not against your rules) as soon
 as I a expertise this software, which I believe is awesome,  since the
 actual manual is not meant for us.
 Thank you in advance.
 Adan




new to compiling 1.43 version.

2011-03-21 Thread Joey L
I am running Kannel that comes as a debian package.
I installed and configured it via apt-get .
I have download the new version 1.43 and have compiled it.
I would like to remove the old version of the debian package and install the
new code - can someone help me ???

I know to remove the package, it is dpkg -e kannel.

I have compiled the new package and i have to run one more command :

make bindir=/somewhere/suitable install

Can anyone tell me what /somewhere/suitable install  should be 

I would also like to know how i can get the init.d script running
properly under the new version.


thanks

mjh


Re: new to compiling 1.43 version.

2011-03-21 Thread Alexander Ulitin
I think, you need to learn how to use and administrate linux.
/somewhere/suitable is your bin path. Print whereis whereis in your
console and take /.../bin part. Init.d doesn't need to be changed,
but you could write your own, it's not so difficult.

this is my script, made from old default one, you can take a part of
it if you don't need 2 smsboxes and an sqlbox

#!/bin/sh
# PROVIDE: kannel_smsbox kannel_wapbox kannel_bearerbox
# REQUIRE: NETWORKING SERVERS
# BEFORE: LOGIN
# KEYWORD: shutdown

. /etc/rc.subr

name=kannel
rcvar=`set_rcvar`
command=/usr/local/sbin/run_kannel_box
extra_commands=reload
sig_reload=SIGUSR1

load_rc_config $name
# Set defaults
kannel_config=${kannel_config:-/usr/local/etc/kannel.conf}
kannel1_config=${kannel1_config:-/usr/local/etc/kannel1.conf}
kannel2_config=${kannel2_config:-/usr/local/etc/kannel-sqlbox.conf}
kannel_user=${kannel_user:-kannel}
# Config file is required
if [ ! -r ${kannel_config} ]; then
warn ${kannel_config} is not readable.
case $1 in
force*) : ;;
*) exit 1 ;;
esac
fi

if test -n ${kannel_enable:-}  checkyesno kannel_enable; then
kannel_bearerbox_enable=${kannel_bearerbox_enable:-YES}
kannel_smsbox_enable=${kannel_smsbox_enable:-YES}
kannel_wapbox_enable=${kannel_wapbox_enable:-NO}
fi

# bearerbox
name=kannel_bearerbox
rcvar=`set_rcvar`
pidfile=/var/run/kannel/${name}.pid
# Defaults
kannel_bearerbox_user=${kannel_bearerbox_user:-${kannel_user}}
kannel_bearerbox_enable=${kannel_bearerbox_enable:-NO}
kannel_bearerbox_config=${kannel_bearerbox_config:-${kannel_config}}
kannel_bearerbox_flags=${kannel_bearerbox_flags:---pidfile ${pidfile}
--min-delay 1 /usr/local/sbin/bearerbox ${kannel_bearerbox_flags}
${kannel_bearerbox_config}}
#
load_rc_config $name
run_rc_command $1
#
_rc_restart_done=false

# smsbox
name=kannel_smsbox
rcvar=`set_rcvar`
pidfile=/var/run/kannel/${name}.pid
# Defaults
kannel_smsbox_user=${kannel_smsbox_user:-${kannel_user}}
kannel_smsbox_enable=${kannel_smsbox_enable:-NO}
kannel_smsbox_config=${kannel_smsbox_config:-${kannel_config}}
kannel_smsbox_flags=${kannel_smsbox_flags:---pidfile ${pidfile}
--min-delay 1 /usr/local/sbin/smsbox ${kannel_smsbox_flags}
${kannel_smsbox_config}}
#
load_rc_config $name
run_rc_command $1
#
_rc_restart_done=false

# smsbox1
name=kannel_smsbox1
rcvar=`set_rcvar`
pidfile=/var/run/kannel/${name}.pid
# Defaults
kannel_smsbox1_user=${kannel_smsbox1_user:-${kannel_user}}
kannel_smsbox1_enable=${kannel_smsbox1_enable:-NO}
kannel_smsbox1_config=${kannel_smsbox1_config:-${kannel1_config}}
kannel_smsbox1_flags=${kannel_smsbox1_flags:---pidfile ${pidfile}
--min-delay 1 /usr/local/sbin/smsbox ${kannel_smsbox1_flags}
${kannel_smsbox1_config}}
#
load_rc_config $name
run_rc_command $1
#

_rc_restart_done=false

# smsbox1
name=kannel_sqlbox
rcvar=`set_rcvar`
pidfile=/var/run/kannel/${name}.pid
# Defaults
kannel_sqlbox_user=${kannel_sqlbox_user:-${kannel_user}}
kannel_sqlbox_enable=${kannel_sqlbox_enable:-NO}
kannel_sqlbox_config=${kannel_sqlbox_config:-${kannel2_config}}
kannel_sqlbox_flags=${kannel_sqlbox_flags:---pidfile ${pidfile}
--min-delay 1 /usr/local/sbin/sqlbox ${kannel_sqlbox_flags}
${kannel_sqlbox_config}}
#
load_rc_config $name
run_rc_command $1
#


2011/3/22 Joey L mjh2...@gmail.com:
 I am running Kannel that comes as a debian package.
 I installed and configured it via apt-get .
 I have download the new version 1.43 and have compiled it.
 I would like to remove the old version of the debian package and install the
 new code - can someone help me ???
 I know to remove the package, it is dpkg -e kannel.
 I have compiled the new package and i have to run one more command :

 make bindir=/somewhere/suitable install

 Can anyone tell me what /somewhere/suitable install  should be 

 I would also like to know how i can get the init.d script running properly
 under the new version.

 thanks

 mjh




Re: New to Kannel

2011-03-21 Thread Milan P. Stanic
On Mon, 2011-03-21 at 18:48, Nikos Balkanas wrote:
 Go to the site http://www.kannel.org and follow downloading
 instructions. You will need to install package svn. To check you can
 use:
 
 ls $(which svn)
 
 (I am sure there must be a better command to check packages in Debian)
 and to install it:
 
 apt-get svn.

apt-get install subversion

or

aptitude install subversion 

-- 
Kind regards,  Milan
--
Arvanta, IT Securityhttp://www.arvanta.net
Please do not send me e-mail containing HTML code.



Re: new to compiling 1.43 version.

2011-03-21 Thread Milan P. Stanic
On Mon, 2011-03-21 at 17:01, Joey L wrote:
 I am running Kannel that comes as a debian package.
 I installed and configured it via apt-get .
 I have download the new version 1.43 and have compiled it.
 I would like to remove the old version of the debian package and install the
 new code - can someone help me ???
 
 I know to remove the package, it is dpkg -e kannel.
 
 I have compiled the new package and i have to run one more command :
 
 make bindir=/somewhere/suitable install
 
 Can anyone tell me what /somewhere/suitable install  should be 
 
 I would also like to know how i can get the init.d script running
 properly under the new version.

Which Debian release you run?

I have built Kannel 1.5.0 (not svn) for Debian squeeze (current stable)
and for i386 and amd64 architectures only. If it suits your needs send
me a mail and I will put it somewhere for download.

-- 
Kind regards,  Milan
--
Arvanta, IT Securityhttp://www.arvanta.net
Please do not send me e-mail containing HTML code.



Re: New to Kannel

2011-03-21 Thread Milan P. Stanic
On Mon, 2011-03-21 at 10:48, Adan Canales wrote:
 I quit on Debian, too dificult, instead on Ubuntu was easy to install.

Ubuntu is Debian derivative so it is very similar and admin tools are
the same. 

And Debian is stable as a rock. One server with Kannel which I maintain,
right now have uptime of 606 days (should I announce when it comes to
666 ;- ), i.e. works 606 days without reboot.

Here it is:
# uptime
23:19:55 up 606 days, 15:18,  2 users,  load average: 0.00, 0.00, 0.00

-- 
Kind regards,  Milan
--
Arvanta, IT Securityhttp://www.arvanta.net
Please do not send me e-mail containing HTML code.



storing received sms to Database

2011-03-21 Thread Harbhag Singh Sohal
Hi,
I want to know that how can I store the received SMS to the database.
I guess I am receiving SMS beacause I can see them in the access.log
file. But I want to know if how can I store them into the Database. ?
below are my config files

#Sample configuration file for Kannel bearerbox on Debian.
# See the documentation for explanations of fields.
#

# HTTP administration is disabled by default. Make sure you set the
# password if you enable it.

group = core
admin-port = 13015
admin-password = hard2guess
#admin-deny-ip = *.*.*.*
admin-allow-ip = 127.0.0.1
dlr-storage = internal
smsbox-port = 13016
#wdp-interface-name = *
log-file = /var/log/kannel/bearerbox.log
access-log = /var/log/kannel/access.log
#box-deny-ip = *.*.*.*
box-allow-ip = 127.0.0.1
log-level = 0

#group = wapbox
#bearerbox-host = localhost
#log-file = /var/log/kannel/wapbox.log
group = smsc
smsc-id = huawei_e220
smsc = at
modemtype = huawei
device= /dev/ttyUSB0
my-number = +91
connect-allow-ip = 127.0.0.1
sim-buffering = true
log-level = 0

# DLR with MySQL support configuration
group = mysql-connection
id = mydlr
host = localhost
username =
password =
database = a

group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-source=source
field-destination = destination
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc

group = modems
id = nokia
name = Huawei
detect-string = huawei
init-string = ATZ
init-string = AT+CMEE=1
init-string = AT Q0 V1 E1 S0=0 C1 D2 +FCLASS=0
init-string = AT+CNMI=0,1
message-storage = SM
message-start = 0
#speed = 460800
#message-start = 0

group = smsbox
smsbox-id = mysmsc
bearerbox-host = 2
#bearerbox-port = 13018
sendsms-port = 13018
global-sender = +91
access-log = /var/log/kannel/smsbox-access.log
log-file = /var/log/kannel/smsbox.log
log-level = 0
mo-recode = true

group = smsbox-route
smsbox-id = mysmsc

group = sendsms-user
username =
password = hard2guess
concatenation= true
max-messages = 1

group = sms-service
keyword-regex = .*
catch-all = yes
accepted-smsc = huawei_e220
max-messages = 3
get-url = http://localhost/~harbhag/test.php?phone=%ptext=%a;



group = sqlbox
id = sqlbox-db
smsbox-id = mysmsc
global-sender = +91
bearerbox-host = 202
bearerbox-port = 13016
smsbox-port = 13017
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = /var/log/kannel/kannel-sqlbox.log
log-level = 0
#ssl-client-certkey-file = 
#ssl-server-cert-file = 
#ssl-server-key-file = 
#ssl-trusted-ca-file = 

# Database connection examples. Please uncomment as needed

# Example MYSQL Connection
group = mysql-connection
id = sqlbox-db
host = localhost
username =
password =
database =



This is what I see when I start bearerbox



2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- ATF^M
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- ATF
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- ATE0^M
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- ATE0
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+IFC=2,2^M
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPIN?^M
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPIN: READY
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CMGF=0^M
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CSMS=?^M
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CNMI=0,1^M
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CSMS: (0-1)
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPMS=SM^M
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] INFO: AT2[huawei_e220]: AT SMSC
successfully opened.
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPMS:
0,20,0,20,0,20
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPMS?^M
2011-03-22 08:12:35 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPMS:
SM,0,20,SM,0,20,SM,0,20
2011-03-22 08:12:35 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPMS?^M
2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPMS:
SM,0,20,SM,0,20,SM,0,20
2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPMS?^M
2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPMS:
SM,0,20,SM,0,20,SM,0,20
2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK

Re: Using SQLBOX - unix timestamp

2011-03-21 Thread Willy Mularto
change the type to datetime ;)


On Mar 21, 2011, at 5:47 PM, ha...@aeon.pk wrote:

 Hi,
 
 While using sqlbox, the column 'time' in sent_sms column of kannel database 
 is having timestamp values in unix time. Is there a parameter in config by 
 which I could control it to paste values in normal timestamps in the table?
 
 Thanks,
 H

Willy Mularto
F300HD+MR18DE (NLC1725)










Re: storing received sms to Database

2011-03-21 Thread ha...@aeon.pk
Use sqlbox.

On Tue, Mar 22, 2011 at 7:52 AM, Harbhag Singh Sohal 
harbhag.so...@gmail.com wrote:

 Hi,
 I want to know that how can I store the received SMS to the database.
 I guess I am receiving SMS beacause I can see them in the access.log
 file. But I want to know if how can I store them into the Database. ?
 below are my config files

 #Sample configuration file for Kannel bearerbox on Debian.
 # See the documentation for explanations of fields.
 #

 # HTTP administration is disabled by default. Make sure you set the
 # password if you enable it.

 group = core
 admin-port = 13015
 admin-password = hard2guess
 #admin-deny-ip = *.*.*.*
 admin-allow-ip = 127.0.0.1
 dlr-storage = internal
 smsbox-port = 13016
 #wdp-interface-name = *
 log-file = /var/log/kannel/bearerbox.log
 access-log = /var/log/kannel/access.log
 #box-deny-ip = *.*.*.*
 box-allow-ip = 127.0.0.1
 log-level = 0

 #group = wapbox
 #bearerbox-host = localhost
 #log-file = /var/log/kannel/wapbox.log
 group = smsc
 smsc-id = huawei_e220
 smsc = at
 modemtype = huawei
 device= /dev/ttyUSB0
 my-number = +91
 connect-allow-ip = 127.0.0.1
 sim-buffering = true
 log-level = 0

 # DLR with MySQL support configuration
 group = mysql-connection
 id = mydlr
 host = localhost
 username =
 password =
 database = a

 group = dlr-db
 id = mydlr
 table = dlr
 field-smsc = smsc
 field-timestamp = ts
 field-source=source
 field-destination = destination
 field-service = service
 field-url = url
 field-mask = mask
 field-status = status
 field-boxc-id = boxc

 group = modems
 id = nokia
 name = Huawei
 detect-string = huawei
 init-string = ATZ
 init-string = AT+CMEE=1
 init-string = AT Q0 V1 E1 S0=0 C1 D2 +FCLASS=0
 init-string = AT+CNMI=0,1
 message-storage = SM
 message-start = 0
 #speed = 460800
 #message-start = 0

 group = smsbox
 smsbox-id = mysmsc
 bearerbox-host = 2
 #bearerbox-port = 13018
 sendsms-port = 13018
 global-sender = +91
 access-log = /var/log/kannel/smsbox-access.log
 log-file = /var/log/kannel/smsbox.log
 log-level = 0
 mo-recode = true

 group = smsbox-route
 smsbox-id = mysmsc

 group = sendsms-user
 username =
 password = hard2guess
 concatenation= true
 max-messages = 1

 group = sms-service
 keyword-regex = .*
 catch-all = yes
 accepted-smsc = huawei_e220
 max-messages = 3
 get-url = http://localhost/~harbhag/test.php?phone=%ptext=%a;



 group = sqlbox
 id = sqlbox-db
 smsbox-id = mysmsc
 global-sender = +91
 bearerbox-host = 202
 bearerbox-port = 13016
 smsbox-port = 13017
 smsbox-port-ssl = false
 sql-log-table = sent_sms
 sql-insert-table = send_sms
 log-file = /var/log/kannel/kannel-sqlbox.log
 log-level = 0
 #ssl-client-certkey-file = 
 #ssl-server-cert-file = 
 #ssl-server-key-file = 
 #ssl-trusted-ca-file = 

 # Database connection examples. Please uncomment as needed

 # Example MYSQL Connection
 group = mysql-connection
 id = sqlbox-db
 host = localhost
 username =
 password =
 database =



 This is what I see when I start bearerbox



 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- ATF^M
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- ATF
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- ATE0^M
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- ATE0
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+IFC=2,2^M
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPIN?^M
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPIN: READY
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CMGF=0^M
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CSMS=?^M
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CNMI=0,1^M
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CSMS: (0-1)
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPMS=SM^M
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] INFO: AT2[huawei_e220]: AT SMSC
 successfully opened.
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPMS:
 0,20,0,20,0,20
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPMS?^M
 2011-03-22 08:12:35 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPMS:
 SM,0,20,SM,0,20,SM,0,20
 2011-03-22 08:12:35 [7861] [6] DEBUG: AT2[huawei_e220]: -- OK
 2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: -- AT+CPMS?^M
 2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: -- +CPMS:
 SM,0,20,SM,0,20,SM,0,20
 2011-03-22 08:13:37 [7861] [6] DEBUG: