Mailing List Archive: Trac psycopg2 connection string escape character

Trac psycopg2 connection string escape character

Jun 2, 2022, 12:04 AM

Post #1 of 3 (333 views)

I'm trying to install Trac 1.5.3 on Ubuntu 20.04 LTS server using
PostgreSQL/psycopg2.

My password contains '@' twice and the installer barfs at that.

I've tried all the quote characters known to me (``, `', '', "", ||)
around the password and also tried backslashing the @ symbols and
doubling them - all to no avail.

How can I use my existing database password?

Thanks

Mike

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/fc0ecec3-e8f3-4817-dbfe-7ab14333b686%40dewhirst.com.au.

Re: Trac psycopg2 connection string escape character [ In reply to ]

jun66j5 at gmail

Jun 2, 2022, 12:13 AM

Post #2 of 3 (333 views)

Permalink

On Thu, Jun 2, 2022 at 4:04 PM Mike Dewhirst <miked@dewhirst.com.au> wrote:
>
> I'm trying to install Trac 1.5.3 on Ubuntu 20.04 LTS server using
> PostgreSQL/psycopg2.
>
> My password contains '@' twice and the installer barfs at that.
>
> I've tried all the quote characters known to me (``, `', '', "", ||)
> around the password and also tried backslashing the @ symbols and
> doubling them - all to no avail.
>
> How can I use my existing database password?

See https://trac.edgewall.org/wiki/TracEnvironment#DatabaseConnectionStrings

The page says: Note that if the username or password of the connection
string (if applicable) contains the :, / or @ characters, they need to
be URL encoded.

--
Jun Omae <jun66j5@gmail.com> (?? ?)

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CAEVLMaiQJvc-4HUUMcB-PtxdkEWuHvouZhN6AKrq2UHW2dSr6g%40mail.gmail.com.

Re: Trac psycopg2 connection string escape character [ In reply to ]

miked at dewhirst

Jun 2, 2022, 12:20 AM

Post #3 of 3 (333 views)

Permalink

On 2/06/2022 5:13 pm, Jun Omae wrote:
> On Thu, Jun 2, 2022 at 4:04 PM Mike Dewhirst <miked@dewhirst.com.au> wrote:
>> I'm trying to install Trac 1.5.3 on Ubuntu 20.04 LTS server using
>> PostgreSQL/psycopg2.
>>
>> My password contains '@' twice and the installer barfs at that.
>>
>> I've tried all the quote characters known to me (``, `', '', "", ||)
>> around the password and also tried backslashing the @ symbols and
>> doubling them - all to no avail.
>>
>> How can I use my existing database password?
> See https://trac.edgewall.org/wiki/TracEnvironment#DatabaseConnectionStrings
>
> The page says: Note that if the username or password of the connection
> string (if applicable) contains the :, / or @ characters, they need to
> be URL encoded.

Many thanks - that worked :-)

Mike

>

--
Signed email is an absolute defence against phishing. This email has
been signed with my private key. If you import my public key you can
automatically decrypt my signature and be sure it came from me. Just
ask and I'll send it to you. Your email software can handle signing.

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/fb1c4527-ff01-e621-41a4-ca96315f40bf%40dewhirst.com.au.

Mailing List Archive

Attached Files:

Attached Files: