FreePBX 17 new install on Debian 12

FreePBX Installation / Upgrade
1

Hi guys,

I have been going round in circles with ChatGPT.

Debian 12 installed and updated on local machine.
FreePBX added

Asterisk is running.

I cannot get at the GUI. 192.168.0.xxx on the same machine or over the network.

If I use remote desktop from a windows machine 192.168.0.xxx I see a login into asterisk screen. So I presume this is the issue is to do with the routing (eg remote desktop is using the same port as FreePBX ???)

Running blind here so any help appreciated.

2

centos <> Debian

3

Updated title to Debian 12. (Tired…)

4

OK well for starters, I know this is going to sound really irritating, but lots of people have done the “vanilla FreePBX 17 on top of a fresh Debian 12” thing with no problems. So, what I’d like to focus on is what, if any, deviations you MIGHT have made from the “vanilla install instructions”

You said “Debian 12 installed and updated on local machine.
FreePBX added”

So, did you record the steps you took? Starting from “blank hard disk” or “blank virtual machine”

Here’s my set of load instructions on top of ESXi 5.5. Take a look and tell me if you deviated:

  1. Install Debian 12 on ESXi 5.5 using Debian 6 template. Note that console video mouse buttons do not work right all the time from VSphere client.
    [must set at least 2GB ram in case system needs to repair mysql database on boot]
  2. Run through install and add user tedm set password to eatme and root password to eatme use /dev/sda
    for the grub menu install
  3. After setup go to vsphere client and make sure the Shutdown OS works. Shutdown OS and modify settings to disconnect the CDROM on powerup, boot system
  4. Go into main router/dhcp server and obtain client id from a show ip dhcp bindings and then clear the ip address binding and add a static DHCP entry, ssh into VM and reboot it to obtain the new number, clear the arp entry from router, save config
  5. ssh into VM 172.16.1.16 and
    su
    apt-get install aptitude
    aptitude update
    root@FreePBX17:/home/tedm# aptitude full-upgrade

make sure you get 0 output:

No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.

root@FreePBX17:/home/tedm#

cd /tmp

wget https://github.com/FreePBX/sng_freepbx_debian_install/raw/master/sng_freepbx_debian_install.sh -O /tmp/sng_freepbx_debian_install.sh

bash /tmp/sng_freepbx_debian_install.sh

Go to http://172.16.1.16 with a web browser and login

So that’s pretty basic and simple. Obviously if you are NOT installing in a VM then you have a bare metal install - but that’s just clicking through the GUI, same as I did under ESXi

5

Getting closer. Freepbx is running I get the following error

PDOException (42S02)

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘asterisk.freepbx_settings’ doesn’t exist

Which ChatGPT tells me I need:

The error PDOException (42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'asterisk.freepbx_settings' doesn't exist indicates that the asterisk database is missing critical tables, including the freepbx_settings table, which is essential for FreePBX.

It gives me this link to the schema but fails.
sudo wget -O /tmp/core_install.sql https://raw.githubusercontent.com/FreePBX/core/release/17.0/SQL/newinstall.sql

What is the correct link please V17

Cheers

SteveW