Monday, July 14, 2014

Configure Pycharm development environment on Azure Ubuntu server

Steps to configure pycharm development environment on Azure Ubuntu server

Step 1) Install pycharm
Step 2) configure pycharm editor


Step 1) Install pycharm

login to server as odoo via putty

$ wget -q -O - http://archive.getdeb.net/getdeb-archive.key | sudo apt-key add -
$ sudo sh -c 'echo "deb http://archive.getdeb.net/ubuntu trusty-getdeb apps" >> /etc/apt/sources.list.d/getdeb.list'
$ sudo apt-get update
$ sudo apt-get install pycharm

Step 2) Configure pycharm for odoo

Open folder odoo








Configure windows rdp to Azure Ubuntu Server

Steps to configure windows rdp to Azure Ubuntu Server

Step 1: Open azure server Remote Desktop endpoint  port 3389
Step 2: Configure xrdp on Azure Ubuntu Server
Step 3: Login to server using windows rdp


Step 1: Open azure server Remote Desktop endpoint  port 3389



Step 2: Configure xrdp on Azure Ubuntu Server

login to server as odoo via putty

Here is a good description of process for installing and connecting to xrdp from windows via rdp, link

$ sudo apt-get update
$ sudo apt-get install xrdp
$ sudo apt-get install xfce4
$ sudo /etc/init.d/xrdp start
$ echo xfce4-session > ~/.xsession

Step 3: Login to server using windows rdp







Create odoo database instance

Steps to create odoo database instance

Step 1) create database
Step 2) View newly created database in pgadmin


Step 1) create database

First time going to aspenwareerp.cloudapp.net:8069 takes you to the management interface.



login with username: admin and password of what was entered above.





Step 2) View newly created database in pgadmin

newly created postgres database aspenware




Configure remote pgadmin to manage Azure Ubuntu postgres database

Steps to configure remote pgadmin (on windows) to manage Azure Ubuntu postgres database


Step 1) Add a password to postgres account

$ sudo passwd postgres
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully


Step 2) Update postgresql.conf and pg_hba.conf to allow external connection

$ su postgres
Password:

$ cd /etc/postgresql/9.3/main
$ vi postgresql.conf
change #listen_addresses = 'localhost'    to     listen_addresses = '*'

$ vi pg_hba.conf
add line:
host   all  all <ip>/24  md5
<ip> address of the windows client machine

$ cd /etc/init.d
$ ./postgresql restart
 * Restarting PostgreSQL 9.3 database server

Step 3) Add database password to postgres user

$ psql
psql (9.3.4)
Type "help"for help.

postgres=# \password postgres
Enter new password: 
Enter it again:
postgres=# 

Step 4) Open azure server endpoint for port 5432 


Step 5) Windows pgadmin III client connect to postgresql database











Configure odoo on an Azure Ubuntu Server

Steps to configure odoo on an Azure Ubuntu Server

In the following steps replace "http://aspenwareerp.cloudapp.net" with the name of your azure server.

Step 1) Create a PuTTY session to the Ubuntu Server
Step 2) Install and configure odoo from github
Step 3) Open up azure endpoint for port 8069
Step 4) Open browser and connect to the odoo server

Step 1) Create a PuTTY session to the Ubuntu Server
  • Go to http://www.putty.org/ and download putty.exe for your windows client
  • Execute putty and put in the host name (get from windows azure desktop - "DNS NAME")
  • Login to server






Step 2) Install and configure odoo from github

Follow the 11 simple steps outlined in this blog entry by Vimal Rughani.  Step 8 in the blog ends in error about the odoo user which is ok.  Step 9 is "cd odoo" in this configuration.  Step 11 cannot be done until we open up the Azure port 8069.

Copy each of the commands into the terminal as they show in the blog and execute.  Be patient, some of the commands take a while to execute.



This installs the needed python, postgres, and odoo software to run the odoo server.

execute each of the commands in the blog.
note:   $ sudo apt-get install git


Make sure and go to the odoo directory ($ cd ~/odoo) and start the server ($ ./openerp_server).



Step 3) Open up azure endpoint for port 8069






Step 4) Open browser and connect to the odoo server

browse to http://aspenwareerp.cloudapp.net:8069/




Configure an Azure Ubuntu Server

Steps to configure an Azure Ubuntu Server


1) Select "+NEW"
2) Virtual Machine -> From Gallery
3) UBUNTU -> UBUNTU Server 14.04 LTS
4) Configure UBUNTU Server
5) Configure UBUNTU Server User
6) Configure UBUNTU Server Save
7) Takes several minutes for server to configure (it is available to do work once it gets through the first two stages)


Step 1) Select "+NEW"



Step 2) Virtual Machine -> From Gallery



3) UBUNTU -> UBUNTU Server 14.04 LTS



Step 4) Configure UBUNTU Server

I configured a A2 size dual core server to support the database, server and development environment. Created a user named "odoo" with a password.  The user is used throughout the configuration so remember these settings.



Step 5) Configure UBUNTU Server User


Step 6) Configure UBUNTU Server Save

No changes are needed.  Select the configure button at bottom right and the server configuration will take a few minutes.


Step 7) Takes several minutes for server to configure

It is available to do work once it gets through the first two stages (shown in picture below)


odoo v8 (openerp) development environment running on an Azure Ubuntu server

Steps to create an odoo v8  (openerp) development environment running on an Azure Ubuntu server

This tutorial covers the creation of an odoo V8 development environment.  The tutorial is split into a number of posts that cover each stage of this process.

  • Configure an Azure Ubuntu Server
  • Configure odoo on an Azure Ubuntu Server
  • Configure remote pgadmin to manage Azure Ubuntu postgres database
  • Create odoo database instance
  • Configure windows rdp to Azure Ubuntu Server
  • Configure pycharm development environment on Azure Ubuntu Server


  • Here is a quick overview of the environment
    • Windows 7 client
    • Chrome browser
    • Azure management environment, manage.windowazure.com within Chrome browser
    • Azure Ubuntu Server
    • odoo V8.0 from github
    • postgresql 9.3

    This development environment is being used to develop modules for the odoo V8.0 platform.