[asterisk-users] PostgreSQL problems

[David A. Bandel]

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.

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
-- 
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto
Visit my blog at: http://www.pananix.com/cgi-bin/blosxom