iDempiere setup v2

[a platypus]

Hi all,

I hope you're having a good weekend.  I have just unzipped the idempiere v2 server (Windows 64-bit) and run the setup.bat and stumbled on a couple of challenges and a couple of "how did that happen?" curiosities.

The main issue is that the setup is not accepting the password for the adempiere postgres (user) password.  I get a red tick-box (need I say unticked!).  I checked the pg password by forcing psql command to prompt for a password, viz.

• psql -U adempiere -W
  

Which works and connects me to postgres on the command line.  I wondered if the password is OK, since it is, and there can be something wrong with the idempiere database?    

On the setup panel, I have:

• DB Already exists:  [ ] (empty, unclicked)
• database admin password gets a green square
• database name:  idempiere
• database user:   adempiere

My thought was that since "DB already exists" was not ticked, set-up would create a new (empty) database, or at least initialise enough so I can proceed to a subsequent step.

Curiosities, include the JDK.  My JAVA_HOME points to the latest JDK 7 u51.  However the set-up finds the Java 6 JDK.  That's curious.

• JDK
• b:\lang\java\jdk\v1.6\u45\x64

This is the dialogue I see after I press [Test] ...

Where do I start, to resolve this?

Unlike the earlier Adempiere server I got running, iDempiere doesn't ask me for a server type.  I note it is build on Eclipse, does that mean it is using Jetty?  I like that (if so) just wondered why it was different and what serve it was using.

Oh the environment is Windows 7 64-bit, Java 64-bit 1.6u45.  Although the 'default' JDK and JRE are both Java 1.7.  I still think it is weird that the setup seems to find the 1.6 JDK like that.  

Thanks in advance.

Kind regards,

   Will

[Ahmed Elemam]

put the database password Field : adempiere

[pabloalexi...@gmail.com]

Enviado desde mi BlackBerry de Movistar

---

From: a platypus <william....@gmail.com>

Sender: idem...@googlegroups.com

Date: Sat, 8 Feb 2014 04:42:28 -0800 (PST)

To: <idem...@googlegroups.com>

ReplyTo: idem...@googlegroups.com

Subject: [idempiere] iDempiere setup v2

--
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/66ea75a8-fa10-412e-a9cb-0db569d25f86%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Carlos Antonio Ruiz Gomez]

Hi,

> My thought was that since "DB already exists" was not ticked,
> set-up would create a new (empty) database, or at least
> initialise enough so I can proceed to a subsequent step.

You're 100% right - that's the intention of the flag, and the intention of keeping the check red is to let user aware that the DB doesn't exist.

> Unlike the earlier Adempiere server I got running, iDempiere doesn't ask me for a server type.

iDempiere uses tomcat within the OSGi container.

Regards,

Carlos Ruiz

On 08/02/14 07:42, a platypus wrote:

Hi all,

I hope you're having a good weekend.  I have just unzipped the idempiere v2 server (Windows 64-bit) and run the setup.bat and stumbled on a couple of challenges and a couple of "how did that happen?" curiosities.

The main issue is that the setup is not accepting the password for the adempiere postgres (user) password.  I get a red tick-box (need I say unticked!).  I checked the pg password by forcing psql command to prompt for a password, viz.

• psql -U adempiere -W
  

Which works and connects me to postgres on the command line.  I wondered if the password is OK, since it is, and there can be something wrong with the idempiere database?    

On the setup panel, I have:

• DB Already exists:  [ ] (empty, unclicked)
• database admin password gets a green square
• database name:  idempiere
• database user:   adempiere

My thought was that since "DB already exists" was not ticked, set-up would create a new (empty) database, or at least initialise enough so I can proceed to a subsequent step.

Curiosities, include the JDK.  My JAVA_HOME points to the latest JDK 7 u51.  However the set-up finds the Java 6 JDK.  That's curious.

• JDK
• b:\lang\java\jdk\v1.6\u45\x64

This is the dialogue I see after I press [Test] ...

Where do I start, to resolve this?

...

Unlike the earlier Adempiere server I got running, iDempiere doesn't ask me for a server type.  I note it is build on Eclipse, does that mean it is using Jetty?  I like that (if so) just wondered why it was different and what serve it was using.

[a platypus]

Hello folk.

Thanks for the comments.  My password for the adempiere user is: 'adempiere'.  I still get the red square.  The setup did NOT create a new database.  This is the list of databases after running setup:

   Name    |   Owner   | Encoding |

-----------+-----------+----------+

 adempiere | adempiere | UTF8     |

 postgres  | postgres  | UTF8     |

 template0 | postgres  | UTF8     |

 template1 | postgres  | UTF8     |

           |           |          |

The 'adempiere' database is from an earlier version.  Postgres 

