U++ forum: Welcome to the forum

Sqlite3 ChangePassword() failed. [message #59957]

Mon, 19 June 2023 13:35

zouql
Messages: 15
Registered: December 2020
Location: China

Promising Member

Helo
when I test the sqlite3 at reference/SQL_sqlite3, I found a question about
ChangePassword() function.

Step 1: Use sqlite3.Open(file, "password") create an encrypted db file.

Step 2: Use sqlite3.ChangePassword("password_changed") change the file's password.

Step 3: Use sqlite3.Open(file, "password_changed") to open the db again.

The problem occurred in th third step, when I opened the db file with changed password, that failed about "ERROR file is not a database(26)".

I am not familiar with encryption. Can anyone test and answer this question?

Thanks.

1. create a encrypted file.
index.php?t=getfile&id=6818&private=0

2. change password

index.php?t=getfile&id=6819&private=0

3. use newpassword open failed.
index.php?t=getfile&id=6820&private=0

Attachment: sqlite_1.jpg
(Size: 277.04KB, Downloaded 126 times)
Attachment: sqlite_2.jpg
(Size: 269.02KB, Downloaded 120 times)
Attachment: sqlite_3.jpg
(Size: 303.99KB, Downloaded 122 times)

[Updated on: Mon, 19 June 2023 13:38]

Report message to a moderator