topic Re: Incorrect Username or Password in Expedition Discussions

Incorrect Username or Password

TerryDes — Mon, 16 May 2022 16:53:08 GMT

Hello all. I have just installed Expedition but am unable to log in. I get the "Incorrect Username or Password" error.

I have run php /var/www/html/OS/startup/restore/restoreAdmin.php and got the expected reply:

✓ Connected successfully to the database
✓ Admin user found
✓ Admin password restored to: 'paloalto'

Still I cannot log in. Any suggestions? Thanks in advance.

Terry

Re: Incorrect Username or Password

lychiang — Mon, 16 May 2022 17:01:59 GMT

Hi @TerryDes ,

Couple things you can check:.

1. Make sure you HD has enough space , if there is no space left in / folder , it will prevent you to login.

2. Follow the solution in this article to re-install Expedition: https://live.paloaltonetworks.com/t5/expedition-discussions/incorrect-user-or-password-when-logging-in-php-connection/m-p/333444#M2676

Re: Incorrect Username or Password

TerryDes — Mon, 16 May 2022 17:16:04 GMT

We have enough space, and tried the second suggestion and it still does not work.

Re: Incorrect Username or Password

lychiang — Mon, 16 May 2022 17:20:39 GMT

Please follow the steps below to troubleshoot, after each of the steps , try to login to GUI , if you are able to login , you do not need to continue the remaining steps.

1. Delete the cookies on your browser , and refresh the browser

2. login to CLI to verify mysql service is up and running by issue below command:

sudo service mysql status

You should see mysql service is "active(running) , if not , trying to restart the mysql by issue below command:

sudo service mysql restart

If you encounter an error, pelase follow the instructions to view more details on why mysql is not started.

3. Follow the below article to remove tc.log:

https://live.paloaltonetworks.com/t5/expedition-discussions/incorrect-user-or-password-when-logging-in-php-connection/m-p/333444#M2676

4. Verify if all php package are 7.0 by issuing below command:

apt list --installed | grep php

If there are versions other than 7.0 installed, you will need to re-install the ubuntu VM from scratch.

Re: Incorrect Username or Password

TerryDes — Mon, 16 May 2022 17:27:18 GMT

Thank you for the prompt replies!

1. Have done after every attempt to fix, hasn't worked. Tried different browsers as well (Edge, Chrome)

2. Reply from server:

mariadb.service - MariaDB 10.5.15 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Mon 2022-05-16 16:26:52 UTC; 54min ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 1114 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 11 (limit: 4612)
Memory: 105.9M
CGroup: /system.slice/mariadb.service
└─1114 /usr/sbin/mariadbd

3. Completed, no change.

4. Reply from server:

libapache2-mod-php7.0/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php-common/focal,now 2:92+ubuntu20.04.1+deb.sury.org+2 all [installed,automatic]
php7.0-bcmath/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-bz2/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-cli/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-common/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-curl/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-gd/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-json/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-ldap/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-mbstring/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-mcrypt/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-mysql/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-opcache/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-radius/focal,now 1.4.0~b1-22+ubuntu20.04.1+deb.sury.org+10 amd64 [installed]
php7.0-readline/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed,automatic]
php7.0-soap/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-xml/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0-zip/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 amd64 [installed]
php7.0/focal,now 7.0.33-57+ubuntu20.04.1+deb.sury.org+1 all [installed]

Re: Incorrect Username or Password

TerryDes — Wed, 18 May 2022 14:10:28 GMT

Figured it out. Simple problem, the 'root@localhost' didn't have a password in MySQL. Added one and it magically started working! Thank you @lychiang for helping.

Terry

Re: Incorrect Username or Password

trcoates — Sat, 23 Jul 2022 17:22:34 GMT

@TerryDes Can you share the process you used to perform this step? I'm on my second install of Ubuntu and Expedition to troubleshoot the issue of being unable to login using the default username and password included in the guide. I tried to add a password using some commands I found, last install before the wipe, but I'm not sure I did it properly because I was never able to login.

Thank you!

Re: Incorrect Username or Password

TerryDes — Mon, 25 Jul 2022 14:00:06 GMT

Good morning @trcoates . It has been a while but I believe I used this article: sql - MySQL Error: : 'Access denied for user 'root'@'localhost' - Stack Overflow

And entered this command:

sudo mysql

-- for MySQL
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

-- for MariaDB
ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('root');

Re: Incorrect Username or Password

trcoates — Wed, 27 Jul 2022 22:14:46 GMT

Hey thanks for getting back so quick. I tried those steps too and I still get "Incorrect user or password" with the default credentials. I've spent enough time on this that I could have just used Notepad++ to copy config to config, so I think I'm going back to that reliable route until PAN can officially support this tool. Thanks for your assistance!

Re: Incorrect Username or Password

Stiffler — Thu, 29 Dec 2022 16:07:21 GMT

I had the same problem. the link provided by you help me solve the situation. Slightly different commands for me, but it worked.

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

Thank you

Re: Incorrect Username or Password

Lenniusce — Fri, 10 Feb 2023 21:47:02 GMT

What if this doesn't fix the issue? I still cannot login from the gui homepage using default credentials. Looks like mysql/mariadb are runnning and the only error messages are:

"looking for 'mysql' as: /usr/bin/mysql"

"looking for 'mysqlcheck' as as /usr/bin/mysqlcheck

background: I transferred the ubuntu/expedition combo as an ovf form workstation 17 to esxi6.7