Have you managed to fix this issue? I have a working setup and I will share my files with you here:
core.conf: group = core admin-port = 13000 admin-password = bar log-file = "kannel/bearerbox.log" log-level = 1 access-log = "kannel/bearerbox-access.log" smsbox-port = 13001 box-allow-ip = "127.0.0.1" store-file = "kannel/kannel.store" sqlbox.conf: group = sqlbox id = sqlbox-db smsbox-id = "default-smsbox" bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "kannel/kannel-sqlbox.log" log-level = 0 # Database connection examples. Please uncomment as needed # Example MYSQL Connection group = mysql-connection id = sqlbox-db host = localhost username = root password = root database = kannel smsbox.conf: group = smsbox bearerbox-host = localhost bearerbox-port = 13005 sendsms-port = 13013 log-file = "kannel/smsbox.log" log-level = 0 access-log = "kannel/smsbox-access.log" reply-couldnotfetch = "Could not fetch the response" reply-couldnotrepresent = "Could not represent the response" reply-requestfailed = "Could not make request" reply-emptymessage = "Response was an empty response" Nii Amon Suranga Ranjith wrote: > > 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 > > -- View this message in context: http://old.nabble.com/MO---MT-stores-on-mysql-tp33046308p33178746.html Sent from the Kannel - User mailing list archive at Nabble.com.
