Fix OpenERP Server Connection Issue Outside Wireless Network

To access your OpenERP server outside your local wireless network, you’ll need to configure both your server and router to allow external access. Here’s a step-by-step guide to help you set this up:

Step 1: Configure Your OpenERP Server

1. Ensure OpenERP is Listening on All Interfaces:
   By default, OpenERP may only be listening on localhost (127.0.0.1). You need to ensure it listens on all network interfaces (0.0.0.0).

• Open your OpenERP configuration file, usually located at /etc/openerp-server.conf or /etc/openerp.conf.
• Find the line with xmlrpc_interface and make sure it is set to 0.0.0.0:
  plaintext xmlrpc_interface = 0.0.0.0
• Save the changes and restart the OpenERP service:
  bash sudo service openerp restart

2. Ensure Ubuntu Firewall Allows Traffic:

• Use ufw (Uncomplicated Firewall) to check and allow traffic to OpenERP’s port (default is 8069):
  bash sudo ufw allow 8069/tcp

Step 2: Configure Your Cisco Router

1. Access the Router’s Admin Panel:

• Open a web browser and enter the router’s IP address (usually something like 192.168.1.1).
• Log in with the admin credentials (username and password).

2. Set Up Port Forwarding:

• Locate the Port Forwarding section (it may be under Advanced Settings or NAT).
• Create a new port forwarding rule:
  • Service Name: A descriptive name like OpenERP.
  • External Port: 8069 (or whatever port OpenERP is using).
  • Internal Port: 8069.
  • Internal IP Address: The internal IP address of your Ubuntu server (e.g., 192.168.1.10).
  • Protocol: TCP.
• Save the settings.

3. Apply the Changes:

• Restart your router to apply the new configuration.

Step 3: Determine Your Public IP Address

• Go to a website like WhatIsMyIP or IP Chicken to find your public IP address.
• Note this address, as it will be used to access your server from outside your network.

Step 4: Test External Access

1. Test from an External Network:

• From a device not connected to your local network, open a web browser.
• Enter http://<your-public-ip>:8069.
• You should see the OpenERP login page if everything is correctly configured.

Additional Considerations

1. Dynamic DNS (Optional):

• If your public IP address changes frequently, consider setting up a Dynamic DNS (DDNS) service like No-IP or DynDNS. This provides a domain name (e.g., myopenerpserver.ddns.net) that always points to your current IP.

2. Security:

• Use SSL: Consider setting up SSL (HTTPS) for secure communication.
• Access Control: Restrict access by IP address if possible or use a VPN for secure remote access.
• Router Security: Ensure your router firmware is up to date, and the admin interface is secure.

3. Check with Your ISP:

• Some ISPs block certain ports or restrict inbound connections. Contact them if you’re unable to connect after these steps.

Would you like details on setting up Dynamic DNS or securing your OpenERP server with SSL?

Conclusion

To easily access your server of OpenERP outside from all your common wireless networks, then you have to organize both your router and server to permit any outside access. Go get the best managed Odoo server solutions, then Infinitive Host is an ideal choice.