[SOLVED] I can't open database file from OneDrive. But desktop MMEX can open it normally.

MMEX4Android: Manage your finances on-the-go, encrypted for security, sync via your own storage

Moderator: Renato

Post Reply
jkambb
New User
Posts: 5
Joined: Sat Dec 16, 2023 4:33 am
Are you a spam bot?: No

[SOLVED] I can't open database file from OneDrive. But desktop MMEX can open it normally.

Post by jkambb »

When I editing database on OneDrive, after syncing, I open android app to access the file, and this is happening [File is not a database: , while compiling: select count(*) from sqlite_master;] Can you tell me what is the error?
Now I only access the data from desktop version, only runs on desktop. Android is unable to run.
I'm using 2024.03.07, downloaded from F-droid.
Attachments
Image_20240318215938.png
Image_20240318215938.png (38.9 KiB) Viewed 4709 times
Last edited by jkambb on Mon Mar 25, 2024 6:12 am, edited 1 time in total.
guanlisheng
Developer
Posts: 461
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Contact:

Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.

Post by guanlisheng »

Seems can’t open the file, please leave password empty/blank for non-encrypted database .
jkambb
New User
Posts: 5
Joined: Sat Dec 16, 2023 4:33 am
Are you a spam bot?: No

Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.

Post by jkambb »

It works for non-encrypted database. I still keep backup of non-encrypted version. Thanks a lot Sir. :D
But with encrypted database, I can't open it even type password correctly. I am working on it.
2 cases testing with encrypted database
Case 1: filling password and still appear the same error.
Case 2: leave blank and press OK, it appears the error as screenshot I attach
* Encrypted file still be opened on desktop with the same password I will to open the file on android.
Attachments
Image_20240319092148.png
Image_20240319092148.png (42.1 KiB) Viewed 4673 times
guanlisheng
Developer
Posts: 461
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Contact:

Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.

Post by guanlisheng »

Great it works.

So far, the two use different ciphers, aes256(SQLCihper) for android while aes128 for desktop. Desktop has a temp schedule (v1.7.2) to upgrade to aes256.


a workaround to test/verify encrypted desktop database is via wxSQLitePlus to covert it to aes256.
jkambb
New User
Posts: 5
Joined: Sat Dec 16, 2023 4:33 am
Are you a spam bot?: No

Re: I can't open database file from OneDrive. But desktop MMEX can open it normally.

Post by jkambb »

I got it Sir. Ok. Cool! Thank you. 8-) 8-) 8-)
Post Reply