Hi Chun Li,
Are you refering to "mysql storage" for DLRs? This is a temporary storage
system for only deliver receipts.
The advantage is that you can restart your bearerbox process without
losing any delivery receipts.
If you want to store the actual messages persistently then you need to
specify a get-url parameter which will hand the SMS off to an application
(something you need to write).
Cheers,
Iain
On Tue, 25 Oct 2011, Chun Li wrote:
Hi team,
I got confused about where I saved my incoming messages. It's supposed to be
mysql database. But nothing found in mysql when Kannel knows new message
received. It seems Kannel does talk to mysql because when I send messages
they are inserted into mysql. Anyone can share some ideas?
My configure file:
group = core
admin-port = 13070
smsbox-port = 13071
admin-password = a****
status-password = a****
log-file = "/home/****/SMSconf.log"
log-level = 0
store-type = file
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
http-proxy-host = "127.0.0.1"
http-proxy-port = 80
access-log = "/****/access.log"
store-location = "/****/kannel.store"
#store-location = "/****/etc/"
store-type = file
dlr-storage = mysql
group = mysql-connection
id = mydlr
host = localhost
username = root
password = a****
database = dlr_db
max-connections = 1
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
group = modems
id = ZTE
name = "ZTE"
init-string = "ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0;+CNMI=1,2,0,1,0;+CMGF=1"
init-string = "AT+CSCA="+6421600600""
detect-string = "ZTE INCORPORATED"
message-storage = "SM"
no-smsc = false
group = smsc
smsc = at
smsc-id = mlte
modemtype = auto
device= /dev/ttyUSB2
my-number = +6****
sms-center = +6****06****
log-level = 0
sim-buffering = false
allowed-prefix = "+6****;+4****2;+6****;****1;0****2;****;+****"
reroute = no
group = smsbox
bearerbox-host = localhost
bearerbox-port = 13071
sendsms-port = 13073
log-file = "/h****.log"
log-level=0
group = sms-service
keyword = default
#keyword-regex = .*
max-messages = 0
catch-all = true
omit-empty = true
accept-x-kannel-headers = false
get-url = "http://localhost/kannel/sendsms.php?mobile=%p&text=%a";
group = sendsms-user
username = a****
password = a****
concatenation= true
max-messages = 4
After I started bearerbox and smsbox, I sent a SMS to the GSM modem and got
log:
2011-10-26 15:30:45 [22704] [6] INFO: AT2[mlte]: AT SMSC successfully
opened.
2011-10-26 15:31:08 [22704] [5] INFO: Client connected from <127.0.0.1>
2011-10-26 15:31:08 [22704] [5] DEBUG: Started thread 9
(gw/bb_boxc.c:function)
2011-10-26 15:31:08 [22704] [9] DEBUG: Thread 9 (gw/bb_boxc.c:function) maps
to pid 22704.
2011-10-26 15:31:08 [22704] [9] DEBUG: Started thread 10
(gw/bb_boxc.c:boxc_sender)
2011-10-26 15:31:08 [22704] [10] DEBUG: Thread 10 (gw/bb_boxc.c:boxc_sender)
maps to pid 22704.
2011-10-26 15:31:33 [22704] [6] DEBUG: AT2[mlte]: <-- +CMTI: "ME",2
2011-10-26 15:31:33 [22704] [6] DEBUG: AT2[mlte]: +CMTI incoming SMS
indication: +CMTI: "ME",2
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: --> AT+CPMS="ME"^M
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: <-- +CPMS:
3,100,0,20,3,100
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: <-- OK
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: --> AT+CMGR=2^M
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: <-- +CMGR: 0,,24
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: <--
06914612061107040B914612124293F100001101625113132505F7B77C3D07
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: received message from
SMSC: +64**1170
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: Numeric sender
(international) <+64******>
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: User data length read as
(5)
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: Udh decoding done len=5
udhi=0 udhlen=0 udh=''
2011-10-26 15:31:35 [22704] [10] DEBUG: send_msg: sending msg to box:
<127.0.0.1>
2011-10-26 15:31:35 [22704] [10] DEBUG: boxc_sender: sent message to
<127.0.0.1>
2011-10-26 15:31:35 [22704] [9] DEBUG: boxc_receiver: got ack
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: <-- OK
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: --> AT+CMGD=2^M
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: <-- OK
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: --> AT+CPMS="SM"^M
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: <-- +CPMS: 0,20,0,20,2,100
2011-10-26 15:31:35 [22704] [6] DEBUG: AT2[mlte]: <-- OK
2011-10-26 15:31:38 [22704] [9] DEBUG: boxc_receiver: heartbeat with load
value 0 received
2011-10-26 15:31:47 [22704] [8] DEBUG: Dumping 0 messages to store
and:
2011-10-26 15:31:35 [22782] [4] INFO: Starting to service <works> from
<+64212124391> to <+64212439798>
2011-10-26 15:31:35 [22782] [4] DEBUG: Started thread 8
(gwlib/fdset.c:poller)
2011-10-26 15:31:35 [22782] [8] DEBUG: Thread 8 (gwlib/fdset.c:poller) maps
to pid 22782.
2011-10-26 15:31:35 [22782] [4] DEBUG: Started thread 9
(gwlib/http.c:write_request_thread)
2011-10-26 15:31:35 [22782] [9] DEBUG: Thread 9
(gwlib/http.c:write_request_thread) maps to pid 22782.
2011-10-26 15:31:35 [22782] [9] DEBUG: Queue contains 0 pending requests.
2011-10-26 15:31:35 [22782] [9] DEBUG: Parsing URL
`http://127.0.0.1/playsms/plugin/gateway/kannel/geturl.php?t=2011-10-26+02:31:31&q=%2B64212124391&a=works':
2011-10-26 15:31:35 [22782] [9] DEBUG: Scheme: http://
2011-10-26 15:31:35 [22782] [9] DEBUG: Host: 127.0.0.1
2011-10-26 15:31:35 [22782] [9] DEBUG: Port: 80
2011-10-26 15:31:35 [22782] [9] DEBUG: Username: (null)
2011-10-26 15:31:35 [22782] [9] DEBUG: Password: (null)
2011-10-26 15:31:35 [22782] [9] DEBUG: Path:
/playsms/plugin/gateway/kannel/geturl.php
2011-10-26 15:31:35 [22782] [9] DEBUG: Query:
t=2011-10-26+02:31:31&q=%2B64212124391&a=works
2011-10-26 15:31:35 [22782] [9] DEBUG: Fragment: (null)
2011-10-26 15:31:35 [22782] [9] DEBUG: HTTP: Opening connection to
`127.0.0.1:80' (fd=27).
2011-10-26 15:31:35 [22782] [9] DEBUG: Socket connecting
2011-10-26 15:31:35 [22782] [8] DEBUG: Get info about connecting socket
2011-10-26 15:31:35 [22782] [8] DEBUG: HTTP: Sending request:
2011-10-26 15:31:35 [22782] [8] DEBUG: Octet string at 0x89b0058:
2011-10-26 15:31:35 [22782] [8] DEBUG: len: 188
2011-10-26 15:31:35 [22782] [8] DEBUG: size: 1024
2011-10-26 15:31:35 [22782] [8] DEBUG: immutable: 0
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 47 45 54 20 68 74 74 70 3a 2f
2f 31 32 37 2e 30 GET http://127.0
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 2e 30 2e 31 2f 70 6c 61 79 73
6d 73 2f 70 6c 75 .0.1/playsms/plu
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 67 69 6e 2f 67 61 74 65 77 61
79 2f 6b 61 6e 6e gin/gateway/kann
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 65 6c 2f 67 65 74 75 72 6c 2e
70 68 70 3f 74 3d el/geturl.php?t=
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 32 30 31 31 2d 31 30 2d 32 36
2b 30 32 3a 33 31 2011-10-26+02:31
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 3a 33 31 26 71 3d 25 32 42 36
34 32 31 32 31 32 :31&q=%2B6421212
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 34 33 39 31 26 61 3d 77 6f 72
6b 73 20 48 54 54 4391&a=works HTT
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 50 2f 31 2e 31 0d 0a 48 6f 73
74 3a 20 31 32 37 P/1.1..Host: 127
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 2e 30 2e 30 2e 31 0d 0a 43 6f
6e 6e 65 63 74 69 .0.0.1..Connecti
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 6f 6e 3a 20 6b 65 65 70 2d 61
6c 69 76 65 0d 0a on: keep-alive..
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 55 73 65 72 2d 41 67 65 6e 74
3a 20 4b 61 6e 6e User-Agent: Kann
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 65 6c 2f 31 2e 34 2e 33 0d 0a
0d 0a el/1.4.3....
2011-10-26 15:31:35 [22782] [8] DEBUG: Octet string dump ends.
2011-10-26 15:31:35 [22782] [8] DEBUG: HTTP: Status line: <HTTP/1.1 200 OK>
2011-10-26 15:31:35 [22782] [8] DEBUG: HTTP: Received response:
2011-10-26 15:31:35 [22782] [8] DEBUG: Octet string at 0x89b5808:
2011-10-26 15:31:35 [22782] [8] DEBUG: len: 249
2011-10-26 15:31:35 [22782] [8] DEBUG: size: 1024
2011-10-26 15:31:35 [22782] [8] DEBUG: immutable: 0
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 44 61 74 65 3a 20 57 65 64 2c
20 32 36 20 4f 63 Date: Wed, 26 Oc
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 74 20 32 30 31 31 20 30 32 3a
33 31 3a 33 35 20 t 2011 02:31:35
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 47 4d 54 0d 0a 53 65 72 76 65
72 3a 20 41 70 61 GMT..Server: Apa
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 63 68 65 2f 32 2e 32 2e 31 37
20 28 55 62 75 6e che/2.2.17 (Ubun
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 74 75 29 0d 0a 58 2d 50 6f 77
65 72 65 64 2d 42 tu)..X-Powered-B
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 79 3a 20 50 48 50 2f 35 2e 33
2e 35 2d 31 75 62 y: PHP/5.3.5-1ub
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 75 6e 74 75 37 2e 33 0d 0a 50
72 61 67 6d 61 3a untu7.3..Pragma:
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 20 6e 6f 2d 63 61 63 68 65 0d
0a 56 61 72 79 3a no-cache..Vary:
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 20 41 63 63 65 70 74 2d 45 6e
63 6f 64 69 6e 67 Accept-Encoding
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 0d 0a 43 6f 6e 74 65 6e 74 2d
4c 65 6e 67 74 68 ..Content-Length
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 3a 20 30 0d 0a 4b 65 65 70 2d
41 6c 69 76 65 3a : 0..Keep-Alive:
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 20 74 69 6d 65 6f 75 74 3d 31
35 2c 20 6d 61 78 timeout=15, max
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 3d 31 30 30 0d 0a 43 6f 6e 6e
65 63 74 69 6f 6e =100..Connection
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 3a 20 4b 65 65 70 2d 41 6c 69
76 65 0d 0a 43 6f : Keep-Alive..Co
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 6e 74 65 6e 74 2d 54 79 70 65
3a 20 74 65 78 74 ntent-Type: text
2011-10-26 15:31:35 [22782] [8] DEBUG: data: 2f 68 74 6d 6c 0d 0a 0d 0a
/html....
2011-10-26 15:31:35 [22782] [8] DEBUG: Octet string dump ends.
2011-10-26 15:31:35 [22782] [5] INFO: No reply sent, denied.
2011-10-26 15:31:50 [22782] [8] DEBUG: HTTP: Server closed connection,
destroying it <127.0.0.1:80:0::><0x89b02d0><fd:27>.
Thanks
Chun
--
View this message in context:
http://old.nabble.com/Where-did-I-save-incoming-messages--tp32721871p32721871.html
Sent from the Kannel - User mailing list archive at Nabble.com.
