artodeto's blog about coding, politics and the world

I am using NetworkManager to work with any kind of network connection.

I found my freedom with the nmtui and it was working fine until today. Today, I needed to connect to an eduroam WiFi. Long story short this is currently not possible that easy with nmtui or nmcli.

Since I try to keep the system footprint small, I have not installed any gui for the NetworkManager.

Thanks to GallaFrancesco, I found a way to connect to my eduroam realm.

Execute the following command in your shell.

nmcli connection add \
    type wifi con-name "eduroam" ifname $(ifconfig | grep -i w | cut -d":" -f 1) ssid "eduroam" -- \
    wifi-sec.key-mgmt wpa-eap 802-1x.eap peap \ 
    802-1x.phase2-auth mschapv2 802-1x.identity "<username>@<realm>"

After that, restart your networkmanager service with systemctl restart NetworkManager.service to ensure the eduroam connection was found.

Finally, open nmtui and activate the eduroam connection. Now, you have to provide your password.

I've created a small howto here.

Hello there,

when logged into my nextcloud server as user, I clicked to User Bubble -> Settings -> Security and found a long list of entries below Devices & sessions.

After searching the issue list, I found this issue ticket.

The issue is know but either it is a kind of special issue ore no one really cares about it.

There is currently no real solution but I want to offer a temporary one.

You can create a cronjob that executes the following sql statement once per week or day.

```sql
--- 
--- You have to replace <user_name> with your user name
--- 

DELETE FROM 
  `oc_authtoken` 
WHERE 
  `uid` = <user> 
  AND `last_activity` < UNIX_TIMESTAMP(DATE_SUB(CURRENT_DATE(), INTERVAL 16 DAY));

OPTIMIZE TABLE `oc_authtoken`;
```

From my point of view, it looks like Firefox is doing something strange. Maybe other browsers behave the same.

Best regards, artodeto

So today I wanted to quickly setup a public shared link so that a friend of mine is able to easily upload a file to me.

Of course, I've stumbled over the file drop but I was not able to find the "File drop (upload only" section when I was creating this share.

I tried to find more information and was digging into the documentation. I was going through the issue list but at the end, I was not able to fix the missing option. I was also quickly updating the server to the latest version, but also, no "File drop" selection.

Than, after reading the logs, investigating the config.php, I finally found the missing link.

As an administrator, you have to go to Sharing and check the Allow public uploads configuration setting. After that, you can finally create your share as a user known as "file drop".

I've just finished a simple houseskeeping/maintenance script for zabbix if you use mariadb or mysql as database.

You can find it here.

It installs a systemd timer to automatically run optimize on the two tables zabbix.history and zabbix.history_uint.

All you have to do is to add your username and passwort to the created file /etc/net.bazzline/zabbix/housekeeping/local_configuration.sh.