AnsweredAssumed Answered

Errors installing a local SugarCRM environment

Question asked by Chris Maggiulli on May 7, 2019
Latest reply on May 8, 2019 by 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

Outcomes