X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DC45052872 for ; Wed, 13 Jul 2005 02:47:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23547-07 for ; Wed, 13 Jul 2005 05:47:06 +0000 (GMT) Received: from smtp02.mail.interbaun.com (smtp02.mail.interbaun.com [199.185.130.41]) by svr1.postgresql.org (Postfix) with SMTP id 96CAB52A24 for ; Wed, 13 Jul 2005 02:47:05 -0300 (ADT) Received: (qmail 25204 invoked by uid 502); 13 Jul 2005 05:48:05 -0000 Received: from 243.209-89-66-0.interbaun.com (HELO zeecore.net) (209.89.66.243) by smtp02.mail.interbaun.com with SMTP; 13 Jul 2005 05:48:05 -0000 Received: (qmail 23535 invoked from network); 12 Jul 2005 22:46:58 -0000 Received: from unknown (HELO ipsolution1) (192.168.0.2) by zeecore.net with SMTP; 12 Jul 2005 22:46:58 -0000 Message-ID: <003801c5876e$6a40ef80$0200a8c0@ipsolution1> From: "Karim Mardhani" To: Subject: Postgres service user keeps losing password Date: Tue, 12 Jul 2005 23:47:54 -0600 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0035_01C5873C.1F7D2590" 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, hits=0.486 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200507/79 X-Sequence-Number: 18135 This is a multi-part message in MIME format. ------=_NextPart_000_0035_01C5873C.1F7D2590 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All: I am having an interesting problem with the user which starts postmaster = as service. I am using postgres 8.0.1 as backend to my stand alone windows = application. My installation program installs postgres in silent mode = and sets it to start as windows service. Before installing postgres my = installation program creates a user by running following script: net user /add /y postgres mypassword /EXPIRES:NEVER /COMMENT:"PostgreSQL = Service Account" /FULLNAME:"Postgres Service Account"=20 ntrights -u postgres +r SeServiceLogonRight ntrights -u postgres +r SeNetworkLogonRight ntrights -u postgres +r SeInteractiveLogonRight After creating the user the installation program installs postgres as = windows service by using following command: msiexec /i postgresql-8.0-int.msi /qb! INTERNALLAUNCH=3D1 = ADDLOCAL=3Dserver,psql SERVICEDOMAIN=3D%COMPUTERNAME% = SERVICEPASSWORD=3Dmypassword SERVICENAME=3Dpgdb = SUPERPASSWORD=3Dsupperpassword PERMITREMOTE=3D1=20 =20 So this works fine till the end user actually power cycles the PC rather = than shutting it down properly from the start menu. Basically when the = windows starts up after the power cycle the postgres service doesn't = start. The error it gives is 1069 "logon failure". The only way to fix = this is to reset the passward for the user "postgres" to "mypassword" = and after that every thing works fine till next power cycle happens. = This has been seen on both windows 2000 and windows xp. Also I can't = even use NET USER command to reset the password. The password must be = reset from "users and password" GUI. So the question I have is why a power cycle causes the system to lose = the passward for this user? It doesn't happen to any other user. There = are quite a few other users in the system. Also why can't "net user" = utility be used to reset the password. Does anybody see any thing = obvious with the way installation program creates the user? Any help in this regard would greatly appreciated. Thanks Karim ------=_NextPart_000_0035_01C5873C.1F7D2590 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All:
 
I am having an interesting problem with the user = which starts=20 postmaster as service.
 
I am using postgres 8.0.1 as backend to = my stand alone=20 windows application.  My installation program installs postgres in = silent=20 mode and sets it to start as windows service.  Before installing = postgres=20 my installation program creates a user by running following=20 script:
 
net user /add /y=20 postgres mypassword /EXPIRES:NEVER /COMMENT:"PostgreSQL Service = Account"=20 /FULLNAME:"Postgres Service Account"
ntrights -u postgres +r=20 SeServiceLogonRight
ntrights -u postgres +r = SeNetworkLogonRight
ntrights=20 -u postgres +r SeInteractiveLogonRight
 
 After creating the user the installation = program=20 installs postgres as windows service by using following = command:
 
msiexec /i = postgresql-8.0-int.msi=20 /qb! INTERNALLAUNCH=3D1 ADDLOCAL=3Dserver,psql = SERVICEDOMAIN=3D%COMPUTERNAME%=20 SERVICEPASSWORD=3Dmypassword SERVICENAME=3Dpgdb = SUPERPASSWORD=3Dsupperpassword=20 PERMITREMOTE=3D1
 
So this works fine till the end user actually power = cycles the=20 PC rather than shutting it down properly from the start menu.  = Basically=20 when the windows starts up after the power cycle the postgres service = doesn't=20 start.  The error it gives is 1069 "logon failure".  The only = way to=20 fix this is to reset the passward for the user "postgres" to = "mypassword" and=20 after that every thing works fine till next power cycle happens.  = This has=20 been seen on both windows 2000 and windows xp.  Also I can't even = use NET=20 USER command to reset the password.  The password must be reset = from "users=20 and password" GUI.
 
So the question I have is why a power cycle causes = the system=20 to lose the passward for this user?  It doesn't happen to any other = user.  There are quite a few other users in the system.  Also = why=20 can't "net user" utility be used to reset the password.  Does = anybody see=20 any thing obvious with the way installation program creates the=20 user?
 
Any help in this regard would greatly=20 appreciated.
 
Thanks
 
Karim

------=_NextPart_000_0035_01C5873C.1F7D2590--