When using UI Web interface to add node into cluster, the following error occurred
ERROR: TFA-enabled login currently works only with a TTY. at /usr/share/perl5/PVE/APIClient/LWP.pm line 100Use command line below to add node via Shell
pvecm add <target ip> -link0 <source ip>If got error on key validation, try node name instead
pvecm add <target_dns_name>When adding the Proxmox node into existing cluster, the IP to DNS reverse lookup has different name, miss configuration. Then the new node thought it is already a member of cluster, but other nodes are not.
Convert the node back to local mode
Stop the corosync and pve-cluster services on the node:
systemctl stop pve-cluster
systemctl stop corosyncStart the cluster file system again in local mode:
pmxcfs -lDelete the corosync configuration files:
rm /etc/pve/corosync.conf
rm -r /etc/corosync/*Start the file system again as a normal service:
killall pmxcfs
systemctl start pve-clusterThe node is now separated from the cluster.
Deleted it from any remaining node of the cluster if it is already a node of cluster
pvecm delnode oldnodeIf the command fails due to a loss of quorum in the remaining node, you can set the expected votes to 1 as a workaround:
pvecm expected 1And then repeat the pvecm delnode command.
This ensures that the node can be added to another cluster again without problems.
rm /var/lib/corosync/*
Remove /etc/pve/nodes/<node_name> from other nodes.
Remove ssh key from /etc/pve/priv/authorized_keys file
If same certificate can be used for multiple domains in Proxmox clusters' nodes, then can use following steps to synchronous certificates.
/etc/pve/nodes/<target_node_name>pveproxy-ssl.pem and pveproxy-ssl.key in /etc/pve/nodes/<source_node_name> directory into target node directory.pveproxy service using command systemctl restart pveproxy.After install custom certificate, the Proxmox UI could not be displayed.
Remove two files pveproxy-ssl.pem and pveproxy-ssl.key in /etc/pve/nodes/<node_name> directory. Then restart Proxmox.
Unable to access GUI after uploading my certificates
Proxmox Certificate Management
The (*) operator returns ANDfunction result
=FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"")Above means get a sub list of A5:D20 which has C5:C20=H1 and A5:A20=H2. The H1 and H2 are values to be matched in column C and column A.
Function Returns TRUE if -
Return value searching
=VLOOKUP(value, table_array, col_index,[range_lookup])Return index of a value in an range.
=MATCH(25,A1:A3,0)Return value of specific cell in an range
=INDEX(A2:B3,2,2)=INDEX(range, MATCH(lookup_value, lookup_range, match_type))Better than VLOOKUP as
=COUNTIF(A2:A5,A4)
=COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
=COUNTIFS(A2:A7, "<" & A6,B2:B7,"<" & B4)FILTER function
MATCH function
INDEX function
Difference between ISNA and ISERROR
COUNTIF function
To remove duplicated hard link files using following command. The hard link files could be created by rmlint deduplication.
find . -type f -links +1 -printf '%i %n %p\n' -exec rm '{}' \;Tmux is a command line tool to manage terminal sessions.
To run tmux on Windows, WSL is required to be installed.
This is a shareware, which can be used to manage files.
This is not a free tool, but can automate GUI actions.
Pgweb is a web-based database browser for PostgreSQL, written in Go and works on OSX, Linux and Windows machines.
It can be downloaded from following website