[Freeswitch-users] Freeswitch Postgres Core

Michael Jerris mike at jerris.com
Mon Dec 28 21:56:09 MSK 2015


I suspect you will see these errors the first time as it is testing to see if the tables exist to create them.  Does the user have permissions to create the schema?

> On Dec 27, 2015, at 10:28 AM, Murugan Pandian <manpower13.cse at gmail.com> wrote:
> 
> Hi,
> 
>      I try to use postgres my core database in freeswitch,But when i try to run freeswitch after changing my switch.conf.xml,Getting following error in console 
> 
> 2015-12-27 15:21:41.131713 [INFO] switch_core_sqldb.c:3381 Opening DB
> 
> 2015-12-27 15:21:41.132636 [DEBUG] switch_pgsql.c:415 Query (delete from channels where hostname='debian-jessie') returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.133062 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "channels" does not exist
> 
> LINE 1: delete from channels where hostname='debian-jessie'
> 
>      2015-12-27 15:21:41.133614 [DEBUG] switch_pgsql.c:415 Query (delete from calls where hostname='debian-jessie') returned PGRES_FATAL_ERROR
> 
> 
> 2015-12-27 15:21:41.133983 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "calls" does not exist
> 
> LINE 1: delete from calls where hostname='debian-jessie'
> 
>                     ^
> 
> 2015-12-27 15:21:41.134455 [DEBUG] switch_pgsql.c:415 Query (delete from tasks where hostname='debian-jessie') returned PGRES_FATAL_ERROR
> 
> 
> 2015-12-27 15:21:41.135202 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "tasks" does not exist
> 
> LINE 1: delete from tasks where hostname='debian-jessie'
> 
>                     ^
> 
> 
> 
> 2015-12-27 15:21:41.135612 [DEBUG] switch_pgsql.c:415 Query (select hostname from aliases) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.135955 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "aliases" does not exist
> 
> LINE 1: select hostname from aliases
> 
>                              ^
> 
> 
> 
> 2015-12-27 15:21:41.136424 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE aliases) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.136764 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "aliases" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.140727 [DEBUG] switch_pgsql.c:415 Query (select hostname from complete) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.141003 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "complete" does not exist
> 
> LINE 1: select hostname from complete
> 
>                              ^
> 
> 
> 
> 2015-12-27 15:21:41.141602 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE complete) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.141952 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "complete" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.145120 [DEBUG] switch_pgsql.c:415 Query (select hostname from nat) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.145371 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "nat" does not exist
> 
> LINE 1: select hostname from nat
> 
>                              ^
> 
> 
> 
> 2015-12-27 15:21:41.145951 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE nat) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.146371 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "nat" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.147824 [DEBUG] switch_pgsql.c:415 Query (delete from registrations where reg_user='') returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.148176 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "registrations" does not exist
> 
> LINE 1: delete from registrations where reg_user=''
> 
>                     ^
> 
> 
> 
> 2015-12-27 15:21:41.148623 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE registrations) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.148962 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "registrations" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.152717 [DEBUG] switch_pgsql.c:415 Query (select hostname from recovery) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.153209 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "recovery" does not exist
> 
> LINE 1: select hostname from recovery
> 
>                              ^
> 
> 
> 
> 2015-12-27 15:21:41.153622 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE recovery) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.153949 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "recovery" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.162491 [DEBUG] switch_pgsql.c:415 Query (create index recovery3 on recovery(runtime_uuid)) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.163004 [DEBUG] switch_pgsql.c:415 Query (select call_uuid, read_bit_rate, sent_callee_name, initial_cid_name, initial_cid_num, initial_ip_addr, initial_dest, initial_dialplan, initial_context from channels) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.163190 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "channels" does not exist
> 
> LINE 1: ...nitial_dest, initial_dialplan, initial_context from channels
> 
>                                                                ^
> 
> 
> 
> 2015-12-27 15:21:41.163558 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE channels) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.163843 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "channels" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.167943 [DEBUG] switch_pgsql.c:415 Query (select call_uuid from calls) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.168897 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "calls" does not exist
> 
> LINE 1: select call_uuid from calls
> 
>                               ^
> 
> 
> 
> 2015-12-27 15:21:41.169869 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE calls) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.170186 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "calls" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.172855 [DEBUG] switch_pgsql.c:415 Query (select * from basic_calls where sent_callee_name='') returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.173239 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "basic_calls" does not exist
> 
> LINE 1: select * from basic_calls where sent_callee_name=''
> 
>                       ^
> 
> 
> 
> 2015-12-27 15:21:41.173682 [DEBUG] switch_pgsql.c:415 Query (DROP VIEW basic_calls) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.174007 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  view "basic_calls" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.178108 [DEBUG] switch_pgsql.c:415 Query (select * from detailed_calls where sent_callee_name='') returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.178625 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "detailed_calls" does not exist
> 
> LINE 1: select * from detailed_calls where sent_callee_name=''
> 
>                       ^
> 
> 
> 
> 2015-12-27 15:21:41.179041 [DEBUG] switch_pgsql.c:415 Query (DROP VIEW detailed_calls) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.179225 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  view "detailed_calls" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.183253 [DEBUG] switch_pgsql.c:415 Query (select ikey from interfaces) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.184367 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "interfaces" does not exist
> 
> LINE 1: select ikey from interfaces
> 
>                          ^
> 
> 
> 
> 2015-12-27 15:21:41.184798 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE interfaces) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.185094 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "interfaces" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.188082 [DEBUG] switch_pgsql.c:415 Query (select task_id, task_desc, task_group, task_runtime, task_sql_manager, hostname from tasks) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.188535 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  relation "tasks" does not exist
> 
> LINE 1: ...k_group, task_runtime, task_sql_manager, hostname from tasks
> 
>                                                                   ^
> 
> 
> 
> 2015-12-27 15:21:41.189027 [DEBUG] switch_pgsql.c:415 Query (DROP TABLE tasks) returned PGRES_FATAL_ERROR
> 
> 2015-12-27 15:21:41.189357 [ERR] switch_pgsql.c:656 Error executing query:
> 
> ERROR:  table "tasks" does not exist
> 
> 
> 
> 2015-12-27 15:21:41.248531 [INFO] switch_core_sqldb.c:1693 CORE Starting SQL thread.
> 
> 
> 
> And its automatically fallback to SQLlite
>  
>  
> _________________________________________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20151228/5e3b7832/attachment-0001.html 


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