hawkmaster
22nd April 2010 11:44 UTC

ExecWait Update Mysql not work, Batch file ok
Hello forum,

With my installer I install a mysql database.
After installation a table should be updated. (A directory path)
If I do it in this way the update is not be done.
------------------------------------------------
Section "UpdateMySQLDatabase"
SetOutPath $TEMP
FileOpen $0 updatedir.sql w
FileWrite $0 "UPDATE directoriestable SET RootDirectoriesPath='$Mod_INSTDIR2' WHERE RootDirectoriesKeyName='DirectoriesMain';$\r$\n"
FileClose $0
ExecWait '"$INSTDIR\mysql\bin\mysql.exe" -uroot -ppassword -Dtestdb < "$TEMP\updatedir.sql"'
SectionEnd
-----------------------------------------------------

The command ;
ExecWait '"$INSTDIR\mysql\bin\mysql.exe" -uroot -ppassword -Dtestdb < "$TEMP\updatedir.sql"'

is wrong or is not be executed.
But if I put the same into a batch file and execute this, all works fine.

-------------------------------------------------------
Section "UpdateMySQLDatabase"
SetOutPath $TEMP
FileOpen $0 updatedir.sql w
FileWrite $0 "UPDATE directoriestable SET RootDirectoriesPath='$Mod_INSTDIR2' WHERE RootDirectoriesKeyName='DirectoriesMain';$\r$\n"
FileClose $0
FileOpen $0 updatedir.bat w
FileWrite $0 "@echo off $\r$\n"
FileWrite $0 '"$INSTDIR\mysql\bin\mysql.exe" -uroot -ppassword -Dtestdb < "$TEMP\updatedir.sql"'
FileClose $0
ExecWait "$TEMP\updatedir.bat";
SectionEnd
------------------------------------------------------

Two questions:

1. What is wrong with the first version without the batch file?
2. How can I debug the ExecWait "Dos" window?
I see that there is an error in it, but the messages are so quick that I cannot read it and the window will be closed quickly.
Is there any way to pause the ExecWait or is there an option to debug the ExecWait or the complete installer script with all output?

thanks a lot
regards
hawk

Afrow UK
22nd April 2010 12:15 UTC

Piping can only be done in command prompt (or cmd /C command < input.txt). Use nsExec::Exec to hide the window:

ReadEnvStr $R0 COMSPEC
nsExec::Exec `"$R0" /C ...`

Stu

hawkmaster
22nd April 2010 14:07 UTC

Hi Stu,
thanks a lot for your help.
If I understand it right, with Exec or ExecWait you cannot execute a command with < or > or || ?
So you always need a batch file for this?

What do you mean with "Use nsExec::Exec to hide the window"?
I dont want to hide a window. My 2. question was how to see the error messages or how to debug if Exec window shows errors.

thanks a lot
regards
hawk

Afrow UK
22nd April 2010 14:11 UTC

Exec and ExecWait do not use cmd.exe to run programs. No you don't have to use a batch file - read my post again. If you don't want to hide the command prompt window then don't use nsExec.

Stu

Afrow UK
22nd April 2010 14:13 UTC

Check the error level (exit code) of the ran command to detect errors. See ExecWait in the manual for more information.

Stu

hawkmaster
22nd April 2010 15:17 UTC

Hi Stu,
I searched with google and also in the NSIS wiki and in the scripting reference doku.
Where can I find info and usage docu about
nsExec ?

regards
hawk

Afrow UK
22nd April 2010 15:48 UTC

NSIS\Docs\nsExec

Stu

Afrow UK
22nd April 2010 15:51 UTC

This is probably what you are after:

ReadEnvStr $R0 COMSPEC
nsExec::Exec '"$R0" /C "$INSTDIR\mysql\bin\mysql.exe" -uroot -ppassword -Dtestdb <  "$TEMP\updatedir.sql"'