Debian Install 2015-04-24

[geoi...@gmail.com]

I thought I would give Idempiere a spin so fired up a container and here are some of the issues

# uname -a
Linux idempiere 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt7-1 (2015-03-01) x86_64 GNU/Linux

postgresql-9.4:
  Installed: 9.4.1-1

idempiere.gtk.linux.x86_64.deb
from http://ci.idempiere.org/job/iDempiere2.1Daily/ws/buckminster.output/org.adempiere.server_2.1.0-eclipse.feature/


lxc:
  Installed: 1:1.0.7-1


Apr 24, 2015 4:21:17 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL test
INFO: OK: Database Server = localhost/127.0.0.1
testPort[127.0.0.1, 5432]
Apr 24, 2015 4:21:17 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL test
INFO: OK: Database Port = 5432
Apr 24, 2015 4:21:17 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL test
INFO: OK: System Connection = jdbc:postgresql://localhost:5432/template1
Apr 24, 2015 4:21:17 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL testJDBC
SEVERE: org.postgresql.util.PSQLException: FATAL: database "idempiere" does not exist
Apr 24, 2015 4:21:17 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL test
WARNING: Database imported? Cannot connect to User: adempiere/demp
Mail Server Host Name [localhost]:
Mail User Login []:
Mail User Password []
Administrator EMail []:
Apr 24, 2015 4:21:17 PM org.compiere.install.ConfigurationData testMail
WARNING: Not valid:  - Illegal address
Save changes (Y/N) [Y]:
Apr 24, 2015 4:21:17 PM org.compiere.util.Ini loadProperties
INFO: /opt/idempiere-server/idempiere.properties #28
Apr 24, 2015 4:21:17 PM org.compiere.install.ConfigurationData save
INFO: /opt/idempiere-server/idempiereEnv.properties
Changes save successfully.
file=/opt/idempiere-server/org.adempiere.install/build.xml exists=false
Apr 24, 2015 4:21:19 PM org.compiere.util.Language getLanguage
INFO: Adding Language=en, Country=CA, Locale=en_CA
Apr 24, 2015 4:21:19 PM org.compiere.util.Language getLanguage
WARNING: Adding Language=en, Country=CA, Locale=en_CA
Buildfile: build.xml

no server logs but postgres dumped this out

2015-04-24 16:07:45 EDT [31529-1] adempiere@idempiere FATAL:  database "idempiere" does not exist
2015-04-24 16:07:45 EDT [31531-1] adempiere@idempiere FATAL:  database "idempiere" does not exist

2015-04-24 15:53:36 EDT [31168-1] adempiere@idempiere FATAL:  password authentication failed for user "adempiere"
2015-04-24 15:53:36 EDT [31168-2] adempiere@idempiere DETAIL:  Connection matched pg_hba.conf line 92: "host    all             all             127.0.0.1/32            md5"

I changed md5 to "trust" and that error went away, but for a more secure system I don't beleive that to be a could choice.

can this be made work?

Thanks
Geordie

[Carlos Antonio Ruiz Gomez]

Hi Geordie,

Those lines are fine during installation as the database still doesn't
exist and is created just after that.

When installation finishes a message is shown telling you to start the
service, did you try it?

Regards,

Carlos Ruiz

[geoi...@gmail.com]

Hi Carlos

When installation finishes a message is shown telling you to start the
service, did you try it?

 

I forgot to add this to my previous output

setup:
BUILD SUCCESSFUL

BUILD SUCCESSFUL
Total time: 1 second

 For problems, check log file in base directory
Done
Error deploying iDempiere, please verify and try again

I did try this /etc/init.d/idempiere start however it looks like nothing has started. I am not sure how I would check that
 As for logs postgresql did not post any activity

Any other thoughts
Geordie

[Carlos Antonio Ruiz Gomez]

> I did try this /etc/init.d/idempiere start however it looks like nothing has started. I am not sure how I would check that

Check the message at the end of the configure step - it must have shown something like:

To access the iDempiere Server Home Page, start the server with '/etc/init.d/idempiere start'
and then go to "http://127.0.0.1:${ADEMPIERE_WEB_PORT}"

[geoi...@gmail.com]

Hi Carlos

Okay I created a new container and tried my steps again.

postgresql log
2015-04-24 19:40:37 EDT [9396-1] adempiere@idempiere FATAL:  role "adempiere" does not exist
2015-04-24 19:40:37 EDT [9398-1] adempiere@idempiere FATAL:  role "adempiere" does not exist


/etc/init.d/idempiere configure gives this
Apr 24, 2015 7:40:37 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL test

INFO: OK: Database Server = localhost/127.0.0.1
testPort[127.0.0.1, 5432]

Apr 24, 2015 7:40:37 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL test

INFO: OK: Database Port = 5432

Apr 24, 2015 7:40:37 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL test

INFO: OK: System Connection = jdbc:postgresql://localhost:5432/template1

Apr 24, 2015 7:40:37 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL testJDBC
SEVERE: org.postgresql.util.PSQLException: FATAL: role "adempiere" does not exist
Apr 24, 2015 7:40:37 PM org.adempiere.db.postgresql.config.ConfigPostgreSQL test
WARNING: Database imported? Cannot connect to User: adempiere/dempiere

and this is the last statement in the terminal

For problems, check log file in base directory
Done
Error deploying iDempiere, please verify and try again

