Setting up churchcrm but stuck

[aglow76]

I have been trying to install churchcrm off and on now for several months & I keep running in to the problem when i go to localhost/churchcrm initally it showed
"ChurchCRM – Setup failure
Could not connect to MySQL on churchcrm as churchcrm. Please check the settings in Include/Config.php.
MySQL Error:"

But now I can get to the login screen but i won't login....
I am trying to get this up and running on a local machine & at this time i won't have access available to outside. I don't have the ability currently to do this so I am running it locally.

here is my config.php info

Any help or pointing in the right direction would be extremely helpful........ What could be causing me to not be able to login .... i've used my user name churchcrm & the password i set up

[crossan007]

on new installs, the default un/pw is admin/changeme

I'm wondering if you're mistaking the database password you set up for the application password (which you, presumably, have not yet set up)/

[aglow76]

I just tried that and got a not found.'
The requested url /CheckVersion.php was not found on this server
Apache/2.4.18 (Ubuntu) Server at localhost Port 80

How would I have set up the application password?

Config.txt

If I can get this up and running it will make me extremely happy... Thanks for your assistance

[crossan007]

Check your sRootPath variable in config - it's blank.

If you have the app installed in the root of tour domain, this is OK

If the app is in a subfolder, u need to put the subfolder in this setting

[aglow76]

I am still having issues with this & has stumped me. Your correct the sRootPath is blank in the config...
I have is set up on a local computer using Ubuntu and its located in /var/www/html/churchcrm. this is where it should be when doing it locally on my Ubuntu server is that right? I also have in this html folder churchinfo (I found this program first & wanted to try it as well, but I feel like churchcrm will be more of what I am needing).

after entering the default username & password I still get
"not found.'
The requested url /CheckVersion.php was not found on this server
Apache/2.4.18 (Ubuntu) Server at localhost Port 80".

I attached in my previous message my config file. this has me stumped

[crossan007]

Is this still an issue?

[aglow76]

Yes it is. I am not normally one to give up on figuring out how to do things like this but at the moment I've gotten to the point of putting it on the back burner /giving up.

As i said in my last message

after entering the default username & password I still get
"not found.'
The requested url /CheckVersion.php was not found on this server
Apache/2.4.18 (Ubuntu) Server at localhost Port 80".

Any thoughts you can give me on this to get this up and running.
I wish it was easy to get this running as it was to get churchinfo up.

[crossan007]

Your correct the sRootPath is blank in the config...

The only time sRootPath should be blank is if the application is literally in the DocumentRoot of your Apache's instance

have is set up on a local computer using Ubuntu and its located in /var/www/html/churchcrm.

This likely means that your Apache Server's document root is /var/www/html, and any files inside of /churchcrm will require the inclusion of "churchcrm" in the HTTP GET request's path.

The requested url /CheckVersion.php was not found on this server

this would make sense if CheckVersion.php was in /var/www/html/churchcrm, because your Apache instance is looking in /var/www/html/.

[crossan007]

@aglow76 Did you have any success with updating the root path in your config?

[aglow76]

@crossan007 Not yet no. I've been dealing with health issues I plan to work on this next week & will let you know how it goes. Thanks for checking in with me.

[andrep0350]

I know you are doing the church universal a sacrificial service by providing us with a much needed piece of software. I know your software works!! I used your demo site and want to use it. However, getting it onto a server of my own - not possible. I spent the last day attempting every trick in the book trying to install your software, either directly onto multiple servers with different versions of the software or a clean Ubuntu 16.04 LTS server with docker. With 20 years experience in software development and testing there are serious issues with installing this application. In my opinion the installation documentation is missing some things.

The docker instructions when followed have the webserver unable to connect to mysql database (yes I checked all the passwords and no I'm not confused between a mysql root, dbuser and admin passwords).

The manual instructions get much further, but I end up with an ajax error on the Group listing page. Bump! I even took a datadump (through the backup functionality) from your demo site and used that to see if it was related to an empty dataset - no avail! Its not that.

I suggest you create yourself a brand new server (VirtualBox can help) and follow the two sets of instructions from scratch and you will find it fails to work like the demo.

Please persevere! You've put in huge effort and its a shame we can't use it at all.

If you need technical info from me let me know.

[DawoudIO]

@andrep0350 Happy to help you can you start a new issue and list the issues you are facing. I just setup a new system last night for a friend and had no issues...

let us work other and see where you are stuck ... please chat with us on https://gitter.im/ChurchCRM/CRM

[aglow76]

@crossan007 Ok I have tried some but still am stuck. I need to ask what may seem like a dumb question but I'm not sure what you mean when you say

This likely means that your Apache Server's document root is /var/www/html, and any files inside of /churchcrm will require the inclusion of "churchcrm" in the HTTP GET request's path.

what do you mean by it "will require the inclusion of "churchcrm" in the HTTP GET request's path. Can you explain what you mean by this and how do i go about including it.

also am I reading things correctly that the sRootPath shouldn't be blank but /var/www/html/churchcrm because that is where the CheckVersion.php is located?

[crossan007]

@aglow76:

Assuming your ChurchCRM is unzipped at /var/www/public/churchcrm:

If your apache config looks like this:

<VirtualHost *:80>
        ServerAdmin webmaster@localhost
        ServerName churchcrm.local
        ServerAlias www.churchcrm.local
        DocumentRoot /var/www/public
        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

then you would need to access the application inside of the subdirectory: i.e. http://churchcrm.local/churchcrm. This configuration would require sRootPath ="/churchcrm"

However, if your apache config looks like this:

<VirtualHost *:80>
        ServerAdmin webmaster@localhost
        ServerName churchcrm.local
        ServerAlias www.churchcrm.local
        DocumentRoot /var/www/public/churchcrm
        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

Note that /churchcrm is now included in the apache's DocumentRoot config - this means that the url of http://churchcrm.local would launch the application directly. This configuration would not require an sRootPath value

In short - sRootPath needs to include the sub path of the ChurchCRM application from the perspective of the web server's DocumentRoot.

[DawoudIO]

see https://github.com/ChurchCRM/CRM/wiki/FAQs and please reopen if you still have the issue