Re: BUG #15049: Initdb.exe failing to create DB

2018-02-05 10:18 GMT+01:00 Dheeraj <dheeru(dot)chhabra(at)gmail(dot)com>:

> Hi Pavel,
>
> We have tried running command on command prompt with same user 'admrak'
> who is running the java program. The command works fine on command prompt
> but failing through java-program with below error.
>
> We have used unprivileged user( who is not part of Administrator group)
> also but still the same issue with java program.
>
> Please suggest what should we do differently to run the initdb.exe command
> through java program.
>

are you sure so your java user is unprivileged?

Regards

Pavel

>
> -Dheeraj
>
> Thanks and Regards
> Dheeraj Chhabra
> +91 8600149952 <+91%2086001%2049952>
>
> On Mon, Feb 5, 2018 at 1:37 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>
>> Hi
>>
>> doesn't look like PostgreSQL bug
>>
>> 2018-02-05 8:53 GMT+01:00 PG Bug reporting form <noreply(at)postgresql(dot)org>:
>>
>>> The following bug has been logged on the website:
>>>
>>> Bug reference: 15049
>>> Logged by: dheeraj chhabra
>>> Email address: dheeru(dot)chhabra(at)gmail(dot)com
>>> PostgreSQL version: 9.4.4
>>> Operating system: Windows 2012 R2
>>> Description:
>>>
>>> The DB creation is failing with below output:
>>>
>>> initdb: could not start process for command ""D:\BMC
>>> Software\TrueSightPServer\truesightpserver\modules\pgsql\bin\initdb.exe"
>>> -U
>>> SVC_BMCMON -A trust -E utf8 -D "D:\BMC
>>> Software\TrueSightPServer\truesightpserver\data\pgsql" -X "D:\BMC
>>> Software\TrueSightPServer\truesightpserver\data\pgsql_txnlog" --pwfile
>>> "D:\BMC
>>> Software\TrueSightPServer\truesightpserver\tmp\DBdata7317520
>>> 133955961463ks"":
>>> error code 1260
>>> initdb: could not re-execute with restricted token: error code 3
>>> The files belonging to this database system will be owned by user
>>> "admrak".
>>> This user must also own the server process.
>>>
>>> The database cluster will be initialized with locale
>>> "English_Australia.1252".
>>> The default text search configuration will be set to "english".
>>>
>>> Data page checksums are disabled.
>>>
>>> creating directory D:/BMC
>>> Software/TrueSightPServer/truesightpserver/data/pgsql ... ok
>>> creating directory D:/BMC
>>> Software/TrueSightPServer/truesightpserver/data/pgsql_txnlog ... ok
>>> creating subdirectories ... ok
>>> selecting default max_connections ... 10
>>> selecting default shared_buffers ... 400kB
>>> selecting dynamic shared memory implementation ... windows
>>> creating configuration files ... ok
>>> running bootstrap script ... Execution of PostgreSQL by a user with
>>> administrative permissions is not
>>> permitted.
>>> The server must be started under an unprivileged user ID to prevent
>>> possible system security compromises. See the documentation for
>>> more information on how to properly start the server.
>>> child process exited with exit code 1
>>>
>>
>> You are running initdb as privileged user. It is prohibited due
>> security.
>>
>> https://dba.stackexchange.com/questions/35056/trying-to-star
>> t-a-newly-created-cluster-in-postgresql-on-windows
>> https://www.postgresql.org/message-id/7be3f35d040930110679c1
>> 1892(at)mail(dot)gmail(dot)com
>>
>> Regards
>>
>> Pavel
>>
>>
>>
>>> initdb: removing data directory "D:/BMC
>>> Software/TrueSightPServer/truesightpserver/data/pgsql"
>>> initdb: removing transaction log directory "D:/BMC
>>> Software/TrueSightPServer/truesightpserver/data/pgsql_txnlog"
>>>
>>>
>>> Please suggest the resolution ASAP.
>>>
>>> -Dheeraj
>>>
>>>
>>
>