Hello,
I am having a hard time getting SQL box working.
I need inbound MOs to be handled by the standard "exec" command I have
specified in the kannel.conf file, not via SQLBox. I want to use SQLbox for
outbound messages (ie, insert messages into the SQLBox table to send them).
It seems that all MOs are currently being handled by the SQLbox, and the exec
command i specify in kannel.conf is not running.
Here is my kannel.conf:
#Kannel.conf
group = core
admin-port = 13000
smsbox-port = 13001
admin-password = bar
admin-allow-ip = "*.*.*.*"
log-file = "/var/log/kannel/kannel.log"
log-level = 0
box-allow-ip = "*.*.*.*"
dlr-storage = mysql
group = smsbox
smsbox-id = smsbox1
bearerbox-host = localhost
sendsms-port = 13013
bearerbox-port = 13003
sendsms-chars = "0123456789 +-"
log-file = "/var/log/kannel/smsbox.log"
log-level = 0
# SERVICE: Just one: its all handled by exec.php
group = sms-service
keyword = default
exec = /var/www/html/exec.php msg="%a" phone=%p shortcode=%P operatorid=%o
metadata=%D >/dev/null 2>&1 &
max-messages = 0
accept-x-kannel-headers = true
Here's the sqlbox.conf:
#SQLBOX.conf
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
#global-sender = ""
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13003
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/kannel-sqlbox.log"
log-level = 100
Any help you could lend would be great. Thank you.