edb installation failed for pgadmin when username is Chinese under c;\user #7432

Started by 周志勤almost 2 years ago15 messagesbugs
Jump to latest
#1周志勤
joe.zhou@dualhelios.com

Hi,pgsql-bugs

I have reported a bug to pgadmin regarding the issue on the email title. However pagadmin team refer me to your team that it's under your responsibility.

Shall I open a new ticket or your moderator can dispature the following to your team ?

Thanks and best regards,
Joe

view it on GitHub

joe.zhou@dualhelios.com

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: 周志勤 (#1)
Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

On Sun, 2024-04-28 at 09:03 +0800, 周志勤 wrote:

https://github.com/pgadmin-org/pgadmin4/issues/7432
I have reported a bug to pgadmin regarding the issue on the email title. However
pagadmin team refer me to your team  that it's  under your responsibility.

Shall I open a new ticket or your moderator can dispature the following to your team ?

Sorry, for playing poing pong, but I'd say that somebody at EnterpriseDB is
not doing his job. The error image in the referenced issue shows an error
caused by a Windows executable called "icacls" invoked on a directory called
"windows_installer_<something>".

There is no reference to either of that in the PostgreSQL source. Perhaps the
error is connected to some PostgreSQL misbehavior, but that is not obvious.
This clearly needs investigation by the people that wrote the Windows installer.
They can then report a PostgreSQL bug if they think it is one.

Yours,
Laurenz Albe

#3Thomas Munro
thomas.munro@gmail.com
In reply to: Laurenz Albe (#2)
Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

On Tue, Apr 30, 2024 at 5:32 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:

On Sun, 2024-04-28 at 09:03 +0800, 周志勤 wrote:

https://github.com/pgadmin-org/pgadmin4/issues/7432
I have reported a bug to pgadmin regarding the issue on the email title. However
pagadmin team refer me to your team that it's under your responsibility.

Shall I open a new ticket or your moderator can dispature the following to your team ?

Sorry, for playing poing pong, but I'd say that somebody at EnterpriseDB is
not doing his job. The error image in the referenced issue shows an error
caused by a Windows executable called "icacls" invoked on a directory called
"windows_installer_<something>".

I guess the point is that it's not a pgadmin installer bug, it's a
postgresql installer bug (also not a pgsql-bugs@ issue, but getting
closer...).

There is no reference to either of that in the PostgreSQL source. Perhaps the

Nothing to do with me, but in the interests of skipping a ping pong
cycle or two, I guess it's an encoding problem around here, and I know
who works on that (CCing Sandeep):

https://github.com/EnterpriseDB/edb-installers/blob/REL-16/server/scripts/windows/initcluster.vbs#L411

#4Thomas Munro
thomas.munro@gmail.com
In reply to: 周志勤 (#1)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

On Tue, Apr 30, 2024 at 1:40 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

What's your suggestion on way fowrard ? Shall I register a case towards "enterprisedb windows installer" to Sandeep? How?

I'd start by filing a bug report here:

https://github.com/EnterpriseDB/edb-installers/issues

#5Sandeep Thakkar
sandeep.thakkar@enterprisedb.com
In reply to: 周志勤 (#1)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Hi Joe,

Thanks for the report. I'll check and revert.

On Tue, Apr 30, 2024 at 8:01 AM 周志勤 <joe.zhou@dualhelios.com> wrote:

Hi,Sandeep

Please be informed that the following #106 case has been registered for
your investigation.

https://github.com/EnterpriseDB/edb-installers/issues/106

Best regards,
Joe

------------------------------
joe.zhou@dualhelios.com

*From:* Thomas Munro <thomas.munro@gmail.com>
*Date:* 2024-04-30 10:14
*To:* 周志勤 <joe.zhou@dualhelios.com>
*CC:* Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-bugs
<pgsql-bugs@postgresql.org>; Sandeep Thakkar
<sandeep.thakkar@enterprisedb.com>
*Subject:* Re: Re: edb installation failed for pgadmin when username is
Chinese under c;\user #7432
On Tue, Apr 30, 2024 at 1:40 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

What's your suggestion on way fowrard ? Shall I register a case

towards "enterprisedb windows installer" to Sandeep? How?

I'd start by filing a bug report here:

https://github.com/EnterpriseDB/edb-installers/issues

--
Sandeep Thakkar

#6周志勤
joe.zhou@dualhelios.com
In reply to: 周志勤 (#1)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Hi,Thomas & all

I have reported a bug on postgreSQL on the bug in the title as you advised.

However it has been rejected by postgreSQL as they think it should be reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql to avoid ping-pong there ? or I have some misuderstanding there?

Thanks and best regards,
Joe

joe.zhou@dualhelios.com

From: Thomas Munro
Date: 2024-04-30 10:14
To: 周志勤
CC: Laurenz Albe; pgsql-bugs; Sandeep Thakkar
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
On Tue, Apr 30, 2024 at 1:40 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

What's your suggestion on way fowrard ? Shall I register a case towards "enterprisedb windows installer" to Sandeep? How?

I'd start by filing a bug report here:

https://github.com/EnterpriseDB/edb-installers/issues

#7Thomas Munro
thomas.munro@gmail.com
In reply to: 周志勤 (#6)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you

advised.

However it has been rejected by postgreSQL as they think it should be

reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql to

avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be still
open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that
https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be in
the right place to talk to the right people about that, or if not,
hopefully they will explain why not. As for why you saw that error when
you were installing PGAdmin, leading to the first ping-pong cycle, perhaps
the Windows installer for #3 also installs #2 or something like that? I
dunno because I don't use Windows or those installers myself... I was just
trying to redirect things to the right people... Hopefully there will be a
response there!

#8周志勤
joe.zhou@dualhelios.com
In reply to: 周志勤 (#1)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue is on the right place,i.e. EDB PostgreSQL installer and Sandeep is working on that.

If it turns out to be some connecting issue in pgadmin or even postgreSQL after Sandeep's investigation, then we can turn to them respectively. Correct?

Best regards,
Joe

joe.zhou@dualhelios.com

From: Thomas Munro
Date: 2024-05-06 09:37
To: 周志勤
CC: Laurenz Albe; pgsql-bugs; Sandeep Thakkar; pgsql-bugs-owner
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you advised.

However it has been rejected by postgreSQL as they think it should be reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql to avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be in the right place to talk to the right people about that, or if not, hopefully they will explain why not. As for why you saw that error when you were installing PGAdmin, leading to the first ping-pong cycle, perhaps the Windows installer for #3 also installs #2 or something like that? I dunno because I don't use Windows or those installers myself... I was just trying to redirect things to the right people... Hopefully there will be a response there!

#9Sandeep Thakkar
sandeep.thakkar@enterprisedb.com
In reply to: 周志勤 (#8)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Hi,

We have identified a bug in the PostgreSQL installer and fixed it. But with
further testing of the generated installer, we are seeing an intermittent
issue with the ACL on the data directory and starting of the service. Would
it be possible for you to install the test installer and confirm if the
installation is successful ? The test installer (not for production use) is
available for download here
<https://drive.google.com/file/d/1LAIglpCNLqZhYeMC4MAC279ytL_58i8v/view?usp=drive_link&gt;

thanks

On Mon, May 6, 2024 at 7:39 AM 周志勤 <joe.zhou@dualhelios.com> wrote:

Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue is
on the right place,i.e. EDB PostgreSQL installer and Sandeep is working on
that.

If it turns out to be some connecting issue in pgadmin or even postgreSQL
after Sandeep's investigation, then we can turn to them respectively.
Correct?

Best regards,
Joe

------------------------------
joe.zhou@dualhelios.com

*From:* Thomas Munro <thomas.munro@gmail.com>
*Date:* 2024-05-06 09:37
*To:* 周志勤 <joe.zhou@dualhelios.com>
*CC:* Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-bugs
<pgsql-bugs@postgresql.org>; Sandeep Thakkar
<sandeep.thakkar@enterprisedb.com>; pgsql-bugs-owner
<pgsql-bugs-owner@lists.postgresql.org>
*Subject:* Re: Re: edb installation failed for pgadmin when username is
Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you

advised.

However it has been rejected by postgreSQL as they think it should be

reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql to

avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be
still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that
https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be in
the right place to talk to the right people about that, or if not,
hopefully they will explain why not. As for why you saw that error when
you were installing PGAdmin, leading to the first ping-pong cycle, perhaps
the Windows installer for #3 also installs #2 or something like that? I
dunno because I don't use Windows or those installers myself... I was just
trying to redirect things to the right people... Hopefully there will be a
response there!

--
Sandeep Thakkar

#10周志勤
joe.zhou@dualhelios.com
In reply to: 周志勤 (#1)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Hi Sandeep

Would it be possible for you to move the package to somewhere other than google driver as google is not accessiable from main land China here?

Best regards,
Joe

joe.zhou@dualhelios.com

From: Sandeep Thakkar
Date: 2024-05-09 00:04
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Hi,

We have identified a bug in the PostgreSQL installer and fixed it. But with further testing of the generated installer, we are seeing an intermittent issue with the ACL on the data directory and starting of the service. Would it be possible for you to install the test installer and confirm if the installation is successful ? The test installer (not for production use) is available for download here

thanks

On Mon, May 6, 2024 at 7:39 AM 周志勤 <joe.zhou@dualhelios.com> wrote:
Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue is on the right place,i.e. EDB PostgreSQL installer and Sandeep is working on that.

If it turns out to be some connecting issue in pgadmin or even postgreSQL after Sandeep's investigation, then we can turn to them respectively. Correct?

Best regards,
Joe

joe.zhou@dualhelios.com

From: Thomas Munro
Date: 2024-05-06 09:37
To: 周志勤
CC: Laurenz Albe; pgsql-bugs; Sandeep Thakkar; pgsql-bugs-owner
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you advised.

However it has been rejected by postgreSQL as they think it should be reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql to avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be in the right place to talk to the right people about that, or if not, hopefully they will explain why not. As for why you saw that error when you were installing PGAdmin, leading to the first ping-pong cycle, perhaps the Windows installer for #3 also installs #2 or something like that? I dunno because I don't use Windows or those installers myself... I was just trying to redirect things to the right people... Hopefully there will be a response there!

--
Sandeep Thakkar

#11周志勤
joe.zhou@dualhelios.com
In reply to: 周志勤 (#1)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Hi Sandeep

I have installed the test package you delivered. The installation is succesful with installation log attached.

Please check the log to see if you can close the issue.

Best regards,
Joe

joe.zhou@dualhelios.com

From: Sandeep Thakkar
Date: 2024-05-09 00:04
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Hi,

We have identified a bug in the PostgreSQL installer and fixed it. But with further testing of the generated installer, we are seeing an intermittent issue with the ACL on the data directory and starting of the service. Would it be possible for you to install the test installer and confirm if the installation is successful ? The test installer (not for production use) is available for download here

thanks

On Mon, May 6, 2024 at 7:39 AM 周志勤 <joe.zhou@dualhelios.com> wrote:
Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue is on the right place,i.e. EDB PostgreSQL installer and Sandeep is working on that.

If it turns out to be some connecting issue in pgadmin or even postgreSQL after Sandeep's investigation, then we can turn to them respectively. Correct?

Best regards,
Joe

joe.zhou@dualhelios.com

From: Thomas Munro
Date: 2024-05-06 09:37
To: 周志勤
CC: Laurenz Albe; pgsql-bugs; Sandeep Thakkar; pgsql-bugs-owner
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you advised.

However it has been rejected by postgreSQL as they think it should be reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql to avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be in the right place to talk to the right people about that, or if not, hopefully they will explain why not. As for why you saw that error when you were installing PGAdmin, leading to the first ping-pong cycle, perhaps the Windows installer for #3 also installs #2 or something like that? I dunno because I don't use Windows or those installers myself... I was just trying to redirect things to the right people... Hopefully there will be a response there!

--
Sandeep Thakkar

Attachments:

install-postgresql.logapplication/octet-stream; name=install-postgresql.logDownload
#12Sandeep Thakkar
sandeep.thakkar@enterprisedb.com
In reply to: 周志勤 (#11)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Hi Joe,

Looking at the installation log, it seems the installer is not
returning the reported error message but I see the post installation steps
like creation of cluster and starting of the services missing. Are you
running the installer with a non-admin user account? Or did you run the
installer in the extract-only mode?

On Thu, May 9, 2024 at 1:14 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

Hi Sandeep

I have installed the test package you delivered. The installation is
succesful with installation log attached.

Please check the log to see if you can close the issue.

Best regards,
Joe

------------------------------
joe.zhou@dualhelios.com

*From:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
*Date:* 2024-05-09 00:04
*To:* 周志勤 <joe.zhou@dualhelios.com>
*CC:* Thomas Munro <thomas.munro@gmail.com>; Laurenz Albe
<laurenz.albe@cybertec.at>; pgsql-bugs <pgsql-bugs@postgresql.org>; Muralikrishna
Bandaru <muralikrishna.bandaru@enterprisedb.com>
*Subject:* Re: Re: edb installation failed for pgadmin when username is
Chinese under c;\user #7432
Hi,

We have identified a bug in the PostgreSQL installer and fixed it. But
with further testing of the generated installer, we are seeing an
intermittent issue with the ACL on the data directory and starting of the
service. Would it be possible for you to install the test installer and
confirm if the installation is successful ? The test installer (not for
production use) is available for download here
<https://drive.google.com/file/d/1LAIglpCNLqZhYeMC4MAC279ytL_58i8v/view?usp=drive_link&gt;

thanks

On Mon, May 6, 2024 at 7:39 AM 周志勤 <joe.zhou@dualhelios.com> wrote:

Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue
is on the right place,i.e. EDB PostgreSQL installer and Sandeep is working
on that.

If it turns out to be some connecting issue in pgadmin or even postgreSQL
after Sandeep's investigation, then we can turn to them respectively.
Correct?

Best regards,
Joe

------------------------------
joe.zhou@dualhelios.com

*From:* Thomas Munro <thomas.munro@gmail.com>
*Date:* 2024-05-06 09:37
*To:* 周志勤 <joe.zhou@dualhelios.com>
*CC:* Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-bugs
<pgsql-bugs@postgresql.org>; Sandeep Thakkar
<sandeep.thakkar@enterprisedb.com>; pgsql-bugs-owner
<pgsql-bugs-owner@lists.postgresql.org>
*Subject:* Re: Re: edb installation failed for pgadmin when username is
Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you

advised.

However it has been rejected by postgreSQL as they think it should be

reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql

to avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be
still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that
https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be
in the right place to talk to the right people about that, or if not,
hopefully they will explain why not. As for why you saw that error when
you were installing PGAdmin, leading to the first ping-pong cycle, perhaps
the Windows installer for #3 also installs #2 or something like that? I
dunno because I don't use Windows or those installers myself... I was just
trying to redirect things to the right people... Hopefully there will be a
response there!

--
Sandeep Thakkar

--
Sandeep Thakkar

#13周志勤
joe.zhou@dualhelios.com
In reply to: 周志勤 (#1)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Hi,Sandeep

See my comments/answers inline in pink.

joe.zhou@dualhelios.com

From: Sandeep Thakkar
Date: 2024-05-09 17:06
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Hi Joe,

Looking at the installation log, it seems the installer is not returning the reported error message but I see the post installation steps like creation of cluster and starting of the services missing.
[Joe]: pgadmin was the only component i selected to install, as this was the error I encoutered last time. No database installation, I guess this explain no service starting etc.

Are you running the installer with a non-admin user account?
[Joe]: No, with admin.

Or did you run the installer in the extract-only mode?
[Joe]: only pgadmin installation.

On Thu, May 9, 2024 at 1:14 PM 周志勤 <joe.zhou@dualhelios.com> wrote:
Hi Sandeep

I have installed the test package you delivered. The installation is succesful with installation log attached.

Please check the log to see if you can close the issue.

Best regards,
Joe

joe.zhou@dualhelios.com

From: Sandeep Thakkar
Date: 2024-05-09 00:04
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Hi,

We have identified a bug in the PostgreSQL installer and fixed it. But with further testing of the generated installer, we are seeing an intermittent issue with the ACL on the data directory and starting of the service. Would it be possible for you to install the test installer and confirm if the installation is successful ? The test installer (not for production use) is available for download here

thanks

On Mon, May 6, 2024 at 7:39 AM 周志勤 <joe.zhou@dualhelios.com> wrote:
Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue is on the right place,i.e. EDB PostgreSQL installer and Sandeep is working on that.

If it turns out to be some connecting issue in pgadmin or even postgreSQL after Sandeep's investigation, then we can turn to them respectively. Correct?

Best regards,
Joe

joe.zhou@dualhelios.com

From: Thomas Munro
Date: 2024-05-06 09:37
To: 周志勤
CC: Laurenz Albe; pgsql-bugs; Sandeep Thakkar; pgsql-bugs-owner
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you advised.

However it has been rejected by postgreSQL as they think it should be reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql to avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be in the right place to talk to the right people about that, or if not, hopefully they will explain why not. As for why you saw that error when you were installing PGAdmin, leading to the first ping-pong cycle, perhaps the Windows installer for #3 also installs #2 or something like that? I dunno because I don't use Windows or those installers myself... I was just trying to redirect things to the right people... Hopefully there will be a response there!

--
Sandeep Thakkar

--
Sandeep Thakkar

#14Sandeep Thakkar
sandeep.thakkar@enterprisedb.com
In reply to: 周志勤 (#13)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

Ah I got it now. So the installation looks good.

Please note the PostgreSQL maintenance releases will be available for
download today. They will include this fix.

Thank you

On Thu, May 9, 2024 at 3:06 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

Hi,Sandeep

See my comments/answers inline in pink.

------------------------------
joe.zhou@dualhelios.com

*From:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
*Date:* 2024-05-09 17:06
*To:* 周志勤 <joe.zhou@dualhelios.com>
*CC:* Thomas Munro <thomas.munro@gmail.com>; Laurenz Albe
<laurenz.albe@cybertec.at>; pgsql-bugs <pgsql-bugs@postgresql.org>; Muralikrishna
Bandaru <muralikrishna.bandaru@enterprisedb.com>
*Subject:* Re: Re: edb installation failed for pgadmin when username is
Chinese under c;\user #7432
Hi Joe,

Looking at the installation log, it seems the installer is not
returning the reported error message but I see the post installation steps
like creation of cluster and starting of the services missing.
[Joe]: pgadmin was the only component i selected to install, as this was
the error I encoutered last time. No database installation, I guess this
explain no service starting etc.

Are you running the installer with a non-admin user account?
[Joe]: No, with admin.

Or did you run the installer in the extract-only mode?
[Joe]: only pgadmin installation.

On Thu, May 9, 2024 at 1:14 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

Hi Sandeep

I have installed the test package you delivered. The installation is
succesful with installation log attached.

Please check the log to see if you can close the issue.

Best regards,
Joe

------------------------------
joe.zhou@dualhelios.com

*From:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
*Date:* 2024-05-09 00:04
*To:* 周志勤 <joe.zhou@dualhelios.com>
*CC:* Thomas Munro <thomas.munro@gmail.com>; Laurenz Albe
<laurenz.albe@cybertec.at>; pgsql-bugs <pgsql-bugs@postgresql.org>; Muralikrishna
Bandaru <muralikrishna.bandaru@enterprisedb.com>
*Subject:* Re: Re: edb installation failed for pgadmin when username is
Chinese under c;\user #7432
Hi,

We have identified a bug in the PostgreSQL installer and fixed it. But
with further testing of the generated installer, we are seeing an
intermittent issue with the ACL on the data directory and starting of the
service. Would it be possible for you to install the test installer and
confirm if the installation is successful ? The test installer (not for
production use) is available for download here
<https://drive.google.com/file/d/1LAIglpCNLqZhYeMC4MAC279ytL_58i8v/view?usp=drive_link&gt;

thanks

On Mon, May 6, 2024 at 7:39 AM 周志勤 <joe.zhou@dualhelios.com> wrote:

Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue
is on the right place,i.e. EDB PostgreSQL installer and Sandeep is working
on that.

If it turns out to be some connecting issue in pgadmin or even
postgreSQL after Sandeep's investigation, then we can turn to them
respectively. Correct?

Best regards,
Joe

------------------------------
joe.zhou@dualhelios.com

*From:* Thomas Munro <thomas.munro@gmail.com>
*Date:* 2024-05-06 09:37
*To:* 周志勤 <joe.zhou@dualhelios.com>
*CC:* Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-bugs
<pgsql-bugs@postgresql.org>; Sandeep Thakkar
<sandeep.thakkar@enterprisedb.com>; pgsql-bugs-owner
<pgsql-bugs-owner@lists.postgresql.org>
*Subject:* Re: Re: edb installation failed for pgadmin when username is
Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you

advised.

However it has been rejected by postgreSQL as they think it should be

reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql

to avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be
still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that
https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be
in the right place to talk to the right people about that, or if not,
hopefully they will explain why not. As for why you saw that error when
you were installing PGAdmin, leading to the first ping-pong cycle, perhaps
the Windows installer for #3 also installs #2 or something like that? I
dunno because I don't use Windows or those installers myself... I was just
trying to redirect things to the right people... Hopefully there will be a
response there!

--
Sandeep Thakkar

--
Sandeep Thakkar

--
Sandeep Thakkar

#15周志勤
joe.zhou@dualhelios.com
In reply to: 周志勤 (#1)
Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432

This sounds a good news for all Asia-Pacific region users using non english characters in the installation directory.

joe.zhou@dualhelios.com

From: Sandeep Thakkar
Date: 2024-05-09 18:09
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Ah I got it now. So the installation looks good.

Please note the PostgreSQL maintenance releases will be available for download today. They will include this fix.

Thank you

On Thu, May 9, 2024 at 3:06 PM 周志勤 <joe.zhou@dualhelios.com> wrote:
Hi,Sandeep

See my comments/answers inline in pink.

joe.zhou@dualhelios.com

From: Sandeep Thakkar
Date: 2024-05-09 17:06
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Hi Joe,

Looking at the installation log, it seems the installer is not returning the reported error message but I see the post installation steps like creation of cluster and starting of the services missing.
[Joe]: pgadmin was the only component i selected to install, as this was the error I encoutered last time. No database installation, I guess this explain no service starting etc.

Are you running the installer with a non-admin user account?
[Joe]: No, with admin.

Or did you run the installer in the extract-only mode?
[Joe]: only pgadmin installation.

On Thu, May 9, 2024 at 1:14 PM 周志勤 <joe.zhou@dualhelios.com> wrote:
Hi Sandeep

I have installed the test package you delivered. The installation is succesful with installation log attached.

Please check the log to see if you can close the issue.

Best regards,
Joe

joe.zhou@dualhelios.com

From: Sandeep Thakkar
Date: 2024-05-09 00:04
To: 周志勤
CC: Thomas Munro; Laurenz Albe; pgsql-bugs; Muralikrishna Bandaru
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Hi,

We have identified a bug in the PostgreSQL installer and fixed it. But with further testing of the generated installer, we are seeing an intermittent issue with the ACL on the data directory and starting of the service. Would it be possible for you to install the test installer and confirm if the installation is successful ? The test installer (not for production use) is available for download here

thanks

On Mon, May 6, 2024 at 7:39 AM 周志勤 <joe.zhou@dualhelios.com> wrote:
Hi,Thomas

Thanks for your quick response.

If I understand what you mentioned below correctly, I suppose the issue is on the right place,i.e. EDB PostgreSQL installer and Sandeep is working on that.

If it turns out to be some connecting issue in pgadmin or even postgreSQL after Sandeep's investigation, then we can turn to them respectively. Correct?

Best regards,
Joe

joe.zhou@dualhelios.com

From: Thomas Munro
Date: 2024-05-06 09:37
To: 周志勤
CC: Laurenz Albe; pgsql-bugs; Sandeep Thakkar; pgsql-bugs-owner
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
On Mon, May 6, 2024 at 1:15 PM 周志勤 <joe.zhou@dualhelios.com> wrote:

I have reported a bug on postgreSQL on the bug in the title as you advised.

However it has been rejected by postgreSQL as they think it should be reported on pgadmin.

Do you have any coordination mechnism bewteen pgadmin and postgresql to avoid ping-pong there ? or I have some misuderstanding there?

Hi Joe,

https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be still open, no?

Note there are three separate projects here:

1. PostgreSQL (that's what this mailing list, pgsql-bugs, is about)
2. EDB PostgreSQL installer for Windows
3. PGAdmin (a GUI for using PostgreSQL)

As far as I can tell so far, the problem you reported is in #2, and that https://github.com/EnterpriseDB/edb-installers/issues/106 seems to be in the right place to talk to the right people about that, or if not, hopefully they will explain why not. As for why you saw that error when you were installing PGAdmin, leading to the first ping-pong cycle, perhaps the Windows installer for #3 also installs #2 or something like that? I dunno because I don't use Windows or those installers myself... I was just trying to redirect things to the right people... Hopefully there will be a response there!

--
Sandeep Thakkar

--
Sandeep Thakkar

--
Sandeep Thakkar