Freeswitch Postgres Core
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
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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (2)
-
Michael Jerris
-
Murugan Pandian