Ive managed to solve every problem using playsms with kannel.
Everything now is working great, have just to correctly configure
playsms for the forwarders :)
Regards
Il 07/12/2011 14:42, Carlos Massoglia Lillo ha scritto:
Hi,
you can install sqlbox, and you get a table called "sent_sms" with all
sms sent and DLR.
Cheers.
El mié, 07-12-2011 a las 10:49 +0100, Supporto Tecnico - Crazy Network
escribió:
Hi everyone.
im trying to work with Kannel since some month now and ive successfull
let it work as the company where i work want.. now.. my next step is
save SMS into a DB so ive recompiled Kannel with latest SVN (yesterday
06/12/11) with mysql option enabled (and ofc mysql-devel installed).
Installation went just fine, configuration doent give any error but im
unable to see sms stored in database.
Ive made some search on google and i should have wrong understand what i
read (my native language is not english, so, sorry for any error), ive
read that mysql is used just as temp database where kannel put the sms
and remove that line once he have reply to the database, is this correct?
If yes, how should i do for let sms stored to the database?
Also, what about if i dont want that kannel reply directly to the sms?
(Now he reply with a get-url in sms-service and with a status 0 delivery
accepted from source code (that i had edited for test).
Here my needs so:
1 - Kannel receive the SMS and store it in a MySQL DB
2 - A custom PHP script (that will be programmed from some programmers
here in office) will check every minute (with crontab) if there are new sms
3 - The PHP script will call smsbox for send multiple sms (like sms
accepted, forward of the sms to tech support or/and whatever)
4 - Kannel store the sent sms into another table using sqlbox i suppose
(still didnt study this yet)
Anyone can help me out with this request? Here my config:
>cat kannel.conf
include = "/usr/local/kannel/core.conf"
include = "/usr/local/kannel/smsc.conf"
include = "/usr/local/kannel/smsbox.conf"
include = "/usr/local/kannel/sms-user.conf"
include = "/usr/local/kannel/sms-service.conf"
include = "/usr/local/kannel/modems.conf"
include = "/usr/local/kannel/mysql.conf"
>cat core.conf
group = core
admin-port = 13000
smsbox-port = 13001
admin-password = foo
#status-password = foo
#admin-deny-ip = ""
admin-allow-ip = ""
log-file = "/var/log/kannel/bearerbox.log"
log-level = 0
#box-deny-ip = "*.*.*.*"
box-allow-ip = "*.*.*.*"
dlr-storage = mysql
#unified-prefix = "+39,0039;+,00"
access-log = "/var/log/kannel/bearerbox-access.log"
#store-location = "/usr/local/kannel/store.kannel"
#ssl-server-cert-file = "cert.pem"
#ssl-server-key-file = "key.pem"
#ssl-certkey-file = "mycertandprivkeyfile.pem"
>cat smsc.conf
group = smsc
smsc = at
modemtype = auto
device=/dev/ttyUSB1
my-number = 3806320353
connect-allow-ip = "*.*.*.*"
log-level = 0
>cat smsbox.conf
group = smsbox
bearerbox-host = 10.10.15.123
sendsms-port = 13013
global-sender = 3806320353
#sendsms-chars = "0123456789 +-"
log-file = "/var/log/kannel/smsbox.log"
log-level = 0
access-log = "/var/log/kannel/bearerbox-access.log"
>cat sms-user.conf
group = sendsms-user
username = andrea
password = password
concatenation = true
max-messages = 1000
#user-deny-ip = ""
user-allow-ip = "*.*.*.*"
>cat sms-service.conf
group = sms-service
keyword =
catch-all = yes
get-url =
"http://10.10.15.123:13013/cgi-bin/sendsms?username=andrea&password=password&from=RTH&to=3388552885+%q&text=GAI+USER+%q+your+request+is+accepted+form+the+system+at+%t+and+will+be+sent+to+our+team.+Text:+%a";
group = sms-service
keyword = default
text = "No service specified"
>cat mysql.conf
group = mysql-connection
id = dlr-db
host = 10.10.11.7
username = sms
password = vR174
database = sms
max-connections = 10
group = dlr-db
id = dlr-db
table = dlr
field-smsc = smsc
field-timestamp = ts
field-source = source
field-destination = destination
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
I didnt pasted modem.conf cause i dont think is needed, modem is an
Huawei E220 USB that is working great if anyone would like to use it.
Can anyone point me to the right edits?
Thanks in advance.
Best regards
--
Andrea Iannucci
----------------------------
----------------------------
Crazy Network di Iannucci Andrea
Viale G.B. Lulli, 24
00050 Cerveteri - RM
(w) www.crazynetwork.it
(e) andrea.iannu...@crazynetwork.it
(t) +39 06 62279876
(f) +39 06 62298767
(m) +39 338 8552885
-------------------------------------------------------------------------------
Please consider our enviromental responsabilità before printing this
E-Mail. Thank you.
-------------------------------------------------------------------------------
Questo messaggio di posta elettronica contiene informazioni di carattere
confidenziale rivolte esclusivamente al destinatario sopra indicato.
E' vietato l'uso, la diffusione, distribuzione o riproduzione da parte
di ogni altra persona. Nel caso aveste ricevuto questo messaggio di
posta elettronica per errore, siete pregati di segnalarlo immediatamente
al mittente e distruggere quanto ricevuto (compresi i file allegati)
senza farne copia.
Qualsivoglia utilizzo non autorizzato del contenuto di questo messaggio
costituisce violazione dell'obbligo di non prendere cognizione della
corrispondenza tra altri soggetti, salvo più grave illecito, ed espone
il responsabile alle relative conseguenze.
--------------------------------------------------------------------------------
This e-mail is confidential and may also contain privileged information.
If you are not the intended recipient you are not authorised to read,
print, save, process or disclose this message. If you have received this
message by mistake, please inform the sender immediately and delete this
e-mail, its attachments and any copies.
Any use, distribution, reproduction or disclosure by any person other
than the intended recipient is strictly prohibited and the person
responsible may incur penalties.
--------------------------------------------------------------------------------
