[Freeswitch-users] PostgreSQL core and reg db

Roman Dissauer roman at dissauer.net
Fri Jun 19 11:05:26 MSD 2015


Thank you,

now, that I know this I’ll ignore it.

Roman Dissauer

> Am 19.06.2015 um 04:13 schrieb William King <william.king at quentustech.com>:
> 
> The sofia profiles will always try to recreate the indexes when the
> module loads. You can either ignore these, or configure sofia to skip
> the schema update on startup.
> 
> William King
> Senior Engineer
> Quentus Technologies, INC
> 1037 NE 65th St Suite 273
> Seattle, WA 98115
> Main:   (877) 211-9337
> Office: (206) 388-4772
> Cell:   (253) 686-5518
> william.king at quentustech.com
> 
> On 6/18/15 5:52 AM, Roman Dissauer wrote:
>> Hey,
>> 
>> I started using my PostgreSQL database for freeswitch core and sofia_reg_internal. All works fine but every time I start the internal profile I get a bunch of errors:
>> 
>> 2015-06-18 13:58:48.471346 [NOTICE] sofia.c:5565 Connecting ODBC Profile internal [sofia_reg_internal]
>> 2015-06-18 13:58:48.489141 [ERR] switch_pgsql.c:645 Error executing query:
>> FEHLER:  Relation „sr_call_id“ already exists
>> 
>> 2015-06-18 13:58:48.489515 [ERR] switch_pgsql.c:645 Error executing query:
>> FEHLER:  Relation „sr_sip_user“ already exists
>> 
>> ...
>> 
>> This errors didn’t appear when I was using MySQL ODBC Database connector. As I said, everything works fine but maybe I’m overlooking something and I don’t want to run into some serious troubles.
>> 
>> My Freeswitch version Info:
>> FreeSWITCH Version 1.4.18+git~20150312T185523Z~4eed221b69~64bit (git 4eed221 2015-03-12 18:55:23Z 64bit)
>> 
>> running on CentOS 7.1 with PostgreSQL 9.4
>> 
>> Thanks,
>> Roman
>> _________________________________________________________________________
>> 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
>> 
> 
> _________________________________________________________________________
> 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




Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list