Renaming the Database

compumatter

Hello. I feel a little more vulnerable when the world can assume my database and user is named itflow. So I'd like to rename it. However upon renaming the database, creating a new user with correct permissions and changing the config.php file to match I get a white screen and the following message in the console:
TSS: excluded result: false [content-scripts.js:1:59969](moz-extension://1cdf8254-9c98-4dd1-bd53-20a7cab972b3/content-scripts.js "View source in Debugger → moz-extension://1cdf8254-9c98-4dd1-bd53-20a7cab972b3/content-scripts.js:1:59969")
TSS: hosted page injected

Any thoughts on why that would be?

I did clear the cache and tried from a new browser entirely. Definitely not cache.

Follow up. So in testing and continuing to troubleshoot this I finally found I was able to change both the database and the username. However, very strangely indeed if I use anything except the original dynamically generated password during the install, the white screen appears instead of a login screen. If I change it back to the original password, works every time.

What is required to rename the database password and insure itflow respects the change and does not force the original?

wrongecho

Hey @compumatter

I've pulled the below from the manual install guide, perhaps it has a step you're missing.

Log in to the database

sudo mysql -u root

Create a new database for ITFlow

MariaDB> CREATE DATABASE itflow-db-name;
MariaDB> FLUSH PRIVILEGES;

Setup a user for the ITFlow app

MariaDB> CREATE USER 'itflow-usr'@'localhost' IDENTIFIED BY 'supersecurepassword';
MariaDB> GRANT ALL PRIVILEGES on itflow-db-name.* to 'itflow-usr'@'localhost';
exit

If this doesn't help, I'm happy to follow this up on your ticket and do a remote session with you?

compumatter

Thanks for the follow up. I have done these things and still have the same end results.

I have created a video to demonstrate the problem. Everything is installed and running. I have added some clients and assets. I now wish to change the password of the username. Should be a simple matter of adding it to the config.php file and changing it in Mysql / MariaDB. However, it doesn't work. No matter that I've reloaded / flushed privs it continues to only want the original password.

Take a look at this video and let me know your thoughts:

https://www.youtube.com/watch?v=mZT0QkiPQPo

Thanks - Jay

wrongecho

Hi Jay,

Thanks for the video explanation.

To clarify, ITFlow does no database caching or anything. The config.php file is run fresh with each page load.

Can you please confirm the behaviour when the password change command is run in MariaDB (e.g. To ABC_1234) but you don't adjust config.php - so ITFlow itself still uses the original password?

wrongecho

As a follow-up, please also try adjusting the password using the below (when logged into MariaDB as root)?

ALTER USER 'msp-matter'@'localhost' IDENTIFIED BY 'ABC_123';

compumatter

OK, so this is pretty embarrassing. I was missing a semi colon in the config.php file and did not pick it up in the logs. It was there. Very sorry to have wasted your time. You can close this ticket…

wrongecho

compumatter

Hahaha, no problem at all! Glad you managed to figure it out 🙂