Thread: Need some help getting started
I'm using Win XP Home I'm stuck on step 9 of these instructions: http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README It doesn't say whether I should run it as "postgres" or my "Dan" account, but neither seems to work. 1) As "Dan", I get: cygrunsrv: Error starting a service: StartService: Win32 error 1069: The service did not start due to a logon failure. and there's an application Event with these comments: The description for Event ID ( 0 ) in Source ( postmaster ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: postmaster : PID 3460 : starting service `postmaster' failed: execv: 1, Operation not permitted. 2) As "postgres", I get: cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error 1062: The service has not been started. and there are the following two application Events: The description for Event ID ( 0 ) in Source ( postmaster ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: postmaster : PID 4044 : starting service `' failed: redirect_fd: open (1, /var/log/postmaster.log): 13, Permission denied. The description for Event ID ( 0 ) in Source ( postmaster ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: postmaster : PID 2128 : starting service `postmaster' failed: execv: 1, Operation not permitted. BTW, as "postgres", I was getting another error before giving the postgres user a non-blank password. You might want to add that to the instructions. Thanks in advance for any ideas. __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/
Dan wrote: >I'm using Win XP Home > >I'm stuck on step 9 of these instructions: > >http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README > >It doesn't say whether I should run it as "postgres" >or my "Dan" account, but neither seems to work. > I have to run it as my "User" account, i.e., the one that owns the files. See: I assume you've seen: http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN This is what got me over the hump for Windows XP Home: http://archives.postgresql.org/pgsql-cygwin/2003-01/msg00068.php I didn't find the advice in the readme helpful at all for setting rights on XP Home. >1) As "Dan", I get: >cygrunsrv: Error starting a service: StartService: >Win32 error 1069: >The service did not start due to a logon failure. > Do you have a password set for the account? That was necessary for me. - Marsh
Thanks. Yes, my "Dan" and my "postgres" users have non-blank passwords. I read these instructions: http://archives.postgresql.org/pgsql-cygwin/2003-01/msg00068.php I had these problems: Step 1) ipc-daemon is not found. ipc-daemon2 is. Step 4) Perhaps I need to change "--dep ipc-daemon" to "--dep ipc-daemon2" Step 9) I'm getting the same errors as before. I still can't tell what user we should use for each step. Do we still create a "postgres" user at all? I honestly do appreciate the author's intention to explain why things are different, but it would be more helpful to just see a continuous, usable, corrected script with blanks to fill in. Does anyone have one? Another fun little snag I've discovered is that somehow mkpasswd translates my "Dan" user to "Owner" in the etc/passwd file. I don't know why. At least I now know where the "Owner" in my cygwin command prompt comes from. Thanks again __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/
Dan,
On Sat, Oct 25, 2003 at 02:47:03PM -0700, Dan wrote:
> It doesn't say whether I should run it as "postgres"
> or my "Dan" account, but neither seems to work.
>
> 1) As "Dan", I get:
> cygrunsrv: Error starting a service: StartService:
> Win32 error 1069:
> The service did not start due to a logon failure.
Did you in grant "Dan" the "Log on as a service" right as indicated in
the README?
3. Grant the "postgres" user the "Log on as a service" user right:
# cmd /c secpol.msc # [3] [4] [5] [12]
[snip]
[12] On Windows XP Home, there is no built in way to assign user
rights -- use editrights instead:
$ editrights -u postgres -a SeServiceLogonRight
> [snip]
>
> 2) As "postgres", I get:
> cygrunsrv: Error starting a service:
> QueryServiceStatus: Win32 error 1062:
> The service has not been started.
Does the following from the README help?
4. Cygwin PostgreSQL can fail to start or not function properly if
certain files and directories have incorrect permissions. The
following usually solves these kinds of problems:
$ chmod a+rwx /tmp
$ chmod a+rx /usr/bin /usr/bin/*
$ chmod a+rw /var/log # could adversely affect other daemons
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Nope, that didn't work. But, I found the following line in the /var/logs/postmaster file. FATAL: Can't read lock file /tmp/.s.PGSQL.5432.lock: Permission denied I get the following for /tmp when I type "ls -l /" drwxrwxrwx+ 2 Dan None 0 Oct 27 08:38 tmp and /tmp/.s.PGSQL.5432.lock does not exist So, I have another question. Am I looking at the right README file? I'm using /usr/doc/Cygwin/postgresql-7.3.4.README My copy of this file says to use "ntrights", not "editrights". Here again are the 2 errors logged in application events: Event 2 The description for Event ID ( 0 ) in Source ( postmaster ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: postmaster : PID 1928 : starting service `postmaster' failed: execv: 1, Operation not permitted. Event 1 The description for Event ID ( 0 ) in Source ( postmaster ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: postmaster : PID 968 : starting service `' failed: redirect_fd: open (1, /var/log/postmaster.log): 13, Permission denied. I'm confused why this says "postmaster.log" instead of "postmaster". __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/
Dan,
On Mon, Oct 27, 2003 at 10:26:02AM -0800, Dan wrote:
> But, I found the following line in the /var/logs/postmaster file.
What is the above file?
> FATAL: Can't read lock file /tmp/.s.PGSQL.5432.lock:
> Permission denied
>
> I get the following for /tmp when I type "ls -l /"
> drwxrwxrwx+ 2 Dan None 0 Oct 27 08:38
> tmp
>
> and /tmp/.s.PGSQL.5432.lock does not exist
Sounds like you are eventually going to have to solve the above problem
too.
> So, I have another question. Am I looking at the right README file?
Yes.
> I'm using /usr/doc/Cygwin/postgresql-7.3.4.README
Oh, your previous post mentioned the following:
On Sat, Oct 25, 2003 at 02:47:03PM -0700, Dan wrote:
> I'm stuck on step 9 of these instructions:
>
> http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README
so I thought you were using the online version and not the one that is
part of the package.
> My copy of this file says to use "ntrights", not "editrights".
I just updated the above URL. Hence, the difference.
> Here again are the 2 errors logged in application
> events:
>
> Event 2
> [snip]
> postmaster : PID 1928 : starting service
> `postmaster' failed: execv: 1, Operation not permitted.
>
> Event 1
> [snip]
> postmaster : PID 968 : starting service `' <***
> failed: redirect_fd: open (1, /var/log/postmaster.log): 13, Permission denied.
If you Google on the above, you will see that my previous suggestion
solved the these problems in the past.
BTW, where did the service name go in "<***" above?
> I'm confused why this says "postmaster.log" instead of "postmaster".
The cygrunsrv usage indicates the following:
$ cygrunsrv --help
Usage: cygrunsrv [OPTION]...
[snip]
-1, --stdout <file> Optional output file used for stdout redirection.
Default is /var/log/<svc_name>.log.
[snip]
Hence, postmaster when running as a service under Cygwin usually logs to
/var/log/postmaster.log.
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Dan, Please keep you replies on-list. On Mon, Oct 27, 2003 at 02:40:47PM -0800, Dan wrote: > One more thing.. I don't know if "editrights" was installed when I > downloaded and installed ntrights. If so, there should be a step to > download ntrights. My README is already too "cluttered." IMO, adding this obvious step will only make it more so. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
--- Jason Tishler <jason@tishler.net> wrote: > Dan, > > Please keep you replies on-list. > Since you're the one who's maintaining the README, I sent my question to you alone. Otherwise, if I was wrong about the editrights thing, there would be confusing/bogus info in the mail archive. That's important to me as a newbie. I should have mentioned that in the last message. I think you probably didn't get my other email with the revised README attachment. This would have made more sense in that context. > On Mon, Oct 27, 2003 at 02:40:47PM -0800, Dan wrote: > > One more thing.. I don't know if "editrights" was > installed when I > > downloaded and installed ntrights. If so, there > should be a step to > > download ntrights. > > My README is already too "cluttered." IMO, adding > this obvious step > will only make it more so. I respectfully disagree. I am very grateful for your help and maintenance of the guide, but it took me three days to get this thing to work. Excluding what's "obvious" isn't the way to attract new users. Making it idiot-proof is. Surely keeping it "uncluttered" is not more important than attracting new users. I can't imagine a prospective user choosing a different product because the postgresql installation instructions insulted his intelligence with obvious info. IMO, there wasn't too much information, but rather having footnotes and omitting what's obvious made it harder to use than if verbose information was placed in-line. Consider me a usability tester of the postgres cygwin setup process. I'm just offering my feedback as a user. Did you get my revised README? I sent it as an attachment in a separate email. I'd like you to review and post it if you like it, or correct it if you don't. Again, to keep the mail archives free from inconsistent information, I sent it only to you. So that there's only one source of instructions, I'd rather not just post it in a message here, but I will if you prefer. I wonder why these instructions are not just part of the postgresql docs. They're really nice and that's the first place everyone looks. __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/
Dan, On Tue, Oct 28, 2003 at 10:36:49AM -0800, Dan wrote: > --- Jason Tishler <jason@tishler.net> wrote: > > Please keep you replies on-list. > > Since you're the one who's maintaining the README, I sent my question > to you alone. Otherwise, if I was wrong about the editrights thing, > there would be confusing/bogus info in the mail archive. That's > important to me as a newbie. I should have mentioned that in the last > message. Understood. Nevertheless, the proper place to discuss these matters is the appropriate mailing list. Unfortunately, individuals do not scale -- mailing list do. > I think you probably didn't get my other email with the revised README > attachment. I just checked my spam folder (and inbox). I did not receive the above email. > This would have made more sense in that context. Agreed. > > On Mon, Oct 27, 2003 at 02:40:47PM -0800, Dan wrote: > > > One more thing.. I don't know if "editrights" was installed when I > > > downloaded and installed ntrights. If so, there should be a step > > > to download ntrights. > > > > My README is already too "cluttered." IMO, adding this obvious step > > will only make it more so. > > I respectfully disagree. The purpose of my README is to describe the differences between a Cygwin and Unix PostgreSQL setup. The goal was not to provide exhaustive Cygwin and PostgreSQL documentation. This documentation can be found elsewhere. > I am very grateful for your help and maintenance of the guide, You are welcome. > but it took me three days to get this thing to work. Sorry, but it appears that XP Home adds to the complexity of setting up Cygwin PostgreSQL. AFAICT, installation on other Windows versions is easier. > Excluding what's "obvious" isn't the way to attract new users. > [snip] > I'm just offering my feedback as a user. I appreciate your feedback. However, the harsh reality is that I only have very limited spare time and many interests. Hence, rewriting a README is very low on my priority list. FWIW, others have reported to me that they found my README easy to follow and useful. > Did you get my revised README? No. > I sent it as an attachment in a separate email. I'd like you to review > and post it if you like it, or correct it if you don't. Again, to keep > the mail archives free from inconsistent information, I sent it only > to you. I would prefer a patch (i.e., diff) instead. It is much easier to quickly see your changes. > So that there's only one source of instructions, I'd rather not just > post it in a message here, but I will if you prefer. I think you know my preferences, but I will leave it up to you. > I wonder why these instructions are not just part of the postgresql > docs. They're really nice and that's the first place everyone looks. Why not contribute the above to the PostgreSQL docs? Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Jason, Nevermind, I'm not getting anywhere here. I'll post the steps that worked for me to this list and post a link to it in the postgresql docs. Dan __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/
PostgreSQL-Cygwin Installation Steps
On Windows 9x/Me, you can only install postgresql as
an app:
1. Start the cygipc ipc-daemon2:
$ ipc-daemon2 &
2. Initialize PostgreSQL:
$ initdb -D /usr/share/postgresql/data
3. Start the PostgreSQL postmaster:
$ postmaster -D /usr/share/postgresql/data &
4. Connect to PostgreSQL:
$ psql template1
For Windows XP Home, Windows XP Pro, Windows NT 4.0,
Windows 2000, it's better to install it as a service:
In the following steps, replace the following
placeholders with appropriate values:
[USER_1] : Any Windows Admin user. Example: joeuser.
[POSTGRES_USER_DIR]: directory to the postgres user's
home directory. Example: /home/postgres
[POSTGRES_PASSWORD]: password for postgres user
account. Must be non-blank. Example: anonblankpwd
1. Make sure Cygwin's bin directory (e.g.,
C:\Cygwin\bin) is added to the
Windows NT/2000's system PATH and the machine
rebooted for the SCM
to find cygwin1.dll.
2. Log in as [USER_1]
3. Install the cygipc ipc-daemon2 as a NT service:
$ ipc-daemon2 --install-as-service
4. Create the "postgres" user account:
$ net user postgres [POSTGRES_PASSWORD] /add
/fullname:postgres /comment:'PostgreSQL user account'
/homedir:"[POSTGRES_DIR]"
$ mkpasswd -l -u postgres >>/etc/passwd
5. Grant the "postgres" user the "Log on as a service"
user right. (See
http://support.microsoft.com/default.aspx?scid=KB;en-us;q259733
for
a Microsoft KB article explaining how to configure
user rights.):
# If on Windows XP Home:
# I think you have to download and install the
ntrights utility for setting nt permissions
# from here
http://www.dynawell.com/reskit/microsoft/win2000/ntrights.zip
$ editrights -u postgres -a SeServiceLogonRight
# else if on Windows NT 4.0:
# start User Manager, select Policies, and then
select User Rights...
# else if on Windows 2000 or XP Pro:
$ cmd /c secpol.msc
6. Install postmaster as a NT service (Clean
postmaster shutdown will only work with a post Cygwin
1.3.2
snapshot from 2001-Jul-28 or later.):
$ cygrunsrv --install postmaster --path
/usr/bin/postmaster --args "-D
/usr/share/postgresql/data -i" --dep ipc-daemon2
--termsig INT --user postgres --shutdown
7. Create the PostgreSQL data directory:
$ mkdir /usr/share/postgresql/data
8. Change ownership of the PostgreSQL data directory
(Assumes that ntsec is set via the CYGWIN environment
variable):
$ chown postgres /usr/share/postgresql/data
9. Start the cygipc ipc-daemon2
If ipc-daemon2 is not running or a version
previous to
2.01-1 is running, then initdb and postmaster
can fail with the error
message:
IpcSemaphoreCreate: semget(...) failed:
Function not implemented
and
IpcMemoryCreate: shmget(...) failed:
Function not implemented
respectively.
$ cygrunsrv -S ipc-daemon2
10. Switch from [USER_1] to "postgres":
11. Initialize PostgreSQL:
$ initdb -D /usr/share/postgresql/data
12. Switch from "postgres" to [USER_1]:
13. Start postmaster:
$ cygrunsrv -S postmaster
14. Verify postmaster is running (If postmaster fails
to start, then examine /var/log/postmaster.log
and/or the NT Event Log):
$ cygrunsrv -Q postmaster
15. Connect to PostgreSQL (This can be run as any
user. One can use PostgreSQL's createuser command or
set PGUSER to obviate
the need to specify "-U postgres" on the psql
command line):
$ psql -U postgres template1
__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/