Hi All, I'm studying the Kannel and I want to store the incoming messages and/or outgoing messages on a mysql database. I have no idea how to configure the sqlbox.Can you tell me where is the error of conf files? (I can send/ receive sms to/from SMPPsim with these configurations. When I brows the db=kannel I can see the tables but no messages)
$ bearerbox kannel.conf $ smsbox kannel.conf $ sqlbox sqlbox.conf These are my .conf files. ===========File(1)==================== #kannel.conf group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar log-file = /home/suranga/klogs/kannel.log log-level = 0 access-log = /home/suranga/klogs/access_kannel.log store-file = /home/suranga/klogs/store_sms dlr-storage = internal group = smsbox smsbox-id = mysmsbox bearerbox-host = localhost sendsms-port = 13003 global-sender = 123456 log-file = /home/suranga/klogs/smsbox.log log-level = 0 mo-recode = true group = smsc smsc = smpp smsc-id = SMPPSim host = localhost port = 2775 transceiver-mode = 1 receive-port = 2775 smsc-username = smppclient smsc-password = password system-type = 'VMA' #service-type = 'test' interface-version = 34 system-id = smppclient preferred-smsc-id = SMPPSim group = sendsms-user username = a password = a #forced-smsc = SMPPSim default-sender = 9471 group = sendsms-user username = hutch password = a #forced-smsc = hutch default-sender = 9478 group = sendsms-user username = dialog password = a #forced-smsc = dialog default-sender = 9477 group = sms-service keyword = default text = "No service specified" ============File(2)==================== #sqlbox.conf group = sqlbox id = sqlbox-db smsbox-id = mysmsbox global-sender = "+91" bearerbox-host = localhost bearerbox-port = 13000 smsbox-port = 13001 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/home/suranga/klogs/sqlbox.log" log-level = 0 group = mysql-connection id = sqlbox-db host = localhost username = root password = database = kannel Thank you! SKS. Ranjith
