Installing PostgreSQl

moppelstroppel · Post by **moppelstroppel** » Thu Jan 15, 2009 8:36 am

Hello all,

I tried to install a PostgreSQL datatbase by calling

Run Programm msiexec.exe /i C:\\tmp\\postgresql.msi  /qr INTERNALLAUNCH=1 ADDLOCAL=server,psql,nls,pgadmin SERVICEDOMAIN="%COMPUTERNAME%" SUPERUSER="root" SERVICEPASSWORD="monas" SUPERPASSWORD="monasur" BASEDIR="C:\\Programme\\PostgreSQL" TRANSFORMS=:lang_de

But an error comes during installation from the PostgreSQL installer.
"User account 䌥䵏啐䕔乒䵁╅瀀獯杴敲s潭慮畳浭牥\\潰瑳牧獥洀湯獡浵敭r doesn't exists."

If I open the cmd.exe and put the command in no error appears and the database will be installed.

Thanks for help

MichaelNesmith · Post by **MichaelNesmith** » Thu Jan 15, 2009 9:45 am

Don't call msiexec, that is not a clever way to do this from InstallAware. Instead, call the (Un)Install MSI Setup plug-in so you can capture the exact native progress of the installation and also interact with any error messages directly from the UI of your own setup wizard, while installing this external MSI setup!!!

moppelstroppel · Post by **moppelstroppel** » Thu Jan 15, 2009 10:26 am

Thanks but the same error appears, but instead of chinese char '?' appears.
Any other ideas?

One error in log is the following

MSI (s) (C0:58) [16:21:39:968]: Creating MSIHANDLE (13013) of type 790536 for thread 600
MSI (s) (C0:38) [16:21:40:000]: Invoking remote custom action. DLL: C:\\WINDOWS\\Installer\\MSI29F.tmp, Entrypoint: _DoVerifyUser@4
MSI (s) (C0:00) [16:21:40:046]: Generating random cookie.
MSI (s) (C0:00) [16:21:40:125]: Created Custom Action Server with PID 1944 (0x798).
MSI (s) (C0:58) [16:21:40:296]: Running as a service.
MSI (s) (C0:70) [16:21:40:328]: Hello, I'm your 32bit Elevated custom action server.
MSI (s) (C0!D4) [16:21:40:546]: Creating MSIHANDLE (13014) of type 790531 for thread 3540
Benutzerkonto ???????????s?????\\?????????r existiert nicht.
MSI (s) (C0!D4) [16:21:43:125]: Note: 1: 2205 2: 3: Error
MSI (s) (C0!D4) [16:21:43:140]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709
MSI (s) (C0!D4) [16:21:43:171]: Produkt: PostgreSQL 8.3 -- Benutzerkonto ???????????s?????\\?????????r existiert nicht.

moppelstroppel · Post by **moppelstroppel** » Fri Jan 16, 2009 9:13 am

Has nobody any idea why?

MichaelNesmith · Post by **MichaelNesmith** » Fri Jan 16, 2009 2:44 pm

Use full paths in the MSI command line, see if that helps, you should never use relative paths.

moppelstroppel · Post by **moppelstroppel** » Sat Jan 17, 2009 2:56 pm

Hi MichaelNesmith
thanks for your answer, but what do you mean with full path.
The only call what I did is C:\\tmp\\postgresql.msi
Thats a full path or which path do you mean?

MichaelNesmith · Post by **MichaelNesmith** » Sat Jan 17, 2009 3:15 pm

TRANSFORMS=:lang_de : this is NOT a full path to the transform file.

moppelstroppel · Post by **moppelstroppel** » Sun Jan 18, 2009 5:26 am

No this parameter I can only select as written from me. I cannot define a path here. I can only select the type of language here. This is defined here http://pginstaller.projects.postgresql.org/silent.html

MichaelNesmith · Post by **MichaelNesmith** » Sun Jan 18, 2009 10:49 am

Incorrect, the transform is a file that is applied to the MSI at runtime per your commandline and the transform is most probably failing due to an incomplete path specification - it cannot find the correct transform file. Otherwise, there's no reason why running msiexec from InstallAware can fail.

I think if you integrate the transform into the MSI file using Orca at build time then, you will probably be eliminating this source of failure.

You can also set the current directory in InstallAware before calling msiexec as an alternative solution.

But of course the proper way of solving this is by using the (Un)Install MSI Setup command with the full path to the transform file in the property.