Installation/Appliance/Openbravo - Revision history

Wikiadmin: Created page with "{| style="margin: auto;" cellpadding="0" |- align="center" |

2021-11-18T00:40:36Z

Created page with "{| style="margin: auto;" cellpadding="0" |- align="center" | <div class="t"><div class="b"><div class="l"><div class="r"><div class="bl"><div class="br"><div class="tl"><div..."

New page
{| style="margin: auto;" cellpadding="0"
|- align="center"

| <div class="t"><div class="b"><div class="l"><div
class="r"><div class="bl"><div class="br"><div class="tl"><div
class="tr">
<div style="height:25px;display:
table-cell;vertical-align:middle;"><span style="color:#DC6710">[[Installation | Installation]]</span></div>
</div></div></div></div></div></div></div></div>

|rowspan="2" | <div class="t"><div class="b"><div class="l"><div class="r"><div
class="bl"><div class="br"><div class="tl"><div class="tr">
<div style="height:25px;display:
table-cell;vertical-align:middle;"><span style="color:#DC6710">[[Installation/Appliance/Openbravo | Work with Openbravo]]</span>
</div></div></div></div></div></div></div></div></div>

|rowspan="2" | <div class="t"><div class="b"><div class="l"><div class="r"><div
class="bl"><div class="br"><div class="tl"><div class="tr">
<div style="height:25px;display:
table-cell;vertical-align:middle;"><span style="color:#DC6710">[[Installation/Appliance/Config | Configuration of appliance]]</span>
</div></div></div></div></div></div></div></div></div>

|rowspan="2" | <div class="t"><div class="b"><div class="l"><div class="r"><div
class="bl"><div class="br"><div class="tl"><div class="tr">
<div style="height:25px;display:
table-cell;vertical-align:middle;"><span style="color:#DC6710">[[Installation/Appliance/Howto | Howto / Optional configuration]]</span>
</div></div></div></div></div></div></div></div></div>

|rowspan="2" | <div class="t"><div class="b"><div class="l"><div class="r"><div
class="bl"><div class="br"><div class="tl"><div class="tr">
<div style="height:25px;display:
table-cell;vertical-align:middle;"><span style="color:#DC6710">[[Installation/Appliance/Migration | Migration to new appliances]]</span>
</div></div></div></div></div></div></div></div></div>

|}

{{(!)|This document refers to the appliances 12.04, 14.04 and 18.04.}}

== Connect to the database ==

=== psql ===

Connect by ssh with openbravo user and then you can connect to the database with:
psql -h localhost -U tad openbravo
Default password: tad

=== pgadmin with ssh tunnel ===

==== ssh tunnel in linux ====

Connect by ssh doing a tunnel from your local port 5433 of the server port 5432
ssh openbravo@<IP_ADDRESS> -L 5433:localhost:5432
Then in your local pgadmin in host set localhost and port 5433

==== ssh tunnel in windows ====

PuTTY is an open source and free SSH client.

Use PuTTY to connect to PostgreSQL:
# Select ''Session'''.
# In the ''Host Name''' box, enter IP Address of the Openbravo Appliance.
# Select ''Connection -> SSH -> Tunnels''.
# In the ''Source port'' field, enter ''5433''.
# In the ''Destination'' field, enter ''localhost:5432''.
# Click ''Add''.
# Click ''Open'' to open the ssh connection.
# Type openbravo as user name and your password, then leave this Putty window opened.

==== pgAdmin connection setup ====

Now you can start psql, pgAdmin or your favorite client and use localhost as the host and 5433 as the port in the connection details.

The database name is ''openbravo'', the username ''tad'' and the password ''tad''.

[[Image:appliance-ssh-tunnel-pgsql.png|center|700px]]

== Compile ==

Check that you are logged in with the openbravo user and in the /opt/OpenbravoERP folder.

You can check the current username with:
whoami
You can check the folder in which you are with:
pwd
Then you can compile. For example:
ant smartbuild

{{(!)|Do not use sudo or the root user for compilation. Use the openbravo user.}}

== Logs ==

The logfiles of openbravo are in the /var/log/openbravo folder.

The application logfiles:
/var/log/openbravo/catalina.out
/var/log/openbravo/openbravo.log
/var/log/openbravo/openbravo_hibernate.log
The PostgreSQL logfile
/var/log/openbravo/postgresql-9.1-main.log # Appliance 12.04
/var/log/openbravo/postgresql-9.3-main.log # Appliance 14.04
/var/log/openbravo/postgresql-10-main.log # Appliance 18.04
And the log of the periodic/automatic backups
/var/log/openbravo/openbravo-backup.log

== Customizing parameters ==

=== Customizing Tomcat parameters ===

The configuration for Tomcat is in
/etc/profile.d/tomcat.sh

If you need to set more ram to tomcat take a look to the [[Installation/Appliance/Howto#Memory|memory]] recommendations.

=== Customizing PostgreSQL parameters ===

The configuration for PostgreSQL is:
/etc/postgresql/9.1/main/ # Appliance 12.04
/etc/postgresql/9.3/main/ # Appliance 14.04
/etc/postgresql/10/main/ # Appliance 18.04

{{(!)|The new Appliance 18.04 has the main config postgresql.conf split to several files}}

The appliance will contain now 2 files prepared:
/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf # Do NOT edit this
/etc/postgresql/10/main/conf.d/91-local-custom.conf # Put your changes here

Goals behind this are:
* Splitting the configuration of a server into:
Openbravo Standard configuration
Custom local changes done in a particular server
* Allowing to centrally manage some config files in advanced scenarios (i.e. Openbravo Cloud)

In practice that means instead of editing main/postgresql.conf you want to typically edit '''conf.d/91-local-custom.conf'''

{{(!)|When working with big volume databases, it may be a good idea to increase the [[Installation/Appliance/Howto#Memory|memory]] assigned to postgres.}}

=== Customizing Ant parameters ===

The default options should be fine for most cases, but if you need to adjust them they are in
/etc/profile.d/ant.sh

== Restart services ==

=== Restart Tomcat ===
To restart Tomcat
sudo /etc/init.d/tomcat restart

=== Restart PostgreSQL ===

Usually it is only needed to restart PostgreSQL manually when you want to apply some new configuration values.

Before restarting PostgreSQL, close all connections to postgres (openbravo, pgadmin, etc), i.e:
sudo /etc/init.d/tomcat stop
sudo /etc/init.d/postgresql restart
sudo /etc/init.d/tomcat start

[[Category:Installation]]