Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Sqlite3 ChangePassword() failed.
Sqlite3 ChangePassword() failed. [message #59957] Mon, 19 June 2023 13:35 Go to previous message
zouql is currently offline  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 149 times)
  • Attachment: sqlite_2.jpg
    (Size: 269.02KB, Downloaded 143 times)
  • Attachment: sqlite_3.jpg
    (Size: 303.99KB, Downloaded 150 times)

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

Report message to a moderator

 
Read Message
Read Message
Read Message icon14.gif
Previous Topic: Transfer compress data
Next Topic: Bitwise and, or, xor in sql
Goto Forum:
  


Current Time: Thu Jul 18 20:25:38 CEST 2024

Total time taken to generate the page: 0.02156 seconds