From the log (below) it looks like the the "database not exist" is the problem.  Do I need to have loaded a database before hand?  

I guess the real question is, where do I look for the set-up instructions for iDempiere?  Unfortunately the help button displays text in a large font that you can only read 3 or 4 words at a time.  Not at all useful.  It looks like a web page, does someone know the URL for that help text?

It seems to connect to the template database.  How is the template manifest in the first place?  Do you think I need to drop all the old data? 

Cheers,

    Will

----[ idempiere launcher ]-------------

testPort[http,bluegum, 8080, /]

testServerPort: 8080

11:07:00.442 Config.test: OK: Web Port = 8080 [12]

testPort[https,bluegum, 8443, /]

testServerPort: 8443

11:07:01.652 Config.test: OK: SSL Port = 8443 [12]

11:07:01.653 ConfigPostgreSQL.test: OK: Database Server = bluegum/127.0.0.1 [12]

testPort[127.0.0.1, 5432]

11:07:01.659 ConfigPostgreSQL.test: OK: Database Port = 5432 [12]

11:07:01.807 ConfigPostgreSQL.test: OK: System Connection = jdbc:postgresql://bluegum:5432/template1 [12]

11:07:01.961===========> ConfigPostgreSQL.testJDBC: org.postgresql.util.PSQLException: FATAL: database "idempiere" does not exist [12]

11:07:01.961===========> ConfigPostgreSQL.testJDBC: org.postgresql.util.PSQLException: FATAL: database "idempiere" does not exist [12]

11:07:01.962-----------> ConfigPostgreSQL.test: Database imported? Cannot connect to User: adempiere/adempiere [12]

11:07:01.966-----------> ConfigurationData.testMail: Not valid:  - Illegal address [12]

------------------[end]------------------------------------------------------------

[VuongCT]

Hi,

You need to import Idempiere Database so it works with idempiere server application, link: http://www.globalqss.com/wiki/index.php/IDempiere/Importing_DB_Seed_Manually  

Or just simply execute RUN_ImportIdempiere.bat in idempiere-server/utils directory since you're running iDempiere on Windows.

[a platypus]

Hi Vuong!

Thanks for that.  Once I ran the: 

• util/RUN_ImportIdempiere.bat
  

File, things went a lot better.

I will also point people to this wiki page:

• http://wiki.idempiere.org/en/Windows_Installation_an_more
  

This page is invaluable once you get up and running.  I am pasting the link here for folk like me who want to get going and feel totally clueless.  I think this project will benefit immensely from a motivated Product Information team.  All the information seems to be 'somewhere' but it is really challenging to source and get started.  I guess that's like everything; all in due time ;-)

Many thanks for the assist to all who posted.

Best wishes,

  Will

On Monday, 10 February 2014 13:47:08 UTC+11, VuongCT wrote:

Hi,

You need to import Idempiere Database so it works with idempiere server application, link: http://www.globalqss.com/wiki/index.php/IDempiere/Importing_DB_Seed_Manually  

Or just simply execute RUN_ImportIdempiere.bat in idempiere-server/utils directory since you're running iDempiere on Windows.

On Sunday, February 9, 2014 7:14:41 AM UTC+7, a platypus wrote:

Hello folk.

Thanks for the comments.  My password for the adempiere user is: 'adempiere'.  I still get the red square.  The setup did NOT create a new database.  This is the list of databases after running setup:

[Rahmat Jaffari]

Hi guys,

I am a newbie in the ID/ AD world. I have played around with the demo site and really enjoyed the power of this tool. I am trying to install idempiere V2 on a Windows 8 R2 64 bit server that has PostgreSQL 9.3 and Java 7u67. I have the following issue:

1) In the setup window, "Database Password" is red when I click on test.

2) I ran "RUN_ImportIdempiere.bat" and nothing happened.

Here is what I did so far in order:

1) Installed Java 7u67 (ran as administrator)

2) Installed PostgreSQL 9.3 (ran as administrator)

3) Downloaded "idempiereServer.win32.win32.x86_64" and unzipped it. Ran the setup.bat and got the first error mentioned above.

4) Ran "RUN_ImportIdempiere.bat" and got the second error above.

5) Ran the setup.bat and got the first error mentioned above again.

I have spent over 2 days of trial and error and researching but I had no luck. Any help will be greatly appreciated.

Thanks,

RJ

[Chuck Boecking]

Hi RJ,

I think I can make your life a little easier. Please start by reading this post about installing iDempiere in VirtualBox or in AWS. Most users, in my experience, use Linux to host iDempiere. There are many more tools and scripts available for making your life much easier. For example, here is an installation script where you simply paste the Single Line Summary into a new ubuntu 14.04 LTS Linux server, and the system is completely configured for you. Eight minutes later, iDempiere magically appears on port 8080.

