Pgadmin - request for documentation correction on pgAgent-Installation

Author

request for documentation correction on pgAgent-Installation

Harald Armin Massa

2005-11-02, 7:23 am

Hello,

I tried to install pgAgent on Windows XP Prof. SP2.

Documentation and help suggest:

options:
-u <user>
-p <password>
-d <displayname>
-t <poll time interval in seconds (default 10)>
-r <retry period after connection abort in seconds (>=10, default 30)>
-l <logging verbosity (ERROR=0, WARNING=1, DEBUG=2, default 0)>

using

-u<space>username

or
-p<space>password

leads to
ERROR: Invalid command line argument

only without a space I can move on to "illegal account name"

Maybe it could be fixed in documentation or in command line parser (so that
both accept a space between -u; or that documentation does not show a space
between -u and username)

Harald

--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607

Dave Page

2005-11-02, 7:23 am

____________________
____________

From: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Harald Armin
Massa
Sent: 02 November 2005 10:54
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] request for documentation correction
on pgAgent-Installation

Hello,

I tried to install pgAgent on Windows XP Prof. SP2.

Documentation and help suggest:

options:
-u <user>
-p <password>
-d <displayname>
-t <poll time interval in seconds (default 10)>

-r <retry period after connection abort in seconds (>=10,
default 30)>
-l <logging verbosity (ERROR=0, WARNING=1, DEBUG=2, default
0)>
using

-u<space>username

or
-p<space>password

leads to
ERROR: Invalid command line argument

only without a space I can move on to "illegal account name"

Maybe it could be fixed in documentation or in command line
parser (so that both accept a space between -u; or that documentation
does not show a space between -u and username)

Hi Harald,

I cannot reproduce this on XP SP2 here. It installs and starts correctly
either with, or without a space between the option letter and the value,
on both the username and the password. Are you sure you didn't mistype
something?

Regards, Dave.

Harald Armin Massa

2005-11-02, 7:23 am

Dave,

C:\Programme\pgAdmin
III\1.4>pgagent.exe INSTALL pgAgent -unasenbaer
ERROR: Der Kontenname ist unzulõssig oder nicht vorhanden, oder das Kennwort
ist
f³r den angegebenen Kontennamen ung³ltig.

C:\Programme\pgAdmin
III\1.4>pgagent.exe INSTALL pgAgent -u nasenbaer
ERROR: Invalid command line argument

C:\Programme\pgAdmin
III\1.4>

thats a cutout from my commandline.

"ERROR: Der Kontenname ist unzulõssig oder nicht vorhanden, oder das
Kennwort ist
f³r den angegebenen Kontennamen ung³ltig." is sth. like "wrong account name"

I am not able to supply a valid account name, esp. since I found no way to
supply user@doman as a username ...

My workaround was to do install without user and password, and to change
them in services.msc

Harald

--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607

Dave Page

2005-11-03, 8:28 pm

____________________
____________

From: Harald Armin Massa & #91;mailto:haraldarm
inmassa@gmail.com]
Sent: 02 November 2005 12:12
To: Dave Page
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] request for documentation correction on pgAgent-Installation

Dave,

C:\Programme\pgAdmin
III\1.4>pgagent.exe INSTALL pgAgent -unasenbaer
ERROR: Der Kontenname ist unzulõssig oder nicht vorhanden, oder das Kennwort ist
f³r den angegebenen Kontennamen ung³ltig.

C:\Programme\pgAdmin
III\1.4>pgagent.exe INSTALL pgAgent -u nasenbaer
ERROR: Invalid command line argument

C:\Programme\pgAdmin
III\1.4>

thats a cutout from my commandline.

"ERROR: Der Kontenname ist unzulõssig oder nicht vorhanden, oder das Kennwort ist
f³r den angegebenen Kontennamen ung³ltig." is sth. like "wrong account name"

OK, I've committed a fix to tidy up the space/no space issue. It only occured if the space was included on the last argument supplied. Thanks for the info.

I am not able to supply a valid account name, esp. since I found no way to supply user@doman as a username ...

My workaround was to do install without user and password, and to change them in services.msc

I've had no problems using a domain user account with a command line like:

pgagent INSTALL pgAgent -u DOMAIN\user -p FooBar dbname=postgres user=postgres port=5433

user@domain syntax is not supported however, but that's down to the Microsoft API, not us.

Regards, Dave.

Harald Armin Massa

2005-11-03, 8:28 pm

Wow, thank you very very much, Dave!

think you can put that DOMAIN\user syntax into the documentation?

Everytime I stumble upon I get mixed up if it is

user@domain
or
domain/user
or
domain\user
or
\\domain\user

or even
\\domain/user

.... so, to have it in that documentation could really help.

Thanks for all that gould work,

Harald

--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607

Dave Page

2005-11-03, 8:28 pm

____________________
____________

From: Harald Armin Massa & #91;mailto:haraldarm
inmassa@gmail.com]
Sent: 03 November 2005 10:04
To: Dave Page
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] request for documentation
correction on pgAgent-Installation

Wow, thank you very very much, Dave!

You're welcome :-)

think you can put that DOMAIN\user syntax into the
documentation?

Sure.

Everytime I stumble upon I get mixed up if it is

user@domain
or
domain/user
or
domain\user
or
\\domain\user

or even
\\domain/user

... so, to have it in that documentation could really help.

As far as I'm aware, the only Microsoft supported syntaxes are:

DOMAIN\user (which is NT/2K/2K3 compatible)
user@domain (which is only 2K/2K3 compatible).

Regards, Dave

Sponsored Links