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
