Unable to create relations in both databases freeswitch and fusionpbx. ERROR: relation "v_domains" does not exist while building fusionpbx.

Status
Not open for further replies.

Anurag

New Member
Aug 19, 2021
1
0
1
26
System Configurations:

OS : Debian 10, Postgresql-bdr 9.4 installed , Extension and BDR group created, Data syncing correctly.(checked it, by manually creating database "test" and syncing tables between them). Before installing FusionPBX , I installed postgresql-bdr-9.4 and created Databases (user=postgres)"fusionpbx" & "freeswitch" and joined them using bdr.create and join() commands which happened successfully. After doing that i used the following command to clone fusionpbx installation directory(below).

# git clone https://github.com/fusionpbx/fusionpbx-install.sh.git

-> changed config.sh script and added:
database_username=fusionpbx
database_password=secretpass

->changed postgresql.sh script and commented out everything as i have done installing and creation of databases manually at the beginning.

->inside finish.sh script, i commented: #if [ .$database_password = .'random' ]; then fi ......
and added database_password=secretpass
same as written inside config.sh file.

-> after doing this i ran:
# cd /usr/src/fusionpbx-install.sh/debian
# ./install.sh

At the end of the installation, i get the following error :

ERROR:
relation "v_domains" does not exist
LINE 1: insert into v_domains (domain_uuid, domain_name, domain_enab..
^
PHP Fatal error: Uncaught PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "v_default_settings" does not exist
LINE 1: select * from v_default_settings
^ in /var/www/fusionpbx/resources/classes/domains.php:474
 

Attachments

  • problem.txt.txt
    7.1 KB · Views: 14
Status
Not open for further replies.