I am not a Postgresql expert, far from it, I kind of endure its eclectic messages and google for help. How ever I believe your script is having a few issues. By the way this is not uncommon for the programs that use the latest versions of postgresql for new installs. Things have changed. I even had to change su postgres to this
su -s /bin/bash postgres to enter psql. I did not need to do that a year ago

The first time I tried to correct some of the errors that postgresql was creating I did this
CREATE ROLE adempiere WITH SUPERUSER LOGIN NOINHERIT ENCRYPTED PASSWORD 'dempiere';
However this got rid of the error but the program still did not work the first time hence the questions
I am just as happy with good command line how-to, however these are rare beasts in the Linux world these days and it is probably just as much if not more work to maintain than a script

Thanks again
Geordie

[Sánchez Torres, Max]

Hi you have an error in user and database:

User: adempiere/dempiere

Regards

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/1c04c9a7-7ad6-47de-8769-502a7aa7797d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[redhuan d. oon]

Generally speaking, the error is relating to not finding your PG DB 'iDempiere' and not finding a Role access 'adempiere' defined in it. You can use PGAdmin to look that up. Google for latest tips on this.
Also you can run a script called setup-alt.sh or setup-console.sh that also does the checking for you.
You are almost there but if still stuck just reply again. We want you to be part of the solution and not part of the problem. :P

[geoi...@gmail.com]

Hi
Okay I tried a few of the scripts that redhuan d. suggest with the resultant info

/# /opt/idempiere-server/setup-alt.sh
... Setup idempiere Server
JAVA_HOME is not set.
You may not be able to start the Setup
Set JAVA_HOME to the directory of your local JDK.
Error: Unable to access jarfile plugins/org.eclipse.equinox.launcher_1.*.jar
... Setup Jetty
Error: Unable to access jarfile plugins/org.eclipse.equinox.launcher_1.*.jar
... Make .sh executable
chmod: cannot access ‘*.sh’: No such file or directory
find: `./proc/tty/driver': Permission denied


usr/share/doc/openjdk-7-jdk/JAVA_HOME

                             JAVA_HOME

1. Legacy use of JAVA_HOME

   As of the latest versions of java-common there really should
   be no need for JAVA_HOME as Java(TM) should be completely
   integrated with your Debian GNU/Linux system.


2. Selecting OpenJDK 7 as the default Java(TM) implementation

   Please see README.alternatives for instructions on how
   to make OpenJDK 7 executables and man pages the default on your system.


/proc is empty

#/opt/idempiere-server/console-setup.sh
Setup idempiere Server
/opt/idempiere-server/console-setup.sh: 6: /opt/idempiere-server/console-setup.sh: ./idempiere: not found
/opt/idempiere-server/console-setup.sh: 9: /opt/idempiere-server/console-setup.sh: ./idempiere: not found
.

For problems, check log file in base directory

There are no log files

After seeing the errors I did not check out PGadmin, It is installed on the host system, but there is no activity in Postgresql DB according to its logs.

I did not set the java alternatives, I figuired I would ask first before I procceed

Thanks
Geordie

[redhuan d. oon]

I got this before 'Error: Unable to access jarfile plugins/org.eclipse.equinox.

launcher_1.*.jar'. Solution:
Edit setup-alt.sh and replace the * with the actual name of the jar in the mentioned plugins folder. Try again see if same error comes out.

[Carlos Antonio Ruiz Gómez]

Hi Geordie,

I launched a Jessie server in DigitalOcean and succeeded installing with the actual debian installer.  But before I needed to ensure that postgresql-9.4 was correctly installed with UTF-8 support.

I think the problem you're finding is becaues of a postgresql 9.4 wrongly installed.

This is what I needed to do before trying to install postgresql-9.4:

* edit the file /etc/locale.gen and change last line to en_US UTF-8

* execute locale-gen

And that's all - after that the installation went smooth:

apt-get install postgresql-9.4

and the rest of instructions at

http://wiki.idempiere.org/en/IDempiere_Debian_Installer

BTW - it worked smooth with Ubuntu 14.04 also - but it failed with 15.04 - issues installing prerequisites.

Regards,

Carlos Ruiz

On Friday, 24 April 2015 15:51:05 UTC-5, Carlos Antonio Ruiz Gómez wrote:

Hi Geordie,

Those lines are fine during installation as the database still doesn't
exist and is created just after that.

When installation finishes a message is shown telling you to start the
service, did you try it?

Regards,

Carlos Ruiz

On 24/04/15 a las 15:41, Geordie wrote:

[Geo]

redhuan d. oon

# /opt/idempiere-server/setup-alt.sh
... Setup idempiere Server
JAVA_HOME is not set.
You may not be able to start the Setup
Set JAVA_HOME to the directory of your local JDK.

Error: Unable to access jarfile plugins/org.eclipse.equinox.launcher_1.3.0v20140415-2008.jar
... Setup Jetty
Error: Unable to access jarfile plugins/org.eclipse.equinox.launcher_1.3.0v20140415-2008.jar

... Make .sh executable
chmod: cannot access ‘*.sh’: No such file or directory
find: `./proc/tty/driver': Permission denied

...

For problems, check log file in base directory

I am bothered by this statement Set JAVA_HOME to the directory of your local JDK. and my google foo on this is terrible on this search

Any clues

Geordie

 

--

You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/f8c892fd-ce40-4318-9358-bbe0f6455ae7%40googlegroups.com.