Receiving error updating SimpleRisk / Updating Registration
If you're having trouble with registration or updating the SimpleRisk application and see an error indicating that your instance key might be invalid, this FAQ will guide you through the process of clearing your registration information and instance key, as well as generating new ones during registration. Before proceeding, please ensure that your SimpleRisk Healthcheck shows no issues that could hinder the upgrade or registration process.
To begin, we need to access the MySQL console. If you're unsure how to do this, don't worry; I've outlined a few simple steps for you below. These instructions are designed for users on Ubuntu Linux or similar operating systems.
1) Open your terminal and type `cat /var/www/simplerisk/includes/config.php`. This command will display the configuration settings on your terminal screen. Keep this information handy, as you will need the value for "DB_PASSWORD" in the next step.
2) Next, enter `mysql -u simplerisk -p` in the terminal. You will be prompted to enter the password you just retrieved. If you encounter any difficulties logging in, double-check the "DB_USERNAME" field in the config.php file to ensure you are using the correct username for SimpleRisk.
3) After successfully entering the MySQL console, type `use simplerisk` or replace "simplerisk" with the value found in the "DB_DATABASE" field to select the appropriate SimpleRisk database.
4) To reset your registration status and remove any registration information stored in the system, run the following commands:
DELETE FROM settings WHERE name='instance_id';
UPDATE settings SET value=0 WHERE name='registration_registered';
DELETE FROM settings WHERE name='services_api_key';
DELETE FROM settings WHERE name='registration_name';
DELETE FROM settings WHERE name='registration_fname';
DELETE FROM settings WHERE name='registration_lname';
DELETE FROM settings WHERE name='registration_company';
DELETE FROM settings WHERE name='registration_title';
DELETE FROM settings WHERE name='registration_phone';
DELETE FROM settings WHERE name='registration_email';
5) Once you've entered these MySQL commands, you can log in to SimpleRisk again. Navigate to “Configure” at the top of the page and then select “Register & Upgrade” from the left menu. You should no longer see any registration information. After filling out the required fields, you should be able to register the instance successfully. Once you’ve completed this process, updates should function as expected.