Details about this thread
  • State Not Answered
  • Replies 9 replies
  • Subscribers 295 subscribers
  • Views 4569 views
  • Users 0 members are here
Related content from around SugarClub

Errors installing a local SugarCRM environment

Chris Maggiulli

Background

We are running Sugar 8.3 Enterprise in the cloud.  I am developing a custom module (REST service) and need to get a local environment running because if I upload and run a bad module it takes down the entire cloud server.  I attempted to follow the documentation listed here but there is no option to download from the Customer Resources tab in sugarcrm.com. 

Steps

I have done the following steps

1. Installed Apache 2.4 on Windows 10

2. Installed PHP 7.1

3. Installed MySQL 8.0

4. Installed Elastic Search 6.5.4

4. Downloaded the backup from our sugarcrm production environment

5. Unzipped into %APACHE_HOME%\htdocs\sugar

My directory structure looks like

Directory Structure

I have these modules enabled in my php.ini file.  I have set the following directives to the recommended values as specified in the SugarCRM documentation:

date.timezone
display_errors
max_input
max_execution_time
mbstring.func_overload
memory_limit
post_max_size
session.use_cookies
session.ciookiehttponly
session.cookielifetime
session.gc_maxlifetime
session.use_trans_sid
upload_max_filesize

In C:\ProgramData\MySQL\my.ini I attempted to add the following line

sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

but when I restart my MySQL service it fails with an error.

I made sure that that the htdocs folder and all content underneath have full permissions for all users.  

I downloaded the curl cacert and added the following line to the php.ini file

curl.cainfo=c:\php\cacert.pem

In my httpd.conf file I did the following:

1. I enabled the the mod_rewrite, mod_headers, and mod_expire, php7_module module

2. I added the following options

     a. Options Indexes FollowSymLinks MultiViews

     b. AllowOverride All

     c. Require all granted

   to the following directory tags

     a. <Directory />

     b. <Directory "${SRVROOT}/htdocs">

     c. <Directory "${SRVROOT}/cgi-bin">

     d. <Directory "${SRVROOT}/htdocs/sugar">

3. I added the following two configs

     a. AddType application/x-httpd-php .php
     b. PHPIniDir "C:/php"

Error

When I navigate to http://localhost/sugar/install.php I get right up to the check config page and always get the following error message

Test for .htaccess rewrites failed. This usually means you do not have AllowOverride set up for Sugar directory.

error

I've been struggling with this for several days.  Can someone please provide assistance here?

In the install.log file I get

