Re: doas tab completion

2024-07-30 Thread Alexander Hall
On July 30, 2024 8:03:45 AM GMT+02:00, Jason McIntyre wrote: >On Tue, Jul 30, 2024 at 12:42:04AM +0200, Alexander Hall wrote: >> In this specific case, I believe >> >> $ alias doas='doas ' # Note the space >> >> might have done the trick as well, for ksh at least. >is that correct? as far

Optimization Advice for High Resource Utilization PostgreSQL Query on OpenBSD

2024-07-30 Thread Kihaguru Gathura
Hi, I am seeking advice on optimizing a PostgreSQL query that is consuming a significant amount of CPU resources on my Dell PowerEdge T340 server. The server has an Intel Xeon E-2124 CPU @ 3.30GHz (4 cores, no Hyper-Threading) and 16GB RAM, running OpenBSD 7.3 (GENERIC.MP) #1125. The query in que

Re: Optimization Advice for High Resource Utilization PostgreSQL Query on OpenBSD

2024-07-30 Thread Claudio Jeker
On Tue, Jul 30, 2024 at 03:04:54PM +0300, Kihaguru Gathura wrote: > Hi, > > I am seeking advice on optimizing a PostgreSQL query that is consuming a > significant amount of CPU resources on my Dell PowerEdge T340 server. The > server has an Intel Xeon E-2124 CPU @ 3.30GHz (4 cores, no Hyper-Thread

xfreerdp / remmina won't connect to Win11 RDP with NLA

2024-07-30 Thread Lévai , Dániel
Hi all, I'm noticing that xfreerdp and remmina fails to connect to a Windows 11 machine while using NLA: $ xfreerdp /v:host /u:u...@example.com /d:MicrosoftAccount /sec:nla [17:04:04:954] [26344:92f3b640] [WARN][com.freerdp.crypto] - Certificate verification failure 'unable to get local issuer

Re: doas tab completion

2024-07-30 Thread Kirill A . Korinsky
On Mon, 29 Jul 2024 17:32:06 +0200, Florian Obser wrote: > > again, in .kshrc: > > HOST_LIST=`awk '{print $1}' < ~/.ssh/known_hosts | cut -f 1 -d, \ > | egrep -v '^[[:digit:]]|^$|\:\:' | sort -u` > > set -A complete_ssh -- ${HOST_LIST} > set -A complete_ping -- ${HOST_LIST} > set -A complet

Re: doas tab completion

2024-07-30 Thread Kirill A . Korinsky
On Mon, 29 Jul 2024 17:32:06 +0200, Florian Obser wrote: > > in .kshrc: > > set -A complete_doas_1 -- $(ls /sbin /usr/sbin /bin /usr/bin /usr/X11R6/bin \ > /usr/local/sbin /usr/local/bin) > I think this way is cleaner, isn't it? set -A complete_doas_1 -- $(echo $PATH | tr ':' '\n' | xargs

Re: Optimization Advice for High Resource Utilization PostgreSQL Query on OpenBSD

2024-07-30 Thread Kihaguru Gathura
Hi Claudio, Yes, I did run 'Explain Analyze' on the query to diagnose the performance issues. Based on the analysis, I created indexes on the relevant columns and ran a VACUUM on the tables. This resulted in an improvement, reducing CPU utilization from 40% to 30%. I haven't yet delved into expli

Re: Optimization Advice for High Resource Utilization PostgreSQL Query on OpenBSD

2024-07-30 Thread Matthias Pfeifer
On 30.07.24 14:04, Kihaguru Gathura wrote: Hi, I am seeking advice on optimizing a PostgreSQL query that is consuming a significant amount of CPU resources on my Dell PowerEdge T340 server. The server has an Intel Xeon E-2124 CPU @ 3.30GHz (4 cores, no Hyper-Threading) and 16GB RAM, runni

Re: doas tab completion

2024-07-30 Thread Страхиња Радић
Дана 24/07/30 05:32PM, Kirill A. Korinsky написа: > I think this way is cleaner, isn't it? > > set -A complete_doas_1 -- $(echo $PATH | tr ':' '\n' | xargs ls) Or, to limit the types of files to regular files or symlinks with execute bit set and avoid parsing the output of ls[1]: set -A complet

Re: iked authentication logging ?

2024-07-30 Thread J Doe
On 2024-07-25 03:11, Crystal Kolipe wrote: On Wed, Jul 24, 2024 at 06:20:26PM -0400, J Doe wrote: My hypothesis is that iked does not name an identity because this is certificate based authentication vs. MSCHAPv2 for EAP authentication which would provide an identity (ie: a username). Is that

Re: xfreerdp / remmina won't connect to Win11 RDP with NLA

2024-07-30 Thread Stuart Henderson
On 2024-07-30, Lévai Dániel wrote: > Hi all, > > I'm noticing that xfreerdp and remmina fails to connect to a Windows 11 > machine while using NLA: > > $ xfreerdp /v:host /u:u...@example.com /d:MicrosoftAccount /sec:nla > [17:04:04:954] [26344:92f3b640] [WARN][com.freerdp.crypto] - Certificate

Re: iked authentication logging ?

2024-07-30 Thread J Doe
On 2024-07-30 18:13, J Doe wrote: On 2024-07-25 03:11, Crystal Kolipe wrote: On Wed, Jul 24, 2024 at 06:20:26PM -0400, J Doe wrote: My hypothesis is that iked does not name an identity because this is certificate based authentication vs. MSCHAPv2 for EAP authentication which would provide an

Re: iked authentication logging ?

2024-07-30 Thread Stuart Henderson
On 2024-07-30, J Doe wrote: > As a result with continuing to experiment with my configuration, I ran > into a new issue. I followed the instructions in the OpenBSD FAQ[0] for > an X.509 configuration - in particular the following (with hostnames for > my server and Mac): > > server1# ikectl

Re: iked authentication logging ?

2024-07-30 Thread Stuart Henderson
On 2024/07/30 20:19, J Doe wrote: > On 2024-07-30 19:39, Stuart Henderson wrote: > > > On 2024-07-30, J Doe wrote: > > > As a result with continuing to experiment with my configuration, I ran > > > into a new issue. I followed the instructions in the OpenBSD FAQ[0] for > > > an X.509 configurati

Re: iked authentication logging ?

2024-07-30 Thread J Doe
On 2024-07-30 19:39, Stuart Henderson wrote: On 2024-07-30, J Doe wrote: As a result with continuing to experiment with my configuration, I ran into a new issue. I followed the instructions in the OpenBSD FAQ[0] for an X.509 configuration - in particular the following (with hostnames for my s

Re: iked authentication logging ?

2024-07-30 Thread J Doe
> On Jul 30, 2024, at 20:34, Stuart Henderson wrote: > > On 2024/07/30 20:19, J Doe wrote: >>> On 2024-07-30 19:39, Stuart Henderson wrote: >>> >>> On 2024-07-30, J Doe wrote: As a result with continuing to experiment with my configuration, I ran into a new issue. I followed the i

Re: iked authentication logging ?

2024-07-30 Thread Crystal Kolipe
On Tue, Jul 30, 2024 at 11:39:39PM -, Stuart Henderson wrote: > On 2024-07-30, J Doe wrote: > > As a result with continuing to experiment with my configuration, I ran > > into a new issue. I followed the instructions in the OpenBSD FAQ[0] for > > an X.509 configuration - in particular the fol