Thanks alot Barry this was really helpful 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! On Mon, Aug 31, 2009 at 6:06 PM, Barry L. Kline <[email protected]>wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > ABBAS SHAKEEL wrote: > > > but when i execute this ./configure --with-postgres=<dir where > > postgresql is installed> > > > > it gives an error for missing an pg_config file ..... i searched the PC > > but it really dont exists..... but database server is fine and working > OK! > > > > what to do in this situation > > You should have the following packages installed on your Asterisk system > > postgresql-libs > postgresql-devel > postgresql > > If the database is on the same box, include: > postgresql-server > > If you want to hit the database from the dialplan for any reason, include: > > postgresql-odbc > > Once you install these, be sure to rerun ./configure > > Barry > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.5 (GNU/Linux) > > iD8DBQFKm8rOCFu3bIiwtTARAijbAJ4vt0DVZJYUPRhPrNpXm2KEngRmxACgn24T > aHtpBzyGhPBmw8a4veqdLhQ= > =TI+m > -----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
