I attach sqlbox configuration.
I only find send sms stored in database.
get-url = "http://localhost/api/sms.php?phone=%p&text=%a";
localhost/api/sms.php code
<?php
include 'Db.php';
$phone = $_GET['phone'];
$msg = $_GET['text'];
$sql="INSERT INTO send_sms (sender,msgdata)
VALUES ('$phone','$msg')";
mysql_query($sql);
?>
sqlbox.conf
group = sqlbox
id = sqlbox-db
smsbox-id = mysqlbox
global-sender = "+919888888887"
bearerbox-host = localhost
bearerbox-port = 13016
smsbox-port = 13020
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 = ""
# Database connection examples. Please uncomment as needed
# Example MYSQL Connection
group = mysql-connection
id = sqlbox-db
host = localhost
username = boot
password = abc
database = key
On Sun, Dec 2, 2012 at 12:18 PM, Amin Mukhaimer
<[email protected]> wrote:
> You don't seem to have attached sqlbox configurations, but you should be
> able to find the sent and received SMSs in the sql box "sent_sms" table.
>
> You can also handle storing received SMSs using the webpage:
>
> get-url = "http://localhost/api/sms.php?phone=%p&text=%a";
>
> Good luck.
--
Navdeep Bagga
Happy Bird
[W] http://navdeepbagga.com
[T] http://www.navdeepbagga.com/category/daily-diary-3/
