-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 ABBAS SHAKEEL wrote:
> Can i know which querry is executed to insert record to database... > > i am asking this because of > > [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:309 pgsql_log: Failed to > insert call detail record into database! > [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:310 pgsql_log: Reason: > ERROR: syntax error at or near ")" at character 17 > > [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:311 pgsql_log: Connection > may have been lost... attempting to reconnect. > [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:314 pgsql_log: Connection > reestablished. > [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:320 pgsql_log: HARD ERROR! > Attempted reconnection failed. DROPPING CALL RECORD! > Which version of Asterisk are you using? Did you create the PG database for Asterisk? Have you confirmed that you can connect to it using the CLI psql with the appropriate credentials? There are a few steps ahead of where you are before we worry about this particular problem. Barry -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFKnRL4CFu3bIiwtTARAnwNAJ9+CiWdtq17DRSqelNl7bsN5pS32gCeIn+l VNyWYBauMOBvVMhyGUeP/Pk= =G9NP -----END PGP SIGNATURE----- _______________________________________________ -- 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
