Please check you database connection in `app/Config/database.php` or may be some syntax error in you

[Jason Dykstra]

I have been searching and troubleshooting for hours.

I am trying to install this as a test on Windows 7 before putting it on a server in our environment.

I follow the Windows installation documentation to a T (Using xampp).

When I try to go to http://myipaddy/orangescrum-master/ I am getting the error (I have also tried 127.0.0.1):

Please check you database connection in `app/Config/database.php` or may be some syntax error in your code

I tried to google this information and found a few entries.

I made sure that extension=php_pdo_mysql.dll was uncommented in my php.ini file under C:\xampp\php folder

I have recreated the database and user multiple times, also tried just changing the password multiple times.

I have made sure that my database.php under C:\xampp\htdocs\orangescrum-master\app\Config had the correct information by what the install document says.

I also checked my constants.php file for my smtp information.

I went into my.ini and added sql_mode = "" to turn off strict mode.

I am not sure what I am missing here.

Any help would be appreciated.


Time to head to bed, I am working after hours to try and do this and I am tired now. I will check back in the morning.

[Mircea Constantinescu-Dobra]

Hi Jason,

it looks like database is not accessible, either MySQL server does not accept connections, either parameters for accessing the database are wrong. 

Your database.php file located under the app/Config/ should look like :

class DATABASE_CONFIG {

    public $default = array(
        'datasource' => 'Database/Mysql',
        'persistent' => false,
        'host' => 'localhost',   <-- change localhost with hostname or ip addres of your MySQL server only if MySQL server is hosted on another machine
        'login' => 'username',   <-- change with your MySQL username, e.g. root
        'password' => 'password',    <-- change with your MySQL user password, e.g. p4ssw0rd_for_r00t
        'database' => 'orangescrumdatabase',  <-- name of database, it must be created before and loaded with database.sql
        'prefix' => '',  <-- should be completed only if you use this database for multiple applications
        'encoding' => 'utf8',
    );
}

I suggest the following tutorial that I had used to install OrangeScrum CE :
https://hostpresto.com/community/articles/how-to-setup-and-install-orangescrum-on-ubuntu-14-04/

regards,
Mircea.

[Jason Dykstra]

Thank you for the reply. below I have pasted what I have in the database.php file under C:\xampp\htdocs\orangescrum-master\app\Config

I am unable to install this on a linux based system without talking to my director first.

class DATABASE_CONFIG {

