Help with installation!

Trying to install oro commerce but there is not clear error. The server was configured according to the instructions running on apache2. The maximum far is to check the server then goes to error 500. The logs of apache2 is attached.
Access denied for user ‘root’@’localhost’ (using password: NO) in /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43\nStack trace:\n#0 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct(‘mysql:host=127….’, ‘root’, NULL, Array)\n#1 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(44): Doctrine\\DBAL\\Driver\\PDOConnection->__construct(‘mysql:host=127….’, ‘root’, NULL, Array)\n#2 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, ‘root’, NULL, Array)\n#3 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\\DBAL\\Connection->connect()\n#4 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\\DBAL\\Connec in /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 103, referer: http://******/install.php

————— – – [13/Sep/2017:03:47:54 -0400] “GET /installer HTTP/1.1” 500 185 “http://********/install.php” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.9 Safari/537.36”

Topic

[msulimaModerator]

Hi,

probably you should set database password for ‘root’ user in ‘parameters.yml’.

parameters.yml

YAML

parameters: database_driver: pdo_mysql database_host: 127.0.0.1 database_port: null database_name: my_database database_user: root database_password: root

1 2 3 4 5 6 7

parameters:     database_driver: pdo_mysql     database_host: 127.0.0.1     database_port: null     database_name: my_database     database_user: root     database_password: root

---

Check our free technical guide ”How to Build a Reliable and Secure Infrastructure for OroCommerce”.

[alexvoronkrdParticipant]

Good afternoon. Even changes to the settings.yml (parameters:
database_driver: pdo_mysql
database_host: localhost
database_port: 3306
db_name: xukxam
database_user: sedmax
database_password: Ghjvbcrebntn1 has not remedied the situation. the apache2 log file says the following:
[Thu Sep 14 03:17:36.629909 2017] [:error] [pid 576] [client *************] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1049] Unknown database ‘b2b_crm_dev’ in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43\nStack trace:\n#0 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct(‘mysql:host=127….’, ‘root’, ‘Ghjvbcrebntn1’, Array)\n#1 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(44): Doctrine\\DBAL\\Driver\\PDOConnection->__construct(‘mysql:host=127….’, ‘root’, ‘Ghjvbcrebntn1’, Array)\n#2 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, ‘root’, ‘Ghjvbcrebntn1’, Array)\n#3 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\\DBAL\\Connection->connect()\n#4 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\\DBAL\\Connection->getDatabasePlatformVersion()\n#5 /var/www/web/xukxam.xyz/vendor/do in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 103

[zboldizsarParticipant]

Hi,

I see you have a ‘db_name’ parameter in you parameters.yml, is that a mistake, or it’s a custom parameter? The correct name is ‘database_name’. Please delete your cache after modifying the file, and make sure you have the database created with name defined in ‘database_name’.

[alexvoronkrdParticipant]

All entered parameters are correct. While OROCRM installed without a problem. But ORO Commerce (during the transition to install.php no error indicates but trying to move on to the next step reports /orocommerce-application/web/installer was not found

[zboldizsarParticipant]

Can you please try to use the terminal installer (following this), and post back the whole results the installer gives you? Thank you!

[alexvoronkrdParticipant]

Tried to install via the console terminal. All over no luck on the command composer install –prefer-dist he gave kiled and that’s all okonchilos

[zboldizsarParticipant]

Can you give me a screenshot/detailed contents of the composer failed command?

[alexvoronkrdParticipant]

doing the installation from the console enter the command: git clone https://github.com/orocommerce/orocommerce-application.git downloads the files everything goes well – then run the command composer install –prefer-dist in the terminal leaves a message (loading composer repositories with package information. Updating dependencies (including require-dev)) after a while getting Killed in what a problem of mind is not preloge.

[zboldizsarParticipant]

Do you have xdebug enabled?

[tijo.joelParticipant]

I had changes the parameters.yml file inside app/config folder. It is not working when I checked the error log it is showing

PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO) in /var/www/html/orocommerce/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43\nStack trace:\n#0 /var/www/html/orocommerce/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct(‘mysql:host=127….’, ‘root’, NULL, Array)\n#1 /var/www/html/orocommerce/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(44): Doctrine\\DBAL\\Driver\\PDOConnection->__construct(‘mysql:host=127….’, ‘root’, NULL, Array)\n#2 /var/www/html/orocommerce/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, ‘root’, NULL, Array)\n#3 /var/www/html/orocommerce/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\\DBAL\\Connection->connect()\n#4 /var/www/html/orocommerce/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\\DBAL\\Connection->getDatabasePlatformVersion()\n#5 /var/www/html/orocomme in /var/www/html/orocommerce/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 103, referer: http://192.168.1.195/orocommerce/web/install.php

Looks like the file that I changes takes no effect.
Then I changed mysql password to null so only I can install the orocommerce.
Can you please help me to install orocommerce with mysql password.?

[Author]

Replies