!! UGRENT !! all DS Note are gone

[kookaburra]

I have setup the ds note in my iPhone for a few years, somehow, it stop syncing for some time, when I login and want to sync it back, it erase all my notes !!! which includes all my important information.

I have restore my iPhone from icloud backup, but when I open dsnote app, it ask for login.

I wonder if I login again, it will erase my note again, please help. is there any tricks to login the apps locally?



thanks

 

[Rusty]

I have setup the ds note in my iPhone for a few years, somehow, it stop syncing for some time, when I login and want to sync it back, it erase all my notes !!! which includes all my important information.

I have restore my iPhone from icloud backup, but when I open dsnote app, it ask for login.

I wonder if I login again, it will erase my note again, please help. is there any tricks to login the apps locally?



thanks

Best to log into your Note Station on the NAS, check the status there and back it up using hyper backup before doing anything else.

 

[kookaburra]

I have login my Note Station, they have no note, I guess may be it lost during upgrade to DSM7, just wonder if I can use the local copy in my iphone to sync it back to synology

 

[fredbert]

Have you tried restoring Note Station on the NAS from Hyper Backup? If you go backwards from the latest (pre-DSM 7) through older versions you may find there is a point that the notes are recovered.

 

[jeyare]

seems to be:
1. you have lost adapter for internal Syno PostgreSQL. The Adapter for PostgreSQL allows applications to access PostgreSQL data sources. The adapter converts application requests into PostgreSQL calls and returns optimized answer sets to the requesting application.

or

2. you have lost entire internal PostgreSQL - no way to repair it. Only by backup.

in case of point 1. you need check if you can find “pgsql” here:

ll /volume1/@database

- when you can see the pgsql in the DB list, try to start the Adapter by:

sudo synoservice --start pgsql
synoservice --start synoindexd

now check the DS Note.

- ONLY when you can’t see the pgsql in the DB list, try to create the Adapter:

sudo mkdir /volume1/@database/pgsql
sudo chown postgres.postgres /volume1/@database/pgsql

and again try to start the services by:

sudo synoservice --start pgsql
synoservice --start synoindexd

Check the DS Note

 

[Telos]

What is file size here:

 

[kookaburra]

seems to be:
1. you have lost adapter for internal Syno PostgreSQL. The Adapter for PostgreSQL allows applications to access PostgreSQL data sources. The adapter converts application requests into PostgreSQL calls and returns optimized answer sets to the requesting application.

or

2. you have lost entire internal PostgreSQL - no way to repair it. Only by backup.

in case of point 1. you need check if you can find “pgsql” here:

ll /volume1/@database

- when you can see the pgsql in the DB list, try to start the Adapter by:

sudo synoservice --start pgsql
synoservice --start synoindexd

now check the DS Note.

- ONLY when you can’t see the pgsql in the DB list, try to create the Adapter:

sudo mkdir /volume1/@database/pgsql
sudo chown postgres.postgres /volume1/@database/pgsql

and again try to start the services by:

sudo synoservice --start pgsql
synoservice --start synoindexd

Check the DS Note

seems like it is not the cause, because I have a few account have notes, only one of them which outsync for a while happens....

-- post merged: 25. Sep 2021 --

What is file size here:

I don't have the db folder here? how come....

-- post merged: 25. Sep 2021 --

Have you tried restoring Note Station on the NAS from Hyper Backup? If you go backwards from the latest (pre-DSM 7) through older versions you may find there is a point that the notes are recovered.

what should I restore from the hyperbackup?

 

[Telos]

I don't have the db folder here? how come....

IDK. Either it moved to a new location with DSM7, or that is the root of your problem.

 

[kookaburra]

some breakthrough, I am able to extract the syncQueue.sqlite from the itune backup, anyone have idea how can I restore it?

 

[fredbert]

@kookaburra couldn't you restore Note Station on the NAS from your Hyper Backup data?

If you have found a SQLite database that has recognisable data not matter if it's directly usable by Note Station or mobile app, what I'd look at doing is opening a copy of this database on Mac. A couple of ways to open the database:

1. From Terminal you can use sqlite3 syncQueue.sqlite
2. Using DB Browser for SQLite from here DB Browser for SQLite

If using Terminal there are a few useful commands:
.headers on to show the column names when listing out selected data from tables.
.tables to list the tables in the database.
select * from <table name>; lists out all the data in columns for the requested <table name>.
.exit to end the sqlite3 session.

At worse, if there's useful data here, you can copy out the note text.

 

[kookaburra]

Great thanks, however, most of my notes are encrypted notes, any tools can decrypt it?

 

[fredbert]

Just to confirm: you are logging into the right account?

Did you ever use Note Station on the Mac? Any other device that you no longer use but put in a drawer?

Did you backup the NAS?

 

[kookaburra]

yes, it is the right account, I use ds note on iphone, however, It is outsync, which means it is not connected, and stay at cache login mode for I don't know how long....
when I discover that, I tried to login again, but the note station has 0 note (I guess it is because of the DSM7 upgrade), the server side "push" back to my iphone and erase everything.

I have backup for a few directory, but I don't think it includes the note station database.

 

[fredbert]

I have backup for a few directory, but I don't think it includes the note station database.

Do you use Hyper Backup? It backs up packages and their data, whichever you've selected, along with the DSM configuration and selected shared folders. Maybe check what you selected to back up?

You could open a support ticket with Synology. It's a long shot but they may be able to find something.

 

[Telos]

Did you ever export the db to a *.nsx file?