Re: support for using runas for pg

Hi,

The password prompting was happpened while using runas in win 2k & XP.As you mentioned in the previous mail i used a thirdy party utility to solve this issue and its working in XP &Win 2k. The third part utiity is a seperate pack which is called runasv, its not using the runas in windows. The utility providers ensures that the utility will work in NT also. This will behave similar to runas and without prompting password. In NT this utility is invoking innitdb, pg-ctl but creating an errorr as i mentioned in the previous mail. command execute will be similar as follows in command prompt
D:\runasv\Release>runasv "D:\Test\pg8.1.1ni\bin\initdb.exe -A "trust" -D "D:\Testing\pgsql8.1ni\data"" -h \DEVTEST\postgres password
after invoking this i am getting the dll error. syntax mentioned in the above command is as instructed by third party providers. If i am providing administrator rights to the user postgres and tried the above , then it is not showinng the dll error but pg will not work. I had provided read & execute rights for the user postgres to Kernl32.dll, user32.dll & for the folder of pg that contains libraries and exe's. Then also its not working. Hope ur doubt has cleared.

Mohamed Fazil
Magnus Hagander <mha(at)sollentuna(dot)net> wrote:
> Hi,
>
> I got a third party utility to run pgsql in non
> administrative users account and without prompting password.
> The utility providers ensure that the utility will work in
> NT. I used this utility for running pg8.1.1 and it shows me
> the following error with a prompt titled "ININTDB.EXE - DLL
> Initialization Failed" and the message "Initialization of
> Dynamic Link Library D:\WINNT\system32\KERNEL32.dll failed.
> The process is terminating abnormally". Before running this i
> had created new user named postgres without administrator
> rights. I tried by providing read & execute rights for the
> user postgres to Kernl32.dll, user32.dll & for the folder of
> pg that contains libraries and exe's. Then also it is showing
> the same error.

Does it work when you use runas (I know this is not a permanent solution
for you, but as a part of the debugging). IIRC, you said it did and the
problem was just that runas prompted for password - but was this on the
samme machine?

If it does work with runas, then you have a bug in the third party
program you're using, and you need to take it up with them.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

---------------------------------
Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!