Expedition default password not accepted

[Rich.H]

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?

[lychiang]

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

[Rich.H]

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,

[lychiang]

Could you please refer the solutions in the below article:

https://live.paloaltonetworks.com/t5/expedition-discussions/incorrect-user-or-password-when-logging-...

[Rich.H]

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$

[Rich.H]

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.

[Rich.H]

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