Install fails: Data folder [C:\PostgresPlus\8.3AS\data] does not exist

Hi

We're using Advanced Server for our core systems, so I'm just trying to do a local install to familiarise myself with Postgres.
I'm running Windows XP Pro SP3 and I've downloaded Postgres Plus Advanced Server 8.3 (8.3.0.12) (pgplus-advsvr-windows_83012b.exe)

When I run the setup the install fails at 33% and the log file contains:

(Aug 19, 2008 11:22:33 AM), Install, com.enterprisedb.isaction.InitDBFailAction, err, An error occurred and product installation failed. Look at the log file C:\PostgresPlus\8.3AS\log.txt for details.
(Aug 19, 2008 11:22:33 AM), Install, com.enterprisedb.isaction.InitDBFailAction, err, ProductException: (error code = 601; message="Initdb Failed"; additional data = [Data folder [C:\PostgresPlus\8.3AS\data] does not exist.])
STACK_TRACE: 12
ProductException: (error code = 601; message="Initdb Failed"; additional data = [Data folder [C:\PostgresPlus\8.3AS\data] does not exist.])
at com.enterprisedb.isaction.InitDBFailAction.install(InitDBFailAction.java:117)
at com.installshield.product.service.product.PureJavaProductServiceImpl.installProductAction(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.getResultForProductAction(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitComponent(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitInstallableComponents(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitProductBeans(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.install(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$Installer.execute(Unknown Source)
at com.installshield.wizard.service.AsynchronousOperation.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)

I've selected "PostgreSQL-compatible defaults and samples", default options for the rest.
Password for EnterpriseDB is 8 characters, upper and lower case and number, no symbols.
I've tried deleting and recreating EnterpriseDB user. Logged on as EnterpriseDB locally. Added EnterpriseDB to local Adminstrators
Tried with -use_local_logon but got error "Invalid command line option: -use_local_logon is not supported"
Tried deleting C:\Documents and Settings\enterprisedb\Local Settings\Temp\ files

Does anyone have any other suggestions please?
Thanks in advance.

Ian

In the "install_log" directory under your PostgresPlus\8.3AS directory, there should be 2 initdb log files. Is there any information in those files? If so, can you post the error messages you are seeing?

Jim

Thanks for your help.

There are four files in install_log:
initdb_stderr.txt
initdb_stdout.txt
initerr.txt
initout.txt

All are completely empty except initout.txt which contains:

Calling initdb as user enterprisedb...
Initializing Database Cluster

C:\PostgresPlus\8.3AS\dbserver\scripts-win>"C:\PostgresPlus\8.3AS\dbserver\bin\initdb" --pwfile=password.txt -U enterprisedb -D "C:\PostgresPlus\8.3AS\data" -A md5 --locale="English_United Kingdom.1252" --encoding= 1>"C:\PostgresPlus\8.3AS\dbserver\..\install_logs\initdb_stdout.txt" 2>"C:\PostgresPlus\8.3AS\dbserver\..\install_logs\initdb_stderr.txt"
Done!

...which looked like it had been successful to me!

Any advice or suggestions gratefully received.

Ian

C:\PostgresPlus\8.3AS\dbserver\scripts-win>"C:\PostgresPlus\8.3AS\dbserver\bin\initdb" --pwfile=password.txt -U enterprisedb -D "C:\PostgresPlus\8.3AS\data" -A md5 --locale="English_United Kingdom.1252" --encoding=

Looking at the results of the generated initdb command, it seems that the installer isn;t able to pick up the encoding.

Can you let me know what values show up in locale and encoding drop downs (these will be disabled by default, but you should be able to read the value) during the installation process.

This message was edited 2 times. Last update was at 20 Aug 2008 11:10:34

ashaar

Well spotted.

They were:
locale = English (United Kingdom)
encoding = UTF8

I tried 'Specify Custom Locale and Encoding' with
locale = English (United States)
encoding = UTF8

Unfortunately I got the same result in all respects except intiout.txt where the encoding showed up:

Calling initdb as user enterprisedb...
Initializing Database Cluster

C:\PostgresPlus\8.3AS\dbserver\scripts-win>"C:\PostgresPlus\8.3AS\dbserver\bin\initdb" --pwfile=password.txt -U enterprisedb -D "C:\PostgresPlus\8.3AS\data" -A md5 --locale="English_United States.1252" --encoding=UTF8 1>"C:\PostgresPlus\8.3AS\dbserver\..\install_logs\initdb_stdout.txt" 2>"C:\PostgresPlus\8.3AS\dbserver\..\install_logs\initdb_stderr.txt"
Done!

Thanks for your help

Ian

I am surprised that the initdb_stderr.txt file is coming up empty.

Can you try setting the encoding to sql_ascii. I do not have access to a windows machine, and can't check it out myself right now, but this encoding should work fine.

ashaar

Same result I've afraid:

log.txt

(Aug 20, 2008 4:25:39 PM), Install, com.enterprisedb.isaction.InitDBFailAction, err, An error occurred and product installation failed. Look at the log file C:\PostgresPlus\8.3AS\log.txt for details.
(Aug 20, 2008 4:25:39 PM), Install, com.enterprisedb.isaction.InitDBFailAction, err, ProductException: (error code = 601; message="Initdb Failed"; additional data = [Data folder [C:\PostgresPlus\8.3AS\data] does not exist.])
STACK_TRACE: 12
ProductException: (error code = 601; message="Initdb Failed"; additional data = [Data folder [C:\PostgresPlus\8.3AS\data] does not exist.])
at com.enterprisedb.isaction.InitDBFailAction.install(InitDBFailAction.java:117)
at com.installshield.product.service.product.PureJavaProductServiceImpl.installProductAction(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.getResultForProductAction(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitComponent(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitInstallableComponents(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitProductBeans(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.install(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$Installer.execute(Unknown Source)
at com.installshield.wizard.service.AsynchronousOperation.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)

initout.txt

Calling initdb as user enterprisedb...
Initializing Database Cluster

C:\PostgresPlus\8.3AS\dbserver\scripts-win>"C:\PostgresPlus\8.3AS\dbserver\bin\initdb" --pwfile=password.txt -U enterprisedb -D "C:\PostgresPlus\8.3AS\data" -A md5 --locale="English_United States.1252" --encoding=SQL_ASCII 1>"C:\PostgresPlus\8.3AS\dbserver\..\install_logs\initdb_stdout.txt" 2>"C:\PostgresPlus\8.3AS\dbserver\..\install_logs\initdb_stderr.txt"
Done!

Same three files in install_logs are empty.

Thanks

Ian

Here are some questions/suggestion... if this doesn't work we can try extracting the installer and manually setting up the database.

Are you logged in as a local administrator, or a user with Administrative privileges?

Can you please ensure that you have permissions to create the folder under C:\PostgresPlus\8.3AS\. Can you try to create the 'data' folder by using the "md" command.

Try changing the location of the data folder during the install process

Are you creating the user 'enterprisedb' through the installer?

Do you know if port 5444 or 5432 are free and not in use by any other programs/application.

Sorry - I've not had chance to look at this for a few days...

Q: Are you logged in as a local administrator, or a user with Administrative privileges?
A: Yes - logged in a local Adminstrator

Q: Can you please ensure that you have permissions to create the folder under C:\PostgresPlus\8.3AS\. Can you try to create the 'data' folder by using the "md" command.
A: Have permission. Tried manually creating folder once the install had started. I get a slightly different error:

(Sep 1, 2008 10:51:46 AM), Install, com.enterprisedb.isaction.InitDBFailAction, err, An error occurred and product installation failed. Look at the log file C:\PostgresPlus\8.3AS\log.txt for details.
(Sep 1, 2008 10:51:46 AM), Install, com.enterprisedb.isaction.InitDBFailAction, err, ProductException: (error code = 601; message="Initdb Failed"; additional data = [Contents of data folder [C:\PostgresPlus\8.3AS\data] are invalid.])
STACK_TRACE: 12
ProductException: (error code = 601; message="Initdb Failed"; additional data = [Contents of data folder [C:\PostgresPlus\8.3AS\data] are invalid.])
at com.enterprisedb.isaction.InitDBFailAction.install(InitDBFailAction.java:10

at com.installshield.product.service.product.PureJavaProductServiceImpl.installProductAction(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.getResultForProductAction(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitComponent(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitInstallableComponents(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitProductBeans(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.install(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$Installer.execute(Unknown Source)
at com.installshield.wizard.service.AsynchronousOperation.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)

Q: Try changing the location of the data folder during the install process
A: Same result folder is not created, or "contents of folder are invalid"

Q: Are you creating the user 'enterprisedb' through the installer?
A: Tried letting the installer create and tried creating manually and putting enterprisedb in the Administrators group

Q: Do you know if port 5444 or 5432 are free and not in use by any other programs/application.
A: Not in use.

If I just install the client tools that works okay.
Any new ideas please?

Ian

i have the same problem when i install in XP
(Sep 3, 2008 1:13:11 PM), Install, com.enterprisedb.isaction.InitDBFailAction, err, An error occurred and product installation failed. Look at the log file C:\PostgresPlus\8.3AS\log.txt for details.
(Sep 3, 2008 1:13:11 PM), Install, com.enterprisedb.isaction.InitDBFailAction, err, ProductException: (error code = 601; message="Initdb Failed"; additional data = [Data folder [C:\PostgresPlus\8.3AS\data] does not exist.])
STACK_TRACE: 12
ProductException: (error code = 601; message="Initdb Failed"; additional data = [Data folder [C:\PostgresPlus\8.3AS\data] does not exist.])
at com.enterprisedb.isaction.InitDBFailAction.install(InitDBFailAction.java:117)
at com.installshield.product.service.product.PureJavaProductServiceImpl.installProductAction(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.getResultForProductAction(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitComponent(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitInstallableComponents(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitProductBeans(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.install(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$Installer.execute(Unknown Source)
at com.installshield.wizard.service.AsynchronousOperation.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)

Hi Steve,

Are you also using Win XP SP3? Can you check the install_logs folder for errors?

Thanks,

This message was edited 1 time. Last update was at 4 Sep 2008 06:14:44

you press right mouse on "Postgresplus" folder (example for "c:\Postgresplus").
->select properties->security tab->select "Users" group
in "permission for Users" select "Full Control"
if it isn't successfull you look for "Advanced".
i'm using window server 2003 sp2.

This message was edited 1 time. Last update was at 15 Sep 2008 08:21:37

tra_x Thanks for your suggestion, but the install creates the c:/Postgresplus folder and the EnterpriseDB user, so when did you change the security on the folder?

Anyway - I will have to leave this for the Enterprise DB guys to sort out (please let me know when you do), because for the moment I have to make do with the client tools.

BTW - it would be great if you could make it so that I don't have to uninstall the client tools before I try each new install suggestion.

Ian

i don't know your client tool and how it operation.
your case,enterprisedb user dosen't permit to run initdb.exe
you should add permission for enterprisedb user
i met your same case,i installed enterprisedb on win server2003 successfully.

I was getting the same error on a Windows XP laptop. I already had a PostgreSQL database service running and shut it down. I started the installer again and once it created the C:\PostgresPlus folder, I changed the permissions to full control for everyone and it worked like a charm. I'm not sure which change corrected the problem. I'll try the installation again later to isolate it and report back soon.

Anthony

I had no problem installing. I just followed the steps.
I have XP Professional Media Center with SP3
on a Toshiba Satellite P105-S6134
DynaTune Option: Mixed
Workload Option: General Purpose

May be you have some anti-virus programs which must be disabled.

I also have
SQL Server 2008 Enterprise
SQL Server Express 2005
Oracle XE 10G
SQL Anyhwhere 10 and 11

I am trying to do some cross vendor products comparisons.