Re: [asterisk-users] Postgresql in Asterisk

2012-02-29 Thread Sergio Basurto
-users@lists.digium.com Sent: Wednesday, February 22, 2012 6:54:47 AM Subject: Re: [asterisk-users] Postgresql in Asterisk On Wed, 2012-02-22 at 06:48 -0600, Sergio Basurto wrote: Hello, I install asterisk an postgresql 9.1 in gentoo, I already did the configuration

Re: [asterisk-users] Postgresql in Asterisk

2012-02-27 Thread Sergio Basurto
-gator.com To: asterisk-users@lists.digium.com Sent: Wednesday, February 22, 2012 6:54:47 AM Subject: Re: [asterisk-users] Postgresql in Asterisk On Wed, 2012-02-22 at 06:48 -0600, Sergio Basurto wrote: Hello, I install asterisk an postgresql 9.1 in gentoo, I already did

Re: [asterisk-users] Postgresql in Asterisk

2012-02-24 Thread Jonathan Rose
:47 AM Subject: Re: [asterisk-users] Postgresql in Asterisk On Wed, 2012-02-22 at 06:48 -0600, Sergio Basurto wrote: Hello, I install asterisk an postgresql 9.1 in gentoo, I already did the configuration in both asterisk and postgresql, in fact If I make a call and asterisk log it to CDR

[asterisk-users] Postgresql in Asterisk

2012-02-22 Thread Sergio Basurto
Hello, I install asterisk an postgresql 9.1 in gentoo, I already did the configuration in both asterisk and postgresql, in fact If I make a call and asterisk log it to CDR table, my question is: how can I make a function like the ones in func_odbc.conf for postgresql, if I am using

Re: [asterisk-users] Postgresql in Asterisk

2012-02-22 Thread Sergio Basurto
On Wed, 2012-02-22 at 06:48 -0600, Sergio Basurto wrote: Hello, I install asterisk an postgresql 9.1 in gentoo, I already did the configuration in both asterisk and postgresql, in fact If I make a call and asterisk log it to CDR table, my question is: I make a typo mistake I mean If I make

[asterisk-users] Postgresql Reconnect on connection failure

2011-09-23 Thread Eric Hiller
Currently if asterisk loses its connection to the postgresql it does not attempt to reconnect. I have searched all over for a setting that would have asterisk attempt to reconnect but I can not find anything. Is there something I am missing? Thanks! -Eric

Re: [asterisk-users] Postgresql Reconnect on connection failure

2011-09-23 Thread Danny Nicholas
From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Eric Hiller Sent: Friday, September 23, 2011 1:29 PM To: asterisk-users@lists.digium.com Subject: [asterisk-users] Postgresql Reconnect on connection failure Currently if asterisk loses

Re: [asterisk-users] PostgreSQL is asterisk friendly with it?

2010-09-14 Thread Edwin Quijada
*---* From: benny+use...@amorsen.dk To: brya...@zktech.com Date: Mon, 13 Sep 2010 20:24:25 +0200 CC: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] PostgreSQL is asterisk friendly with it? Bryant Zimmerman brya...@zktech.com writes

[asterisk-users] PostgreSQL is asterisk friendly with it?

2010-09-13 Thread Bryant Zimmerman
As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully supported with asterisk? Is there any down side to

Re: [asterisk-users] PostgreSQL is asterisk friendly with it?

2010-09-13 Thread Danny Nicholas
From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Bryant Zimmerman Sent: Monday, September 13, 2010 10:47 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] PostgreSQL is asterisk friendly

Re: [asterisk-users] PostgreSQL is asterisk friendly with it?

2010-09-13 Thread Vince Vielhaber
-users] PostgreSQL is asterisk friendly with it? As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully

Re: [asterisk-users] PostgreSQL is asterisk friendly with it?

2010-09-13 Thread Steve Kennedy
On Mon, Sep 13, 2010 at 12:31:55PM -0400, Vince Vielhaber wrote: change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully [snippage and probably off topic] Why are you worried

Re: [asterisk-users] PostgreSQL is asterisk friendly with it?

2010-09-13 Thread Sherwood McGowan
I agree with Steve, I've had a couple of people speak with me about concerns of MySQL's new ownership, but I stand by the same reasons Steve doesMySQL will not be going anywhere, and if it does, someone'll just fork and keep it going under a new name. On Mon, Sep 13, 2010 at 11:46 AM, Steve

Re: [asterisk-users] PostgreSQL is asterisk friendly with it?

2010-09-13 Thread Benny Amorsen
Bryant Zimmerman brya...@zktech.com writes: As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully

[asterisk-users] PostgreSQL problems

2009-10-14 Thread David A. Bandel
Folks, I know this must be a configuration problem. Just changed servers last nite -- an interim server running 1.6.1.6. Copied all of /etc/asterisk to the new server and fired it up. Now I'm getting: [Oct 14 12:28:10] ERROR[8471]: cdr_pgsql.c:309 pgsql_log: Failed to insert call detail record

Re: [asterisk-users] PostgreSQL problems

2009-10-14 Thread Roderick A. Anderson
David A. Bandel wrote: Folks, I know this must be a configuration problem. Just changed servers last nite -- an interim server running 1.6.1.6. Copied all of /etc/asterisk to the new server and fired it up. Local or remote PostgreSQL server? Is the new Asterisk server allowed to connect

[asterisk-users] PostgreSQL CDRs 1.6 (was: Re: 1.6 upgrade issues)

2008-12-17 Thread Philipp Kempgen
Chris Bagnall schrieb: Also seem to be getting some errors writing CDRs to a postgresql database. What errors precisely? How can you tell? I'm using the schema for pgsql from voip-info.org, which, again, has worked fine logging 1.2 and 1.4. Have there been any schema changes in 1.6 one

[asterisk-users] PostgreSQL query results truncated 255 characters

2008-01-17 Thread vcomp
I am querying an postgresql database from my 1.4.13 system and the results seem to be truncating each column at 255 characters. The columns are typed as character varying 1000. Any suggestion on how to remove this limit? TIA Vic ___ -- Bandwidth and

Re: [Asterisk-Users] PostgreSQL

2004-06-07 Thread Stuart Grimshaw
On Sun, 06 Jun 2004 17:57:19 -0400, mag0007 [EMAIL PROTECTED] wrote: Is there an interface for postgresql and asterisk? It depends what you want to do with Asterisk PostgreSQL, There is a whole host of info on the mailing list archive about PostgreSQL: http://tinyurl.com/328m8 There's also some

[Asterisk-Users] PostgreSQL

2004-06-06 Thread mag0007
Is there an interface for postgresql and asterisk? ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] PostgreSQL

2004-06-06 Thread Steven Critchfield
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 [EMAIL PROTECTED] ___ Asterisk-Users

[Asterisk-Users] PostgreSQL

2004-05-26 Thread Fabio Donaggio
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

Re: [Asterisk-Users] PostgreSQL

2004-05-26 Thread Murali Krishnan
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

Re: [Asterisk-Users] PostgreSQL

2004-05-26 Thread Steven Critchfield
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

Re: [Asterisk-Users] PostgreSQL

2004-05-26 Thread 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.

Re: [Asterisk-Users] PostgreSQL

2004-05-26 Thread Brian Cuthie
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