Hi, You configured mysql below is about storing pending deliveries and not messages. If the message is delivered, the respective record in dlr table is deleted, thats why you dont see those.
In order to play with texts and contacts, do it in application side. I assume you have some db there storing incoming or outgoing SMS. On Mon, Sep 27, 2010 at 4:43 PM, <[email protected]> wrote: > > 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
