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 _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
