Re: devel Digest, Vol 75, Issue 31

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/