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
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