Uploaded image for project: 'FreePBX'
  1. FreePBX
  2. FREEPBX-24066

Installing FreePBX using custom MySQL Port get ignored by ./install script

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 16
    • Fix Version/s: None
    • Component/s: Installation
    • Labels:
      None
    • ToDo:
    • Asterisk Version:
      20.2.0

      Description

      Hi,

      trying to install FreePBX using a custom mysql port get ignored (the install script always try the 3306 port):
       

      ./install -n --skip-install --no-ansi --dbhost=127.0.0.1 --dbport=3307 --dbuser=asterisk --dbpass=CHANGEM3 --dbname=asterisk --cdrdbname=asteriskcdrdb --webroot=/data/var/www/html --astetcdir=/data/etc/asterisk --astvarlibdir=/data/var/lib/asterisk --astagidir=/data/var/lib/asterisk/agi-bin --astspooldir=/data/var/spool/asterisk --astrundir=/var/run/asterisk --astlogdir=/data/var/log/asterisk --ampbin=/data/var/lib/asterisk/bin --ampsbin=/data/var/lib/asterisk/sbin --ampcgibin=/data/var/www/cgi-bin --ampplayback=/data/var/lib/asterisk/playback --astmoddir=/usr/lib64/asterisk/modules

       

      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: 20.2.0
      Checking if NodeJS is installed and we can get a version from it...Yes. Determined NodeJS version to be: 10.24.0
      Preliminary checks done. Starting FreePBX Installation
      Checking if this is a new install...Yes (No /etc/freepbx.conf file detected)
      Database installation checking credentials and permissions..Error!

      Invalid Database Permissions. The error was: SQLSTATE[HY000] [2002] Connection refused

       

      Of course, the MariaDB listening port is configured correctly:

      1. nc -v 127.0.0.1 3306
        nc: connect to 127.0.0.1 port 3306 (tcp) failed: Connection refused
      1. nc -v 127.0.0.1 3307
        Connection to 127.0.0.1 3307 port [tcp/opsession-prxy] succeeded!
        5.5.5-10.6.12-MariaDB-1:10.6.12+maria~ubu2004DjSA-Z]Dz��-��\<W~:Ay^MDO>mysql_native_password

       

      Can be related to then missing dbport option here?

      ./amp_conf/htdocs/admin/libraries/extensions.class.php: return "MYSQL(Connect ".$this->connid." ".$this->dbhost." ".$this->dbuser." ".$this->dbpass." ".$this->dbname." ".$this->charset.")";

      ./amp_conf/htdocs/admin/libraries/extensions.class.php: return "MYSQL(Connect ".$this->connid." ".$this->dbhost." ".$this->dbuser." ".$this->dbpass." ".$this->dbname.")";

       

      of course installing with mysql running in default 3306 port works without problems.

       

      Thank you for the support.

      Kind Regards

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jin Ugo Viti
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:

                  NextupJiraPlusStatus

                  Error rendering 'slack.nextup.jira:nextup-jira-plus-status'. Please contact your Jira administrators.