From mohdfazil_p_a@yahoo.com Fri Jan 6 07:15:12 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A99689DCB5E for ; Fri, 6 Jan 2006 03:15:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44846-04 for ; Fri, 6 Jan 2006 03:15:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31006.mail.mud.yahoo.com (web31006.mail.mud.yahoo.com [68.142.200.169]) by postgresql.org (Postfix) with SMTP id 936759DCB4D for ; Fri, 6 Jan 2006 03:15:09 -0400 (AST) Received: (qmail 48547 invoked by uid 60001); 6 Jan 2006 07:15:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=2xQUutrZI7901KA80tN21INQjMLOWCAQOOW2eedpgMQDVk/akk0ZaATwT5C/Hq3LdH17LKbUP7zCxT8jY0ya+AdSpTs+3vVmVHlY8y+cZRkalv7+ME66i4HEu00cZAwQde2cOl7VSHhlLnaB1JhujoLoR9Vjh93ChzNbPVDWpVA= ; Message-ID: <20060106071510.48545.qmail@web31006.mail.mud.yahoo.com> Received: from [220.227.114.194] by web31006.mail.mud.yahoo.com via HTTP; Thu, 05 Jan 2006 23:15:10 PST Date: Thu, 5 Jan 2006 23:15:10 -0800 (PST) From: Mohamed Fazil Subject: support for using runas for pg To: magnus , pg-admin postgre MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1522134078-1136531710=:44417" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.537 required=5 tests=[AWL=0.057, DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.537 X-Spam-Level: X-Archive-Number: 200601/77 X-Sequence-Number: 20165 --0-1522134078-1136531710=:44417 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, Thanks for the support provided by you guys. I am able to run the application using runas.exe but it does not allows me to provide the domain password with the same command. Could you please provide me a solution to provide password with it. Also Is there any utility to run postgres as a different user in NT. Please help me out. Regards Mohamed Fazil --------------------------------- Yahoo! DSL Something to write home about. Just $16.99/mo. or less --0-1522134078-1136531710=:44417 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi,
 
Thanks for the support provided by you guys. I am able to run the application using runas.exe but it does not allows me to provide the domain password with the same command. Could you please provide me a solution to provide password with it. Also Is there any utility to run postgres as a different user in NT. Please help me out.
 
Regards
Mohamed Fazil


