[asterisk-users] troubles with res_pgsql

[Hendrik Visage]

Database on a remote machine

res_pgsql.conf:
[general]
dbhost=172.16.0.2
dbport=5432
dbname=ast_config
dbuser=pbx
dbpass=
dbsock=5432

[Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime
Host: 172.16.0.2
[Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime Port: 5432
[Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime User: pbx
[Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime Password:
[Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime
DBName: ast_config
[Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime:
Everything is fine.
[Nov 28 20:12:45] DEBUG[6603] res_config_pgsql.c: Postgresql RealTime:
Everything is fine.
[Nov 28 20:12:45] DEBUG[6603] res_config_pgsql.c: Postgresql RealTime:
Query: SELECT * FROM sip_conf WHERE name = '172.16.0.1'
[Nov 28 20:12:45] DEBUG[6603] res_config_pgsql.c: Postgresql RealTime:
Query Failed because: connection pointer is NULL
[Nov 28 20:12:45] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime:
Everything is fine.
[Nov 28 20:12:45] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime:
Query: SELECT * FROM sip_conf WHERE name = '172.16.0.1'
[Nov 28 20:12:45] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime:
Query Failed because: connection pointer is NULL
[Nov 28 20:12:45] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime:
Everything is fine.
[Nov 28 20:12:45] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime:
Query: SELECT * FROM sip_conf WHERE name = '172.16.0.1'
[Nov 28 20:12:45] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime:
Query Failed because: connection pointer is NULL
[Nov 28 20:12:48] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime:
Everything is fine.
[Nov 28 20:12:48] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime:
Query: SELECT * FROM sip_conf WHERE name = '172.16.0.1'


the CDRs gets pumped fine to a different database on the same
postgresql server :(
(172.16.0.1 is the local machine IP.. which tells me something isn't
right with sip also, but my first trouble is this realtime pgsql :()

-- 
Hendrik Visage