"An Internal Error Has Occurred. Error: An Internal Error Has Occurred" while installing orangescrum, how to fix this issue?

[Brief-Wishbone9091]

I've done this a lot of times(i've installed 15 different vms just to install orangescrum). https://techtutorial.net/operating-systems/linux-guides/how-to-install-orangescrum-on-centos-7/

This is the latest tutorial that I was following.

I'm getting the above mentioned error when I open up my server's IP address. 192.168.169.150. (I'm trying to install orangescrum in my centos 7 vm).

[root@localhost ~]# tail -f /var/log/httpd/error_log
    [Thu May 11 20:01:21.183253 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant CURRENT_FREE_PLAN already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 86, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.183405 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant CURRENT_EXPIRED_PLAN already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 87, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.183497 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant UPGRADE_PLAN already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 88, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.183590 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant FREE_TRIAL_PERIOD already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 90, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.183695 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant HTTP_FILES already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 172, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.266758 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant CURRENT_FREE_PLAN already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 86, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.266979 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant CURRENT_EXPIRED_PLAN already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 87, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.267159 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant UPGRADE_PLAN already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 88, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.267318 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant FREE_TRIAL_PERIOD already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 90, referer: http://192.168.169.150/
    [Thu May 11 20:01:21.267482 2023] [php7:notice] [pid 9126] [client 192.168.169.1:60892] PHP Notice:  Constant HTTP_FILES already defined in /var/www/html/orangescrum-2.0.11/app/Config/bootstrap.php on line 172, referer: http://192.168.169.150/

This is my error.log located at /var/www/html/orangescrum-2.0.11/app/tmp/logs/error.log
(it's too long, so just sharing the pastebin)

2023-05-11 14:16:21 Warning: Warning (2): Declaration of User::afterSave($create - Pastebin.com

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

pastebin.com

Additionally, please debug the core.php (app\Config\core.php) file by changing the value of >"Configure::write('debug',0);" from 0 to 2, and then share a screenshot of your browser.

This is the error as per /var/www/html/orangescrum-2.0.11/app/Config/core.php

How do I fix this issue? I don't think these notices are a problem as the name implies they're just notices. I can't see any error here. I've already imported the database, so it doesn't make sense. And I get this error when I logged in with my database credentials.

 

[f33dm3bits]

It's better to follow the official documentation if you are going to install software like that.

Open Source Project Management Software Installation Guide | Orangescrum

Orangescrum open source project management software and task management tool written using CakePHP. Check the detailed information and requirements before installation of Orangescrum.

www.orangescrum.com

This probably the problem.

2023-05-11 14:16:21 Error: [MissingTableException] Table users for model User was not found in datasource default.
Exception Attributes: array (
'table' => 'users',
'class' => 'User',
'ds' => 'default',
)

 

[Brief-Wishbone9091]

thank you for the information. Hi @f33dm3bits the official tutorial doesn't work. It stops here:

Unable to install MySQL Server, please try again

 

[f33dm3bits]

Is this for work?

 

[Brief-Wishbone9091]

Is this for work?

though ik you won't continue after this, it's for work. for learning. I'm not sure why your forum is hesitant to help aspiring professionals?

 

[f33dm3bits]

though ik you won't continue after this, it's for work. for learning. I'm not sure why your forum is hesitant to help aspiring professionals?

For one I don't know the software I would have to take the time to set it up myself as well, for two it would cost me time and for three I am hesitant because I don't want to be doing work someone else is getting paid for. As in if I wrote out how I got it to work that person could then just copy what I wrote out without actually having done any work. If I have time later today and I will see how far I can get and help you out.

 

[f33dm3bits]

I got it to work on my test vm Running Rocky Linux 9.1, here are all the steps I did.

1. Install packages: yum install httpd mariadb mariadb-server php unzip
2. Enable services: systemctl enable httpd mariadb php-fpm
3. Setup an apache vhost in /etc/httpd/conf.d/orange.conf
- That looks something like this:

<VirtualHost *:80>
ServerName orange.example.com
ErrorLog /var/log/httpd/orange-error.log
CustomLog /var/log/httpd/orange-access.log combined
Loglevel warn

DocumentRoot /var/ww/html/orangescrum-main

<Directory "/var/www/html/orangescrum-main">
AllowOverride all
Require all granted
</Directory>

- Open http firewall port: firewall-cmd --add-service=http --permanent ; firewalld-cmd --reload

4. Setup php:

• We are going to install the remi repo because more php modules being availabe there: dnf install https://rpms.remirepo.net/enterprise/remi-release-9.rpm
• We are going to use php 7.4: dnf module reset php ; dnf module enable php:remi-7.4 ; dnf module install php:remi-7.4
• We are going to install needed php modules: install php-cli php-common php-dba php-enchant php-fpm php-gd php-imap php-ldap php-mbstring php-mysql php-pdo php-pecl-zip php-pecl-memcache php-pecl-imagick php-tidy php-xml php-opcache php-devel php-pear php-curl

- Change the following settings to 200M in /etc/php.ini
post_max_size = 200M
upload_max_filesize = 200M

- Restart php-fpm: systemctl restart php-fpm

5. Setup Mariadb database and user:

• start mariadb: systemctl start mariadb
• run: mysql_secure_installation and follow the steps to and reset mysql root password when asked.
• login into mysql with root: mysql -u root -p password
• Create: database: create database orangescrum;
• Create user and grant privileges on orangescrum database: GRANT ALL PRIVILEGES ON orangescrum.* TO 'orange'@'localhost' IDENTIFIED BY 'Password1234!';

6. Download orangescrum from github(https://github.com/Orangescrum/orangescrum):

• Click on green "Code" button and download as zip.
• Transfer this file to your server to the location /var/www/html
• Extract it: unzip orangescrum-main.zip

7. Some database and other things left to do:

• Import the sql file under /var/www/html/orange: mysql -u root -p orangescrum < database.sql
• Update the following file to match your database information which you created in the earlier mariadb steps: /var/www/html/orange/app/Config/database.php

It should look something like this at the bottom of that file:

class DATABASE_CONFIG {

    public $default = array(
        'datasource' => 'Database/Mysql',
        'persistent' => false,
        'host' => 'localhost', //ex. localhost
        'login' => 'orange', //root
        'password' => 'Password1234!',
        'database' => 'orangescrum',//orangescrum
        'prefix' => '',
        //'encoding' => 'utf8',
    );

• Change permission of the app/tmp application folder: chmod 0777 -R app/tmp
• Enable the following selinux boolean: setsebool -P httpd_unified on
• Now go to "orange.example.com" or whatever you put for ServerName in your virtualhost.
• The orangescrum webpage should now load, see the screenshot I attached.

I know you were working with CentOS7 but it should work with Rocky Linux 9 like this too. If not I can test it out on CentOS7 as well for you.

 

[Brief-Wishbone9091]

whoa! you're so kind. thank you, I'll try and check out. at least I know it works.

 

[Brief-Wishbone9091]

did you not get any errors while importing database? (like wrong value for default...etc?)
Update: I'm getting the same error I mentioned in my OP. It's not working.

 

[kibasnowpaw]

No problem. I don't need help from such a person. Don't waste your time with me. Thank you and have a nice day.

@Brief-Wishbone9091, we kindly request that you maintain a respectful and understanding tone. While it's our collective goal to assist as much as we can, please remember that we also have our personal lives to manage. Our available time and resources might be limited, and our knowledge isn't always comprehensive.

In order to provide effective help, we often need to conduct our own research and problem-solving, which can be quite time-consuming. This is a factor you should take into account when seeking assistance. A respectful and understanding approach will encourage more people to assist you, as no one appreciates their time being disrespected.

Lastly, I regret to inform you that I lack personal experience with OrangeScrum, and it falls outside my current level of understanding. If I had the necessary knowledge and expertise, I would gladly help you. Nonetheless, I hope you find the assistance you need soon.

 

[Brief-Wishbone9091]

@Brief-Wishbone9091, we kindly request that you maintain a respectful and understanding tone. While it's our collective goal to assist as much as we can, please remember that we also have our personal lives to manage. Our available time and resources might be limited, and our knowledge isn't always comprehensive.

In order to provide effective help, we often need to conduct our own research and problem-solving, which can be quite time-consuming. This is a factor you should take into account when seeking assistance. A respectful and understanding approach will encourage more people to assist you, as no one appreciates their time being disrespected.

Lastly, I regret to inform you that I lack personal experience with OrangeScrum, and it falls outside my current level of understanding. If I had the necessary knowledge and expertise, I would gladly help you. Nonetheless, I hope you find the assistance you need soon.

surely.

 

[f33dm3bits]

did you not get any errors while importing database? (like wrong value for default...etc?)
Update: I'm getting the same error I mentioned in my OP. It's not working.

No I didn't not.
Did you following my instructions and do it using Rocky Linux 9.1?
Where did you download the orangescrum zip/tar from and which version? Share the output of when you import your database? Share the last 30 lines of this file: app/Config/database.php?
Also I don't appreciate you double posting while I took the time to set it up myself and then write out for you of how to get it working. As if I am not helping you fast enough?

 

[Brief-Wishbone9091]

No I didn't not.
Did you following my instructions and do it using Rocky Linux 9.1?

No, I did in centos 7 with modified commands.

Where did you download the orangescrum zip/tar from and which version? Share the output of when you import your database? Share the last 30 lines of this file: app/Config/database.php?

I download orangescrum-main.zip from github. (I've created another server, where I downloaded another orangescrum as well from here: https://github.com/Orangescrum/orangescrum/releases

Also I don't appreciate you double posting while I took the time to set it up myself and then write out for you of how to get it working. As if I am not helping you fast enough?

Sorry for misunderstanding. I got new error that's why make a new post.

class DATABASE_CONFIG {


    public $default = array(
        'datasource' => 'Database/Mysql',
        'persistent' => false,
        'host' => 'localhost', //ex. localhost
        'login' => 'orangescrumuser', //root
        'password' => '\JN.]4;pNCN%TbRg',
        'database' => 'orangescrum',//orangescrum
        'prefix' => '',
        //'encoding' => 'utf8',
    );

 

[f33dm3bits]

No, I did in centos 7 with modified commands.

I download orangescrum-main.zip from github. (I've created another server, where I downloaded another orangescrum as well from here: https://github.com/Orangescrum/orangescrum/releases

Sorry for misunderstanding. I got new error that's why make a new post.

I am currently doing a centos7 install and will post it here for you, which version of orangescrum did you use under releases?

 

[Brief-Wishbone9091]

I am currently doing a centos7 install and will post it here for you, which version of orangescrum did you use under releases?

2.0.11 mainly. I gave a try to the oldest version available as well.

 

[f33dm3bits]

2.0.11 mainly. I gave a try to the oldest version available as well.

I will try that one on centos7 but it doesn't have to be centos7 to work.

 

[f33dm3bits]

I got it to work with CentOS7 but the documentation for orangescrums seems to be outdated. The database error you were getting, this one.

did you not get any errors while importing database? (like wrong value for default...etc?)

I ran into this too with CentOS7. That error is because the database scheme being imported is expecting something in mariadb that isn't in an older version of Mariadb so not even in the ones they recommend: 5.6 and 5.7. I ended up using mariadb 10.5 because I tried using 10.6 and then ran into this issue which has already been reported. Here are all the steps I took to get it working on CentOS7 it should be mostly copy and paste work for you and please don't use php 7.2 because 7.4 works.

OS: CentOS Linux release 7.9.2009 (Core)

1. Install packages: yum install httpd unzip wget
2. Enable services: systemctl enable httpd
3. Setup an apache vhost in /etc/httpd/conf.d/orange.conf
- That looks something like this:

<VirtualHost *:80>
ServerName orange2.example.com
ErrorLog /var/log/httpd/orange-error.log
CustomLog /var/log/httpd/orange-access.log combined
Loglevel warn

DocumentRoot /var/www/html/orangescrum-main

<Directory "/var/www/html/orangescrum-main">
AllowOverride all
Require all granted
</Directory>
</VirtualHost>

- Open http firewall port: firewall-cmd --add-service=http --permanent ; firewall-cmd --reload

3. Setup php(We are going to install php 7.4):

• We are going to install the remi repo because more php modules being availabe there: yum install https://rpms.remirepo.net/enterprise/remi-release-7.rpm
• We are going to install needed php and several modules: yum install php74 php74-php php74-php-cli php74-php-common php74-php-dba php74-php-enchant php74-php-fpm php74-php-gd php74-php-imap php74-php-ldap php74-php-mbstring php74-php-mysql php74-php-pdo php74-php-pecl-zip php74-php-pecl-memcache php74-php-pecl-imagick php74-php-tidy php74-php-xml php74-php-opcache php74-php-devel php74-php-pear php74-php-curl php74-php-intl php74-php-pecl-mcrypt

- Change the following settings to 200M in /etc/opt/remi/php74/php.ini
post_max_size = 200M
upload_max_filesize = 200M

- Enable and start php-fpm: systemctl enable php74-php-fpm.service --now

4. Setup Mariadb database and user:
- Enable official mariadb repo because we need a new mariadb version under Centos7. Create the following file: /etc/yum.repos.d/mariadb.repo
Add the following content:
[mariadb]
name = MariaDB
baseurl = https://rpm.mariadb.org/10.5/centos/$releasever/$basearch
gpgkey= https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

• Install the following mariadb packages: yum install MariaDB-client MariaDB-server
• start and enable mariadb: systemctl enable mariadb --now
• run: mariadb-secure-installation and follow the steps to and reset mysql root password when asked and for the other questions press Y.
• login into mysql with root: mysql -u root -p password
• Create: database: create database orangescrum;
• Create user and grant privileges on orangescrum database: GRANT ALL PRIVILEGES ON orangescrum.* TO 'orange'@'localhost' IDENTIFIED BY 'Password1234!';

5. Download orangescrum from github(https://github.com/Orangescrum/orangescrum/releases): orangescrum-2.0.11.zip

• Click on green "Code" button and download as zip.
• Transfer this file to your server to the location /var/www/html
• Extract it: unzip orangescrum-main.zip
• Give apache ownership of orangescrum-main: chown apache:apache -R /var/www/html/orangescrum-main

6. Still some things left to do.

• Import the sql file under /var/www/html/orangescrum-main: mysql -u root -p orangescrum < database.sql
• Update the following file to match your database information: /var/www/html/orangescrum-main/app/Config/database.php

It should look something like this at the bottom of that file:

class DATABASE_CONFIG {

public $default = array(
'datasource' => 'Database/Mysql',
'persistent' => false,
'host' => 'localhost', //ex. localhost
'login' => 'orange', //root
'password' => 'Password1234!',
'database' => 'orangescrum',//orangescrum
'prefix' => '',
//'encoding' => 'utf8',
);

• Change permission of the app/tmp application folder: chmod 0777 -R app/tmp
• Enable the following selinux boolean: setsebool -P httpd_unified on
• Restart apache to be sure it's running: systemctl restart httpd
• Now go to "orange2.example.com" or whatever you put for ServerName in your VirtualHost.
• The orangescrum webpage should now load, see my attachment.

This took me a while to get working and I have to say it was easier to get working on Rocky Linux 9 and it took me less time as well on Rocky Linux 9. I would advice you to install it on Rocky Linux 9 because CentOS 7 will be end of life within a year and if will save you from having to reinstall it in a year.

 

[Brief-Wishbone9091]

It says wrong database information. What's the login credentials for it? isn't it what you configured while creating database?
I replaced localhost with my ip address, it didn't work either.

database name: orangescrum
host: localhost or ip address
username: orange
password: password1234@!

 

[f33dm3bits]

Try adding the following to /etc/my.cnf.d/server.cnf near the bottom.

[mariadb-10.5]
bind-address=0.0.0.0

Then restart mariadb: systemctl restart mariadb. It should be the database user you created during the database steps.

database name: orangescrum
host: localhost or ip address
username: orange
password: password1234@!

database: orangescrum
host: localhost
username: orange
password: Password1234!

 

[Brief-Wishbone9091]

Try adding the following to /etc/my.cnf.d/server.cnf near the bottom.

[mariadb-10.5]
bind-address=0.0.0.0

Then restart mariadb: systemctl restart mariadb. It should be the database user you created during the database steps.

database: orangescrum
host: localhost
username: orange
password: Password1234!

Did all of this, not happening. Re-installed vm and started from scratch, same issue. Weren't you getting this issue?