User does not exist

[TMzethar]

{L_BUTTON_AT}Jhac

The situation you encounter is different from that of the person who posted the topic, at least in terms of the cause of the problem. And before this, we have not received similar feedback from users who use 223/423 models (BIOS 5.19) and have not used TOS4 like you.
Please generate and download the log report in TOS > Technical Support > Problem Report, and then send it to Technical team as a network disk sharing link for analysis.

[bogyokapitany]

Hi Support,

Today I faced the same issue, suddenly the administrator (Adm1n168) login failed with the message "user does not exist". Previously I could log in.
Via SSH the login is successful.

The pgsql.log:

2023-07-24 20:28:04.539 CST [1678] LOG: starting PostgreSQL 13.2 on x86_64-buildroot-linux-gnu, compiled by x86_64-tnas-linux-gnu-gcc.br_real (Buildroot 2017.11.2
) 7.2.0, 64-bit
2023-07-24 20:28:04.539 CST [1678] LOG: listening on IPv4 address "0.0.0.0", port 5032...
...

2023-07-24 20:28:04.612 CST [1678] LOG: database system is ready to accept connections
2023-07-24 20:28:07.341 CST [1697] ERROR: catalog is missing 6 attribute(s) for relid 16543
2023-07-24 20:28:07.341 CST [1697] STATEMENT: SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_
precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description, c.identity_increment FROM information_schema.columns AS c JOI
N pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_cata
log.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = $1 AND
table_schema = CURRENT_SCHEMA() AND table_name = $2
2023-07-24 20:28:07.342 CST [1697] ERROR: catalog is missing 6 attribute(s) for relid 16543 at character 15
2023-07-24 20:28:07.342 CST [1697] STATEMENT: SELECT * FROM "user_table" LIMIT 1
2023-07-24 20:28:07.530 CST [1697] ERROR: constraint "fk_external_acl_user_table" of relation "external_acl" does not exist
2023-07-24 20:28:07.530 CST [1697] STATEMENT: ALTER TABLE "external_acl" DROP CONSTRAINT "fk_external_acl_user_table"
2023-07-24 20:28:07.537 CST [1697] ERROR: catalog is missing 6 attribute(s) for relid 16543
2023-07-24 20:28:07.537 CST [1697] STATEMENT: SELECT c.column_name, c.is_nullable = 'YES', c.udt_name, c.character_maximum_length, c.numeric_precision, c.numeric_
precision_radix, c.numeric_scale, c.datetime_precision, 8 * typlen, c.column_default, pd.description, c.identity_increment FROM information_schema.columns AS c JOI
N pg_type AS pgt ON c.udt_name = pgt.typname LEFT JOIN pg_catalog.pg_description as pd ON pd.objsubid = c.ordinal_position AND pd.objoid = (SELECT oid FROM pg_cata
log.pg_class WHERE relname = c.table_name AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = c.table_schema)) where table_catalog = $1 AND
table_schema = CURRENT_SCHEMA() AND table_name = $2
2023-07-24 20:28:07.538 CST [1697] ERROR: catalog is missing 6 attribute(s) for relid 16543 at character 15
2023-07-24 20:28:07.538 CST [1697] STATEMENT: SELECT * FROM "user_table" LIMIT 1
2023-07-24 20:28:15.938 CST [1956] ERROR: catalog is missing 6 attribute(s) for relid 16543


NAS: F5-220 4GB
Current version: 5.1.24,

Is there any way to "repair" the database?
The UI is not accessible but in SSH I have terminal access.

Best regards,
Antal

[TMzethar]

{L_BUTTON_AT}bogyokapitany

Your question doesn't match the title.
Regarding the problem of system database corruption, currently it can only be solved by reinstalling TOS, but this also means that you will reset the system data.

[Vaulenst]

Hi,
I'm in troubles too.

I got my brand new F4-423 from a week or so.
It started directly with TOS 5.1 (I think it was 5.1.42).
I put the o.s. and apps on the 1TB nvme drive as single disk/storage pool.
Then I put 4 hdd all as single disks.

I configured my shares, web server, qbittorrent, tmf backup and plex.
All was working perfectly from 6 days.

Then I did 2 things:
1. installed deduplicator app and run it over plex library. It took many hours to finish without finding any duplication at the end.
2. after that, I installed virtualbox, downloaded manjaro xfce iso and started creating a new virtual machine.

During installation of manjaro into the new virtual machine, the process froze in the middle (I was connected through windows remote desktop connection).
I remember I saw that VM folder was created into Superuser home

So I powered off the pc (I didn't touch the nas) and went to sleep.
The day after from the pc I started the browser, which keep all opened sessions of the last time, focused the nas one that was prompting for access.

I provided Superuser credentials, as I do every day from when I bought the nas, but it stated: "User does not exist!".
The page was refreshing correctly in the browser.
From my windows file explorer, I could access the shared folders.

So I thought to restart the nas... it wasn't stuck and it could be powered of normally pressing it's button.
But when I restarted it, the usual address I was used to use (http://tnas.local:8181/tos) was unreachable.

I tried to ping the ip address it always had (192.168.1.172) and it was responding (4ms).
So I tried the folllowing URL: http://192.168.1.172:8181 and it load a complete white page with only this in the middle: "Loading..., please wait!"

I didn't changed the default accessibility so ssh and telnet and I remember they were closed, so I powered off the nas and plugged an hdmi cable connected to a tv and I saw some errors in boot.
After a while during boot time, the console keeps printing the following:

cat: /var/run/TOSDaemon.pid: no such file or directory

I started to worry about my data!

I powered off the nas, removed all 4 hdd and powered on again but nothing changed.
I tried to log-in (using ENTER or ALT-Fx) but nothing worked: seems the os is still in boot phase.

I mounted one of the HDD to a linux pc and I can see the content with no errors (phew!)

And now I don't know what to do: if it's possible, I wouldn't waste all the configurations I did.
And still, if I am forced (sigh) to reinstall TOS, will I be able to reconnect my hdds without loosing data?

I made a video (11MB) but I can't attach as it says it's too big.
I put it here: https://youtu.be/1wjkeGAmvKY

Gio

[TMzethar]

{L_BUTTON_AT}Vaulenst

Your question has nothing to do with the topic, you can create a new topic in the corresponding position. Regarding your question, you need a new USB boot disk. You can ask the after-sales service to provide it, or make it yourself:viewtopic.php?f=76&t=3684