[Asterisk-Users] PostgreSQL

[C. Maj]

On Wed, 26 May 2004, Fabio Donaggio waxed:

> Hi to all!!
> 
> Here's my problem:
> 
> [cdr_pgsql.so] => (PostgreSQL CDR Backend)
>   == Parsing '/etc/asterisk/cdr_pgsql.conf': Found
> May 26 17:21:35 ERROR[16384]: cdr_pgsql.c:298 my_load_module: cdr_pgsql:
> Unable to connect to database server localhost.
> Calls will not be logged!
> May 26 17:21:35 ERROR[16384]: cdr_pgsql.c:299 my_load_module: cdr_pgsql:
> Reason: could not connect to server:
> Connection refused
>         Is the server running on localhost and accepting
>         TCP/IP connections on port 5432?
> 
> Anyone can help me??? Anyone have some suggest about this or about how to
> connect PostgreSQL to Asterisk???
> Thanks!

You need to make sure that PostgreSQL is running with the
'-i' option for net connections OR that postgresql.conf
contains the line 'tcpip_socket = 1'

Are you sure that PostgreSQL is running on the same machine
that Asterisk is running on ?  How did you connect to the
database to create the CDR table initially ?

--Chris


-- 
Chris Maj, Rochester
cmaj_at_freedomcorpse_dot_com
Pronunciation Guide: Maj == May