Skip to content

[bug]: FreePBX sets wrong database user host on remote database #180

@Jomosoto

Description

@Jomosoto

FreePBX Version

FreePBX 17

Issue Description

When running the install command with the --dbhost option set to a remote database and not specifying --dbuser or setting it root, a user freepbx@[host] is created, where host is the host specified in the option, and not the host freepbx connects from. The install script then fails, as the host from which freepbx connects to the database doesn't match the host of the user.

Operating Environment

  • Asterisk 21
  • Debian Bookworm

Relevant log output

Assuming you are Database Root
Checking if SELinux is enabled...Its not (good)!
Reading /etc/asterisk/asterisk.conf...Done
Checking if Asterisk is running and we can talk to it as the 'asterisk' user...Yes. Determined Asterisk version to be: 21.6.1
Checking if NodeJS is installed and we can get a version from it...Yes. Determined NodeJS version to be: 18.19.0
Preliminary checks done. Starting FreePBX Installation
Checking if this is a new install...Yes (No /etc/freepbx.conf file detected)
Database Root installation checking credentials and permissions..Connected!

In utility.functions.php line 120:
                                                                                                                                                                                                                      
  SQLSTATE[HY000] [1045] Access denied for user 'freepbxuser'@'172.18.0.3' (using password: YES)::SQLSTATE[HY000] [1045] Access denied for user 'freepbxuser'@'172.18.0.3' (using password: YES)  
                                                                                                                                                                                                                      

In Database.class.php line 143:
                                                                                                  
  SQLSTATE[HY000] [1045] Access denied for user 'freepbxuser'@'172.18.0.3' (using password: YES)  
                                                                                                  

install [--dbengine DBENGINE] [--dbname DBNAME] [--dbhost DBHOST] [--dbport DBPORT] [--cdrdbname CDRDBNAME] [--dbuser DBUSER] [--dbpass DBPASS] [--user USER] [--group GROUP] [--dev-links] [--skip-install] [--webroot WEBROOT] [--astetc
dir ASTETCDIR] [--astmoddir ASTMODDIR] [--astvarlibdir ASTVARLIBDIR] [--astagidir ASTAGIDIR] [--astspooldir ASTSPOOLDIR] [--astrundir ASTRUNDIR] [--astlogdir ASTLOGDIR] [--ampbin AMPBIN] [--ampsbin AMPSBIN] [--ampcgibin AMPCGIBIN] [--
ampplayback AMPPLAYBACK] [-r|--rootdb] [-f|--force]

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions