nc-who last : more user in output than available

[rakekniven]

I have 15 users on one NC

Output of nc-who last is:

      uid      |       last_login       
---------------+------------------------
 user1         | 2025-02-27 16:50:47+01
 user2         | 2025-02-27 16:33:26+01
 user3         | 2025-02-27 15:45:57+01
 user4         | 2025-02-27 13:14:14+01
 user5         | 2025-02-27 09:53:07+01
 user6         | 2025-02-27 08:37:57+01
 user7         | 2025-02-26 12:36:34+01
 user8         | 2025-02-26 12:36:03+01
 user9         | 2025-02-26 11:21:58+01
 user10        | 2024-10-25 07:01:05+02
 user11        | 2024-08-26 07:31:29+02
 user12        | 2023-08-17 15:23:24+02
 user13        | 2023-01-22 10:42:23+01
 user14        | 2022-06-04 21:29:38+02
 user15        | 2020-02-12 15:02:43+01
 user4         | 1970-01-01 00:59:59+01
 user1         | 1970-01-01 00:59:59+01
 user9         | 1970-01-01 00:59:59+01
 user3         | 1970-01-01 00:59:59+01
 user6         | 1970-01-01 00:59:59+01
 user5         | 1970-01-01 00:59:59+01
 user7         | 1970-01-01 00:59:59+01
 user2         | 1970-01-01 00:59:59+01
 user8         | 1970-01-01 00:59:59+01
(24 rows)

9 one them are double with a suspicious unix date.

Is that normal?

[ernolf]

Hi @rakekniven,

This is basicaly what hapens;
Based on some key data, such as the presence of the guests app,, an SQL query for the used database backend (MySQL or PostgreSQL) is created by the script that leads to this output.

If you append --trace to the command, you'l get the constructed Query instead of the output, You can copy and paste that into the SQL Console (nc-sql) to further analisys..

Here an exampel output (for MariaDB):

root@host:~# nc-who last --trace
==TRACE=start=
Frame 0: Function 'nc_last' in /proc/1020211/fd/63:64 (Arguments: 0)
global bool values  - do_integrity_check=_ do_update=_ dc=: trace=: do_restore_backup=_ check=_ pager=_ docker=_ rt=: aio=_ run2=: irun2=_
Database Backend: mysql
==TRACE=end===
----------
SQL QUERY:
----------
        SELECT uid, last_login
        FROM (
            SELECT users.uid,
                COALESCE(FROM_UNIXTIME(CAST(p.configvalue AS integer)), 'never') AS last_login
            FROM oc_users users
            LEFT JOIN oc_preferences p ON users.uid = p.userid AND p.appid = 'login'
        UNION ALL
            SELECT guests_users.uid,
                COALESCE(FROM_UNIXTIME(CAST(p.configvalue AS integer)), 'never') AS last_login
            FROM oc_guests_users guests_users
            LEFT JOIN oc_preferences p ON guests_users.uid = p.userid AND p.appid = 'login'
        ) combined
        ORDER BY
            CASE WHEN last_login = 'never' THEN 1 ELSE 0 END, last_login DESC;
----------

To get to the bottom of the issue, you need to analyze your database carefully. The query may need to be adjusted.

---

ernolf

[Sanookmakmak]

I have entered the SQL command in PhpMyAdmin, but it comes up:
#1146 - Tabelle 'c1nextcloud.oc_guests_users' existiert nicht

This is because I have not installed the Guests App.

Please what is the SQL command without the Guests app?

[rakekniven]

Hello Sanook,

please do not hijack this issue.
You can easily reach Ernolf in our forums.

Thanks

[Sanookmakmak]

please do not hijack this issue.

I am just trying to find this error.

[Sanookmakmak]

The --trace flag only works as root and the users are displayed twice?
nc-who version 2025-05-18 23:12 CEST 1747602760.

nc-who as unprivileged user:

nc-who last --trace

+--------+---------------------+
| uid    | last_login          |
+--------+---------------------+
| user2  | 2025-05-31 16:19:50 |
| user1  | 2025-05-31 05:15:25 |
| user1  | never               |
| user2  | never               |
+--------+---------------------+

as root:

sudo nc-who last --trace

==TRACE=start=
Frame 0: Function 'nc_last' in /proc/3659138/fd/63:64 (Arguments: 0)
global bool values  - do_integrity_check=_ do_update=_ dc=: trace=: do_restore_backup=_ firstrun=_ check=_ pager=_ docker=_ rt=: aio=_ run2=_ irun2=_
Database Backend: mysql
==TRACE=end===
----------
SQL QUERY:
----------
            SELECT users.uid,
                COALESCE(FROM_UNIXTIME(CAST(p.configvalue AS integer)), 'never') AS last_login
            FROM oc_users users
            LEFT JOIN oc_preferences p ON users.uid = p.userid AND p.appid = 'login'
        ORDER BY
            CASE WHEN p.configvalue IS NULL THEN 1 ELSE 0 END, p.configvalue DESC;
----------
exiting nc-who script.
the janitor can provide extensive system informations and more. simply run: janitor

[ernolf]

Hi @Sanookmakmak

The --trace flag only works as root

Why do you still use this issue. You are making noise for other users. What did you not understand from what @rakekniven wrote?
Please respect that! I did already copy your question to #12 so please use that thread and stop making extra noise here.