TurnKey Linux Virtual Appliance Library

TKLPatch: TurnKey LAPP -> OpenERP

Dear all,

With a bunch of help from Alon and Liraz, here is a "conf" file to patch tkl-lapp iso image to include openerp.

This file may also be use to just install openerp on existing running tkl-lapp installation.

Caution :

  1. Please stop any instance of running Postgres daemon (i.e : /etc/init.d/postgresql-8.3 stop ), since this patch need to write to chrooted pgsql
  2. Openerp-web : run as service, no ssl, at port 8080

Credentials :

Have fun
-bino-

Liraz Siri's picture

Great work - OpenERP will make a great addition to the library

Kudos Bino! OpenERP will make a great addition to the library. I've created a blueprint on launchpad that links back to this forum post so we can keep easily keep track while working on the next release batch.

BTW, looking at the patch it looks like you used the conf for everything, including creating init scripts and such. In the future you may be able to accomplish the same goal more easily by dropping files into the overlay.

Again, many thanks!

Alon Swartz's picture

New TKLPatch section on development wiki

I have created a new section in the development wiki for TKLPatches, and have added this patch to the list. Feel free to update the patch page as you see fit.

patch request

need to update bzr in conf

 

echo "------------------------------------"
echo "Update to bazaar 2.0  "
echo "------------------------------------"
apt-get remove bzr 
curl -O http://backports.org/debian/pool/main/b/bzr/bzr_2.0.3-1~bpo50+1_i386.deb 
dpkg -i bzr_2.0.3-1~bpo50+1_i386.deb
 
...and something like this:
 
OPENERP_EGG=$(basename /usr/lib/python2.5/site-packages/openerp_web-*)
chmod +x /usr/lib/python2.5/site-packages/$OPENERP_EGG/scripts/openerp-web
ln -s /usr/lib/python2.5/site-packages/$OPENERP_EGG/scripts/openerp-web /etc/init.d/openerp-web
update-rc.d openerp-web start 70 2 3 4 5 . stop 20 0 1 6 .
 
#Adopting existing config 
ln -s /usr/lib/python2.5/site-packages/$OPENERP_EGG/config/openerp-web.cfg /etc/openerp-web.cfg
 

Trying to Patch OpenERP TKL

Hello, I'm new to TKL.  I've read this code and downloaded and built the TKLPatch tool.  I tried to apply the patch against the most recent LAPP and when I fire up a VM (virtualbox) with the patched ISO the box stops at BusyBox.

I figured I should try the straight LAPP and it works like a charm.  Does anybody have experience with the Patch of ERP working?  Should I try to patch the running system instead?

Thanks and especially for the patience with the newb.

L. Arnold's picture

This looks like a "built" patch.

I tried an earlier version of this (scroll down the list) a while back and it did load, though had several issues and am now looking at a New Install  (the patch is probably the path)

10 Euros will get a built one it seems off this web site.

http://openerpappliance.com/

Not sure why the built appliance is not floating somewhere in the archives.  Perhaps it is.

As an aside, having looked at OpenERP and OpenBravo I do prefer the OpenERP interface.  There are also some nice connectors to Magento (sneldev which can be downloaded of of a Google Hub seems most up to date in terms of the version of Magento it connects to).

The problem is I have had some errors and am trying a new install.  Also, I am not aware of OpenBravo connectors to Magento though I have seen indications that they are in the works.

All for now.

Jeremy's picture

TKL OpenERP appliance should be coming soon

I imagine that it will be included in the v11 partII release (with the other new appliances that only exist as patches so far). In the meantime you could try using this patch. Although it looks like Scott (above) may have had some issue that were possibly not resolved. I suspect the patch is made for the older 2009.10-2 Hardy based TKL release and that may be why it didn't work?

So the choice is, play with this patch, probably updating and troubleshooting it a bit. Or wait for an official TKL appliance and all the goodness that that entails. Or spend your ten euros and get a TKL based OpenERP now...

You may be able to use a

You may be able to use a linux package manager such as yum to install.  Or even aptitutde.

Openerp 6.0.2

I followed the following links almost exactly:

 

I am just starting to test to see if everything works.  I have not made a patch yet either since I have no idea if everything works.

Installing Openerp on Turnkey LAPP 11

 

https://docs.google.com/document/d/1d1jWy2Qk2Ymvj3F7Sx0R_1F7YraO2gdk8JGv1GShnYM/edit?hl=en&authkey=CJrYxAw

Changes:

I am not sure i wrote all of them down.  Let me know if I missed something.

  • Did not need to install postgresql
  • run openerp server as openerp

Configuring Apache to use https for openerp

 

https://docs.google.com/document/d/1861eyMCcSE0pNZKGHuPY5OfIatorxkpNg-4wFeiP1wI/edit?hl=en&authkey=COW5nkE

 

Changes/Clarification:

  • #serveripaddress     mydomain

          127.0.0.1               192.168.1.***               I was using this on a local network only for testing

  • Redirect / "https://192.168.1.***                 This is in the <VirtualHost *:80> section
  • Modifying /etc/apache2/sites-available/default-ssl/
  •        The Turnkey LAPP Control panel uses  443.  I have no idea how to turn that off...or if want to
  •        Added: Listen 8081 at top of file
  •                    <VirtualHost *:8081> with all of the lines detailed in the tutorial (including SSL lines )                     </VirtualHost>
  • Modifying /etc/openerp-web.cfg
  •         tools.proxy.base = 'https://192.168.1.***:8081'
  •         tools.proxy.local = ''                       THESE ARE 2x    '
  • I have not turned off the http:// access 

 

Hope this helps someone!

rdmelin's picture

Updated patch

There is an updated patch here:  http://www.turnkeylinux.org/forum/general/20111022/openerp-603-tkl-lapp-112

 

I couldn't figure out how to attach a file to a comment of I wouldn't have started a new post.

In theory, practice and theory are the same. In practice they're different.

L. Arnold's picture

Any thoughts on how to Integrate a Branch by Default?

I am cross posting.  My apologies, but the Patch here may be helpful for what I am trying to achieve.

Posted elsewhere, but I am looking to "permanently connect" the MagentoConnector to OpenERP so that out of the box it could Connect to Magento.   It is very difficult for non Branchers to know how to deal with an install that is not packaged as a simple Zip file in OpenERP.  Want to simplify all of this.

Bazaar Branches are here:

https://launchpad.net/openerp/

https://launchpad.net/magentoerpconnect

Technically this would also require having easy access to an Extension on the Magento Side..  I believe that side is a simple MagentoConnect download into magento. 

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)