About lychiang

@BOkay Thank you for sharing the solution!   ... View more

Hello BOkay, The error could be that the MySQL is not listening to ports. Do a netstat -pnuat And check if you have any line with port 3306. Also, which IP are defined to be listening. Normally it should state all ipv6 (it includes ipv4)   Below are possible reasons of this database connection error: a) the MySQL service is blocked to only listen to socket connections, b) the MySQL went uninstalled c) the MySQL is there, but firewall is blocking connections to MySQL d) that they upgraded MySQL and it only allows root MySQL connections from system root user (we connect using www-data) ... View more

Hi @BOkay  have you ran “sudo apt-get upgrade” by mistake ? We have seen user can’t login to GUI after did a “sudo apt-get upgrade “  ... View more

Hello @BOkay  Could you please try below steps : 1.  In Setting-> M. Learning-> Server information-> Expedition ML address, trying to set the Expedition IP to 127.0.0.1 , this will fall back to Expedition server IP and click “Save”. This step will re-initiate the database connections. (If Expedition is behind a different IP or NATed IP , you would need to put the real IP as ML IP not the NATed IP ) , check the IP using ifconfig.  (Most cases, this step should fix your Database connection issue, if not, continue to step 2) 2. Go to #more /home/userSpace/userDefinitions.php review the parameters in the files look like below: define ('DBServer' , '127.0.0.1'); define ('DBUser',  'root'); define ('DBPass', 'paloalto'); define ('DBName' ,'project_schema'); define ('PARSER_max_execution_time','10000'); define ('PARSER_max_execution_memory','1G'); define ('DBSQL_LOG_BIN', 0);   3. Issue SQL commands to check which IPs were being allowed.  # mysql -uroot -ppaloalto   expedition@expedition-documentation : ~ $ mysql -uroot -ppaloalto   Welcome to the MariaDB monitor.  Commands end with ; or \g. Your MariaDB connection id is 319026 Server version: 10.1.44-MariaDB-1~xenial mariadb.org binary distribution   Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.   MariaDB [(none)]> select host,user from mysql.user; +--------------------------+------------------+ | host                     | user             | +--------------------------+------------------+ | 10.8.200.34              | root             | | 127.0.0.1                | root             | | ::1                      | root             | | expedition-documentation | root             | | localhost                | debian-sys-maint | | localhost                | root             | +--------------------------+------------------+ 6 rows in set (0.00 sec)   Verified Expedition IP and User Root is showing up as above   4. Check that /etc/mysql/my.cnf is correctly setup not bind to 127.0.0.1. There is a health check in the dashboard that checks this as well.    Make sure below line is commented out:   # The following values assume you have at least 32M ram /127.0.0.1 ...skipping # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. #bind-address = 127.0.0.1   ... View more

Hello @JonCrockett  Not all BPA item can be remediated in Expedition , only the one shows  "Remediate" icon as attached screenshot. If you want us to look further, can you please send your exported Expedition project to fwmigrate@paloaltonetworks.com and list which remediation is not working for you, and we can further investigate.    Thank you! ... View more

@sd44  , are you running ubuntu 16.04 LTS? ... View more