Viatom O2Ring binary file password?

[since1984]

Hello everyone. 

Sometime in 2024, I researched how to open the binary file from the Viatom O2 Ring in SQLite. Somewhere, somehow in this forum, I came across a post that included the password, but I can’t find it anymore. Does anyone know what the password is to open the binary file in SQLite? 

Thank you very much and best regards,
Hans.

[Crimson Nape]

Unless it has recently changed, there is no password.  There are 2 different database names easily accessed by standard SQL commands.  I have listed them below for each database that is used.

Code:

for filename in `sqlite3 ./PlusebitO2.db 'select mFileName from sleepData'`; do echo $filename;
(sqlite3 PlusebitO2.db "select quote(dataBuf) from sleepData where mFileName = '$filename'" | cut -d\' -f2 | xxd -r -p > $filename); done

Code:

for filename in `sqlite3 ./db_o2.db 'select checktime from tb_check'`; do
echo $filename; (sqlite3 db_o2.db "select quote(checktime) from tb_check where checktime = '$filename'" | cut -d\' -f2 | xxd -r -p > $filename); done

- Red

[since1984]

Thanks, Red!

I´m not too familiar with this. Look at the attached file (normally unzipped file). This is the binary file I can download from ViHealth and if I try to open it in DB Browser for SQLite, the attached window appears ...

Hans

[Crimson Nape]

That is a binary data file (20250325234058) that began recording on March 25, 2025, at 11:40:58PM. The actual database will have a ".db" suffix. The 2 database names that I'm aware of are db_o2.db and PlusebitO2.db.
- Red

[since1984]

This binary file is what ViHealth exports and is accepted and imported by OSCAR as input for the SpO2 data. This is the normal daily process – click the 'Import Viatom/Wellue Data' menu item in OSCAR, select this binary file, and OSCAR then reads and displays the data.

I therefore suspect that the binary file needs to be decoded first or something. In any case, when I try to open it in DB Browser for SQLite, the window shown in the last post appears and asks for a password.

I'm somewhat perplexed – where else could the .db files be?

Hans

[Crimson Nape]

That's because it is not a database file, but just a binary file. You will use a Hex editor to view its contents, not SQL.
- Red

[Crimson Nape]

Here is a dump of the first 5 lines of the file you posted above.

Hex Dump  (command: hd 20250325234058)

Code:

00000000  03 00 e9 07 03 19 17 28  3a 09 51 00 00 b4 40 00
00000010  00 5d 52 31 19 0c f0 07  31 46 00 00 00 00 00 00
00000020  00 00 00 00 00 00 00 00  5d 3c 00 00 00 5d 3c 00
00000030  00 00 5d 3c 00 07 00 5d  3c 00 0a 00 5d 3c 00 07
00000040  00 5d 3c 00 03 00 5d 3c  00 00 00 5d 3c 00 03 00

Decimal Dump (command: od -t u1 20250325234058)

Code:

0000000   3   0 233   7   3  25  23  40  58   9  81   0   0 180  64   0
0000020   0  93  82  49  25  12 240   7  49  70   0   0   0   0   0   0
0000040   0   0   0   0   0   0   0   0  93  60   0   0   0  93  60   0
0000060   0   0  93  60   0   7   0  93  60   0  10   0  93  60   0   7
0000100   0  93  60   0   3   0  93  60   0   0   0  93  60   0   3   0

- Red

[since1984]

Okay, thank you very much! 

Then I assume that's the end of the line for me, because I can't do anything with all that jumble of numbers.

So all I have left is the CSV file. Or am I making a fundamental mistake somewhere?

Hans