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!
Dear, Check whether you have enable tcp/ip socket connection in your Postgres config. postgresql.conf, if yes, see whether u have respective user and password strategy 'trust'. Fabio Donaggio wrote:> 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! > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
On Wed, 2004-05-26 at 08:40, Fabio Donaggio wrote:> 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!Seems it told you pretty clear that it could not establish a connection to your postgresql server. I suggest you start by checking that it is running, that it is accessible via TCP/IP(maybe use nmap), and that you can connect to it with 'psql -h localhost'. Most likely you are not configured to answer TCP/IP. Look in /etc/postgresql/postgresql.conf for something like 'tcpip_socket = true' and 'port = 5432'. You may also need to have '-i' in POSTMASTER_OPTIONS under postmaster.conf. There is still the possibility then that you don't have the proper pg_hba.conf entry to allow connects in. Don't forget to restart postgres after your config changes so they take effect. I'm not sure how much it will allow to change when you kill -HUP it. -- Steven Critchfield <critch@basesys.com>
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
Fabio,
You need to enable tcp connectivity on psql. Wherever you configured the
databases to live (/var/lib/pgsql/data on my machine) you'll find a file
called "postgres.conf". You need to read that and uncomment out the
appropriate lines to get:
tcpip_socket = true
port = 5432
-brian
Fabio Donaggio wrote:
>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!
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users@lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
Thaks to all!!! Now it works! Thanks
Is there an interface for postgresql and asterisk?
On Sun, 2004-06-06 at 16:57, mag0007 wrote:> Is there an interface for postgresql and asterisk?Did you even do a minor amount of research before you gave up to ask a documented question? -- Steven Critchfield <critch@basesys.com>