Hello Barry <br><br>I am using asterisk 1.6.1.2 ... <br><br>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...<br>
<br><br>The problem is solved automatically ... I have done nothing (restart etc not included in nothing ;)....)....<br><br>It is working fine Thanks <br><br><div class="gmail_quote">On Tue, Sep 1, 2009 at 5:26 PM, Barry L. Kline <span dir="ltr"><<a href="mailto:blkline@attglobal.net">blkline@attglobal.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<br>
ABBAS SHAKEEL wrote:<br>
<br>
</div><div class="im">> Can i know which querry is executed to insert record to database...<br>
><br>
> i am asking this because of<br>
><br>
> [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:309 pgsql_log: Failed to<br>
> insert call detail record into database!<br>
> [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:310 pgsql_log: Reason:<br>
> ERROR: syntax error at or near ")" at character 17<br>
><br>
> [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:311 pgsql_log: Connection<br>
> may have been lost... attempting to reconnect.<br>
> [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:314 pgsql_log: Connection<br>
> reestablished.<br>
> [Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:320 pgsql_log: HARD ERROR!<br>
> Attempted reconnection failed. DROPPING CALL RECORD!<br>
><br>
<br>
<br>
</div>Which version of Asterisk are you using? Did you create the PG database<br>
for Asterisk? Have you confirmed that you can connect to it using the<br>
CLI psql with the appropriate credentials?<br>
<br>
There are a few steps ahead of where you are before we worry about this<br>
particular problem.<br>
<div class="im"><br>
Barry<br>
-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG v1.4.5 (GNU/Linux)<br>
<br>
</div>iD8DBQFKnRL4CFu3bIiwtTARAnwNAJ9+CiWdtq17DRSqelNl7bsN5pS32gCeIn+l<br>
VNyWYBauMOBvVMhyGUeP/Pk=<br>
=G9NP<br>
<div><div></div><div class="h5">-----END PGP SIGNATURE-----<br>
<br>
_______________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
<br>
AstriCon 2009 - October 13 - 15 Phoenix, Arizona<br>
Register Now: <a href="http://www.astricon.net" target="_blank">http://www.astricon.net</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Best Regards<br>Shakeel Abbas<br><br>