Yahoo! DSL Something to write home about. Just $16.99/mo. or less --0-1522134078-1136531710=:44417-- From mha@sollentuna.net Fri Jan 6 16:09:22 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 140189DC816 for ; Fri, 6 Jan 2006 12:09:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40908-08 for ; Fri, 6 Jan 2006 12:09:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx-2.sollentuna.net (mx-2.sollentuna.net [195.84.163.199]) by postgresql.org (Postfix) with ESMTP id C1D9B9DC869 for ; Fri, 6 Jan 2006 12:09:19 -0400 (AST) Received: from ALGOL.sollentuna.se (janus.sollentuna.se [62.65.68.67]) by mx-2.sollentuna.net (Postfix) with ESMTP id DE1BD8F283; Fri, 6 Jan 2006 17:09:18 +0100 (CET) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: Re: support for using runas for pg Date: Fri, 6 Jan 2006 17:09:25 +0100 Message-ID: <6BCB9D8A16AC4241919521715F4D8BCE92E97D@algol.sollentuna.se> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: support for using runas for pg Thread-Index: AcYSkO/TcBLXf7zxTJ+fuZadQ/htPAASmmgw From: "Magnus Hagander" To: "Mohamed Fazil" , "pg-admin postgre" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.074 required=5 tests=[AWL=0.074] X-Spam-Score: 0.074 X-Spam-Level: X-Archive-Number: 200601/83 X-Sequence-Number: 20171 > Thanks for the support provided by you guys. I am able to run=20 > the application using runas.exe but it does not allows me to=20 > provide the domain password with the same command. Could you=20 > please provide me a solution to provide password with it.=20 use runas with /savecred the first time, and then it'll run without prompting you for the password. > Also Is there any utility to run postgres as a different user=20 > in NT. Please help me out. I've heard of thirdparty tools that did this, but I can't name one. You'll be hard-pressed to find one that's supported on NT4 these days, though, but there might be some around. //Magnus From mohdfazil_p_a@yahoo.com Tue Jan 10 12:24:16 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1FA5E9DCC55 for ; Tue, 10 Jan 2006 08:24:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82937-07-7 for ; Tue, 10 Jan 2006 08:24:18 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31005.mail.mud.yahoo.com (web31005.mail.mud.yahoo.com [68.142.200.168]) by postgresql.org (Postfix) with SMTP id 533CF9DCA8F for ; Tue, 10 Jan 2006 07:54:20 -0400 (AST) Received: (qmail 70498 invoked by uid 60001); 10 Jan 2006 11:54:22 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ZWYABgtE5H+zDK4w8vsZsK0VPxP4RscV4qKXepkfihIswMV48GjZQvIqnMWkheltSDwRRx7MaMm7L39lrou1P3gJfvUCdzw6n/jA8Ek9k9RHzvyij/fFmtsiWHRSH8jRnqu5e+OY6D2OEHp83yJZcWU3yGnhDD9YaJ67TY95ikA= ; Message-ID: <20060110115422.70496.qmail@web31005.mail.mud.yahoo.com> Received: from [220.227.114.194] by web31005.mail.mud.yahoo.com via HTTP; Tue, 10 Jan 2006 03:54:22 PST Date: Tue, 10 Jan 2006 03:54:22 -0800 (PST) From: Mohamed Fazil Subject: Re: support for using runas for pg To: Magnus Hagander , pg-admin postgre In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE92E97D@algol.sollentuna.se> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-777921643-1136894062=:70257" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.532 required=5 tests=[AWL=0.052, DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.532 X-Spam-Level: X-Archive-Number: 200601/102 X-Sequence-Number: 20190 --0-777921643-1136894062=:70257 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. please provide me a solution for this. I had tested their utility by running other app same as i tested pg, then it works in NT. As u mentioned in the previous mail /savecred is not working in Windows 2000. This utility will provides solution for this also. Regards Mohamed Fazil Magnus Hagander wrote: > Thanks for the support provided by you guys. I am able to run > the application using runas.exe but it does not allows me to > provide the domain password with the same command. Could you > please provide me a solution to provide password with it. use runas with /savecred the first time, and then it'll run without prompting you for the password. > Also Is there any utility to run postgres as a different user > in NT. Please help me out. I've heard of thirdparty tools that did this, but I can't name one. You'll be hard-pressed to find one that's supported on NT4 these days, though, but there might be some around. //Magnus --------------------------------- Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP. --0-777921643-1136894062=:70257 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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.
 
please provide me a solution for this. I had tested their utility by running other app same as i tested pg, then it works in NT.
 
As u mentioned in the previous mail /savecred is not working in Windows 2000. This utility will provides solution for this also.
 
Regards
Mohamed Fazil

Magnus Hagander <mha@sollentuna.net> wrote:
> Thanks for the support provided by you guys. I am able to run
> the application using runas.exe but it does not allows me to
> provide the domain password with the same command. Could you
> please provide me a solution to provide password with it.

use runas with /savecred the first time, and then it'll run without
prompting you for the password.

> Also Is there any utility to run postgres as a different user
> in NT. Please help me out.

I've heard of thirdparty tools that did this, but I can't name one.You'll be hard-pressed to find one that's supported on NT4 these days,
though, but there might be some around.

