crm
crm copied to clipboard
Receiving "Malformed parameter "url"." error when running "php bin/console oro:message-queue:consume --env=prod".
Receiving Malformed parameter "url".
error when running php bin/console oro:message-queue:consume --env=prod
. I've tried just about everything including a fresh reinstall - but nothing seems to work... In some other libraries that use parameters.yml files, it seems to boil down to the mySQL connection string needing to be escaped due to special characters being used in mySQL passwords and in secret strings, but escaping those doesn't seem to work either. Any thoughts?
/usr/bin/php8.1 bin/console oro:message-queue:consume --env=prod
2023-01-30 02:09:30 consumer.ERROR: Consuming interrupted by exception. "Malformed parameter "url"." ["exception" => Doctrine\DBAL\Exception { …}] ["processor" => "Oro\Bundle\CronBundle\Async\CommandRunnerProcessor","message_id" => "oro.63d75f75ca0787.57521020","message_body" => ["arguments" => [],"command" => "oro:cron:imap-sync"],"message_properties" => ["oro.message_queue.client.topic_name" => "oro.cron.run_command","oro.message_queue.client.queue_name" => "oro.default","oro-redeliver-count" => 38,"delay" => "10"],"message_headers" => ["content_type" => null,"message_id" => "oro.63d75f75ca0787.57521020","timestamp" => "1675059061","priority" => "2"],"elapsed_time" => "28 ms","memory_usage" => "70.84 MB"]
In DriverManager.php line 344:
Malformed parameter "url".
ORO CRM version: v5.0.0 PHP version: v8.1 Node version: v16.19.0
Config file:
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
tracking_data_folder: '%env(ORO_TRACKING_DATA_FOLDER)%'
env(ORO_DB_HOST): 127.0.0.1
env(ORO_DB_PORT): null
env(ORO_DB_NAME): *****
env(ORO_DB_USER): *****
env(ORO_DB_PASSWORD): "*****"
env(ORO_DB_VERSION): null
env(ORO_MAILER_DSN): 'native: //default'
env(ORO_SECRET): "*****"
env(ORO_TRACKING_DATA_FOLDER): null