Hi Kannel Users
I'm new to Kannel and trying to get sqlbox running (I have bearerbox and
smsbox running with no problems)...
when I run sqlbox, I'm getting the following errors:
2010-06-08 20:25:48 [12785] [0] ERROR: PGSQL: connection to database 'dlr'
failed!
2010-06-08 20:25:48 [12785] [0] PANIC: PGSQL: could not connect to server:
Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5?
Strange note that I previously got a port connection error of:
2010-06-08 18:17:08 [5828] [0] ERROR: PGSQL: connection to database 'dlr'
failed!
2010-06-08 18:17:08 [5828] [0] PANIC: PGSQL: could not connect to server:
Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 1936681068?
Any idea why sqlbox isn't automatically using the postgresql port of 5432?
thanks!!
Scott
My conf files are:
##############
sqlbox conf file
##############
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13000
smsbox-port = 13001
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
##############
bearerbox and smsbox conf file
##############
group = core
admin-port = 13000
admin-password = bar
smsbox-port = 13001
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"
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
username = postgres
password = postgres
database = dlr
max-connections = 10
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
