Forums

Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

Forum Replies Created

Viewing 31 replies (of 31 total)
  • Author
    Replies
  • in reply to: PDOException error after install on CentOS 7 #26393

    peeush
    Participant

    Thanks Dmitry; I re-checked the two (parameters.yml, database user permissions) and both are correct. This makes sense too as the install script running on the web/app server was able to connect correctly to the database server, drop the schema and create all required database entities/migrations etc.

    Some information on my setup: My web/app server (IP address: 10.0.0.4) and database server (IP address: 10.0.0.68) are on separate VMs, but par of the same vnet; This is what SHOW GRANTS FOR ‘root’@’10.0.0.%’ returns:
    | GRANT ALL PRIVILEGES ON *.* TO ‘root’@’10.0.0.%’ IDENTIFIED BY PASSWORD ‘<HASH>’ WITH GRANT OPTION |
    Equally, I have verified that port 3306 is open on the database server for connections.

    Below is what my parameters.yml contains:
    database_driver: pdo_mysql
    database_host: 10.0.0.68
    database_port: 3306
    database_name: oro_crm
    database_user: root
    database_password: <PASSEORD>
    mailer_transport: smtp
    mailer_host: 127.0.0.1
    mailer_port: null
    mailer_encryption: null
    mailer_user: null
    mailer_password: null
    websocket_host: 127.0.0.1
    websocket_port: 8080
    session_handler: session.handler.native_file
    locale: en
    secret: ThisTokenIsNotSoSecretChangeIt
    installed: ‘2014-11-14T02:00:29+05:30’

    Below is the full error log:
    2014/11/14 12:17:10 [error] 12449#0: *9 FastCGI sent in stderr: “PHP message: PHP Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000] [2002] Permission denied’ in /usr/share/nginx/html/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
    Stack trace:
    #0 /usr/share/nginx/html/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(40): PDO >__construct(‘mysql:host=10.0…’, ‘root’, ‘<PASSWORD>’, Array)
    #1 /usr/share/nginx/html/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(41): Doctrine\DBAL\Driver\PDOConnection->__construct(‘mysql:host=10.0…’, ‘root’, ‘<PASSWORD>’, Array)
    #2 /usr/share/nginx/html/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(356): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, ‘root’, ‘<PASSWORD>’, Array)
    #3 /usr/share/nginx/html/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(680): Doctrine\DBAL\Connection->connect()#4 /usr/share/nginx/html/orocrm/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php(” while reading response header from upstream, client: nn.nn.nnn.nnn, server: xyz.cloudapp.net, request: “GET / HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php-fpm/php-fpm.sock:”, host: “xyz.cloudapp.net”

    Lastly, when I perform the same setup on a CentOS 6.5 image, all seems to go well…

    Appreciate your help on how to fix it!

Viewing 31 replies (of 31 total)
Back to top

You will be redirected to [title]. Would you like to continue?

Yes No

You will be redirected to [title]. Would you like to continue?

Yes No