Hi, Have tried specifying:
port=<pgsql-port> in your pgsql-connection group? BR, Nikos ----- Original Message ----- From: Scott Geller To: [email protected] Sent: Wednesday, June 09, 2010 3:32 AM Subject: sqlbox: PGSQL: could not connect to server 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
