topic Re: Expedition default password not accepted in Expedition Discussions

Expedition default password not accepted

Rich.H — Mon, 02 Aug 2021 23:52:58 GMT

I have installed expedition on Ubuntu Server 16.04 following the instruction video. The default admin/paloalto username and password does not work for the GUI login. How should I proceed?

Re: Expedition default password not accepted

lychiang — Tue, 03 Aug 2021 00:15:07 GMT

@Rich.H Could you double check you are downloading the correct Ubuntu server images. it needs to be 64bit AMD server version.

Re: Expedition default password not accepted

Rich.H — Tue, 03 Aug 2021 00:26:51 GMT

it is that version ubuntu-16.04.7-server-amd64.iso

It seems there is a database issue. I am seeing int he error log for apache:

PHP Warning: mysqli::__construct(): (HY000/2002): No such file or directory in /var/www/html/libs/database.php on line 22,
PHP Fatal error: Database connection failed: No such file or directory in /var/www/html/libs/database.php on line 24,

Re: Expedition default password not accepted

lychiang — Tue, 03 Aug 2021 03:14:29 GMT

Could you please refer the solutions in the below article:

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

Re: Expedition default password not accepted

Rich.H — Tue, 03 Aug 2021 09:58:40 GMT

It looks to me like mysql is not installed. Should it have been installed as part of the setup script, or was it something I should have done manually. Reinstalling expedition-beta throws quite a few DB related errors.

rhall@loodrhall1:/var/log/apache2$ apt list --installed | grep sql

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

libaprutil1-dbd-sqlite3/xenial,now 1.5.4-1build1 amd64 [installed,automatic]
libsqlite3-0/xenial-updates,xenial-security,now 3.11.0-1ubuntu1.5 amd64 [installed]
php7.0-mysql/xenial-updates,xenial-security,now 7.0.33-0ubuntu0.16.04.16 amd64 [installed]
rhall@loodrhall1:/var/log/apache2$

Re: Expedition default password not accepted

Rich.H — Tue, 03 Aug 2021 13:42:22 GMT

OK, I worked it out. I was logged in as another user than expedition when I sudo ran the installer, which apparently broke some of the script. after logging in as the user expedition and re-running the script it installed the database bits and I can now log in. There were still some errors, but I am at least logged in now.

Re: Expedition default password not accepted

Rich.H — Tue, 03 Aug 2021 14:24:27 GMT

I just reinstalled the server to check, and it looks like the script fails to install mariadb-server and mariadb-client


Installing the DB server.

spawn apt-get install -y mariadb-server mariadb-client
Reading package lists... Done
Building dependency tree 
Reading state information... Done
The following additional packages will be installed:
galera-3 libaio1 libcgi-fast-perl libcgi-pm-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl libjemalloc1
liblwp-mediatypes-perl libmariadbclient18 libmysqlclient18 libmysqlclient20 libtimedate-perl liburi-perl mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1 mysql-common socat
Suggested packages:
libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl libdata-dump-perl libipc-sharedcache-perl libwww-perl libterm-readkey-perl mailx mariadb-test tinyca
The following NEW packages will be installed
galera-3 libaio1 libcgi-fast-perl libcgi-pm-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl libjemalloc1
liblwp-mediatypes-perl libmariadbclient18 libmysqlclient18 libmysqlclient20 libtimedate-perl liburi-perl mariadb-client mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server mariadb-server-10.1 mariadb-server-core-10.1 mysql-common
socat
0 to upgrade, 30 to newly install, 0 to remove and 88 not to upgrade.
Need to get 24.5 MB of archives.
After this operation, 198 MB of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
mysql-common mariadb-common galera-3 libmysqlclient18 libmariadbclient18 mariadb-client-core-10.1 mariadb-client-10.1 mariadb-server-core-10.1 mariadb-server-10.1 mariadb-client mariadb-server
E: There were unauthenticated packages and -y was used without --allow-unauthenticated
./initSetup.sh: line 162: mysql: command not found
./initSetup.sh: line 166: mysql: command not found
./initSetup.sh: line 174: mysql: command not found
sed: can't read /etc/mysql/my.cnf: No such file or directory
sed: can't read /etc/mysql/my.cnf: No such file or directory
sed: can't read /etc/mysql/my.cnf: No such file or directory
Failed to restart mysql.service: Unit mysql.service not found.

Creating initial Databases

./initSetup.sh: line 185: mysqladmin: command not found
./initSetup.sh: line 186: mysqladmin: command not found
./initSetup.sh: line 187: mysqladmin: command not found
./initSetup.sh: line 188: mysqladmin: command not found