[asterisk-users] CDR to Postgres Centos

[ABBAS SHAKEEL]

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 <blkline at attglobal.net>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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090901/c253a4bc/attachment.htm