I have successfully managed to start kannel gateway with mysql connected as you can see from the log file provided below but the challenge is when i send and receive the messages the delivery reports are not stored in the mysql even when i have provided the required configuration as you can see from my configuration file below.
Moving forward according to what the user guide says you can store the received messages and the phone numbers of the senders in mysql but am a bit stack on how i can do that.Please provide me with the details that are needed to straight away post the received messages and the numbers into the database.If possible tell me the steps that i must undertake. The project that am undertaking requires messages and phone numbers to be stored in mysql database so that i can dynamically play around with the contact details but to do that i need a way of sending both the messages and phone numbers into the mysql database. bearerbox log file 2010-09-27 01:57:36 [3146] [0] INFO: Debug_lvl = 1, log_file = <none>, log_lvl = 0 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 196 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 27 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 13 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 15 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 9 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 11 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 13 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 25 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 197 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 2 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: MYSQL: Connected to server at localhost. 2010-09-27 01:57:36 [3146] [0] INFO: MYSQL: server version 5.1.45, client version 5.1.45. 2010-09-27 01:57:36 [3146] [0] INFO: DLR using storage type: mysql 2010-09-27 01:57:36 [3146] [0] INFO: Added logfile `/tmp/kannel.log' with level `0'. 2010-09-27 01:57:36 [3146] [0] INFO: Started access logfile `/tmp/access.log'. 2010-09-27 01:57:36 [3146] [0] INFO: HTTP: Opening server at port 13000. 2010-09-27 01:57:36 [3146] [0] INFO: Mutex gwlib/list.c:135: 1 locks, 0 collisions. 2010-09-27 01:57:36 [3146] [0] INFO: BOXC: 'smsbox-max-pending' not set, using default (100). 2010-09-27 01:57:36 [3146] [0] INFO: Set SMS resend frequency to 60 seconds. 2010-09-27 01:57:36 [3146] [0] INFO: SMS resend retry set to unlimited. 2010-09-27 01:57:36 [3146] [0] INFO: DLR rerouting for smsc id <(null)> disabled. 2010-09-27 01:57:36 [3146] [0] INFO: AT2[/dev/ttyUSB0]: configuration doesn't show modemtype. will autodetect 2010-09-27 01:57:36 [3146] [6] INFO: AT2[/dev/ttyUSB0]: opening device 2010-09-27 01:57:36 [3146] [0] INFO: ---------------------------------------- 2010-09-27 01:57:36 [3146] [0] INFO: Kannel bearerbox II version svn-r4838 starting 2010-09-27 01:57:36 [3146] [0] INFO: MAIN: Start-up done, entering mainloop 2010-09-27 01:57:37 [3146] [6] INFO: AT2[/dev/ttyUSB0]: speed set to 115200 2010-09-27 01:57:39 [3146] [6] INFO: AT2[/dev/ttyUSB0]: Closing device 2010-09-27 01:57:39 [3146] [6] INFO: AT2[/dev/ttyUSB0]: detect speed is 115200 2010-09-27 01:57:39 [3146] [6] INFO: AT2[/dev/ttyUSB0]: opening device 2010-09-27 01:57:40 [3146] [6] INFO: AT2[/dev/ttyUSB0]: speed set to 115200 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 196 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 27 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 13 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 15 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 9 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 11 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 13 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 25 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 197 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 2 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 15 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 14 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 8 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 9 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 29 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 4 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 8 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 8 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 3 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 5 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 7 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 6 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 5 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 5 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 4 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/dict.c:207: 12 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: Mutex gwlib/list.c:135: 4 locks, 0 collisions. 2010-09-27 01:57:43 [3146] [6] INFO: AT2[/dev/ttyUSB0]: Closing device 2010-09-27 01:57:43 [3146] [6] INFO: AT2[/dev/ttyUSB0]: opening device 2010-09-27 01:57:43 [3146] [6] INFO: AT2[/dev/ttyUSB0]: Logging in 2010-09-27 01:57:44 [3146] [6] INFO: AT2[/dev/ttyUSB0]: init device 2010-09-27 01:57:44 [3146] [6] INFO: AT2[/dev/ttyUSB0]: speed set to 115200 2010-09-27 01:57:45 [3146] [6] INFO: Mutex gwlib/list.c:135: 4 locks, 0 collisions. 2010-09-27 01:57:45 [3146] [6] INFO: AT2[/dev/ttyUSB0]: AT SMSC successfully opened. Configuration file group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar status-password = foo #admin-deny-ip = "" admin-allow-ip = "127.0.0.1" log-file = "/tmp/kannel.log" log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" unified-prefix = "00265,0"\ dlr-storage= mysql access-log = "/tmp/access.log" #store-file = "kannel.store" #ssl-certkey-file = "mycertandprivkeyfile.pem" group = smsc smsc = at modemtype = auto device = /dev/ttyUSB0 my-number = 0888959802 log-level = 0 #sim-buffering = true group = modems id = huawei name = "huawei_e160" detect-string = "huawei" init-string = "ATZ" init-string = "ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0" init-string = "AT+CNMI=2,0,0,2,0" message-storage = sm speed = 115200 # SMSBOX SETUP group = smsbox bearerbox-host = localhost sendsms-port = 13013 global-sender = 0888959802 #sendsms-chars = "0123456789 +-" #log-file = "/tmp/smsbox.log" #log-level = 0 #access-log = "access.log" # SEND-SMS USERS group = sendsms-user username = me password = me max-messages=1 concatenation=true #user-deny-ip = "" #user-allow-ip = "" # this sender is for Kannel relay testing (http_smsc) #group = sendsms-user #username = kannel #password = rL4y #user-deny-ip = "*.*.*.*" #user-allow-ip = "127.0.0.1" # SERVICES group = sms-service keyword = nop text = " You asked nothing and I did it!" # this service is for Kannel relay testing, when this #group = sms-service #keyword = relay #max-messages = 1 #get-url ="http://www.thegate.com/testingkannel/testkannel.asp?user=kannel&pass=rL4y&from=%p&to=%P&text=%r"; group = sms-service keyword = default text = "No service specified" # DLR with MySQL support configuration group = mysql-connection id = mydlr host = localhost username = root password = database = dlr 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
