03-22-2019 02:00 AM
update ver 1.1.9 added a CLI option to restore the password for the WebUI account - 'admin'
If you need to restore the password to the default password of 'paloalto' the CLI syntax is shown below:
expedition@Expedition:/var/www/html$ php /home/userSpace/utils/restore/restoreAdmin.php
✓ Connected successfully to the database
✓ Admin user found
✓ Admin password restored to: 'paloalto'
01-18-2021 09:02 PM
I can't use this command to restrore my admin password. Please see below the results when I tried to run the command in expedition:
It doesn't seem that I have utils directory.
expedition@ubuntu1604:/var/www/html$ sudo php /home/userSpace/utils/restore/restoreAdmin.php
Could not open input file: /home/userSpace/utils/restore/restoreAdmin.php
expedition@ubuntu1604:/var/www/html$ cd /home/userSpace/
expedition@ubuntu1604:/home/userSpace$ ls -la
drwxr-xr-x 3 www-data www-data 4096 Jan 18 04:33 .
drwxr-xr-x 5 root root 4096 Jan 18 04:03 ..
-rw-r--r-- 1 www-data www-data 82 Jan 18 04:32 environmentParameters.php
-rw-r--r-- 1 www-data www-data 894 Jan 18 04:32 panReadOrders.log
drwxrw-rw- 3 www-data www-data 4096 Jan 18 04:33 projects
-rw-r--r-- 1 www-data www-data 70 Jan 18 04:32 .signatureMAC
-rw-r--r-- 1 www-data www-data 101 Jan 18 04:33 tempEnvironmentParameters.php
-rw-r--r-- 1 root root 654 Jan 18 04:09 userDefinitions.php
-rw-r--r-- 1 www-data www-data 36 Jan 18 04:09 .uuid5
01-19-2021 02:49 AM
I see you do not have the utils folder. Could I ask which version of Expedition are you currently running?
02-18-2021 10:52 AM
Looks like the file has moved. Here is the new location :
Aswell the login might be admin instead of expedition
expedition:~$ php /var/www/html/OS/startup/restore/restoreAdmin.php ✓ Connected successfully to the database ✓ Admin user found ✓ Admin password restored to: 'paloalto'
02-18-2021 11:05 AM
08-21-2021 11:28 AM
When I run above command I get following error, am I missing anything?
PHP Warning: mysqli::__construct(): (HY000/2002): No such file or directory in /var/www/html/OS/startup/restore/restoreAdmin.php on line 81
Connection failed: No such file or directory
08-23-2021 08:24 AM
Try to switch to Root account using $su , then you should be able to see the file.
08-30-2022 02:49 PM
I followed the commands and it shows the correct restoration, however credentials not working in the GUI:
expedition@expedition1:~$ sudo php /var/www/html/OS/startup/restore/restoreAdmin.php ✓ Connected successfully to the database ✓ Admin user found ✓ Admin password restored to: 'paloalto' expedition@expedition1:~$
I tried using admin/paloalto as default credentials but is not working.
I also have powered-off/on with no luck.
Expedition version: 1.2.39
08-30-2022 02:54 PM
Which version of ubuntu you are running ? Expedition newer version only runs on ubuntu 20.x please follow the installation guide below:
08-30-2022 02:57 PM
My Ubuntu is running 20.04 LTS
08-30-2022 03:19 PM
I have found the following error:
Aug 30 21:32:41 expedition1 /etc/mysql/debian-start: Looking for 'mysql' as: /usr/bin/mysql Aug 30 21:32:41 expedition1 /etc/mysql/debian-start: Reading datadir from the MariaDB server failed. Got the follow> Aug 30 21:32:41 expedition1 /etc/mysql/debian-start: ERROR 1045 (28000): Access denied for user 'root'@'localhost' > Aug 30 21:32:41 expedition1 /etc/mysql/debian-start: FATAL ERROR: Upgrade failed
08-30-2022 03:39 PM
Hi @edgutier Could you please try the solution in the below article:
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!