Invalid input, please enter numeric value of 1 to 0 Database Type [1]

Richard Gunarathna

unread,

Oct 5, 2016, 12:35:03 PM10/5/16

to iDempiere

Hi all ,

I am trying to run install.console.app in eclipse environment. But I am getting following error. Please help to solve this.

idempiere version :3.1

OS : mac

Eclipse Luna : 4.4.2

Database : Postgresql 9.5

Oct 06, 2016 12:25:04 AM org.compiere.install.ConfigurationData setDatabaseType

WARNING: Invalid DatabaseType=PostgreSQL

Oct 06, 2016 12:25:04 AM org.compiere.install.ConfigurationData load

SEVERE: Cannot get local host name

Oct 06, 2016 12:25:04 AM org.compiere.install.ConfigurationData load

INFO: Defaults

Oct 06, 2016 12:25:04 AM org.compiere.install.ConfigurationData initDatabase

WARNING: DatabaseType Index invalid: 0

Java Home [/Library/Java/JavaVirtualMachines/jdk1.7.0_79.jdk/Contents/Home]:

Oct 06, 2016 12:26:43 AM org.compiere.install.ConfigVM test

INFO: OK: JavaHome=/Library/Java/JavaVirtualMachines/jdk1.7.0_79.jdk/Contents/Home

iDempiere Home [/Library/idempiere/idempiere]:

Oct 06, 2016 12:26:43 AM org.compiere.install.ConfigVM test

INFO: OK: Version=1.7.0_79

Key Store Password [myPassword]:

Oct 06, 2016 12:26:49 AM org.compiere.install.KeyStoreMgt <init>

INFO: /Library/idempiere/idempiere/jettyhome/etc/keystore

Oct 06, 2016 12:26:49 AM org.compiere.install.ConfigurationData testAdempiere

INFO: OK: AdempiereHome = /Library/idempiere/idempiere

Oct 06, 2016 12:26:49 AM org.compiere.install.KeyStoreMgt <init>

INFO: /Library/idempiere/idempiere/jettyhome/etc/keystore

Oct 06, 2016 12:26:49 AM org.compiere.install.ConfigurationData testAdempiere

INFO: OK: KeyStore = /Library/idempiere/idempiere/jettyhome/etc/keystore

Application Server Host Name [unknown]:

topra

Application Server Web Port [8080]:

Application Server SSL Port[8443]:

DB Already Exists?(Y/N) [N]:

Y

Database Type [1]

2

Invalid input, please enter numeric value of 1 to 0

Database Type [1]

Orlando Curieles

unread,

Oct 5, 2016, 12:59:31 PM10/5/16

to iDempiere

Hi, in the Application Server Host Name [unknown]:

topra

Use: 0.0.0.0

Regards

Richard Gunarathna

unread,

Oct 5, 2016, 10:37:26 PM10/5/16

to iDempiere

Hi,

I have added host name as you propose 0.0.0.0 still the same.

Application Server Host Name [unknown]:

0.0.0.0

Application Server Web Port [8080]:

Application Server SSL Port[8443]:

DB Already Exists?(Y/N) [N]:

Y

Database Type [1]

2

Invalid input, please enter numeric value of 1 to 0

Database Type [1]

0

Invalid input, please enter numeric value of 1 to 0

Database Type [1]

Then I change the hostname to local host still giving me same error .

Application Server Host Name [unknown]:

localhost

Application Server Web Port [8080]:

Application Server SSL Port[8443]:

DB Already Exists?(Y/N) [N]:

Y

Database Type [1]

2

Invalid input, please enter numeric value of 1 to 0

Database Type [1]

1

Invalid input, please enter numeric value of 1 to 0

Database Type [1]

Database Server Host Name [unknown]:

localhost

Database Server Port [0]:

5432

Database Name[null]:

idempiere

Database user [adempiere]:

adempiere

Database Password [adempiere]:

adempiere

Database System User Password []

adempiere

Oct 06, 2016 10:32:28 AM org.compiere.install.ConfigurationData setDatabaseType

WARNING: Invalid DatabaseType=PostgreSQL

Database test fail: DatabaseType Index invalid: 0

DB Already Exists?(Y/N) [Y]:

Carlos Antonio Ruiz Gomez

unread,

Oct 6, 2016, 4:49:45 AM10/6/16

to idem...@googlegroups.com

That sounds like the installer is getting problems to load the postgresql plugin:

> WARNING: Invalid DatabaseType=PostgreSQL

Cannot advice, first time I see this error.

Regards,

Carlos Ruiz

El 05/10/16 a las 18:35, Richard Gunarathna escribió:

Reply all

Reply to author

Forward