Web GUI Issues after migrating to new server

Status
Not open for further replies.

alexoos

New Member
Apr 10, 2019
17
0
1
36
Hello!

We migrated from a Debian 9 server to Debian 12. We started with a fresh 12 install and used the install script to setup a fresh copy of FusionPBX. All was working perfectly.

We followed the restore process and transferred all the data/configs/DBs from 9 to 12.

The server did not work right away. We had to install PHP7.1-FPM and enable the older version on Nginx. Then we performed an upgrade to the master branch, reverted back to PHP8.1-FPM and we were able to login to the Web UI.

FreeSwitch is working perfectly. The system is making/receiving calls perfectly.

I know performing the upgrade process through the web, you're supposed to do 1 step at a time:

1. I execute step 1 and it confirms I am up to date
2. I execute step 2, I get a white screen, I refresh the page and it shows the schema is also good
3. I execute step 3, and I just get a white screen

There are no errors in the nginx error log. Inside the postgres log I see:


postgres@fusionpbx ERROR: invalid input syntax for type uuid: " " at character 104

postgres@fusionpbx STATEMENT: update "v_domains" set "domain_uuid" = '328c16eb-acad-4501-9e1e-3151a52a3847' , "domain_parent_uuid" = ' ' , "domain_name" = 'customera.XYZ.com' , "domain_enabled" = ' t' , "domain_description" = 'Company A' , "insert_date" = '2023-02-15 19:56:02.746601+00' , "insert_user" = '9204814b-9ff7-42eb-bd5b-df54e1ec32e1' , "update_date" = '2024-03-04 18:37:16.31125+00' , "update_user" = '9204814b-9ff7-42eb-bd5b-df54e1ec32e1' where "domain_uuid" = '328c16eb-acad-4501-9e1e-3151a52a3847'


I also noticed if i launch fs_cli and try to run reloadacl - I get the error "[WARNING] switch_core.c:1644 Cannot locate domain"

Here are some photos of what the web UI looks like.

Any help would be greatly appreciated!
 

Attachments

  • Screenshot 2024-03-21 at 11.49.11 AM.png
    Screenshot 2024-03-21 at 11.49.11 AM.png
    209.2 KB · Views: 11
  • Screenshot 2024-03-21 at 11.49.58 AM.png
    Screenshot 2024-03-21 at 11.49.58 AM.png
    265.5 KB · Views: 11

Neyamt

Member
Nov 12, 2021
52
5
8
29
Please follow this video but only use some steps:


From the Video:

1. Export from the old server and Import the database to the new server.
2. Do the voicemail, voice records section.

Other steps:
cd /var/www/fusionpbx
php /var/www/fusionpbx/core/upgrade/upgrade.php # repeat this command two to three times


if you have some custom scripts for the freeswitch, only copy your scripts in freeswitch script folder and fix the permission correctly using cli commands accordingly.

Back to the GUI:
*Upgrade Database with advanced -> upgrade schema
*Update permissions
*Update the menu
*Logout and back in


I have upgraded using these steps from 4.4 to 5.0 and to 5.1 multiple servers in last 6 months. its stable and without any issues.
 
Last edited:
Status
Not open for further replies.