Incorrect User or Password from GUI

[rds-r2d2]

We have changed the admin password to something other than the default but now after a period of time we are getting "Incorrect User or Password" when trying to login via the GUI.  A few times before this we getting logged in then kicked out immediately and I had to reboot the device to fix it. But now nothing seems to work. 

I can still login via the CLI with expedition user. Is there a way I can add an Expedition user or edit the admin account from the CLI?

[dgildelaig · Accepted solution]

Is still the issue persisting?

This may be related to a database access issue, and the reasons could be:

• PHP database access parameters have been modified and are now incorrect (php files within /home/userSpace)
• The OS has been upgraded an libraries for database drivers are now in a non-supported version (this would require recreating an Expedition instance)
• Database is not up and running (the service mysql is down)

[rds-r2d2]

@dgildelaig Thanks again for your help. As you mention it was an issue with mysql being down. But looks like something might be corrupt since our conversion of the origional beta tool from Fusion to ESX. 

To be safe we will probably build a new Expedition and migrate our projects if needed. 

[msober]

I am experiencing the same issue. I can login immediately after rebooting Expedition using the "admin" account. I cannot login using any LDAP accounts or using admin credentials after logging out or waiting to login.

• Which file houses the database paramenters? userDefinitions.php?

• The OS has not been upgraded, still on 16.04.5 LTS. Upgraded to Expedition 1.1.3 yesterday using the update commands.
• The mysql service is running.

[msober]

Found the issue, how would this be resolved?

> service mysql status

Jan 17 15:52:20 Expedition mysqld[1693]: 2019-01-17 15:52:20 140514870733568 [Warning] Aborted connection 106 to db: 'RealTimeUpdates' user: 'root' host: 'localhost' (Got timeout reading communication pac
Jan 17 15:52:20 Expedition mysqld[1693]: 2019-01-17 15:52:20 140515157236480 [Warning] Aborted connection 103 to db: 'pandb' user: 'root' host: 'localhost' (Got timeout reading communication packets)
Jan 17 15:52:20 Expedition mysqld[1693]: 2019-01-17 15:52:20 140514871339776 [Warning] Aborted connection 104 to db: 'pandbRBAC' user: 'root' host: 'localhost' (Got timeout reading communication packets)
Jan 17 15:55:20 Expedition mysqld[1693]: 2019-01-17 15:55:20 140515605535488 [Warning] Aborted connection 2 to db: 'pandb' user: 'root' host: 'localhost' (Got timeout reading communication packets)
Jan 17 15:55:20 Expedition mysqld[1693]: 2019-01-17 15:55:20 140515552967424 [Warning] Aborted connection 3 to db: 'pandbRBAC' user: 'root' host: 'localhost' (Got timeout reading communication packets)
Jan 17 15:55:20 Expedition mysqld[1693]: 2019-01-17 15:55:20 140515552664320 [Warning] Aborted connection 4 to db: 'RealTimeUpdates' user: 'root' host: 'localhost' (Got timeout reading communication packe
Jan 17 15:55:20 Expedition mysqld[1693]: 2019-01-17 15:55:20 140515552361216 [Warning] Aborted connection 5 to db: 'RealTimeUpdates' user: 'root' host: 'localhost' (Got timeout reading communication packe
Jan 17 15:56:51 Expedition mysqld[1693]: 2019-01-17 15:56:51 140515456244480 [Warning] Aborted connection 54 to db: 'pandb' user: 'root' host: 'localhost' (Got timeout reading communication packets)
Jan 17 15:56:51 Expedition mysqld[1693]: 2019-01-17 15:56:51 140515160570624 [Warning] Aborted connection 56 to db: 'RealTimeUpdates' user: 'root' host: 'localhost' (Got timeout reading communication pack
Jan 17 15:56:51 Expedition mysqld[1693]: 2019-01-17 15:56:51 140515160267520 [Warning] Aborted connection 57 to db: 'RealTimeUpdates' user: 'root' host: 'localhost' (Got timeout reading communication pack

Thanks!