Setup Failure

[perigeion]

#602

I am trying to setup the Church CRM utilizing the MySQL database on BLUEHOST which is our hosting provider, they asked us to get back to you since they tested the environment and verified the settings are good but we keep getting the error below whenever we are trying to continue the setup...

---

Could not connect to MySQL on http://spspcoc.perigeion.com as perigeio_dbadmin. Please check the settings in Include/Config.php. MySQL Error:

---

spspcoc is a subdomain that contains the CRM directory as per the setup instructions, here is a dump of the Config.php file:

$sSERVERNAME = 'http://spspcoc.perigeion.com';
$sUSER = 'perigeio_dbadmin';
$sPASSWORD = 'XXXXXXXXXXXX;
$sDATABASE = 'perigeio_spspcoc';

// Root path of your ChurchCRM installation ( THIS MUST BE SET CORRECTLY! )
//
// Examples:
// - if you will be accessing from http://www.yourdomain.com/churchcrm then you would enter '/churchcrm' here.
// - if you will be accessing from http://www.yourdomain.com then you would enter '' ... an empty string for a top level installation.
//
// NOTE:
// - the path SHOULD Start end with slash, if not ''.
// - the path SHOULD NOT end with slash.
// - the is case sensitive.
$sRootPath = '';

// Set $bLockURL=TRUE to enforce https access by specifying exactly
// which URL's your users may use to log into ChurchCRM.
$bLockURL = FALSE;

// URL[0] is the URL that you prefer most users use when they
// log in. These are case sensitive.
$URL[0] = 'http://spspcoc.perigeion.com/';
// List as many other URL's as may be needed. Number them sequentially.
//$URL[1] = 'https://www.mychurch.org/churchcrm/';
//$URL[2] = 'https://www.mychurch.org:8080/churchcrm/';
//$URL[3] = 'https://www.mychurch.org/churchcrm/';
//$URL[4] = 'https://ssl.sharedsslserver.com/mychurch.org/churchcrm/';
//$URL[5] = 'https://crm.mychurch.org/';

// If you are using a non-standard port number be sure to include the
// port number in the URL. See example $URL[2]

// To enforce https access make sure that "https" is specified in all of the
// the allowable URLs. Safe exceptions are when you are at the local machine
// and using "localhost" or "127.0.0.1"

// When using a shared SSL certificate provided by your webhost for https access
// you may need to add the shared SSL server name as well as your host name to
// the URL. See example $URL[4]

// Sets which PHP errors are reported see http://php.net/manual/en/errorfunc.constants.php
error_reporting(E_ERROR);

//
// SETTINGS END HERE. DO NOT MODIFY BELOW THIS LINE
//
// Absolute path must be specified since this file is called
// from scripts located in other directories
require_once(dirname(FILE) . DIRECTORY_SEPARATOR . 'LoadConfigs.php');
?>

---

not sure if all of the PHP entries above are correct! let me know if I am doing something wrong!

[perigeion]

[crossan007]

Does this mean you fixed it? What was the problem?

[perigeion]

No, I just updated the ticket with a screenshot...

…

On 2017-08-08 15:54, Charles wrote: Does this mean you fixed it? What was the problem? -- You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub [1], or mute the thread [2]. * Links: ------ [1] #2980 (comment) [2] https://github.com/notifications/unsubscribe-auth/AdarB7csQESAWMve_WfU5V-5Ys64vvF_ks5sWNkTgaJpZM4OxTZJ

[DawoudIO]

Please have sSERVERNAME without the http part

sSERVERNAME = 'spspcoc.perigeion.com'

[perigeion]

Got this error after removing the server http:// Not Found The requested URL /login was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache Server at spspcoc.perigeion.com Port 80

…

On 2017-08-08 16:36, George Dawoud wrote: Please have sSERVERNAME without the http part 'sSERVERNAME = 'spspcoc.perigeion.com'' -- You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub [1], or mute the thread [2]. * Links: ------ [1] #2980 (comment) [2] https://github.com/notifications/unsubscribe-auth/AdarB_a0kwO1GaIJ0vju2lqHQUrdHPNCks5sWOLhgaJpZM4OxTZJ

[perigeion]

