Installer doesn't accept database configuration

[bardolf69]

Summary
I've tried manually configuring the platform and installing via composer. I also tried utilizing the vagrant setup file. The Vagrant file had incompatible versions of php and node but even after fixing those issues I encountered the same problem as doing the manual setup. Regardless of the setting in the parameters.yml file the installer reports that the Database if not configured and refuses to go further.

Steps to reproduce
Install the ORO-CRM community Edition

Actual Result
Will not install

Expected Result
Should install

Details about your environment

• OroCRM version: 5.0.0
• PHP version: 8.1
• Database (MySQL, PostgreSQL) version MySQLcode

Additional information

Installing Oro Application.

Check system requirements
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| Check   | Mandatory requirements                                                                                                                            |
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| OK      | /tmp (sys_get_temp_dir()) directory must be writable                                                                                              |
| OK      | Vendor libraries must be installed                                                                                                                |
| OK      | iconv() must be available                                                                                                                         |
| OK      | pcntl_signal() must be available                                                                                                                  |
| OK      | json_encode() must be available                                                                                                                   |
| OK      | session_start() must be available                                                                                                                 |
| OK      | ctype_alpha() must be available                                                                                                                   |
| OK      | token_get_all() must be available                                                                                                                 |
| OK      | simplexml_import_dom() must be available                                                                                                          |
| OK      | PDO should be installed                                                                                                                           |
| OK      | Configured default timezone "UTC" must be supported by your installation of PHP                                                                   |
| OK      | var/cache directory must be writable                                                                                                              |
| OK      | var/logs directory must be writable                                                                                                               |
| OK      | Maximum supported filename length must be greater or equal 242 characters. Make sure that the cache folder is not inside the encrypted directory. |
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------+
+---------+--------------------------------------------+
| Check   | PHP settings                               |
+---------+--------------------------------------------+
| OK      | memory_limit should be at least 512M       |
| OK      | detect_unicode must be disabled in php.ini |
| OK      | string functions should not be overloaded  |
+---------+--------------------------------------------+
+---------+------------------------------------------------------------------------------+
| Check   | Oro specific requirements                                                    |
+---------+------------------------------------------------------------------------------+
| OK      | PHP version must be at least 8.0 (8.1.3 installed)                           |
| OK      | GD extension must be at least 2.0                                            |
| OK      | cURL extension must be at least 7.0                                          |
| OK      | openssl_encrypt() should be available                                        |
| OK      | intl extension should be available                                           |
| OK      | zip extension should be installed                                            |
| OK      | NodeJS is installed                                                          |
| OK      | NodeJS ">=14 <17" version must be installed.                                 |
| OK      | NPM is installed                                                             |
| ERROR   | Database connection is not configured                                        |
| OK      | public/media directory must be writable                                      |
| OK      | public/bundles directory must be writable                                    |
| OK      | var/data directory must be writable                                          |
| OK      | public/js directory must be writable                                         |
| OK      | config/parameters.yml directory must be writable                             |
| OK      | iconv() must not return the false result on converting string "check string" |
+---------+------------------------------------------------------------------------------+
+---------+------------------------------------------------------------------------------------------------------------------+
| Check   | Optional recommendations                                                                                         |
+---------+------------------------------------------------------------------------------------------------------------------+
| OK      | Current version 66.1 of the ICU library should meet the requirements                                             |
| OK      | SOAP extension should be installed (API calls)                                                                   |
| OK      | Tidy extension should be installed to make sure that any HTML is correctly converted into a text representation. |
| WARNING | Disable Phar extension to reduce the risk of PHP unserialization vulnerability.                                  |
| OK      | IMAP extension should be installed for valid email processing on IMAP sync.                                      |
| OK      | PHP-DOM and PHP-XML modules should be installed                                                                  |
| OK      | mb_strlen() should be available                                                                                  |
| OK      | utf8_decode() should be available                                                                                |
| OK      | filter_var() should be available                                                                                 |
| OK      | posix_isatty() should be available                                                                               |
| OK      | a PHP accelerator should be installed                                                                            |
| OK      | Library `jpegoptim` is installed                                                                                 |
| OK      | Library `pngquant` is installed                                                                                  |
| OK      | xdebug.max_nesting_level should be above 100 in php.ini                                                          |
| OK      | intl.error_level should be 0 in php.ini                                                                          |
| OK      | short_open_tag should be disabled in php.ini                                                                     |
| OK      | magic_quotes_gpc should be disabled in php.ini                                                                   |
| OK      | register_globals should be disabled in php.ini                                                                   |
| OK      | session.auto_start should be disabled in php.ini                                                                 |
| WARNING | To get the latest internationalization data upgrade the ICU system package and the intl PHP extension.           |
+---------+------------------------------------------------------------------------------------------------------------------+
Found 1 not fulfilled requirement
The command terminated with an exit code: 1.