Here is a tutorial for buying, selling, storing and shipping product in iDempiere. It gives you enough information so that you can repeat the entire process yourself.

If you have a budget to learn, configure and audit iDempiere, I teach an online iDempiere course to demonstrate common topics including a step by step tutorial of how to install a production server and the development environment. Here are the course frequently asked questions. 

I hope this helps! Let me know if you have additional questions.

Regards,

Chuck Boecking

[Rahmat Jaffari]

Thanks a bunch Chuck! I will give this a shot although I wanted to install it on my Windows 8 R2 VM. Would you happen to have a tutorial for Windows?

I am currently evaluating if iDempiere is the right solution for me. If so, I am definitely interested in learning more and attending your tutorials.

Thank you once again!

Regards,

RJ

[Chuck Boecking]

Hi RJ,

I apologize. I do not have any tutorials for Windows. All my tutorials and scripts are for Linux. Having said that - if you were interested in learning linux, I can make that process pretty easy. I am sympathetic to the Windows to Linux migration.

As a quick note, you can host a Linux iDempiere instance for free for one year in Amazon's AWS (if you are new to AWS). There is no commitment. The server is a t2.micro (1cpu and 1GB RAM). This is big enough to support two concurrent users, which is perfect for the evaluation process. After the year, the same will cost you between $6 USD and $10 USD per month depending on options.

Good luck!!

Regards,


Chuck Boecking
512.850.6068 (office and cell)
ch...@chuboe.com
ChuckBoecking.com
chuck.boecking (skype)

@ChuckBoecking

http://www.linkedin.com/pub/chuck-boecking/10/970/17b

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/9EP3w2UevWY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/c6041684-b347-41fe-8d0d-4bb9a1efe764%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Rahmat Jaffari]

I will take that into consideration. I really appreciate all your tips.

Thank you!

Regards,

RJ

[Fco. Javier Vannini Robelo]

Hey chuck, you say that for 2 concurrent users a server with 1 processor and 1 gb of ram is enough. How does this scale when adding more users ? Is it linear ?

--

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/cdbe977f-bb31-4f94-9c7c-18904a3d9f69%40googlegroups.com.

[Chuck Boecking]

Hi Javier,

I my experience, yes. However, Carlos and Low have performed more load testing than I have. The total AWS cost per user hovers between $4 and $6 per user per month. Here is the typical scaling progression:

• One server for both AppServer and DB
• One server for AppServer and one server for DB
• Use HAProxy to load balance the AppServer with a single DB
• Use HAProxy to Load balance the AppServer and pgPool2 to create a single-write and multi-read DB cluster.

I have personally used HAProxy with great success. Others have used have used pgPool2 with success. For production purposes, I recommend you skip the first bullet and go straight into the second. Here is a link to the installation script examples to create this environment. Look in the shortcuts section.

I plan to demonstration creating a 100+ concurrent user system using HAProxy and pgPool in an upcoming erp-academy discussion. I will let you know when we get close to this topic.

Does this help?

Regards,


Chuck Boecking
512.850.6068 (office and cell)
ch...@chuboe.com
ChuckBoecking.com
chuck.boecking (skype)

@ChuckBoecking

http://www.linkedin.com/pub/chuck-boecking/10/970/17b

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CACejJZhR3j0AfY0%3DNMruSH3kzZcnadjgM%3D%2BC4znOK7NygurV%3DQ%40mail.gmail.com.

[Fco. Javier Vannini Robelo]

Indeed it does helps ! Thanks for the time ! And my apologies for writing out of thread....

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CA%2Bw%3D76gidz7vYvyRHQD-%2BD1y7-ds2TjH%3DPP%2Br4BfzuBmhvf9Vw%40mail.gmail.com.

[stephan...@gmail.com]

hi i have a link that will answer all your questions. just follow http://wiki.idempiere.org/wiki/Cm:Cameroon. i hope it helps you alot

[stephan...@gmail.com]

hi RJ,maybe this link will help you out http://wiki.idempiere.org/wiki/Cm:Cameroon

[mung...@googlemail.com]

Hi RJ, Stephen noted, We in Cameroon have worked on an installer and on how to deploy Idempiere on winders and you can find the links here: http://wiki.idempiere.org/wiki/User:Tatiotir. We have also set up a small support team for New Commers to Idempiere to help them get around with the installation. If you encounter any problems please don't hesitate to contact me so I can be of help.

Thanks

Stanley

Thank you very much for your Question, as

[mung...@googlemail.com]

Hi RJ,

Are you still having the error with this installer: http://wiki.idempiere.org/wiki/User:Tatiotir ?

Please let me know so I can schedule sometime to help you out.

