User session uptime about ocserv-exporter HOT 3 CLOSED

Yes, this is something doable.

Output example from occtl --json show users:

    "Connected at":  "2023-09-22 04:28",
    "_Connected at":  " 9h:46m",

What should be done is to parse the duration of "_Connected at" value.
Don't hesitate to propose a PR if you're interested, otherwise I'll have a look soon.

from ocserv-exporter.

After looking closer into this, the values returned in Connected at or _Connected at are not consistent enough (the format changes depending on the connection time).
I proposed a PR on ocserv project to display the raw value of the connection start time (unix timestamp).

Depending on its acceptance, I'll make the required change on ocserv-exporter.
The only thing you'll have to do on Prometheus is to compute the uptime by doing something like:

time() - vpn_user_start_time_seconds

from ocserv-exporter.

The PR is accepted, so I added vpn_user_start_time_seconds metric (see 11796a5).

It relies on the presence of the raw_connected_at field in JSON output of occtl, which will be most likely available with version 1.2.3 of ocserv.

from ocserv-exporter.