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.
