Hi,
I won't comment on sqlbox. Regarding bb. Please post bb logs in maximum
detail from when receiving DLR from smsc. What kannel version do you have?
BR,
Nikos
----- Original Message -----
From: Scott Geller
To: [email protected]
Sent: Saturday, June 12, 2010 7:00 AM
Subject: getting MO and MT data into a database
Guys,
I've been working on this for days and cant get it working. I'm trying to
get the data from kannel into postgres... either with sqlbox or with BB.
regarding sqlbox:
I have sqlbox working and when I insert a line into the send_sms table,
everything works on the MT side. But I'm under the impression that if if
start sqlbox before I start smsbox, the MO data should also be captured. I
THINK this data would be ritcher than the BB data based on what I've seen
with the table structures
regarding BB:
I am not seeing any data posted into my table
regarding postgres:
I can query the connections and can see that kannel is connecting:
select * from pg_stat_activity;
33362 dlr 27524 10 postgres select * from pg_stat_activity false 2010-06-11
23:38:50.522682 2010-06-11 23:38:50.524477 2010-06-10 21:13:36.271735
127.0.0.1 53776
33362 dlr 9087 10 postgres <IDLE> false 2010-06-11 22:58:51.365257 127.0.0.1
58058
33362 dlr 9100 10 postgres <IDLE> false 2010-06-11 23:38:49.857646
2010-06-11 22:58:59.383983 127.0.0.1 58059
33362 dlr 29443 10 postgres <IDLE> false 2010-06-11 20:45:46.143249
2010-06-10 21:34:24.909323 127.0.0.1 39551
33362 dlr 32004 10 postgres <IDLE> false 2010-06-11 23:02:00.430404
2010-06-11 20:44:41.274866 127.0.0.1 37469
I have my dlr table in two schemas (public and dlr)... the schemas are in a
database called dlr.
Here's the create table code for the schema dlr:
CREATE TABLE dlr.dlr (smsc varchar, ts varchar, destination varchar, source
varchar, service varchar, url varchar, mask varchar, status varchar, boxc
varchar);
I'm not seeing any errors either on the postgres side or the kannel side
that may indicate a problem
here's my config files:
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13011
smsbox-port = 13099
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/kannel-sqlbox.log"
log-level = 0
group = pgsql-connection
id = sqlbox-db
username = postgres
password = postgres
database = dlr
host = localhost
max-connections = 1
port=5432
######################
group = core
admin-port = 13000
admin-password = bar
smsbox-port = 13011
log-file = "/var/log/kannel/bearerbox.log"
log-level = 0
access-log = "/var/log/kannel/bearerbox_access.log"
dlr-storage = pgsql
group = smsc
smsc = at
device = /dev/rfcomm0
#speed = 9600
speed = 115200
group = smsbox
bearerbox-host = localhost
log-file = "/var/log/kannel/smsbox.log"
log-level = 0
access-log = "/var/log/kannel/smsbox_access.log"
bearerbox-port = 13011
sendsms-port = 13012
group = modems
id = generic
name = "Generic Modem"
group = sendsms-user
username = tester
password = foobar
name = "tester sendsms-user"
group = sms-service
keyword = nop
text = "You asked nothing and I did it!"
catch-all = true
group = sms-service
keyword = default
text = "testing 123455"
group = pgsql-connection
id = mydlr
#host = localhost
host = 127.0.0.1
username = postgres
password = postgres
database = dlr
max-connections = 1
port = 5432
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