//Magnus


Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP. --0-777921643-1136894062=:70257-- From mha@sollentuna.net Wed Jan 11 22:48:51 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BF3AE9DC863 for ; Wed, 11 Jan 2006 18:48:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10060-01 for ; Wed, 11 Jan 2006 18:48:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx-2.sollentuna.net (mx-2.sollentuna.net [195.84.163.199]) by postgresql.org (Postfix) with ESMTP id 6307B9DC833 for ; Wed, 11 Jan 2006 18:48:47 -0400 (AST) Received: from ALGOL.sollentuna.se (janus.sollentuna.se [62.65.68.67]) by mx-2.sollentuna.net (Postfix) with ESMTP id 5504A8F28A; Wed, 11 Jan 2006 23:48:50 +0100 (CET) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: Re: support for using runas for pg Date: Wed, 11 Jan 2006 23:48:48 +0100 Message-ID: <6BCB9D8A16AC4241919521715F4D8BCE92E9B3@algol.sollentuna.se> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: support for using runas for pg Thread-Index: AcYV3Jv8gnB5bFVEQbqbflMCtZUrsgBJETSw From: "Magnus Hagander" To: "Mohamed Fazil" , "pg-admin postgre" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.081 required=5 tests=[AWL=0.081] X-Spam-Score: 0.081 X-Spam-Level: X-Archive-Number: 200601/130 X-Sequence-Number: 20218 > Hi, > =20 > I got a third party utility to run pgsql in non=20 > administrative users account and without prompting password.=20 > The utility providers ensure that the utility will work in=20 > NT. I used this utility for running pg8.1.1 and it shows me=20 > the following error with a prompt titled "ININTDB.EXE - DLL=20 > Initialization Failed" and the message "Initialization of=20 > Dynamic Link Library D:\WINNT\system32\KERNEL32.dll failed.=20 > The process is terminating abnormally". Before running this i=20 > had created new user named postgres without administrator=20 > rights. I tried by providing read & execute rights for the=20 > user postgres to Kernl32.dll, user32.dll & for the folder of=20 > pg that contains libraries and exe's. Then also it is showing=20 > the same error.=20 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 From mohdfazil_p_a@yahoo.com Thu Jan 12 09:27:37 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A49AC9DCCCB for ; Thu, 12 Jan 2006 05:27:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63740-07 for ; Thu, 12 Jan 2006 05:27:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31004.mail.mud.yahoo.com (web31004.mail.mud.yahoo.com [68.142.200.167]) by postgresql.org (Postfix) with SMTP id 076709DC89F for ; Thu, 12 Jan 2006 05:27:34 -0400 (AST) Received: (qmail 28777 invoked by uid 60001); 12 Jan 2006 09:27:30 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=mC1Amnc9Qk0ai9XsukrUTUbQ6E2BTk/BLEnmzTbhTkqL8W/gyoraGs7/+3l2SswCLcWlFEftM5rgB2s2IXw1U1bcUlI2bqusjDzox4tBHIsKYFXs+D6/Tzx1BeDSdoYaN3sMOiICBDG3r1oBn13T2dULjqR3C55+iTH1frbtcCg= ; Message-ID: <20060112092730.28775.qmail@web31004.mail.mud.yahoo.com> Received: from [220.227.114.194] by web31004.mail.mud.yahoo.com via HTTP; Thu, 12 Jan 2006 01:27:30 PST Date: Thu, 12 Jan 2006 01:27:30 -0800 (PST) From: Mohamed Fazil Subject: Re: support for using runas for pg To: Magnus Hagander , pg-admin postgre In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE92E9B3@algol.sollentuna.se> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1486629259-1137058050=:24672" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.529 required=5 tests=[AWL=0.049, DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.529 X-Spam-Level: X-Archive-Number: 200601/146 X-Sequence-Number: 20234 --0-1486629259-1137058050=:24672 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 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! --0-1486629259-1137058050=:24672 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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 provid ing 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@sollentuna.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
> D ynamic 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! --0-1486629259-1137058050=:24672-- From postgres@kiwi-fraser.net Thu Jan 12 13:16:12 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 377569DCD9A for ; Thu, 12 Jan 2006 09:16:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32460-08 for ; Thu, 12 Jan 2006 09:16:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 7D86C9DCDAF for ; Thu, 12 Jan 2006 09:16:09 -0400 (AST) Received: from demolish1 (unknown [84.12.188.208]) by smtp.nildram.co.uk (Postfix) with SMTP id C68272538D2 for ; Thu, 12 Jan 2006 13:16:10 +0000 (GMT) Message-ID: <002d01c6177a$5c6c7ae0$0264a8c0@demolish1> From: "Donald Fraser" To: "[ADMIN]" References: <20060112092730.28775.qmail@web31004.mail.mud.yahoo.com> Subject: Re: support for using runas for pg Date: Thu, 12 Jan 2006 13:16:12 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/148 X-Sequence-Number: 20236 First you didn't answer the previous question: >Does it work when you use runas This question was asked to pin point the problem: is the problem with the postgres windows user set-up or is it with the third party tool? I personally have used "runas" to run windows batch files with PostgreSQL and it works fine for me, therefore I would suggest that you have either a problem with the postgres user account or with the third party tool "runasv" I use a third party tool named "cpau" (http://www.joeware.net/win/free/tools/cpau.htm) to automate batch processes without password prompting and again I have no problems with PostgreSQL - therefore please try one of these options before blaming PostgreSQL. If any one of these options work then the problem will be with your third party tool "runasv" Regards Donald Fraser From postgres@kiwi-fraser.net Fri Jan 13 13:21:32 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BCA859DD700 for ; Fri, 13 Jan 2006 09:21:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01371-09 for ; Fri, 13 Jan 2006 09:21:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 62C599DD6FC for ; Fri, 13 Jan 2006 09:21:29 -0400 (AST) Received: from demolish1 (unknown [84.12.188.208]) by smtp.nildram.co.uk (Postfix) with SMTP id 492AB254C1D for ; Fri, 13 Jan 2006 13:20:42 +0000 (GMT) Message-ID: <004f01c61844$34c77f10$0264a8c0@demolish1> From: "Donald Fraser" To: "[ADMIN]" References: <20060113113300.56539.qmail@web31014.mail.mud.yahoo.com> Subject: Re: support for using runas for pg Date: Fri, 13 Jan 2006 13:20:33 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/157 X-Sequence-Number: 20245 >I am able to start and stop database after logging as user postgres in NT. It is clear that you can start and stop postgreSQL using the postgres user. Therefore access to pg_ctl.exe is working as expected! The fact that the problem only exists when you introduce a thrid party tool to perform the same tasks you are able to do when logged on as the postgres user strongly suggests that the problem is with your thrid party tool. That is your third party tool is emulating the command shell environment but not 100%. What happens when you try and run some other application using the postgres user when logged on as the postgres user? For example: 1) log on as postgres and run the program ipconfig.exe (this system program uses the kernel32.dll). 2) When you have established that the previous step works ok, run the same command from a batch/script file using the "runasv" program. Regards Donald Fraser Ps. Please do not include email addresses in your reply - they become public domian and allow spam engines to find them! From mha@sollentuna.net Fri Jan 13 15:22:20 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6728C9DD6E5 for ; Fri, 13 Jan 2006 11:22:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24489-08 for ; Fri, 13 Jan 2006 11:22:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx-2.sollentuna.net (mx-2.sollentuna.net [195.84.163.199]) by postgresql.org (Postfix) with ESMTP id 19AB79DC846 for ; Fri, 13 Jan 2006 11:22:09 -0400 (AST) Received: from ALGOL.sollentuna.se (janus.sollentuna.se [62.65.68.67]) by mx-2.sollentuna.net (Postfix) with ESMTP id C8E298F29C; Fri, 13 Jan 2006 16:22:12 +0100 (CET) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: Re: support for using runas for pg Date: Fri, 13 Jan 2006 16:18:20 +0100 Message-ID: <6BCB9D8A16AC4241919521715F4D8BCE6C7E7D@algol.sollentuna.se> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] support for using runas for pg Thread-Index: AcYYNSCl0J0OfuJCQ/ySX8D4uoptIAAHqNzQ From: "Magnus Hagander" To: "Mohamed Fazil" , "pg-admin postgre" Cc: "Donald Fraser" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.081 required=5 tests=[AWL=0.081] X-Spam-Score: 0.081 X-Spam-Level: X-Archive-Number: 200601/158 X-Sequence-Number: 20246 > Hi, > =20 > Thanks for your response, > =20 > Ur Q: Does it work when you use runas? > YES, it works when i use runas to run postgres in Win 2000 & XP. Ok. > Below i am mentioning my requirements and the bug received=20 > more clearly >=20 > 1. I am trying to use postgres in three versions of=20 > Windows operating system (Windows 2000,XP & NT) > 2. I am able to run postgres in Win 2000 & XP using runas.=20 > The problem which i faced while using runas is the prompting=20 > for password. That problem also solved after using the utility runasv. Okay, that's good. > 3. Now my problem is in Windows NT. Beware that NT4 is not supported anymore, and that PostgreSQL on NT4 is in some kind of not-really-supported-but-works-most-of-the-time state. > 4. In NT we cannot use runas. So i serach for utility that=20 > supports NT also and i got runasv=20 > http://www.codeguru.com/Cpp/W-P/system/article.php/c5755. > 8. I am able to start and stop database after logging as=20 > user postgres in NT. Then your problem is that the tool above that you are using is breaking something, and that is where your error-tracking should be directed. Not much we can help you with from here. > I was using postgres 7.3 version in my intranet web=20 > application for the past two years using cygwin. It is=20 > working fine in NT,2000 & XP. Now i want to upgrade my=20 > database the new feature of pg8.1.1 that removes the use of cygwin.=20 I beleive you can build 8.1.1 on cygwin as well. I haven't done it myself, and I wouldn't put a production db on cygwin, but I know others have done so with 8.0 at least. If you absolutely need to run it on NT4 (which in general is a bad idea, regardless of what version of pg you chose), you might want to investigate that. //Magnus