Tuesday, July 7, 2015

Running PostgreSQL in LAN

These are the files you should modify to make your PostgreSQL accepting connection from LAN
  1. postgresql.conf
    1. Edit file /etc/postgresql/[version number]/main/postgresql.conf
    2. file line listen_addresses, commented it and add your server ip address, examplelisten_addresses = '10.0.0.1,localhost'
  2. pg_hba.conf
    1. Edit file /etc/postgresql/[version number]/main/pg_hba.conf
    2. add this linehost    all         all         10.0.0.0       255.255.255.0    md5

Configuring XAMPP 1.8.1, Oracle XE 11G R2 x64 & Windows x64

System requirement:
  1. VC9
  2. XAMPP 1.8.1
  3. Oracle XE 11G R2
I assumed those requirement already install.
NOTE:
XAMPP 1.8.1 is 32 bits application, therefor, it needs Oracle Instance
Here is steps to configure XAMPP 1.8.1 & Oracle XE 11G x64 work in the same PC:
  1. Download instant client and SDK use this link: http://www.oracle.com/technetwork/topics/winsoft-085727.html
    1. oracle instant client instantclient-basic-nt-11.2.0.4.0.zip
    2. oracle SDK instantclient-sdk-nt-11.2.0.4.0.zip
  2. Extract into C:\instantclient_11_2
    1. oracle instant client instantclient-basic-nt-11.2.0.4.0.zip
    2. oracle SDK instantclient-sdk-nt-11.2.0.4.0.zip
  3. set and or add into path
    C:\instantclient_11_2;C:\oraclexe\app\oracle\product\11.2.0\server\bin;
    Note: DO NOT put C:\instantclient_11_2 after C:\oraclexe\app\oracle\product\11.2.0\server\bin;
  4. Edit php.ini, unset
    ;extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
    extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
    Note: only 1 dll can be activated, for Express edition use extension=php_oci8_11g.dll
  5. Restart apache

OpenERP 6.1: Disable Developer Mode (old)

Create a module and create an xml file named base.xml in the following path disable_developer_mode/static/src/xml/base.xml (where disable_developer_mode is the new module created) and add the following to the base.xml file.
<templates id="base.template" xml:space="preserve">

<t t-extend="ViewManagerAction">
    <t t-jquery="select.oe_debug_view" t-operation="replace">
        <select t-if="self.session.uid === 1 and self.session.debug" class="oe_debug_view"/>
    </t>

</t>
</templates>
Here self.session.uid === 1 is given where 1 is the id of the admin, if it is different in your system check the database and edit it. Add the base.xml file in the disable_developer_mode's __openerp__.py file as the folowing
{
    'name': 'Disable Developer Mode',
    'version': '0.1',
    'category': 'Others',
    'sequence': 20,
    'summary': 'Disable Developer Mode',
    'description': """
Disable Developer Mode
==================
    """,
    'author': 'Gopakumar N G',
    'website': 'http://zbeanztech.com/blogs/nggopakumar',
    'images': [],
    'depends': ['base'],
    'data': [],
    'demo': [],
    'test':[],
    'installable': True,
    'application': False,
    'js': [],
    'css' : [],
    'qweb' : ["static/src/xml/base.xml"]
}
Update your module and restart the server, now the debugging drop-down box will not be shown for all users except admin.

Ref: http://help.openerp.com/question/32065/how-to-deactivate-developer-mode-in-openerp-61-for-all-users-except-admin/

Installing & configuring Oracle Java ME in Netbeans 8 & Windows 8

I do not like installing bundling software, because I just parcular application and I want my JDK can be access, install, uninstall and upgrade dependly. Therefor I tried manual installation, here are my steps: Installation: 
1. Minimum Java SDK Standard Edition Development Kit (JDK) release 7 update 55 must work. 
2. Netbeans 8 already run properly. 
3. Install oracle-jmesdk-3-4-rr-win32-bin.exe 
4. Installing plugin into Netbeans 8: 
a. Extract oracle-jmesdk-3-4-rr-eclipse-plugins.zip 
b. Install plugin melalui Tools -> Plugins -> Downloaded -> Add Plugins 
c. Select all *.ndb files, and open 
d. Click Install e. Restart netbeans

Installing and configure Active Directory in Windows 2008 Server

Requirement:
  1. Legal Software  and Windows Server Security Update
  2. Static IP Address
  3. Strong Administrator's password contains combination of uppercase, lowercase, numeric, and punctuation mark.
Here are the steps:
  1. run server manager (Control Panel -> Administrative Tools)
  2. From Roles, click "add roles"
  3. Make sure to checked "Active Directory Domain Service"
  4. Click next and wait until it done.
  5. Click run dcpromo.exe or from cmd run dcpromo.exe then click next 
  6. For simple configuration, uncheck "Use Advanced mode installation" and choose create a new domain in "a new forest"
    1. FQDN "testing.local"
    2. choose Forest functional level "Windows Server 2008", next
    3. option to install "DNS Server"
  7. Clik next, and wait until installation finish (auto reboot when "reboot on completion" checked)