Please keep replies in the list. >From the logs attached I see you are using a gsm modem for which I have no experience. What I do not see is you sending a message at all. If you do not send a message then nothing would be stored in the DLR table.
Kyriacos -------- Original Message -------- Subject: Fwd: unable to update the DLR in the table Date: Mon, 26 Apr 2010 18:25:33 +0530 From: Anshu Sah <[email protected]> To: [email protected] Please find the all files attached. On Mon, Apr 26, 2010 at 6:15 PM, Alejandro Guerrieri <[email protected] <mailto:[email protected]>> wrote: Please post relevant log entries. On Mon, Apr 26, 2010 at 2:34 PM, Anshu Sah <[email protected] <mailto:[email protected]>> wrote: Hello Team, I am unable to update the DLR in the table . Please take a look over my brief configuration file. I am also looking for some parameters where i can store the Mesage received my Kannel too in mysql table. Is it possible. -- Thanks Anshu ============================== ========= group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar admin-allow-ip = "127.0.0.0" log-file = "/home/anshu/projects/kannel-1.4.3/logs-e12/kannel.log" #log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" dlr-storage = mysql #--- mysql connection group = mysql-connection id = mydlr host = localhost username = root password = XXXXXXX database = kannelsmsc max-connections = 4 #---- DLR table structure group = dlr-db id = mydlr table = smsc0303 field-smsc = smsc field-timestamp = timestamp field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc_id group = sms-service keyword = catch-all = yes max-messages = 0 get-url = "http://localhost/receiveSMS.php?phone=%p&text=%a <http://localhost/receiveSMS.php?phone=%p&text=%a>"
kannel_e12-0303.conf
Description: Binary data
2010-04-26 18:21:03 [10534] [0] INFO: Added logfile `/home/anshu/projects/kannel-1.4.3/logs-e12/kannel.log' with level `0'. 2010-04-26 18:21:03 [10534] [0] INFO: HTTP: Opening server at port 13000. 2010-04-26 18:21:03 [10534] [0] DEBUG: Started thread 1 (gwlib/fdset.c:poller) 2010-04-26 18:21:03 [10534] [0] DEBUG: Started thread 2 (gwlib/http.c:server_thread) 2010-04-26 18:21:03 [10534] [0] DEBUG: Started thread 3 (gw/bb_http.c:httpadmin_run) 2010-04-26 18:21:03 [10534] [0] DEBUG: starting smsbox connection module 2010-04-26 18:21:03 [10534] [0] INFO: BOXC: 'smsbox-max-pending' not set, using default (100). 2010-04-26 18:21:03 [10534] [0] DEBUG: Started thread 4 (gw/bb_boxc.c:sms_to_smsboxes) 2010-04-26 18:21:03 [10534] [0] DEBUG: Started thread 5 (gw/bb_boxc.c:smsboxc_run) 2010-04-26 18:21:03 [10534] [0] INFO: Set SMS resend frequency to 60 seconds. 2010-04-26 18:21:03 [10534] [0] INFO: SMS resend retry set to unlimited. 2010-04-26 18:21:03 [10534] [0] DEBUG: smsbox MO concatenated message handling enabled 2010-04-26 18:21:03 [10534] [0] INFO: DLR rerouting for smsc id <919709600303> disabled. 2010-04-26 18:21:03 [10534] [0] INFO: Added logfile `/home/anshu/projects/kannel-1.4.3/logs-e12/smsc.log' with level `0'. 2010-04-26 18:21:03 [10534] [0] INFO: AT2[919709600303]: configuration doesn't show modemtype. will autodetect 2010-04-26 18:21:03 [10534] [0] DEBUG: Started thread 6 (gw/smsc/smsc_at.c:at2_device_thread) 2010-04-26 18:21:03 [10534] [0] DEBUG: Started thread 7 (gw/bb_smscconn.c:sms_router) 2010-04-26 18:21:03 [10534] [0] INFO: ---------------------------------------- 2010-04-26 18:21:03 [10534] [0] INFO: Kannel bearerbox II version 1.4.3 starting 2010-04-26 18:21:03 [10534] [7] DEBUG: Thread 7 (gw/bb_smscconn.c:sms_router) maps to pid 10534. 2010-04-26 18:21:03 [10534] [0] INFO: MAIN: Start-up done, entering mainloop 2010-04-26 18:21:03 [10534] [0] DEBUG: AT2[919709600303]: start called 2010-04-26 18:21:03 [10534] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps to pid 10534. 2010-04-26 18:21:03 [10534] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) maps to pid 10534. 2010-04-26 18:21:03 [10534] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) maps to pid 10534. 2010-04-26 18:21:03 [10534] [4] DEBUG: Thread 4 (gw/bb_boxc.c:sms_to_smsboxes) maps to pid 10534. 2010-04-26 18:21:03 [10534] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) maps to pid 10534. 2010-04-26 18:21:03 [10534] [6] DEBUG: Thread 6 (gw/smsc/smsc_at.c:at2_device_thread) maps to pid 10534. 2010-04-26 18:21:03 [10534] [6] INFO: Logging thread `6' to logfile `/home/anshu/projects/kannel-1.4.3/logs-e12/smsc.log' with level `0'. 2010-04-26 18:21:06 [10534] [5] INFO: Client connected from <127.0.0.1> 2010-04-26 18:21:06 [10534] [5] DEBUG: Started thread 8 (gw/bb_boxc.c:function) 2010-04-26 18:21:06 [10534] [8] DEBUG: Thread 8 (gw/bb_boxc.c:function) maps to pid 10534. 2010-04-26 18:21:06 [10534] [8] DEBUG: Started thread 9 (gw/bb_boxc.c:boxc_sender) 2010-04-26 18:21:06 [10534] [9] DEBUG: Thread 9 (gw/bb_boxc.c:boxc_sender) maps to pid 10534. 2010-04-26 18:21:12 [10534] [2] DEBUG: HTTP: Creating HTTPClient for `127.0.0.1'. 2010-04-26 18:21:12 [10534] [2] DEBUG: HTTP: Created HTTPClient area 0x1207f20. 2010-04-26 18:21:12 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:21:12 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:21:22 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:21:22 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:21:25 [10534] [8] DEBUG: boxc_receiver: sms received 2010-04-26 18:21:25 [10534] [8] DEBUG: send_msg: sending msg to box: <127.0.0.1> 2010-04-26 18:21:32 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:21:32 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:21:42 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:21:42 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:21:52 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:21:52 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:22:02 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:22:02 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:22:12 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:22:12 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:22:22 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:22:22 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:22:32 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:22:32 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:22:42 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:22:42 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:22:53 [10534] [3] DEBUG: sql: SELECT count(*) FROM smsc0303; 2010-04-26 18:22:53 [10534] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'.
2010-04-26 18:21:06 [10545] [0] INFO: Added logfile `/home/anshu/projects/kannel-1.4.3/logs-e12/smsbox.log' with level `0'. 2010-04-26 18:21:06 [10545] [0] INFO: Service global sender set as '+919709600303' 2010-04-26 18:21:06 [10545] [0] INFO: HTTP: Opening server at port 13013. 2010-04-26 18:21:06 [10545] [0] DEBUG: Started thread 1 (gwlib/fdset.c:poller) 2010-04-26 18:21:06 [10545] [0] DEBUG: Started thread 2 (gwlib/http.c:server_thread) 2010-04-26 18:21:06 [10545] [0] INFO: Set up send sms service at port 13013 2010-04-26 18:21:06 [10545] [0] DEBUG: Started thread 3 (gw/smsbox.c:sendsms_thread) 2010-04-26 18:21:06 [10545] [0] DEBUG: ---------------------------------------------- 2010-04-26 18:21:06 [10545] [0] DEBUG: Kannel smsbox version 1.4.3 starting 2010-04-26 18:21:06 [10545] [0] DEBUG: dumping group (sendsms-user): 2010-04-26 18:21:06 [10545] [0] DEBUG: <user-allow-ip> = <*.*.*.*> 2010-04-26 18:21:06 [10545] [0] DEBUG: <group> = <sendsms-user> 2010-04-26 18:21:06 [10545] [0] DEBUG: <max-messages> = <10> 2010-04-26 18:21:06 [10545] [0] DEBUG: <username> = <kannelUser> 2010-04-26 18:21:06 [10545] [0] DEBUG: <concatenation> = <1> 2010-04-26 18:21:06 [10545] [0] DEBUG: <password> = <test> 2010-04-26 18:21:06 [10545] [0] DEBUG: Started thread 4 (gw/smsbox.c:obey_request_thread) 2010-04-26 18:21:06 [10545] [0] DEBUG: Started thread 5 (gw/smsbox.c:url_result_thread) 2010-04-26 18:21:06 [10545] [0] DEBUG: Started thread 6 (gw/smsbox.c:http_queue_thread) 2010-04-26 18:21:06 [10545] [4] DEBUG: Thread 4 (gw/smsbox.c:obey_request_thread) maps to pid 10545. 2010-04-26 18:21:06 [10545] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps to pid 10545. 2010-04-26 18:21:06 [10545] [5] DEBUG: Thread 5 (gw/smsbox.c:url_result_thread) maps to pid 10545. 2010-04-26 18:21:06 [10545] [3] DEBUG: Thread 3 (gw/smsbox.c:sendsms_thread) maps to pid 10545. 2010-04-26 18:21:06 [10545] [6] DEBUG: Thread 6 (gw/smsbox.c:http_queue_thread) maps to pid 10545. 2010-04-26 18:21:06 [10545] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) maps to pid 10545. 2010-04-26 18:21:06 [10545] [0] INFO: Connected to bearerbox at 127.0.0.1 port 13001. 2010-04-26 18:21:06 [10545] [0] DEBUG: Started thread 7 (gw/heartbeat.c:heartbeat_thread) 2010-04-26 18:21:06 [10545] [7] DEBUG: Thread 7 (gw/heartbeat.c:heartbeat_thread) maps to pid 10545. 2010-04-26 18:21:19 [10545] [2] DEBUG: HTTP: Creating HTTPClient for `127.0.0.1'. 2010-04-26 18:21:19 [10545] [2] DEBUG: HTTP: Created HTTPClient area 0x11ce840. 2010-04-26 18:21:19 [10545] [3] INFO: smsbox: Got HTTP request </cgi-bin/sendsms> from <127.0.0.1> 2010-04-26 18:21:19 [10545] [3] DEBUG: Status: 403 Answer: <Authorization failed for sendsms> 2010-04-26 18:21:19 [10545] [3] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:21:25 [10545] [3] INFO: smsbox: Got HTTP request </cgi-bin/sendsms> from <127.0.0.1> 2010-04-26 18:21:25 [10545] [3] INFO: sendsms used by <kannelUser> 2010-04-26 18:21:25 [10545] [3] INFO: sendsms sender:<kannelUser:anshu> (127.0.0.1) to:<9781114229> msg:<hello anshu> 2010-04-26 18:21:25 [10545] [3] DEBUG: Stored UUID f0c9201e-c7f0-45cd-9e89-4e2c4fadb7d5 2010-04-26 18:21:25 [10545] [3] DEBUG: message length 11, sending 1 messages 2010-04-26 18:21:25 [10545] [3] DEBUG: Status: 202 Answer: <Sent.> 2010-04-26 18:21:25 [10545] [3] DEBUG: Delayed reply - wait for bearerbox 2010-04-26 18:21:25 [10545] [0] DEBUG: Got ACK (0) of f0c9201e-c7f0-45cd-9e89-4e2c4fadb7d5 2010-04-26 18:21:25 [10545] [0] DEBUG: HTTP: Resetting HTTPClient for `127.0.0.1'. 2010-04-26 18:22:25 [10545] [1] DEBUG: Timeout for fd:23 appeares. 2010-04-26 18:22:25 [10545] [1] DEBUG: HTTP: Destroying HTTPClient area 0x11ce840. 2010-04-26 18:22:25 [10545] [1] DEBUG: HTTP: Destroying HTTPClient for `127.0.0.1'.
2010-04-26 18:21:03 [10534] [6] DEBUG: AT2[919709600303]: detecting modem speed. 2010-04-26 18:21:03 [10534] [6] INFO: AT2[919709600303]: opening device 2010-04-26 18:21:03 [10534] [6] DEBUG: AT2[919709600303]: device opened. Telnet mode = 0 2010-04-26 18:21:04 [10534] [6] DEBUG: AT2[919709600303]: device opened 2010-04-26 18:21:04 [10534] [6] INFO: AT2[919709600303]: speed set to 115200 2010-04-26 18:21:04 [10534] [6] DEBUG: AT2[919709600303]: --> ^M 2010-04-26 18:21:06 [10534] [6] DEBUG: AT2[919709600303]: --> AT^M 2010-04-26 18:21:06 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:06 [10534] [6] INFO: AT2[919709600303]: Closing device 2010-04-26 18:21:06 [10534] [6] INFO: AT2[919709600303]: detect speed is 115200 2010-04-26 18:21:06 [10534] [6] DEBUG: AT2[919709600303]: detecting modem type 2010-04-26 18:21:06 [10534] [6] INFO: AT2[919709600303]: opening device 2010-04-26 18:21:06 [10534] [6] DEBUG: AT2[919709600303]: device opened. Telnet mode = 0 2010-04-26 18:21:07 [10534] [6] DEBUG: AT2[919709600303]: device opened 2010-04-26 18:21:07 [10534] [6] INFO: AT2[919709600303]: speed set to 115200 2010-04-26 18:21:07 [10534] [6] DEBUG: AT2[919709600303]: --> ^M 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: --> AT^M 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: --> AT&F^M 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: --> ATE0^M 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: --> ATI^M 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: <-- Undefined 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: found string <Undefined>, using modem definition <Teltonika E12> 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: --> AT+CSMS=?^M 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: <-- +CSMS: (0-1) 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:09 [10534] [6] INFO: AT2[919709600303]: Closing device 2010-04-26 18:21:09 [10534] [6] INFO: AT2[919709600303]: opening device 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: device opened. Telnet mode = 0 2010-04-26 18:21:09 [10534] [6] DEBUG: AT2[919709600303]: device opened 2010-04-26 18:21:09 [10534] [6] INFO: AT2[919709600303]: Logging in 2010-04-26 18:21:10 [10534] [6] INFO: AT2[919709600303]: init device 2010-04-26 18:21:10 [10534] [6] INFO: AT2[919709600303]: speed set to 115200 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: --> ATZ^M 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: --> AT^M 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- AT 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: --> AT&F^M 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- AT&F 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: --> ATE0^M 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- ATE0 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: --> AT+IFC=2,2^M 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: --> AT+CPIN?^M 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- +CPIN: READY 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: --> AT+CSCA="+919709099990"^M 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:10 [10534] [6] DEBUG: AT2[919709600303]: --> AT+CMGF=0^M 2010-04-26 18:21:11 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:11 [10534] [6] DEBUG: AT2[919709600303]: --> AT+CSMS=?^M 2010-04-26 18:21:11 [10534] [6] DEBUG: AT2[919709600303]: <-- +CSMS: (0-1) 2010-04-26 18:21:11 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:11 [10534] [6] DEBUG: AT2[919709600303]: --> AT+CNMI=1,2,0,1,0^M 2010-04-26 18:21:11 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:11 [10534] [6] INFO: AT2[919709600303]: AT SMSC successfully opened. 2010-04-26 18:21:27 [10534] [6] DEBUG: AT2[919709600303]: TP-Validity-Period: 24.0 hours 2010-04-26 18:21:27 [10534] [6] DEBUG: AT2[919709600303]: --> AT+CMGS=23^M 2010-04-26 18:21:27 [10534] [6] DEBUG: AT2[919709600303]: <-- > 2010-04-26 18:21:27 [10534] [6] DEBUG: AT2[919709600303]: send command status: 1 2010-04-26 18:21:27 [10534] [6] DEBUG: AT2[919709600303]: --> 0011000A8179181124920000A70BE8329BFD0685DD73741D 2010-04-26 18:21:27 [10534] [6] DEBUG: AT2[919709600303]: --> ^Z 2010-04-26 18:21:29 [10534] [6] DEBUG: AT2[919709600303]: <-- > 2010-04-26 18:21:29 [10534] [6] DEBUG: AT2[919709600303]: <-- +CMGS: 56 2010-04-26 18:21:29 [10534] [6] DEBUG: AT2[919709600303]: <-- OK 2010-04-26 18:21:29 [10534] [6] DEBUG: AT2[919709600303]: send command status: 0
