{"action":"created","issue":{"url":"https://api.github.com/repos/ChurchCRM/CRM/issues/2980","repository_url":"https://api.github.com/repos/ChurchCRM/CRM","labels_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/2980/labels{/name}","comments_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/2980/comments","events_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/2980/events","html_url":"https://github.com/ChurchCRM/CRM/issues/2980","id":248848698,"number":2980,"title":"Setup Failure","user":{"login":"perigeion","id":30845703,"avatar_url":"https://avatars2.githubusercontent.com/u/30845703?v=4","gravatar_id":"","url":"https://api.github.com/users/perigeion","html_url":"https://github.com/perigeion","followers_url":"https://api.github.com/users/perigeion/followers","following_url":"https://api.github.com/users/perigeion/following{/other_user}","gists_url":"https://api.github.com/users/perigeion/gists{/gist_id}","starred_url":"https://api.github.com/users/perigeion/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/perigeion/subscriptions","organizations_url":"https://api.github.com/users/perigeion/orgs","repos_url":"https://api.github.com/users/perigeion/repos","events_url":"https://api.github.com/users/perigeion/events{/privacy}","received_events_url":"https://api.github.com/users/perigeion/received_events","type":"User","site_admin":false},"labels":[{"id":603313619,"url":"https://api.github.com/repos/ChurchCRM/CRM/labels/Installation%20/%20Upgrade","name":"Installation / Upgrade","color":"fef2c0","default":false},{"id":514717576,"url":"https://api.github.com/repos/ChurchCRM/CRM/labels/Platform:%20Shared%20Hosting","name":"Platform: Shared Hosting","color":"d4c5f9","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/ChurchCRM/CRM/milestones/62","html_url":"https://github.com/ChurchCRM/CRM/milestone/62","labels_url":"https://api.github.com/repos/ChurchCRM/CRM/milestones/62/labels","id":2842002,"number":62,"title":"User Support - Inactive","description":"","creator":{"login":"crossan007","id":11679900,"avatar_url":"https://avatars1.githubusercontent.com/u/11679900?v=4","gravatar_id":"","url":"https://api.github.com/users/crossan007","html_url":"https://github.com/crossan007","followers_url":"https://api.github.com/users/crossan007/followers","following_url":"https://api.github.com/users/crossan007/following{/other_user}","gists_url":"https://api.github.com/users/crossan007/gists{/gist_id}","starred_url":"https://api.github.com/users/crossan007/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crossan007/subscriptions","organizations_url":"https://api.github.com/users/crossan007/orgs","repos_url":"https://api.github.com/users/crossan007/repos","events_url":"https://api.github.com/users/crossan007/events{/privacy}","received_events_url":"https://api.github.com/users/crossan007/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":16,"state":"open","created_at":"2017-10-17T01:57:25Z","updated_at":"2018-02-07T19:10:55Z","due_on":null,"closed_at":null},"comments":12,"created_at":"2017-08-08T21:15:08Z","updated_at":"2018-03-03T01:46:58Z","closed_at":"2017-09-17T19:52:11Z","author_association":"NONE","body":"#602 \r\n\r\nI 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...\r\n____________________________________________________________________________________________________________\r\nCould not connect to MySQL on http://spspcoc.perigeion.com as perigeio_dbadmin. Please check the settings in Include/Config.php. MySQL Error:\r\n____________________________________________________________________________________________________________\r\n\r\nspspcoc is a subdomain that contains the CRM directory as per the setup instructions, here is a dump of the Config.php file:\r\n\r\n\r\n$sSERVERNAME = 'http://spspcoc.perigeion.com';\r\n$sUSER = 'perigeio_dbadmin';\r\n$sPASSWORD = 'XXXXXXXXXXXX;\r\n$sDATABASE = 'perigeio_spspcoc';\r\n\r\n// Root path of your ChurchCRM installation ( THIS MUST BE SET CORRECTLY! )\r\n//\r\n// Examples:\r\n// - if you will be accessing from http://www.yourdomain.com/churchcrm then you would enter '/churchcrm' here.\r\n// - if you will be accessing from http://www.yourdomain.com then you would enter '' ... an empty string for a top level installation.\r\n//\r\n// NOTE:\r\n// - the path SHOULD Start end with slash, if not ''.\r\n// - the path SHOULD NOT end with slash.\r\n// - the is case sensitive.\r\n$sRootPath = '';\r\n\r\n// Set $bLockURL=TRUE to enforce https access by specifying exactly\r\n// which URL's your users may use to log into ChurchCRM.\r\n$bLockURL = FALSE;\r\n\r\n// URL[0] is the URL that you prefer most users use when they\r\n// log in.  These are case sensitive.\r\n$URL[0] = 'http://spspcoc.perigeion.com/';\r\n// List as many other URL's as may be needed. Number them sequentially.\r\n//$URL[1] = 'https://www.mychurch.org/churchcrm/';\r\n//$URL[2] = 'https://www.mychurch.org:8080/churchcrm/';\r\n//$URL[3] = 'https://www.mychurch.org/churchcrm/';\r\n//$URL[4] = 'https://ssl.sharedsslserver.com/mychurch.org/churchcrm/';\r\n//$URL[5] = 'https://crm.mychurch.org/';\r\n\r\n// If you are using a non-standard port number be sure to include the\r\n// port number in the URL. See example $URL[2]\r\n\r\n// To enforce https access make sure that \"https\" is specified in all of the\r\n// the allowable URLs.  Safe exceptions are when you are at the local machine\r\n// and using \"localhost\" or \"127.0.0.1\"\r\n\r\n// When using a shared SSL certificate provided by your webhost for https access\r\n// you may need to add the shared SSL server name as well as your host name to\r\n// the URL.  See example $URL[4]\r\n\r\n// Sets which PHP errors are reported see http://php.net/manual/en/errorfunc.constants.php\r\nerror_reporting(E_ERROR);\r\n\r\n//\r\n// SETTINGS END HERE.  DO NOT MODIFY BELOW THIS LINE\r\n//\r\n// Absolute path must be specified since this file is called\r\n// from scripts located in other directories\r\nrequire_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'LoadConfigs.php');\r\n?>\r\n\r\n____________________________________________________________________________________________________________\r\nnot sure if all of the PHP entries above are correct! let me know if I am doing something wrong!"},"comment":{"url":"https://api.github.com/repos/ChurchCRM/CRM/issues/comments/370105662","html_url":"https://github.com/ChurchCRM/CRM/issues/2980#issuecomment-370105662","issue_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/2980","id":370105662,"user":{"login":"lalas7","id":36691506,"avatar_url":"https://avatars2.githubusercontent.com/u/36691506?v=4","gravatar_id":"","url":"https://api.github.com/users/lalas7","html_url":"https://github.com/lalas7","followers_url":"https://api.github.com/users/lalas7/followers","following_url":"https://api.github.com/users/lalas7/following{/other_user}","gists_url":"https://api.github.com/users/lalas7/gists{/gist_id}","starred_url":"https://api.github.com/users/lalas7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lalas7/subscriptions","organizations_url":"https://api.github.com/users/lalas7/orgs","repos_url":"https://api.github.com/users/lalas7/repos","events_url":"https://api.github.com/users/lalas7/events{/privacy}","received_events_url":"https://api.github.com/users/lalas7/received_events","type":"User","site_admin":false},"created_at":"2018-03-03T01:46:57Z","updated_at":"2018-03-03T01:46:57Z","author_association":"NONE","body":"I have gotten the same error and my include.php files says this:\r\n*******************************************************************************\r\n *\r\n *  filename    : Include/Config.php\r\n *  website     : http://www.churchcrm.io\r\n *  description : global configuration\r\n *\r\n ******************************************************************************/\r\n\r\n// Database connection constants\r\n$sSERVERNAME = 'localhost:8890';\r\n$sUSER = 'root';\r\n$sPASSWORD = 'mypassword';\r\n$sDATABASE = 'ourchurchcrm';\r\n\r\n// Root path of your ChurchCRM installation ( THIS MUST BE SET CORRECTLY! )\r\n//\r\n// Examples:\r\n// - if you will be accessing from http://www.yourdomain.com/churchcrm then you would enter '/churchcrm' here.\r\n// - if you will be accessing from http://www.yourdomain.com then you would enter '' ... an empty string for a top level installation.\r\n//\r\n// NOTE:\r\n// - the path SHOULD Start end with slash, if not ''.\r\n// - the path SHOULD NOT end with slash.\r\n// - the is case sensitive.\r\n$sRootPath = '/churchcrm';\r\n\r\nMy database and everything is showing I just get this:\r\nChurchCRM – Setup failure\r\nCould not connect to MySQL on localhost:8890 as root. Please check the settings in Include/Config.php.\r\nMySQL Error:\r\n\r\nwhen I access: http://localhost:8887/churchcrm/index.php# \r\nI am using MAMP. Anyone using this platform?"}}
{"actor":{"display_login":"lalas7"}}