Hello Barry I am using asterisk 1.6.1.2 ...
Yeah the database was created at that time ..... because if the database is not created then it gives another error i remeber like .. database not found or not accepting connections... The problem is solved automatically ... I have done nothing (restart etc not included in nothing ;)....).... It is working fine Thanks On Tue, Sep 1, 2009 at 5:26 PM, Barry L. Kline <[email protected]>wrote: > -----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 > -- Best Regards Shakeel Abbas
_______________________________________________ -- 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
