Appliance configuration and administration
The Appliance includes a web management console you can use to run the initial configuration (Linux passwords, networking, backups, etc). This is available in https://<IP_ADDRESS>:8003.
Read the Appliance Administration guide for a reference documentation on the features supported by this administration console.
Installing the Appliance from a ISO/DVD
Professional users have exclusive access to a ISO image of the Openbravo Appliance, which can be deployment into a physical server. Burn the ISO into a DVD and follow these instructions to deploy it into a server.
Before you begin, make sure that the BIOS of the server is configured to boot from the DVD drive, otherwise the installation process will not start. Consult the documentation for the motherboard to find out how to configure the BIOS.
Now follow these steps:
- Insert the DVD in the DVD drive.
- Reboot the system.
- For a standard installation, press Enter when prompted. If there are any problems with hardware detection, you may need to set up further parameters. To set up hardware parameters, use the following function keys:
- F2: Options
- F3: General
- F4: Kernel
- F5: Rescue
Once you have set up the parameters correctly, the kernel loads.
- The installation wizard appears. Click Next.
- The license agreement appears. Scroll down to read the agreement.
- Click Next to accept the agreement and begin installing the appliance.
- From the Keyboard Configuration window, select the keyboard layout you require.
- Click Next. The Automatic Partitioning window appears.
- Choose from the following options:
- Remove all Linux partitions from this system. This option is recommended if you are replacing an already installed Linux system, but want to keep other partitions (for example a Windows partition).
- Remove all partitions from this system. This option is recommended if you are installing the appliance on a dedicated server.
- Keep all partitions and use existing free space. Select this option if you use an external tool for partitioning.
- To manually configure the partitions select the Review (and modify if needed) partitions checkbox and click Next. A separate window appears for you to specify the partition structure. To accept the default partitions without reviewing them, clear the checkbox and click Next.
- The Network Configuration window appears, showing a list of network devices that have been detected.
- To configure a device manually, select it and click Edit. If the device is allocated an IP address by DHCP, type DHCP in the box. Otherwise, specify the IP address. To make the device active at boot time, select the Active at boot time checkbox.
- Select Manual and type the hostname in the box.
- Click Next. The Timezone window appears.
- If your system clock is UTC (Universal Time Co-ordinated) select the System Clock is UTC checkbox. Otherwise, select the time zone you require from the list. You can enable UTC in the BIOS settings.
- Click Next. The installation process begins. Checking dependencies and installing the appliance can take up to an hour.
- When the installation is complete, remove the DVD from the DVD drive and reboot the system.
At this stage, you do not need to configure firewall and network services because they are configured using default parameters. You can make further adjustments using the Administration Console.
- Login: you may login with openbravo as the username and openbravo as the password.
- root access: passwordless by default, login as root and set the password with 'passwd'.
Note that these passwords are not used to login to Openbravo ERP, but in Linux.
The Appliance is configured to be secure by default. This means that password authentication for SSH is disabled by default, it only accepts public key authentication. You can enter your public key by using the web administration console in https://<IP_ADDRESS>:8003.
In case you want to enable password authentication for your own convenience, login to the virtual machine's terminal as the root user, edit the /etc/ssh/sshd_config file and set PasswordAuthenticaton:
Direct database access
The Appliance is configured to be secure by default. This is why PostgreSQL is hardened against external access. The way of connecting to the database using a PostgreSQL client (e.g. PgAdmin3) is through a SSH tunnel.
Create tunnel: Linux
Fist create the SSH tunnel:
ssh -L 5433:localhost:5432 openbravo@remote_computer
The database name is openbravo, the username tad and the password tad.
Create tunnel: Windows
Use PuTTY to connect to PostgreSQL in Windows. PuTTY is an open source and free SSH client:
- Select Session'.
- In the Host Name' box, enter IP Address of the Openbravo Network machine.
- 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 the openbravo user name and your passphrase, then leave this terminal opened.
Using the client: PgAdmin3
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.
I'm getting localhost as the IP address
If you are getting localhost as the IP address after booting the Appliance, then this section is for you. This typically happens when your network doesn't have a DHCP server that can provide an IP address to the Appliance. In these cases you need to manually assign an IP address to that Appliance:
- Log in as root to the Appliance.
- Type the following commands to set a specific ip IP_ADDRESS and a gateway IP_GATEWAY:
$ /sbin/ifconfig eth0 IP_ADDRESS netmask 255.255.255.0 up
- $ /sbin/route add default gw IP_GATEWAY
- Finally to make the IP address available to the Internet, assign some DNS servers to it:
$ echo "nameserver IP_DNS1" >> /etc/resolv.conf
- $ echo "nameserver IP_DNS2" >> /etc/resolv.conf
That's all. If the provided IP configuration is correct then Openbravo ERP should now be ready to use at http://<IP_ADDRESS>.