Thanks

Stanley

Am Samstag, 8. Februar 2014 13:42:28 UTC+1 schrieb a platypus:

[Sok Dina]

Hi guys, 

Please could you help me to solve this set up bellow:

*** 2016-10-21 01:56:56.594 idempiere Log (CLogFile) ***

01:56:56.593 Setup.<init>: iDempiere(r) Release 3.1_2015-10-31 -Smart Suite ERP, CRM and SCM- (c) 1999-2013 iDempiere(r); Implementation: iDempiere - Supported by iDempiere community [1]

01:56:56.662 ConfigurationData.load: C:\idempiere-server\idempiereEnv.properties [1]

01:57:14.693 Config.test: OK: JavaHome=C:\Program Files\Java\jre7 [26]

01:57:14.695 Config.test: OK: Version=1.7.0_79 [26]

01:57:14.697 ConfigurationData.testAdempiere: OK: AdempiereHome = C:\idempiere-server [26]

01:57:14.704 KeyStoreMgt.<init>: C:\idempiere-server\jettyhome/etc\keystore [26]

01:57:14.717 ConfigurationData.testAdempiere: OK: KeyStore = C:\idempiere-server\jettyhome/etc\keystore [26]

01:57:14.721 Config.test: OK: AppsServer = localhost/127.0.0.1 [26]

01:57:15.746 Config.test: OK: Web Port = 8081 [26]

01:57:17.025 Config.test: OK: SSL Port = 8443 [26]

01:57:17.029 ConfigPostgreSQL.test: OK: Database Server = localhost/127.0.0.1 [26]

01:57:17.036 ConfigPostgreSQL.test: OK: Database Port = 5432 [26]

01:57:17.145 ConfigPostgreSQL.test: OK: System Connection = jdbc:postgresql://localhost:5432/template1 [26]

01:57:17.168 ConfigPostgreSQL.test: OK: Database User = adempiere [26]

01:57:17.174-----------> ConfigurationData.testMail: Not valid:  - Illegal address [26]

01:58:04.643 Config.test: OK: JavaHome=C:\Program Files\Java\jre7 [28]

01:58:04.644 Config.test: OK: Version=1.7.0_79 [28]

01:58:04.647 ConfigurationData.testAdempiere: OK: AdempiereHome = C:\idempiere-server [28]

01:58:04.649 KeyStoreMgt.<init>: C:\idempiere-server\jettyhome/etc\keystore [28]

01:58:04.655 ConfigurationData.testAdempiere: OK: KeyStore = C:\idempiere-server\jettyhome/etc\keystore [28]

01:58:04.660 Config.test: OK: AppsServer = localhost/127.0.0.1 [28]

01:58:05.666 Config.test: OK: Web Port = 8081 [28]

01:58:06.683 Config.test: OK: SSL Port = 8443 [28]

01:58:06.685 ConfigPostgreSQL.test: OK: Database Server = localhost/127.0.0.1 [28]

01:58:06.689 ConfigPostgreSQL.test: OK: Database Port = 5432 [28]

01:58:06.742 ConfigPostgreSQL.test: OK: System Connection = jdbc:postgresql://localhost:5432/template1 [28]

01:58:06.766 ConfigPostgreSQL.test: OK: Database User = adempiere [28]

01:58:06.767-----------> ConfigurationData.testMail: Not valid:  - Illegal address [28]

01:58:06.771 Ini.loadProperties: C:\idempiere-server\idempiere.properties #28 [23]

01:58:06.775 ConfigurationData.save: C:\idempiere-server\idempiereEnv.properties [23]

*** 2016-10-21 01:58:08.792 idempiere Log (CLogFile) ***

[Chuck Boecking]

Hi Sok,

You need to give it an email address at a minimum. Say: some...@test.com

Regards,


Chuck Boecking
512.850.6068 (office and cell)
ch...@chuboe.com
ChuckBoecking.com
chuck.boecking (skype)

@ChuckBoecking

http://www.linkedin.com/pub/chuck-boecking/10/970/17b

--

You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/9EP3w2UevWY/unsubscribe.

To unsubscribe from this group and all its topics, send an email to idempiere+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/5733635b-cf8c-497a-b6f5-767cc156f77c%40googlegroups.com.

[Sok Dina]

Hi Chuck:

I have configure bellow, but it is still error, please help to check:

---------------------------------------------------------------

- Mail Server: imap.gmail.com

- Mail user: sokdi...@gmail.com

- Admin email: sokdi...@gmail.com

- pwd: .....

---------------------------------------------------------------

Thanks

To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.

[midvide...@gmail.com]

Hi,

Some times gmail not allow  less security app to access to your account, try with this Allowing less secure apps to access your account

Regards