George, Do you guys provide remote support? If so then please let me know your fees. Let me know if it is possible for you or anyone on your team to do a quick remote session in order to get this CRM up and running. Regards, Sam From: George Dawoud [mailto:notifications@github.com] Sent: Tuesday, August 08, 2017 3:36 PM To: ChurchCRM/CRM Cc: perigeion; State change Subject: Re: [ChurchCRM/CRM] Setup Failure (#2980) Please have sSERVERNAME without the http part 'sSERVERNAME = 'spspcoc.perigeion.com'' — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#2980 (comment)> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AdarB_a0kwO1GaIJ0vju2lqHQUrdHPNCks5sWOLhgaJpZM4OxTZJ> . <https://github.com/notifications/beacon/AdarB5lxCE08aIktvt8IKB02ZcBEkrJ_ks5sWOLhgaJpZM4OxTZJ.gif>

[crossan007]

@perigeion I just attempted to access your URL - it appears you have not actually updated your config file to remove http:// in your $sSERVERNAME variable.

'sSERVERNAME = 'spspcoc.perigeion.com''

[perigeion]

When I removed the ‘http://’ in the $sSERVERNAME variable I get this error: Not Found The requested URL /login was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache Server at spspcoc.perigeion.com Port 80 From: Charles [mailto:notifications@github.com] Sent: Friday, August 11, 2017 9:16 AM To: ChurchCRM/CRM Cc: perigeion; Mention Subject: Re: [ChurchCRM/CRM] Setup Failure (#2980) @perigeion <https://github.com/perigeion> I just attempted to access your URL - it appears you have not actually updated your config file to remove http:// in your $sSERVERNAME variable. 'sSERVERNAME = 'spspcoc.perigeion.com'' — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2980 (comment)> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AdarB9AJjMoYTrikbLaj4EoFzW6e1yjuks5sXH5QgaJpZM4OxTZJ> . <https://github.com/notifications/beacon/AdarB4RucWsCrlYTEQNzc8BvwXtIgUjSks5sXH5QgaJpZM4OxTZJ.gif>

[crossan007]

that's better than a failure :-)

since you're getting 404 on /login, please try typing in /Login.php (not the case and file extension)

[perigeion]

Okay, now I got to the login screen, it is asking for username/password but nothing has been setup that I can use! From: Charles [mailto:notifications@github.com] Sent: Friday, August 18, 2017 1:35 PM To: ChurchCRM/CRM Cc: perigeion; Mention Subject: Re: [ChurchCRM/CRM] Setup Failure (#2980) that's better than a failure :-) since you're getting 404 on /login, please try typing in /Login.php (not the case and file extension) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2980 (comment)> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AdarByJGwMb2PYUXyIvGI9hpAl1bFCioks5sZfVrgaJpZM4OxTZJ> . <https://github.com/notifications/beacon/AdarBzLxMfnYT3kHW4XSWCzkA-Ly3vrnks5sZfVrgaJpZM4OxTZJ.gif>

[perigeion]

What is the default system ADMINISTRATOR password to login into the system in order to start the configuration process? From: Charles [mailto:notifications@github.com] Sent: Friday, August 18, 2017 1:35 PM To: ChurchCRM/CRM Cc: perigeion; Mention Subject: Re: [ChurchCRM/CRM] Setup Failure (#2980) that's better than a failure :-) since you're getting 404 on /login, please try typing in /Login.php (not the case and file extension) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2980 (comment)> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AdarByJGwMb2PYUXyIvGI9hpAl1bFCioks5sZfVrgaJpZM4OxTZJ> . <https://github.com/notifications/beacon/AdarBzLxMfnYT3kHW4XSWCzkA-Ly3vrnks5sZfVrgaJpZM4OxTZJ.gif>

[perigeion]

Found it! System configured and we are up and running! Thank you all for your sincere efforts, God bless you+ From: Charles [mailto:notifications@github.com] Sent: Friday, August 18, 2017 1:35 PM To: ChurchCRM/CRM Cc: perigeion; Mention Subject: Re: [ChurchCRM/CRM] Setup Failure (#2980) that's better than a failure :-) since you're getting 404 on /login, please try typing in /Login.php (not the case and file extension) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2980 (comment)> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AdarByJGwMb2PYUXyIvGI9hpAl1bFCioks5sZfVrgaJpZM4OxTZJ> . <https://github.com/notifications/beacon/AdarBzLxMfnYT3kHW4XSWCzkA-Ly3vrnks5sZfVrgaJpZM4OxTZJ.gif>

[lalas7]

I have gotten the same error and my include.php files says this:

---

• filename : Include/Config.php
• website : http://www.churchcrm.io
• description : global configuration

******************************************************************************/

// Database connection constants
$sSERVERNAME = 'localhost:8890';
$sUSER = 'root';
$sPASSWORD = 'mypassword';
$sDATABASE = 'ourchurchcrm';

// Root path of your ChurchCRM installation ( THIS MUST BE SET CORRECTLY! )
//
// Examples:
// - if you will be accessing from http://www.yourdomain.com/churchcrm then you would enter '/churchcrm' here.
// - if you will be accessing from http://www.yourdomain.com then you would enter '' ... an empty string for a top level installation.
//
// NOTE:
// - the path SHOULD Start end with slash, if not ''.
// - the path SHOULD NOT end with slash.
// - the is case sensitive.
$sRootPath = '/churchcrm';

My database and everything is showing I just get this:
ChurchCRM – Setup failure
Could not connect to MySQL on localhost:8890 as root. Please check the settings in Include/Config.php.
MySQL Error:

when I access: http://localhost:8887/churchcrm/index.php#
I am using MAMP. Anyone using this platform?