[asterisk-users] CDR to Postgres Centos

[Barry L. Kline]

-----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-----