Reset password

[astronyu]

Is there a way to reset password?

[ellite]

If you have it enabled on your settings, you can just click the link on the login page.

Otherwise

Assuming you have access to your mounted folders
create a file resetpw.php on your mounted database folder

<?php
$databaseFile = 'wallos.db';
$db = new SQLite3($databaseFile);
$db->busyTimeout(5000);
$password = "mynewpassword";
$sql = "UPDATE user SET password = :password WHERE id = 1";
$stmt = $db->prepare($sql);
$hashedPassword = password_hash($password, PASSWORD_DEFAULT);
$stmt->bindParam(':password', $hashedPassword, SQLITE3_TEXT);
$result = $stmt->execute();
if ($result) {
echo "Password updated successfully.";
} else {
echo "Error updating password.";
}
?>

and run on your browser
http://ip:port/db/resetpw.php

[astronyu]

Sorry for the late response.

I added the resetpw.php file in the same folder of "db", "images" but going to http://ip:port/db/resetpw.php I got this:

seFile = 'wallos.db'; $db = new SQLite3($databaseFile); $db->busyTimeout(5000); $password = "MYNEWPWD"; $sql = "UPDATE user SET password = :password WHERE id = 1"; $stmt = $db->prepare($sql); $hashedPassword = password_hash($password, PASSWORD_DEFAULT); $stmt->bindParam(':password', $hashedPassword, SQLITE3_TEXT); $result = $stmt->execute(); if ($result) { echo "Password updated successfully."; } else { echo "Error updating password."; } ?>```

but still can't login with the new password.

[ellite]

There seems to have been a problem with the copy and paste of the code.
The file should start with

[astronyu]

There seems to have been a problem with the copy and paste of the code. The file should start with

Yeah, my bad. Realized the code I copied from email notification was truncated.
Copied the one from here and page gave me this

Warning: SQLite3::prepare(): Unable to prepare statement: 1, no such table: user in /var/www/html/resetpw.php on line 7

Fatal error: Uncaught Error: Call to a member function bindParam() on bool in /var/www/html/resetpw.php:9 Stack trace: #0 {main} thrown in /var/www/html/resetpw.php on line 9

the resetpw.php added into /var/www/html using portainer console.