OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums Forums OroCRM OroCRM – Installation/Technical Issues or Problems Server with Ubuntu or CentOS or… what?

This topic contains 17 replies, has 3 voices, and was last updated by  mon 7 years, 5 months ago.

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

  • Creator
    Topic
  • #27398

    mon
    Participant

    Hi,

    we are installing ORO CRM in to server with Ubuntu and we are having many problems.

    We are solving the problems at the moment but… my question is: Which Linux distribution is the better?

Viewing 15 replies - 1 through 15 (of 17 total)
  • Author
    Replies
  • #27399

    Mike Kudelya
    Participant

    Many people have been successfully install orocrm on ubuntu. Which kind of problems are you facing?

    #27400

    mon
    Participant

    Hi,

    thanks for your answer.

    The problem we have now:

    we have installed the application and composer. We have reached the screen “System requirements check” (http://orocrm.<domain>/install.php) and we have all points OK.

    However in the log we have an error:

    ———————-log ———————-
    [Thu Oct 20 10:04:56.520272 2016] [fcgid:warn] [pid 32567] [client 83.55.54.90:54083] mod_fcgid: stderr: PHP Fatal error: Uncaught exception ‘Symfony\\Component\\HttpFoundation\\File\\Exception\\FileNotFoundException’ with message ‘The file “The PHP executable could not be found.” does not exist’ in /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/InstallerBundle/CommandExecutor.php:322, referer: http://orocrm.<domain>/install.php
    [Thu Oct 20 10:04:56.520300 2016] [fcgid:warn] [pid 32567] [client 83.55.54.90:54083] mod_fcgid: stderr: Stack trace:, referer: http://orocrm.<domain>/install.php
    [Thu Oct 20 10:04:56.520302 2016] [fcgid:warn] [pid 32567] [client 83.55.54.90:54083] mod_fcgid: stderr: #0 /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/EntityExtendBundle/OroEntityExtendBundle.php(172): Oro\\Bundle\\InstallerBundle\\CommandExecutor::getPhpExecutable(), referer: http://orocrm.<domain>/install.php
    [Thu Oct 20 10:04:56.520305 2016] [fcgid:warn] [pid 32567] [client 83.55.54.90:54083] mod_fcgid: stderr: #1 /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/EntityExtendBundle/OroEntityExtendBundle.php(97): Oro\\Bundle\\EntityExtendBundle\\OroEntityExtendBundle->getPhpExecutable(), referer: http://orocrm.<domain>/install.php
    [Thu Oct 20 10:04:56.520307 2016] [fcgid:warn] [pid 32567] [client 83.55.54.90:54083] mod_fcgid: stderr: #2 /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/EntityExtendBundle/OroEntityExtendBundle.php(84): Oro\\Bundle\\EntityExtendBundle\\OroEntityExtendBundle->checkConfigs(), referer: http://orocrm.<domain>/install.php
    [Thu Oct 20 10:04:56.520310 2016] [fcgid:warn] [pid 32567] [client 83.55.54.90:54083] mod_fcgid: stderr: #3 /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/EntityExtendBundle/OroEntityExtendBundle.php(52): Oro\\Bundle\\ in /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/InstallerBundle/CommandExecutor.php on line 322, referer: http://orocrm.<domain>/install.php
    ———————-/log ———————-

    It seems that we do not have the PHP route, but in our environment variables are:

    ORO_PHP_PATH = / usr / bin / php

    Then, when you click “NEXT”, in the next page http://orocrm.<domain>/app.php/installer it generates an 500 error

    Can you help me?

    Thanks!

    #27401

    Mike Kudelya
    Participant

    Hi,

    How do you set variable ? What version of oro are you using ? Can you show me the error from log file when you got 500 ? I have written approaches how to set variable, through virtual host or ‘export’ program. In any case you can debug function which check php variable and find out what happens.

    #27402

    mon
    Participant

    Hi, Mike, thank you for your help.

    I set the variable from Plesk. I tried the following with erroneous results on all occasions on URL http://orocrm.<domain>/install.php:

    SetEnv ORO_PHP_PATH /opt/plesk/php/5.5/bin/php

    Warning: is_executable(): open_basedir restriction in effect. File(/opt/plesk/php/5.5/bin/php) is not within the allowed path(s): (/var/www/vhosts/<domain>/orocrm/:/tmp/) in /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/InstallerBundle/Process/PhpExecutableFinder.php on line 29

    SetEnv ORO_PHP_PATH /usr/bin/php

    Warning: is_executable(): open_basedir restriction in effect. File(/usr/bin/php) is not within the allowed path(s): (/var/www/vhosts/<domain>/orocrm/:/tmp/) in /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/InstallerBundle/Process/PhpExecutableFinder.php on line 29

    SetEnv ORO_PHP_PATH /usr/bin/php5

    Warning: is_executable(): open_basedir restriction in effect. File(/usr/bin/php5) is not within the allowed path(s): (/var/www/vhosts/<domain>/orocrm/:/tmp/) in /var/www/vhosts/<domain>/orocrm/vendor/oro/platform/src/Oro/Bundle/InstallerBundle/Process/PhpExecutableFinder.php on line 29

    If we do a debug of the function ‘find’, always returns FALSE

    The version of the program that we use I think it’s the last, because we use to download

    wget -c https://oroinc.com/orocrm/downloads/crm-application.tar.gz

    #27403

    Mike Kudelya
    Participant

    Hi

    I think this article may helps you.

    #27404

    mon
    Participant

    Hi, Mike, it works for me. Technical assistance of my hosting provider has fixed the problem.

    But now i have another problem with database. The URL http://orocrm.<domain>/app.php/installer return the next meesage:

    Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[28000] [1045] Access denied for user ‘root’@’127.0.0.1′ (using password: NO)’ in /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43 Stack trace: #0 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct(‘mysql:host=127….’, ‘root’, NULL, Array) #1 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(45): Doctrine\DBAL\Driver\PDOConnection->__construct(‘mysql:host=127….’, ‘root’, NULL, Array) #2 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, ‘root’, NULL, Array) #3 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\DBAL\Connection->connect() #4 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DB in /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 103

    I have customized the user and password database in the file parameters.yml but it seems that does not understand

    can you help me please?

    #27405

    Anton
    Participant

    I am using CentOS with success

    #27406

    Mike Kudelya
    Participant

    Hi,

    As i understood did you successfully install orocrm ? Do you have any question ?

    #27407

    mon
    Participant

    Hi Mike,

    We’re stuck at the same point. When we want to run http://orocrm.<domain>/app.php/installer ,it returns the same message:

    Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[28000] [1045] Access denied for user ‘root’@’127.0.0.1′ (using password: NO)’ in /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43 Stack trace: #0 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct(‘mysql:host=127….’, ‘root’, NULL, Array) #1 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(45): Doctrine\DBAL\Driver\PDOConnection->__construct(‘mysql:host=127….’, ‘root’, NULL, Array) #2 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, ‘root’, NULL, Array) #3 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\DBAL\Connection->connect() #4 /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DB in /var/www/vhosts/<domain>/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 103

    So, we’ve checked out the parameters.yml file and both database_user and database_password are correct ( database_password inside quotes ). Our host provider recommended us to use another database_user instead of root but it doesn’t work it out. Also, we’ve took a look on our config.file and it’s ok. So we’ve run out of ideas. Could you give us a hand, please?

    Thank you in advance.

    #27408

    Mike Kudelya
    Participant

    Hi

    Probably system is trying connect to database, but password is NULL

    I recommend you put orocrm source code without any modifications to web root directory and run http://orocrm.domain. On second “Configuration” step you will enter all necessary parameters (host, port, user, password)

    #27409

    mon
    Participant

    Hi Mike,

    Thanks for your reply.

    We just did as you told, but the problem persists. We put the source code without modifications to a web root directory and when we run http://orocrm.domain/install.php we have all green flags, but we cannot pass to the second step ( Configuration ) because it appears the same error as before:

    Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[28000] [1045] Access denied for user ‘root’@’127.0.0.1′ (using password: NO)’ in /var/www/vhosts/lean2market.com/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43 Stack trace: #0 /var/www/vhosts/lean2market.com/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct(‘mysql:host=127….’, ‘root’, NULL, Array) #1 /var/www/vhosts/lean2market.com/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(45): Doctrine\DBAL\Driver\PDOConnection->__construct(‘mysql:host=127….’, ‘root’, NULL, Array) #2 /var/www/vhosts/lean2market.com/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, ‘root’, NULL, Array) #3 /var/www/vhosts/lean2market.com/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\DBAL\Connection->connect() #4 /var/www/vhosts/lean2market.com/orocrm/vendor/doctrine/dbal/lib/Doctrine/DB in /var/www/vhosts/lean2market.com/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 103

    Do you know what are we doing wrong?

    Thank you in advance.

    #27410

    Mike Kudelya
    Participant

    Hi

    https://oroinc.com/orocrm/downloads/crm-application.tar.gz is very old version of orocrm (1.8.*)

    Try to clone the latest version:

    #27411

    mon
    Participant

    Hi Mike,

    we fix the problem with database. The user ROOT did not have privileges.

    Now, in the step 3 of the installation process, Scheema update fail.

    I provide a screenshot and the oro_install.log, to see if you can help!

    oro_install.log

    screenshot

    #27412

    Mike Kudelya
    Participant

    please tell me did you try install with 1.10.* version ?

    #27413

    mon
    Participant

    Hi Mike,

    thanks for your patience and help.

    ORO CRM is working OK!!

Viewing 15 replies - 1 through 15 (of 17 total)

The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.

Back to top