[Freeswitch-users] freeswitch with postgres setup process?

[Moishe Grunstein]

If you use postgres in the core 
1. <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='xxx' options='-c client_min_messages=NOTICE'" />
https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core

If you use odbc 
2.  <param name="core-db-dsn" value="dsn:freeswitch:xxx" />
https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN




Thanks,

Moishe Grunstein
Tornado Computer Systems, Inc.
212.400.7650 888.IPPBX.US
Service Request Email: support at nysolutions.com 

Computer Networking * Managed Services * IP Video Surveillance * Network Assessments * Web Solutions * Voice over IP * Disaster Recovery * Network Security * Site Surveys * CMS


-----Original Message-----
From: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of jungle Boogie
Sent: Sunday, April 10, 2016 6:06 PM
To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
Subject: Re: [Freeswitch-users] freeswitch with postgres setup process?

On 10 April 2016 at 14:44, Ken Rice <krice at freeswitch.org> wrote:
> Thats because the db strings for native pgsql are libpq connect 
> strings dsn:user:pass is odbc

Which one is correct if I do ./configure --enable-core-pgsql-support

1. <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='xxx' options='-c client_min_messages=NOTICE'" />

2.  <param name="core-db-dsn" value="dsn:freeswitch:xxx" />


Also, I see event_handlers/mod_cdr_pg_csv in modules.conf Does that need to be uncommented?


Thanks,
jb


--
-------
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si

_________________________________________________________________________
Professional FreeSWITCH Consulting Services: 
consulting at freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org