paramters.yml

# This file is auto-generated during the composer install
parameters:
    database_driver: pdo_mysql
    database_host: '%env(ORO_DB_HOST)%'
    database_port: '%env(ORO_DB_PORT)%'
    database_name: '%env(ORO_DB_NAME)%'
    database_user: '%env(ORO_DB_USER)%'
    database_password: '%env(ORO_DB_PASSWORD)%'
    database_server_version: '%env(ORO_DB_VERSION)%'
    database_driver_options: {  }
    mailer_dsn: '%env(ORO_MAILER_DSN)%'
    websocket_bind_address: 0.0.0.0
    websocket_bind_port: 8080
    websocket_frontend_host: '*'
    websocket_frontend_port: 443
    websocket_frontend_path: 'ws'
    websocket_backend_host: '*'
    websocket_backend_port: 8080
    websocket_backend_path: ''
    websocket_backend_transport: tcp
    websocket_backend_ssl_context_options: {  }
    web_backend_prefix: ''
    session_handler: session.handler.native_file
    secret: '%env(ORO_SECRET)%'
    installed: null
    message_queue_transport: dbal
    message_queue_transport_config: null
    deployment_type: null
    liip_imagine.jpegoptim.binary: null
    liip_imagine.pngquant.binary: null
    env(ORO_DB_HOST): 127.0.0.1
    env(ORO_DB_PORT): 3306
    env(ORO_DB_NAME): oro_crm
    env(ORO_DB_USER): ****************
    env(ORO_DB_PASSWORD): *******************
    env(ORO_DB_VERSION): null
    env(ORO_MAILER_DSN): 'native://default'
    env(ORO_SECRET): **********************************

[anyt]

Regardless of the setting in the parameters.yml file the installer reports that the Database if not configured and refuses to go further.

After changes of this file it is required to clear the application cache (by running rm -rf var/cache/*), otherwise, they are not applied.

[TheSquier]

Having same issue. Any solutions?

[dwangove]

Having same issue.
Running composer install returns: In Process.php line 143:
[TypeError]
Symfony\Component\Process\Process::__construct(): Argument #1 ($command) must be of type array, string given, called in /opt/orocrm/
vendor/oro/platform/src/Oro/Bundle/InstallerBundle/Composer/PermissionsHandler.php on line 110

[mbessolov]

@dwangove the error you have is related to a different issue - oroinc/platform#1081
Please use composer version < 2.3.0 until the fix is released.

[dwangove]

Changing to 2.2.12 did remove the error in composer install, but not the database connection error in php oro:install

[nix112691]

Try this '3306' in port instead of plain 3306

[yumthaidelight]

I was able to fix this error, instead of 3306, just leave env(ORO_DB_PORT): null,
It failed later on something else. Is pain is a.. Using Oracle Linux and following their documentation...

[tyuhbh0]

you should re-install orocrm. make sure, all config. has been done before php8.1 bin/console oro:install --env=prod --timeout=2000 command. i had same issue yesterday.