Re: [HACKERS] Window2012R2: initdb error: "The current directory is invalid."

Hi,

Thanks for reply sir,

>
> On 19 January 2016 at 18:49, Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com
> <mailto:huo-dangminh(at)ys(dot)jp(dot)nec(dot)com> > wrote:
>
>
> Hi all,
>
> I have failed in execute initdb in "c:\Windows\Temp\dir" folder
> as
> reproduce logs below. The OS's messages "The current directory is
> invalid."
> was returned.
>
>
>
> Is that directory or any parent of it a junction point?
>
> http://www.nirsoft.net/utils/ntfs_links_view.html
>
>
> http://superuser.com/q/823959
>
>

No, sir. As my confirmed results below.

---
c:\>dir c:\Windows | find "Temp"
2016/01/08 11:55 <DIR> CbsTemp
2016/01/20 13:10 <DIR> Temp

c:\>dir c:\Windows\temp\ | find "dir"
2016/01/19 18:55 <DIR> dir

c:\>
---

> Also, why would you possibly run the installer from there? You should be
> using %TEMP% which should generally resolve to
> C:\Users\{Username}\AppData\Local\Temp or similar.
>

Yes, I think it should be %USERPROFILE%\AppData\Local\Temp
(we specified %TEMP% or %TMP% when create installer).
But in one of my customer's environment, it became "c:\Windows\Temp\ ".

>
> creating template1 database in c:/testdb/base/1 ... The current
> directory is invalid.
>
>
> It looks like somehow the current working directory is unmapped or cannot
> be found.
>
> Is there any chance you have mapped network drives in use?
>

No sir, I have only one drive (C) in reproduce environment.

I have tested some more case and found that,
In Windows2012, execute some command in folder which is subordinate
of "C:\Windows\TEMP\" with user that insufficient permission to
access that folder will produce this error.

initdb was executed with "Administrator" privileges, but
then initdb do popen() with none "Administrator" privileges
(by child process).
Child process not have enough privileges to access to
Current folder ("c:\Windows\Temp\dir"), so the
"The current directory is invalid." message was produced.

I found this phenomenon only in "C:\Windows\TEMP\" (Windows2012R2).

Best regards,
Dang Minh Huong
NEC Solution Innovators, Ltd.
http://www.nec-solutioninnovators.co.jp/en/

> --
>
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services