Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mfjHr-000789-RW for pgsql-www@arkaria.postgresql.org; Wed, 27 Oct 2021 13:48:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mfjHq-0001s2-Pe for pgsql-www@arkaria.postgresql.org; Wed, 27 Oct 2021 13:48:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mfjHq-0001rq-JS for pgsql-www@lists.postgresql.org; Wed, 27 Oct 2021 13:48:14 +0000 Received: from mail-lf1-x131.google.com ([2a00:1450:4864:20::131]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mfjHn-0003O8-2R for pgsql-www@lists.postgresql.org; Wed, 27 Oct 2021 13:48:14 +0000 Received: by mail-lf1-x131.google.com with SMTP id bq11so6280853lfb.10 for ; Wed, 27 Oct 2021 06:48:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hagander-net.20210112.gappssmtp.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=Zxy7PYN5Akdz6E65NYPvluHde/Vr79lH2pU046iJzgo=; b=YzAEV4cCfWmU/8E/irZrXa6hbTWk2e16TIS5I3PeMHkydiiJgZq+vBB00XhTra2KD5 ox8cSTQKpGpb5heqUfZmeCjb9i/StBkgXmsq04vmjTC6gXI8wK1+HixKKknF/jsCdnMB mNFoDs0SGeO7iJ+VKvQ2h6S4nn9psFt3OB4bpM/V09dizOc56ct4/Tbe6jakO/RVJgbO EgVBc/uUrlLN6QZIuda4slPjrSG687mo7LNwrPlC288gzGNyxY8tRaWpCNHxYCxjuWR8 bZa2iwXh7L/24l1H/4WsMMagN10dwwaZHWOpGtY8nyO7NIBuW9ieZOQhCPC7vmSRveiw qH0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=Zxy7PYN5Akdz6E65NYPvluHde/Vr79lH2pU046iJzgo=; b=XxODrd+o1ZsE3fnL5bOiA5ATzZDOX72WJ0g7bbWH0AH5bCH/Jwqf2YqpGF6RK0OyVh LRNYOCaiucbz/KoYH61exv5+QYNVf1NXZ/RL386ry9ppJ9FRpXHxNf13BvWOFCSRvr1P Dy6qjsqKMJylph2xYrWnSa9GiIXQIAxMDdBNX8FbLNnlOIahMooAI8t59EY8IAlLplOq UvJ3mGi2PxnrLSarvpe57moOBsYRV8zFrL/vDS5spl6TBwKSF+xELq3tkBM7B+Njhqko KxlF8VanR7M24V3F7Lb59aEbugecJ2ocR+UMSvBWmnb1urDps16r5mVGLKkxCiMi/Pv7 Dnlw== X-Gm-Message-State: AOAM533NP62qBKbQPA7dTwNb7dD5gSj27lXHLJQ8AXzdq3C2Mt6qSZhC twH2wDzlUtUgXOgDJ4DbnjTPMRT/Fljl8lStd9/rrg== X-Google-Smtp-Source: ABdhPJzppCkZh5McOtcIm6KIWPdRhP++oHrMXibJGEi3zXcmojWVoKZ1UXMgFMptFZ2yrP5PBo7cflkOBu09NkL/7Nc= X-Received: by 2002:a19:520a:: with SMTP id m10mr28338859lfb.399.1635342490264; Wed, 27 Oct 2021 06:48:10 -0700 (PDT) MIME-Version: 1.0 References: <21fbb020-83c6-33e5-9cfe-0aee56badf3e@cmatte.me> <3ee3217a-b014-7601-47f5-775428d1e39d@cmatte.me> In-Reply-To: <3ee3217a-b014-7601-47f5-775428d1e39d@cmatte.me> From: Magnus Hagander Date: Wed, 27 Oct 2021 15:47:59 +0200 Message-ID: Subject: Re: [PATCH] pgweb: Search: bugfix: replace sites.baseurl with sites.hostname To: =?UTF-8?Q?C=C3=A9lestin_Matte?= , "Jonathan S. Katz" Cc: PostgreSQL WWW Content-Type: multipart/alternative; boundary="00000000000037fce905cf55d873" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000037fce905cf55d873 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Oct 25, 2021 at 6:19 PM C=C3=A9lestin Matte wrote: > Hello, > > > But short term, I believe the correct thing to do is to add the baseurl > field to the table in the SQL file. I'll go push a patch taht does that. > > This broke data.sql as baseurl is NOT NULL. Attached patch fixes that. > This might have also broken the crawler but I haven't installed it to tes= t > that. > Indeed it does. Oops. That said, most of that file are not-current examples, and should just be cleaned out, so I'll do that while fixing this. Yeah, another sign that this needs some proper spring cleaning to get rid of configuration of the flexibility that we don't care about. But tihs one for now, to unbreak things short-term. --=20 Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/ --00000000000037fce905cf55d873 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Oct 25, 2021 at 6:19 PM C=C3=A9le= stin Matte <celestin.matte@c= matte.me> wrote:
Hello,

> But short term, I believe the correct thing to do is to add the baseur= l field to the table in the SQL file. I'll go push a patch taht does th= at.

This broke data.sql as baseurl is NOT NULL. Attached patch fixes that.
This might have also broken the crawler but I haven't installed it to t= est that.

Indeed it does. Oops.

That said, most of that file are not-current examples, an= d should just be cleaned out, so I'll do that while fixing this.
<= div>
Yeah, another sign that this needs some proper spring cl= eaning to get rid of configuration of the flexibility that we don't car= e about. But tihs one for now, to unbreak things short-term.

=
--
=C2=A0Magnus Hagander
=C2=A0Me: https://www.hagander.net/
=C2=A0Work: https://www.redpill-= linpro.com/
--00000000000037fce905cf55d873--