If you are wanting to create a calling card application.. Have you
looked at ASTCC? I have hardly done anything with PostgreSQL but I'm
guessing it would not be hard to add support for that as a backend
If you do it would be a worthwhile contribution to the community.
Darren Wiebe
[
On December 10, 2004 03:53 am, Adnan Ahmed wrote:
> I want to use PostgreSQL instead of MySQL, basically i want to create
> an application (calling card),firstly i am not be able to connecting
> postgres to my asterisks i made some configuration in
> odbc.ini,odbcinst.ini cdr_pgsql etc but no luck
Hi *'s,
Back Again
I want to use PostgreSQL instead of MySQL, basically i want to create
an application (calling card),firstly i am not be able to connecting
postgres to my asterisks i made some configuration in
odbc.ini,odbcinst.ini cdr_pgsql etc but no luck asterisk doesn't
recognize it unk
Hello Neil/Everybody,
Yes you are correct, PostgreSQL has to be specifically configured
within the server it is hosted on to allow host calls from Asterisk so
that the socket connects.
Here is how I solved the problem through the help of everybody here:
Firstly enable the -i command in the /etc/
Caleb Kow wrote:
Here we go:
[EMAIL PROTECTED] root]# netstat -ap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address
State PID/Program name
tcp0 0 *:32768 *:*
LISTEN 32
try tcpdump -i lo port 5432 or icmp
(or tethereal if you have it)
Prehaps it's trying a UNIX socket connection?
also, please change your database password as you've now supplied
ip,user,pass to the mailing list :) Hopefully, you've got it restricted
to localhost
Caleb Kow wrote:
Here we go:
[EMA
Here we go:
[EMAIL PROTECTED] root]# netstat -ap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address
State PID/Program name
tcp0 0 *:32768 *:*
LISTEN 3221/
tcp0
Caleb Kow wrote:
Results of netstat -ap
You seem to be missing the top part of the output which looks like this:
[EMAIL PROTECTED] build]# netstat -ap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
PID/Program nam
Caleb,
postgresql is usually run under user postgres and is very sensitive to
config files permissions. Both postgres.conf and pg_hba.conf should be
owned by postgres:postgres and have 0600 permissions. I often get the
same error after editing these files and leaving them owned by root :)
Ivan
Hi Sam,
I have tried adding in the -i flag into the postgresql startup command
line but it displays the following upon starting up of Asterisk:
Jun 25 02:00:02 ERROR[1074494336]: cdr_pgsql.c:298 my_load_module:
cdr_pgsql: Unable to connect to database server localhost. Calls will
not be logged!
Results of netstat -ap
Active UNIX domain sockets (servers and established)
Proto RefCnt Flags Type State I-Node PID/Program
namePath
unix 2 [ ACC ] STREAM LISTENING 5881 3623/
/tmp/.iroha_unix/IROHA
unix 2 [ ACC ] STREAM LIST
Looks like PostgreSQL is running in UNIX local socket mode (which is
default) and does not allow incoming TCP/IP connections even for
localhost. Did you check for "tcpip_socket = true" line in your
postgresql.conf file (it is /var/lib/pgsql/data/ directory on my
system)? You can also check perm
Caleb Kow wrote:
Hello Everybody,
I am trying to configure Asterisk to listen into a database which is
created in PostgreSQL. Whenever asterisk starts up, it is unable to
connect to the pg database and gives the following error:
[cdr_pgsql.so] => (PostgreSQL CDR Backend)
== Parsing '/etc/asteris
On Thu, Jun 24, 2004 at 09:05:42PM +0800, Caleb Kow wrote:
> Jun 24 21:20:53 ERROR[1074494336]: cdr_pgsql.c:299 my_load_module:
> cdr_pgsql: Reason: could not connect to server: Connection refused
> Is the server running on host localhost and accepting
> TCP/IP connections on port 5
Hello Everybody,
I am trying to configure Asterisk to listen into a database which is
created in PostgreSQL. Whenever asterisk starts up, it is unable to
connect to the pg database and gives the following error:
[cdr_pgsql.so] => (PostgreSQL CDR Backend)
== Parsing '/etc/asterisk/cdr_pgsql.con
15 matches
Mail list logo