    public $default = array(
        'datasource' => 'Database/Mysql',
        'persistent' => false,
        'host' => 'localhost',

        'login' => 'orangescrum',
        'password' => '****************',
        'database' => 'orangescrum',
        'prefix' => '',

[Mircea Constantinescu-Dobra]

As I see, that is default database.php file, and should be modified to reflect your environment.
First in mysql (using phpmyadmin) you should create database orangescrum (or other name for database), and import database.sql
Then in file database.php you should replace username and password with your XAMPP/MySQL username and password.
... Now, it should work.

or, just follow the steps in this tutorial, and it should work.
http://www.orangescrum.org/how-to-install-orangescrum-on-windows-using-xampp

regards,
Mircea.

[Jason Dykstra]

I did not add my last reply to the group. I would like to add that the config file i pasted earlier is not just the default, i was using orangescrum as the user and database and I did not type in the password I just put stars. I have since created another user and gave it access to the orangescrum database and changed the config file. I am still getting the same error.

[Mircea Constantinescu-Dobra]

Hi Jason,

then I suggest to do :
- check the Apache server log
- enable debug mode in Orangescrum (change Configure::write('debug',0); to Configure::write('debug',1); in \app\Config\core.php
- check again the Apache server log
- check Orangescrum log at \app\tmp\logs\

Also, you could write a simple script to test connectivity to the database (see exemple at http://www.w3schools.com/php/php_mysql_connect.asp)

regards,
Mircea

[Sunnmann]

Thank you for all the help so far, I am going to try that when I get back to work tomorrow or later that night.

--
You received this message because you are subscribed to a topic in the Google Groups "Orangescrum Community Support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orangescrum-community-support/Sszrbc_MEmc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orangescrum-communit...@googlegroups.com.
To post to this group, send email to orangescrum-co...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orangescrum-community-support/41df2e0e-7e65-46a1-b62b-82d1e567ee61%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Sunnmann]

When you do the step to import the database in phpMyAdmin:

At this point I have NOT copied the orangescrum-master folder (extracted from zip file) to C:\xampp\htdocs.

So when i do the import, I go to where I have the zip file extracted (In my case another folder on my C drive) and select the database.sql file. I was wondering if I need to be using the whole zip file instead, and if so, how do I get phpMyAdmin to import a large zip file such as orangescrum?

[Jason Dykstra]

here is the error line from the error.log from Apache:

[Fri May 27 14:41:02.135061 2016] [:error] [pid 5160:tid 1660] [client ::1:50213] PHP Fatal error:  Cannot use 'String' as class name as it is reserved in C:\\xampp\\htdocs\\orangescrum-master\\lib\\Cake\\Utility\\String.php on line 25, referer: http://localhost/orangescrum-master/

On Friday, May 27, 2016 at 2:35:14 PM UTC-5, Jason Dykstra wrote:

When you do the step to import the database in phpMyAdmin:

At this point I have NOT copied the orangescrum-master folder (extracted from zip file) to C:\xampp\htdocs.

So when i do the import, I go to where I have the zip file extracted (In my case another folder on my C drive) and select the database.sql file. I was wondering if I need to be using the whole zip file instead, and if so, how do I get phpMyAdmin to import a large zip file such as orangescrum?

On Thu, May 26, 2016 at 6:05 PM, Sunnmann <jason....@gmail.com> wrote:

Thank you for all the help so far, I am going to try that when I get back to work tomorrow or later that night.

On Thu, May 26, 2016 at 3:24 PM, Mircea Constantinescu-Dobra <mircea.d...@gmail.com> wrote:

Hi Jason,

then I suggest to do :
- check the Apache server log
- enable debug mode in Orangescrum (change Configure::write('debug',0); to Configure::write('debug',1); in \app\Config\core.php
- check again the Apache server log
- check Orangescrum log at \app\tmp\logs\

Also, you could write a simple script to test connectivity to the database (see exemple at http://www.w3schools.com/php/php_mysql_connect.asp)

regards,
Mircea

--
You received this message because you are subscribed to a topic in the Google Groups "Orangescrum Community Support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orangescrum-community-support/Sszrbc_MEmc/unsubscribe.

To unsubscribe from this group and all its topics, send an email to orangescrum-community-support+unsub...@googlegroups.com.
To post to this group, send email to orangescrum-community-support@googlegroups.com.

[Sunnmann]

Orangescrum logs:
Stack Trace:
#0 C:\xampp\htdocs\orangescrum-master\lib\Cake\Error\ErrorHandler.php(203): ErrorHandler::handleFatalError(64, 'Cannot use 'Str...', 'C:\\xampp\\htdocs...', 25)
#1 C:\xampp\htdocs\orangescrum-master\lib\Cake\Core\App.php(929): ErrorHandler::handleError(64, 'Cannot use 'Str...', 'C:\\xampp\\htdocs...', 25, Array)
#2 C:\xampp\htdocs\orangescrum-master\lib\Cake\Core\App.php(902): App::_checkFatalError()
#3 [internal function]: App::shutdown()
#4 {main}

I looked this up on Google of course.

It says that Cake 2.8 and above fix this error. How do I update Cake within the orangescrum-master folder? I have downloaded the newest version, but the file structure is not the same.

On Fri, May 27, 2016 at 2:50 PM, Jason Dykstra <jason....@gmail.com> wrote:

here is the error line from the error.log from Apache:

[Fri May 27 14:41:02.135061 2016] [:error] [pid 5160:tid 1660] [client ::1:50213] PHP Fatal error:  Cannot use 'String' as class name as it is reserved in C:\\xampp\\htdocs\\orangescrum-master\\lib\\Cake\\Utility\\String.php on line 25, referer: http://localhost/orangescrum-master/

On Friday, May 27, 2016 at 2:35:14 PM UTC-5, Jason Dykstra wrote:

When you do the step to import the database in phpMyAdmin:

At this point I have NOT copied the orangescrum-master folder (extracted from zip file) to C:\xampp\htdocs.

So when i do the import, I go to where I have the zip file extracted (In my case another folder on my C drive) and select the database.sql file. I was wondering if I need to be using the whole zip file instead, and if so, how do I get phpMyAdmin to import a large zip file such as orangescrum?

On Thu, May 26, 2016 at 6:05 PM, Sunnmann <jason....@gmail.com> wrote:

Thank you for all the help so far, I am going to try that when I get back to work tomorrow or later that night.

On Thu, May 26, 2016 at 3:24 PM, Mircea Constantinescu-Dobra <mircea.d...@gmail.com> wrote:

Hi Jason,

then I suggest to do :
- check the Apache server log
- enable debug mode in Orangescrum (change Configure::write('debug',0); to Configure::write('debug',1); in \app\Config\core.php
- check again the Apache server log
- check Orangescrum log at \app\tmp\logs\

Also, you could write a simple script to test connectivity to the database (see exemple at http://www.w3schools.com/php/php_mysql_connect.asp)

regards,
Mircea

--
You received this message because you are subscribed to a topic in the Google Groups "Orangescrum Community Support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orangescrum-community-support/Sszrbc_MEmc/unsubscribe.

To unsubscribe from this group and all its topics, send an email to orangescrum-communit...@googlegroups.com.
To post to this group, send email to orangescrum-co...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/orangescrum-community-support/41df2e0e-7e65-46a1-b62b-82d1e567ee61%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "Orangescrum Community Support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orangescrum-community-support/Sszrbc_MEmc/unsubscribe.

To unsubscribe from this group and all its topics, send an email to orangescrum-communit...@googlegroups.com.
To post to this group, send email to orangescrum-co...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/orangescrum-community-support/203c2097-590b-457c-9d88-713d6978e6a5%40googlegroups.com.

[Mircea Constantinescu-Dobra]

Please tell me what version of Apache, MySQL and PHP do you use ?
It looks like you're using PHP 7, which can cause the error PHP Fatal error:  Cannot use 'String' as class name as it is reserved

On Friday, May 27, 2016 at 10:50:20 PM UTC+3, Jason Dykstra wrote:

here is the error line from the error.log from Apache:

[Fri May 27 14:41:02.135061 2016] [:error] [pid 5160:tid 1660] [client ::1:50213] PHP Fatal error:  Cannot use 'String' as class name as it is reserved in C:\\xampp\\htdocs\\orangescrum-master\\lib\\Cake\\Utility\\String.php on line 25, referer: http://localhost/orangescrum-master/


On Friday, May 27, 2016 at 2:35:14 PM UTC-5, Jason Dykstra wrote:

When you do the step to import the database in phpMyAdmin:

At this point I have NOT copied the orangescrum-master folder (extracted from zip file) to C:\xampp\htdocs.

So when i do the import, I go to where I have the zip file extracted (In my case another folder on my C drive) and select the database.sql file. I was wondering if I need to be using the whole zip file instead, and if so, how do I get phpMyAdmin to import a large zip file such as orangescrum?

On Thu, May 26, 2016 at 6:05 PM, Sunnmann <jason....@gmail.com> wrote:

Thank you for all the help so far, I am going to try that when I get back to work tomorrow or later that night.

On Thu, May 26, 2016 at 3:24 PM, Mircea Constantinescu-Dobra <mircea.d...@gmail.com> wrote:

Hi Jason,

then I suggest to do :
- check the Apache server log
- enable debug mode in Orangescrum (change Configure::write('debug',0); to Configure::write('debug',1); in \app\Config\core.php
- check again the Apache server log
- check Orangescrum log at \app\tmp\logs\

Also, you could write a simple script to test connectivity to the database (see exemple at http://www.w3schools.com/php/php_mysql_connect.asp)

regards,
Mircea

--
You received this message because you are subscribed to a topic in the Google Groups "Orangescrum Community Support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orangescrum-community-support/Sszrbc_MEmc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orangescrum-community-support+unsub...@googlegroups.com.

To post to this group, send email to orangescrum-co...@googlegroups.com.

[Jason Dykstra]

I am going to try installing XAMPP 5.6 instead of 7.0

[Jason Dykstra]

OK, installing a lower version of XAMPP (5.6) worked!  Thank you for your patients with me.

[Mircea Constantinescu-Dobra]

I'm happy that you solved the problem ...
regards,
Mircea.

[ir...@fortuneoman.com]

Dear,

I have installed in Windows 7 Machine and getting below while browsing.

Whats next and how to access the orange scrum url

[Team Orangescrum]

Hello irfan,

Please follow the all 4 steps perfectly  as seen in the screen shot after that you will reload the page then you will get sign up page.

Best Regards

Team Orangescrum