[Freeswitch-users] Connecting freeswitch to postgresql

[Michael Jerris]

would need to see specifics.  from what you said earlier, it sounds like there are permissions issues creating some things.  the first time you boot up you will see a lot of sql errors as it checks if the tables are there, fails, then creates them.

> On May 24, 2018, at 8:45 PM, Blackhold <blackholdmailer at gmail.com> wrote:
> 
> <crying></crying>
> 
> I have search string odbc in each config file and added the line for connecting to psql 
> 
>   549  vi autoload_configs/switch.conf.xml 
>   550  vi sip_profiles/internal.xml 
>   551  vi autoload_configs/directory.conf.xml 
>   552  vi autoload_configs/voicemail.conf.xml 
>   553  vi autoload_configs/easyroute.conf.xml 
>   554  vi autoload_configs/db.conf.xml 
>   555  vi sip_profiles/internal.xml 
>   556  vi autoload_configs/db.conf.xml 
>   557  vi autoload_configs/cidlookup.conf.xml 
>   558  vi autoload_configs/lcr.conf.xml 
>   559  vi autoload_configs/nibblebill.conf.xml 
>   560  vi autoload_configs/callcenter.conf.xml 
>   561  vi jingle_profiles/server.xml 
>   562  vi sip_profiles/internal-ipv6.xml 
>   563  vi sip_profiles/internal-ipv6.xml 
>   564  vi skinny_profiles/internal.xml 
> 
> this is the line I have added (not to all files, the ones that asks for odbc-dsn:
> 
>     <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
> 
> I started freeswitch again, and now it don't turns on and postgresql logs are crazy!
> 
> 
> 
> - Blackhold
> http://blackhold.nusepas.com <http://blackhold.nusepas.com/>
> @blackhold_
> ~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs)
> <°((( ><

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180525/c9f04215/attachment.html>