Put bearerbox-port = 13005 (the sqlbox port) in group = smsbox.
From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of mac...@fastermail.com Sent: Tuesday, 05 October, 2010 13:14 To: users@kannel.org Subject: help with sms-service and sqlbox Hey fellows my kannel server keeps telling me that it can not fetch content even when i specified the directives required in the get-url as you can see below.Then i have installed sqlbox on my fedora 13 but what baffles me is when i send the messages using the httpd interface nothing is recorded in the table sent_sms even if the message is successfully sent.But when i do a manual send in the database with the insert command on the mysql database the messages are sent and stored in the database.Any idea what i should to do in order for the messages to be recorded in the database when i send using the http interface. I defined the table message with fields msg,sender and time and wrote a script that was supposed to insert the values into these fields specified by the incomming message.Could you correct me if am wrong because in my understanding %a,%t and %p are variables for message,time and phone number respectively.Hence i used msg,time and sender as my variables for my php script that was required to insert the messages into the table defined. The smskannel and sqlbox are successfully starting but there are in two seperate configurations but are both in the same directory. smskannel configuration file group = core admin-port = 13000 smsbox-port = 13001 admin-password = camcom status-password = camcom #admin-deny-ip = "" #admin-allow-ip = "" #log-file = "/tmp/kannel.log" #log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" #unified-prefix = "+358,00358,0;+,00" #access-log = "/tmp/access.log" #store-file = "kannel.store" #ssl-server-cert-file = "cert.pem" #ssl-server-key-file = "key.pem" #ssl-certkey-file = "mycertandprivkeyfile.pem" dlr-storage = mysql #group = smsc #smsc = fake #smsc-id = FAKE #port = 20000 #connect-allow-ip = 127.0.0.1 group = smsc smsc = at modemtype = auto device = /dev/ttyUSB0 my-number = 0888959802 log-level = 0 sim-buffering = true group = smsbox bearerbox-host = localhost sendsms-port = 13013 sendsms-chars = "0123456789" global-sender = "0888959802" access-log = "/home/camcom/kannel.access" log-file = "/home/camcom/smsbox.log" log-level = 0 #sendsms-chars = "0123456789 +-" #log-file = "/tmp/smsbox.log" #access-log = "/tmp/access.log" group = sendsms-user username = camcom password = camcom max-messages = 2 concatenation = true group = sms-service keyword = default #text = "You asked nothing and I did it!" get-url = "http://127.0.0.1:80/var/www/html/receive.php?msg=%a&time=%t&sender=%p"; max-messages = 1 concatenation = true #group = sms-service #keyword = default #text = "No service specified" group = mysql-connection id = mydlr host = localhost username = root password = camcom database = dlr # max count of connections that will be opened for dbpool #default is 1 #max-connections = 1 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 group = modems id = huawei_e160 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 = 9600 sqlbox configuration group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = "" 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 = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 #ssl-client-certkey-file = "" #ssl-server-cert-file = "" #ssl-server-key-file = "" #ssl-trusted-ca-file = "" group = mysql-connection id = sqlbox-db host = localhost username = root password = camcom database = dlr max-connections = 1
