- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
08-21-2019 04:53 AM
Hello,
After upgrading expedition, I'm no longer able to login to the tool using the GUI.
Via CLI I still can log in.
I had changed the admin password, and I'm sure I'm using the correct password, since I've been using this login prior to the upgrade of Expedition.
In the past I could reset the admin password via the PHP script in /home/userSpace/utils
But if I try to run this, I'm gettting another error:
sudo php /home/userSpace/utils/restoreAdmin.php
[sudo] password for expedition:
PHP Warning: mysqli::__construct(): (HY000/2002): No such file or directory in /home/userSpace/utils/restoreAdmin.php on line 81
Connection failed: No such file or directoryexpedition@Expedition
74 $servername = "localhost";
75 $username = "root";
76 $password = "paloalto";
77
78 $colors = new Colors();
79
80 // Create connection
81 $conn = new mysqli($servername, $username, $password);
82
83 // Check connection
84 if ($conn->connect_error) {
85 die("Connection failed: " . $conn->connect_error);
86 }
87 echo $colors->getColoredString("\n".chr(0xE2).chr(0x9C).chr( 0x93)."\tConnected successfully to the database\n", "green");
88
89 $checkAdminExists = "SELECT id FROM pandbRBAC.users WHERE email='admin' and id=1;";
90 $result=$conn->query($checkAdminExists);
I'm out of options in how to solve this, without re-installing the tool again.
Anyone has a clue?
Regards,
Gerrit