viachi
16th January 2006 13:59 UTC

Answering to "Password:" prompt in console
Hello,
I am trying to import a dump in PostgreSQL. For that i am using:

C:\>ExecWait "C:\Program Files\PostgreSQL\8.0.0-beta5\bin\psql -U postgres MyDB -f D:\dumps\db.dmp -p 5433"

Then it shows password prompt, which i am trying to handle with:

C:\>FindWindow $R0 windowtitle "C:\Program Files\PostgreSQL\8.0.0-beta5\bin\psql.exe"

And sending the pass to the console:

C:\>SendMessage $R0 ${WM_COMMAND} "STR:postgres" 0

Everything is in command line, without any GUI.
I tried also to pass the password in first command, but it appears extra parameter, and ignores it or some of the other.
Thanks for any help.

Afrow UK
16th January 2006 15:12 UTC

Isn't there a command-line switch for the password?

-Stu

Takhir
16th January 2006 16:07 UTC

For console apps ExecDos may help if your program not require terminal emulation.

viachi
17th January 2006 11:19 UTC

Thnk you, Takhir,
it seems ExecDos can do the job, but i guess i don't do something wright, becouse the result is the same: showing a console with "Password: _" . This is my line, if you see something wrong:

ExecDos::exec /NOUNLOAD /ASYNC "/BRAND=Executing console application" /TIMEOUT=5000 "C:\Program Files\PostgreSQL\8.0.0-beta5\bin\psql.exe" "postgres"

Takhir
17th January 2006 11:29 UTC

ExecDos::exec "/BRAND=Executing console application" /TIMEOUT=5000 "C:\Program Files\PostgreSQL\8.0.0-beta5\bin\psql.exe" "postgres$\n"

viachi
17th January 2006 12:47 UTC

Nope. The same.

viachi
17th January 2006 15:02 UTC

Actually i think the problem is another - i can't handle the console window. It is ok with the Installer window, or the NSIS Compilator window, but not with console. The title is:

C:\Program Files\PostgreSQL\8.0.0-beta5\bin\psql.exe

If I change the .exe file it still doesn't work.
What could be a problem...?

kike_velez
18th January 2006 12:17 UTC

Hello

to do that with Telnet I do this:

ExecShell "" "telnet" "-f temp.txt $CataIP" SW_HIDE

FindWindow $R0 "" "Telnet $CataIP"

;Send password
Push $R0
Push "$Password"
Call SendChars

;send Enter Key
SendMessage $R0 ${WM_CHAR} 13 0


with


; SendChars:
; Send a stream of WM_CHAR messages to a window to simulate user input
; Usage:
; Push <window-handle>
; Push <message>
; Call SendChars

Function SendChars
Exch $R0 ; Get string
Exch
Exch $R1 ; Get hwnd
Push $R2
Push $R3
StrCpy $R2 0 ; Char index
loop:
StrCpy $R3 $R0 1 $R2 ; Get next char
StrCmp $R3 "" done
Push $R3
Call CharToAscii ; Convert it to ASCII
Pop $R3
SendMessage $R1 258 $R3 0 ; Send a WM_CHAR message
IntOp $R2 $R2 + 1
Goto loop
done:
Pop $R3
Pop $R2
Pop $R1
Pop $R0
FunctionEnd

; CharToAscii:
; Convert a character to it's ascii code
; Usage:
; Push <character>
; Call CharToAscii
; Pop <ascii-code>

Function CharToAscii
Exch $R0 ; Get character
Push $R1
Push $R2
StrCpy $R1 255 ; ASCII code test counter
loop:
IntFmt $R2 "%c" $R1 ; Convert current test counter to it's char
StrCmp $R2 $R0 done ; Have we found it yet? (note - not case sensitive)
IntOp $R1 $R1 - 1 ; Next code
IntCmp $R1 0 "" "" loop
done:
Pop $R2
Exch
Pop $R0
Exch $R1
FunctionEnd


Best Regards