Thanks alot Barry this was really helpful<br><br>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 insert call detail record into database!<br>
[Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:310 pgsql_log: Reason: 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 may have been lost... attempting to reconnect.<br>
[Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:314 pgsql_log: Connection reestablished.<br>[Sep 1 12:46:09] ERROR[19498]: cdr_pgsql.c:320 pgsql_log: HARD ERROR! Attempted reconnection failed. DROPPING CALL RECORD!<br><br>
<br><br><br><br><br><br><br><br><div class="gmail_quote">On Mon, Aug 31, 2009 at 6:06 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;">
-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<div class="im"><br>
ABBAS SHAKEEL wrote:<br>
<br>
> but when i execute this ./configure --with-postgres=<dir where<br>
> postgresql is installed><br>
><br>
> it gives an error for missing an pg_config file ..... i searched the PC<br>
> but it really dont exists..... but database server is fine and working OK!<br>
><br>
> what to do in this situation<br>
<br>
</div>You should have the following packages installed on your Asterisk system<br>
<br>
postgresql-libs<br>
postgresql-devel<br>
postgresql<br>
<br>
If the database is on the same box, include:<br>
postgresql-server<br>
<br>
If you want to hit the database from the dialplan for any reason, include:<br>
<br>
postgresql-odbc<br>
<br>
Once you install these, be sure to rerun ./configure<br>
<br>
Barry<br>
-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG v1.4.5 (GNU/Linux)<br>
<br>
iD8DBQFKm8rOCFu3bIiwtTARAijbAJ4vt0DVZJYUPRhPrNpXm2KEngRmxACgn24T<br>
aHtpBzyGhPBmw8a4veqdLhQ=<br>
=TI+m<br>
-----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>
</blockquote></div><br><br clear="all"><br>-- <br>Best Regards<br>Shakeel Abbas<br><br>