2019-05-07 13:16:09...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 13:16:12...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 13:16:15...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 13:16:16...Begin System Check Process *************
2019-05-07 13:16:16...XML Parsing Support Found
2019-05-07 13:16:16...MBString Support Found
2019-05-07 13:16:16...ZIP Support Found
2019-05-07 13:16:16.../custom directory and subdirectory check passed
2019-05-07 13:16:17...cache directory and subdirectory check passed
2019-05-07 13:17:23.../module directory and subdirectory check passed
2019-05-07 13:17:23.../upload directory check passed
2019-05-07 13:17:23.../zip check passed
2019-05-07 13:17:23.../BCMATH check passed
2019-05-07 13:17:23...Testing .htaccess redirects
2019-05-07 13:17:23...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 13:17:23...php.ini location found. C:\php\php.ini
2019-05-07 13:17:23...Outputting HTML for System check
2019-05-07 13:17:23...Errors were found *************
2019-05-07 14:15:08...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:15:13...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:15:15...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:15:17...Begin System Check Process *************
2019-05-07 14:15:17...XML Parsing Support Found
2019-05-07 14:15:17...MBString Support Found
2019-05-07 14:15:17...ZIP Support Found
2019-05-07 14:15:17.../custom directory and subdirectory check passed
2019-05-07 14:15:17...cache directory and subdirectory check passed
2019-05-07 14:16:17.../module directory and subdirectory check passed
2019-05-07 14:16:17.../upload directory check passed
2019-05-07 14:16:17.../zip check passed
2019-05-07 14:16:17.../BCMATH check passed
2019-05-07 14:16:17...Testing .htaccess redirects
2019-05-07 14:16:17...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:16:17...php.ini location found. C:\php\php.ini
2019-05-07 14:16:17...Outputting HTML for System check
2019-05-07 14:16:17...Errors were found *************
2019-05-07 14:17:34...Begin System Check Process *************
2019-05-07 14:17:35...XML Parsing Support Found
2019-05-07 14:17:35...MBString Support Found
2019-05-07 14:17:35...ZIP Support Found
2019-05-07 14:17:35.../custom directory and subdirectory check passed
2019-05-07 14:17:35...cache directory and subdirectory check passed
2019-05-07 14:18:32.../module directory and subdirectory check passed
2019-05-07 14:18:32.../upload directory check passed
2019-05-07 14:18:32.../zip check passed
2019-05-07 14:18:32.../BCMATH check passed
2019-05-07 14:18:32...Testing .htaccess redirects
2019-05-07 14:18:32...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:18:32...php.ini location found. C:\php\php.ini
2019-05-07 14:18:32...Outputting HTML for System check
2019-05-07 14:18:32...Errors were found *************
2019-05-07 14:19:38...Begin System Check Process *************
2019-05-07 14:19:38...XML Parsing Support Found
2019-05-07 14:19:38...MBString Support Found
2019-05-07 14:19:38...ZIP Support Found
2019-05-07 14:19:38.../custom directory and subdirectory check passed
2019-05-07 14:19:38...cache directory and subdirectory check passed
2019-05-07 14:20:33.../module directory and subdirectory check passed
2019-05-07 14:20:33.../upload directory check passed
2019-05-07 14:20:33.../zip check passed
2019-05-07 14:20:33.../BCMATH check passed
2019-05-07 14:20:33...Testing .htaccess redirects
2019-05-07 14:20:33...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:20:33...php.ini location found. C:\php\php.ini
2019-05-07 14:20:33...Outputting HTML for System check
2019-05-07 14:20:33...Errors were found *************
2019-05-07 14:59:14...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:59:17...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:59:19...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 14:59:21...Begin System Check Process *************
2019-05-07 14:59:21...XML Parsing Support Found
2019-05-07 14:59:21...MBString Support Found
2019-05-07 14:59:21...ZIP Support Found
2019-05-07 14:59:21.../custom directory and subdirectory check passed
2019-05-07 14:59:21...cache directory and subdirectory check passed
2019-05-07 15:00:32.../module directory and subdirectory check passed
2019-05-07 15:00:32.../upload directory check passed
2019-05-07 15:00:32.../zip check passed
2019-05-07 15:00:32.../BCMATH check passed
2019-05-07 15:00:32...Testing .htaccess redirects
2019-05-07 15:00:32...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 15:00:32...php.ini location found. C:\php\php.ini
2019-05-07 15:00:32...Outputting HTML for System check
2019-05-07 15:00:32...Errors were found *************
2019-05-07 15:44:46...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 15:44:57...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 15:45:00...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 15:45:04...Begin System Check Process *************
2019-05-07 15:45:04...XML Parsing Support Found
2019-05-07 15:45:04...MBString Support Found
2019-05-07 15:45:04...ZIP Support Found
2019-05-07 15:45:04.../custom directory and subdirectory check passed
2019-05-07 15:45:04...cache directory and subdirectory check passed
2019-05-07 15:48:16.../module directory and subdirectory check passed
2019-05-07 15:48:16.../upload directory check passed
2019-05-07 15:48:16.../zip check passed
2019-05-07 15:48:16.../BCMATH check passed
2019-05-07 15:48:16...Testing .htaccess redirects
2019-05-07 15:48:16...installerHook: Could not find custom/install/install_hooks.php
2019-05-07 15:48:16...php.ini location found. C:\php\php.ini
2019-05-07 15:48:16...Outputting HTML for System check
2019-05-07 15:48:16...Errors were found *************

But I cant find any information beyond that

Parents Reply Children
  • 0 in reply to André Lopes

    When I add either Order Allow,Deny and/or Allow from all it wont let me start the server.  In the error.log file for my httpd server I get the following lines:

    PHP Warning: PHP Startup: Unable to load dynamic library 'ext\\php_bcmath.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0
    PHP Warning: PHP Startup: Unable to load dynamic library 'ext\\php_hash.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0
    PHP Warning: PHP Startup: Unable to load dynamic library 'ext\\php_jsmin.dll' - The specified module could not be found.\r\n in Unknown on line 0
    PHP Warning: PHP Startup: Unable to load dynamic library 'ext\\php_json.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0
    [Tue May 07 12:58:46.216207 2019] [mpm_winnt:notice] [pid 19112:tid 576] AH00354: Child: Starting 64 worker threads.
    [Tue May 07 13:00:15.642375 2019] [php7:warn] [pid 19112:tid 1328] [client ::1:60231] PHP Warning: file_get_contents(localhost:80/sugar/itest.txt): failed to open stream: No such file or directory in C:\\Apache24\\htdocs\\sugar\\install\\installSystemCheck.php on line 372, referer: http://localhost/sugar/install.php

    It seems like it is an issue with the script writing to or modifying files in the htdocs folder, but I cant seem to find any logs that really substantiate this.  Is there anything I can turn on here to get more information?  I've been struggling hard with this one as im not use to working on windows.

    Also, based off the install logs i do see it says "Errors were found" but it seems to just randomly stop.  Im wondering if its timing out

  • 0 in reply to André Lopes

    I feel like this is happening because I am trying to create a local environment from a backup I downloaded from our production system.  I modified the config.php file to point to my local db, local elastic search, increase logging, changed the site url, changed the host name, disabled redis, etc but again I dont have an option to download the application from the sugarcrm.com site.  Why is that option not available?