[asterisk-users] PostgreSQL problems

[Roderick A. Anderson]

David A. Bandel wrote:
> Folks,
> 
> I know this must be a configuration problem.  Just changed servers
> last nite -- an interim server running 1.6.1.6.  Copied all of
> /etc/asterisk to the new server and fired it up.

Local or remote PostgreSQL server?

Is the new Asterisk server allowed to connect to the PostgreSQL 
database.  Iptables or pg_hba.conf on a remote system.


\\||/
Rod
-- 
> 
> Now I'm getting:
> [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:309 pgsql_log: Failed to
> insert call detail record into database!
> [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:310 pgsql_log: Reason:
> ERROR:  syntax error at or near ")"
> LINE 1: INSERT INTO cdr ) VALUES )
>                         ^
> 
> [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:311 pgsql_log: Connection
> may have been lost... attempting to reconnect.
> [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:314 pgsql_log: Connection
> reestablished.
> [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:320 pgsql_log: HARD ERROR!
> Attempted reconnection failed.  DROPPING CALL RECORD!
> [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:321 pgsql_log: Reason:
> ERROR:  syntax error at or near ")"
> LINE 1: INSERT INTO cdr ) VALUES )
> 
> any clues appreciated.
> 
> Thanx,
> 
> David A. Bandel