I thought it was still in development..

http://lathama.net/Installing_OpenERP_7_on_Debian

(text from the llathama ink is basicaly:)

OpenERP or also known as OpenObject is Open Source Software written in Python starting over 13 years ago by Fabien Pinckaers (pinky) for his father and later his uncle's businesses. Today OpenERP provides the infrastructure for huge swaths of the manufacturing, hospitality, and other industries.

Sorry, it looks like I have misinformed you! I was sure that the TKL guys had fixed that up sometime ago. I just went back over the most recent blog posts and must admit that I couldn't find mention of a fix being released that included it so I must sincerely apologise.

I have contacted the devs to see if they can give some clarity on the situation (I know that some time ago Liraz was planning to make it's inclusion in TKLBAM a priority - and perhaps that's whay I thought it had been updated).

I recall that therre was some sort of (unsupported) workaround to include PostgreSQL backups in TKLBAM using the pre and post hooks facility, but it was never totally clearly documented anywhere (just hints on the pieces required to do it yourself).

My advice would be to read the advanced TKLBAM documentation and research creating a hook to dump the PostgreSQL DB on backup (and restore the dump on restore) and then use the --force-profile option to create the backup. Obviously you'll need to put the DB dump file somewhere where it will be included in the backup.

Recent update to TKLBAM now works with Postgres.  I went at least back to version 12 Squeeze.

(just to update the thread)

But you will also need to '--force-profile'. Unfortunately I'm not sure of the specific profile names/format but judging by the error message I would assume something like 'turnkey-mysql-12.0-squeeze-x86' or even 'turnkey-core-12.0-squeeze-x86' would work. Note though if you use the profile of an appliance that includes MySQL (eg the MySQL appliance) then you will need to '--skip databases' to avoid issues (if you use an appliance profile that doesn't include a MySQL DB then you won't need to worry).

When you are testing I would make sure that you try restoring to a fresh instance of PostgreSQL appliance as well (as you would have to if you had a hardware failure).

I'd love to hear how you go and it would be great if you could document your findings thus helping others in a similar position (just post back here to this thread if you want). Also if you have any issues ask here too. I can't guarantee that I will have the answers but more than happy to try to help! :)

Personally I love GitHub and have been using it for all patches that i have worked on for a while now. Launchpad is probably fine too, but I am now familiar with git (and AFAIK Launchpad uses bazaar which I have no experience with).

Here is why I would suggest GitHub:

• Nicer and more intuative UI which allows easier viewing of code (personal opinion)
• Well documented set up on GitHub site (again personal opinion)
• TKL devs use GitHub (makes it easier for them to include your code)
• Git is already installed in all TKL appliance by default (means no extra packages to install to upload/download patch code)
• Applying patches hosted on GitHub is already documented in TKL docs (by me :D)
• I know a bit about git (although not an expert by any stretch of the imagination) so can probably give you some pointers.

At the end of the day, though it probably doesn't matter that much. As long as you are using some sort of version control so you can tweak/adjust your code with facility to backtrack if you muck something up.

Was installed on TKL Lapp  (my modification seemed to have been around magento erp connect. 

Patch Text (conf-la)  (pwds should be changed) and likely were post install.  Never really went live but did function (and is functioning now).  This Patch however will no longer install as the source files have changed.  Should be able to redefine these two lines to aim for version 7.0 in the Nightly Directories cited above.

WebClient drives off Port 8080 in http.  Does not drive off of TKL SSL which is a problem.

http://(domain-or-ip):8080

OpenERP client (python standalone) drives off of 8070 looking like this.

Socket://(domain-or-ip):8070

(Disfunctioning links for PATCH)

wget http://www.openerp.com/download/stable/source/$SERVERSRC.tar.gz
wget http://www.openerp.com/download/stable/source/$WEBSRC.tar.gz

and one set futher down:
wget http://apps.openerp.com/addon/get_module_as_zip/1067/l10n_chart_us_general.zip

#!/bin/bash -ex
#adopted from :
# http://www.theopensourcerer.com/2011/04/19/how-to-install-openerp-6-on-ubuntu-10-04-lts-server-part-1/
#Caution : please stop any instance of running postgres daemon


PSQLRELEASE=8.4
PYTHONRELEASE=python2.6
UBUNTURELEASE=10.04.1
SERVERSRC=openerp-server-6.0.3
WEBSRC=openerp-web-6.0.3
INSTALLPATH=/opt/openerp
PASSWVAR="openerp"
HOSTNAME=openerp

# set hostname
echo "$HOSTNAME" > /etc/hostname
sed -i "s|127.0.1.1 \(.*\)|127.0.1.1 $HOSTNAME|" /etc/hosts


echo "------------------------------------"
echo "Enabling ubuntu multiverse repository"
echo "------------------------------------"
APTSOURCES=/etc/apt/sources.list.d/sources.list

COMMENT=`grep 'lucid multiverse' $APTSOURCES`
UNCOMMENT=$(echo $COMMENT | sed 's|#||')
sed -i "s|$COMMENT|$UNCOMMENT|" $APTSOURCES

COMMENT=`grep 'lucid-updates multiverse' $APTSOURCES`
UNCOMMENT=$(echo $COMMENT | sed 's|#||')
UNCOMMENT=$(echo $COMMENT | sed 's|#||')
sed -i "s|$COMMENT|$UNCOMMENT|" $APTSOURCES

apt-get update
echo "------------------------------------"
echo "installing needed packages"
echo "------------------------------------"

apt-get -y install sudo python python-psycopg2 python-reportlab \
python-egenix-mxdatetime python-tz python-pychart python-mako \
python-pydot python-lxml python-vobject python-yaml python-dateutil \
python-pychart python-pydot python-webdav python-cherrypy3 \
python-formencode python-pybabel python-simplejson python-pyparsing

apt-get install bzr

#Create openerp as system user
/usr/sbin/adduser --system --home=/opt/openerp --group openerp

#create pgsql user called openerp
#/etc/init.d/postgresql-$PSQLRELEASE stop

/etc/init.d/postgresql-$PSQLRELEASE start
sudo -u postgres createuser openerp --no-superuser --createdb --no-createrole
#Alter user open erp with defined password
sudo -u postgres psql template1 -U postgres -c "alter user openerp with password '$PASSWVAR'"

###-----Seting up OpenErp Server
#------Core OpenErp Server
cd /opt/openerp
wget http://www.openerp.com/download/stable/source/$SERVERSRC.tar.gz
wget http://www.openerp.com/download/stable/source/$WEBSRC.tar.gz
tar zxvf $SERVERSRC.tar.gz
tar zxvf $WEBSRC.tar.gz
rm -f  *.tar.gz
chown -R openerp: *
mv  $SERVERSRC server
mv $WEBSRC web

#-------Include US chart of accounts addon
wget http://apps.openerp.com/addon/get_module_as_zip/1067/l10n_chart_us_general.zip
unzip l10n_chart_us_general.zip
rm l10n_chart_us_general.zip
mv l10n_chart_us_general server/bin/addons
chown -R openerp: server/bin/addons/l10n_chart_us_general

#-------Include magentoerpconnect
cd /opt/openerp/server/bin/addons
bzr branch lp:magentoerpconnect
chown -R openerp: magentoerpconnect

bzr branch lp:magentoerpconnect/openerp6-module
chown -R openerp: openerp6-module

cd /opt/openerp/server/bin
md extra-addons
cd extra-addons
bzr branch lp:openobject-addons/6.0


#------Creating /etc/openerp-server.conf
cat > /tmp/openerp-server.conf <<"EOF"
[options]
; This is the password that allows database operations
; Will be written to by the server when password is changed
; !! Keep this file secure !!
; admin_passwd = admin

root_path = /opt/openerp/server/bin

without_demo = False
verbose = False

; Database settings
db_user = openerp
db_password = openerp
; Please uncomment the following line *after* you have created the
; database. It activates the auto module check on startup.
; db_name = False
db_port = False
db_host = False
db_maxconn = 64

; Networking Settings
xmlrpc = True
xmlrpc_interface =
xmlrpc_port = 8069

netrpc = True
netrpc_interface =
netrpc_port = 8070

; Uncomment these for xml-rpc over SSL
;xmlrpcs = True
;xmlrpcs_interface =
;xmlrpcs_port = 8071
;secure_pkey_file = /etc/ssl/openerp/server.pkey
;secure_cert_file = /etc/ssl/openerp/server.crt

; Log settings
logfile = /var/log/openerp/openerp-server.log
syslog = False
logrotate = True
log_level = info

; False prevents the client displaying the list of databases
list_db = True
addons_path = /opt/openerp/server/bin/addons
demo = {}
soap = False
reportgz = False
translate_modules = ['all']

; Static http parameters
static_http_enable = False
static_http_document_root = /var/www/html
static_http_url_prefix = /

; Outbound email configuration
;smtp_user = info@example.com
;email_from = "OpenERP Support" <info@example.com>
;smtp_port = 25
;smtp_password = ********
;smtp_ssl = True
;smtp_server = mail.example.com
EOF

mv /tmp/openerp-server.conf /etc/openerp-server.conf
chown openerp:root /etc/openerp-server.conf
chmod 640 /etc/openerp-server.conf

#------End creating /etc/openerp-server.conf

#------Creating init.d script
cat > /tmp/openerp-server <<"EOF"
#!/bin/sh

### BEGIN INIT INFO
# Provides:             openerp-server
# Required-Start:       $remote_fs $syslog
# Required-Stop:        $remote_fs $syslog
# Should-Start:         $network
# Should-Stop:          $network
# Default-Start:        2 3 4 5
# Default-Stop:         0 1 6
# Short-Description:    Enterprise Resource Management software
# Description:          Open ERP is a complete ERP and CRM software.
### END INIT INFO

PATH=/bin:/sbin:/usr/bin
DAEMON=/opt/openerp/server/bin/openerp-server.py
NAME=openerp-server
DESC=openerp-server

# Specify the user name (Default: openerp).
USER=openerp

# Specify an alternate config file (Default: /etc/openerp-server.conf).
CONFIGFILE="/etc/openerp-server.conf"

# pidfile
PIDFILE=/var/run/$NAME.pid

# Additional options that are passed to the Daemon.
DAEMON_OPTS="-c $CONFIGFILE"

[ -x $DAEMON ] || exit 0
[ -f $CONFIGFILE ] || exit 0

checkpid() {
    [ -f $PIDFILE ] || return 1
    pid=`cat $PIDFILE`
    [ -d /proc/$pid ] && return 0
    return 1
}

case "${1}" in
        start)
                echo -n "Starting ${DESC}: "

                start-stop-daemon --start --quiet --pidfile ${PIDFILE} \
                        --chuid ${USER} --background --make-pidfile \
                        --exec ${DAEMON} -- ${DAEMON_OPTS}

                echo "${NAME}."
                ;;

        stop)
                echo -n "Stopping ${DESC}: "

                start-stop-daemon --stop --quiet --pidfile ${PIDFILE} \
                        --oknodo

                echo "${NAME}."
                ;;

        restart|force-reload)
                echo -n "Restarting ${DESC}: "

                start-stop-daemon --stop --quiet --pidfile ${PIDFILE} \
                        --oknodo
      
                sleep 1

                start-stop-daemon --start --quiet --pidfile ${PIDFILE} \
                        --chuid ${USER} --background --make-pidfile \
                        --exec ${DAEMON} -- ${DAEMON_OPTS}

                echo "${NAME}."
                ;;

        *)
                N=/etc/init.d/${NAME}
                echo "Usage: ${NAME} {start|stop|restart|force-reload}" >&2
                exit 1
                ;;
esac

exit 0
EOF

mv /tmp/openerp-server /etc/init.d/
chmod 755 /etc/init.d/openerp-server
chown root: /etc/init.d/openerp-server
update-rc.d openerp-server defaults
#---------End creating init.d script


#Create /var/log/openerp with proper ownership:
mkdir -p /var/log/openerp
chown -R openerp.root /var/log/openerp/



###--------Setting up openerp  web client
#------Creating /etc/openerp-web.conf
cat > /tmp/openerp-web.conf <<"EOF"
[global]
server.environment = "development"

# Some server parameters that you may want to tweak
server.socket_host = "0.0.0.0"
server.socket_port = 8080

# Sets the number of threads the server uses
server.thread_pool = 10

tools.sessions.on = True
tools.sessions.persistent = False

# Simple code profiling
server.profile_on = False
server.profile_dir = "profile"

# if this is part of a larger site, you can set the path
# to the TurboGears instance here
#server.webpath = ""

# Set to True if you are deploying your App behind a proxy
# e.g. Apache using mod_proxy
#tools.proxy.on = True

# If your proxy does not add the X-Forwarded-Host header, set
# the following to the *public* host url.
#tools.proxy.base = 'http://mydomain.com'

# logging
#log.access_file = "/var/log/openerp-web/access.log"
log.error_file = "/var/log/openerp/openerp-web-error.log"
log.access_level = "INFO"
log.error_level = "INFO"

# Set to false to disable CSRF checks
tools.csrf.on = True

# replace builtin traceback tools by cgitb
tools.log_tracebacks.on: False
tools.cgitb.on: True
# a default install can probably avoid logging those via cgitb as they're
# available in the server log
tools.cgitb.ignore=(
    openobject.errors.Concurrency,
    openobject.errors.TinyException)

# OpenERP Server
openerp.server.host = 'localhost'
openerp.server.port = '8070'
openerp.server.protocol = 'socket'
openerp.server.timeout = 450

# Web client settings
[openerp-web]
# filter dblists based on url pattern?
# NONE: No Filter
# EXACT: Exact Hostname
# UNDERSCORE: Hostname_
# BOTH: Exact Hostname or Hostname_

dblist.filter = 'NONE'

# whether to show Databases button on Login screen or not
dbbutton.visible = True

# will be applied on company logo
company.url = ''
EOF

mv /tmp/openerp-web.conf /etc/
chown openerp:root /etc/openerp-web.conf
sudo chmod 640 /etc/openerp-web.conf

#--------End creating /etc/openerp-web.conf

#------Creating /etc/init.d/openerp-web
cat > /tmp/openerp-web <<"EOF"
#!/bin/sh

### BEGIN INIT INFO
# Provides:             openerp-web
# Required-Start:       $remote_fs $syslog
# Required-Stop:        $remote_fs $syslog
# Should-Start:         $network
# Should-Stop:          $network
# Default-Start:        2 3 4 5
# Default-Stop:         0 1 6
# Short-Description:    OpenERP Web - the Web Client of the OpenERP
# Description:          Open ERP is a complete ERP and CRM software.
### END INIT INFO

PATH="/sbin:/bin:/usr/sbin:/usr/bin"
DAEMON="/opt/openerp/web/openerp-web.py"
NAME="openerp-web"
DESC="openerp-web"

# Specify the user name (Default: openerp).
USER=openerp

# Specify an alternate config file (Default: /etc/openerp-web.conf).
CONFIGFILE="/etc/openerp-web.conf"

# pidfile
PIDFILE=/var/run/$NAME.pid

# Additional options that are passed to the Daemon.
DAEMON_OPTS="-c $CONFIGFILE"

[ -x $DAEMON ] || exit 0
[ -f $CONFIGFILE ] || exit 0

checkpid() {
    [ -f $PIDFILE ] || return 1
    pid=`cat $PIDFILE`
    [ -d /proc/$pid ] && return 0
    return 1
}

case "${1}" in
        start)
                echo -n "Starting ${DESC}: "

                start-stop-daemon --start --quiet --pidfile ${PIDFILE} \
                        --chuid ${USER} --background --make-pidfile \
                        --exec ${DAEMON} -- ${DAEMON_OPTS}

                echo "${NAME}."
                ;;

        stop)
                echo -n "Stopping ${DESC}: "

                start-stop-daemon --stop --quiet --pidfile ${PIDFILE} \
                        --oknodo

                echo "${NAME}."
                ;;

        restart|force-reload)
                echo -n "Restarting ${DESC}: "

                start-stop-daemon --stop --quiet --pidfile ${PIDFILE} \
                        --oknodo

                sleep 1

                start-stop-daemon --start --quiet --pidfile ${PIDFILE} \
                        --chuid ${USER} --background --make-pidfile \
                        --exec ${DAEMON} -- ${DAEMON_OPTS}

                echo "${NAME}."
                ;;

        *)
                N=/etc/init.d/${NAME}
                echo "Usage: ${NAME} {start|stop|restart|force-reload}" >&2
                exit 1
                ;;
esac

exit 0
EOF

mv /tmp/openerp-web /etc/init.d/
chmod 755 /etc/init.d/openerp-web
chown root: /etc/init.d/openerp-web
update-rc.d openerp-web defaults

#--------End creating /etc/init.d/openerp-web


apt-get clean
cd /opt

#add services information
SERVICES=/etc/confconsole/services.txt
echo 'Openerp:    http://$ipaddr:8080' >> $SERVICES

exit 0

I will confirm, when I go into Apache, none of the OPENERP POrts are called out so Apache Proper is not Serving this.  Seems could be installed on Core or PostGre just as well.  Still need to disect how the OpenERP service is being controlled.... though I am sure it is Pointed to in the Text above.

as a side note:

I also had these notes along side..  seemingly learning notes about Bazaar (bzr)...  I don't think real relavent to this.

Notes Installing Magentoerpconnect

(first on Core Appliance)
apt-get update
apt-get install bzr

apt-get install zip (do download modules as zips)

md addbzr

apt-get updatate
apt-get install bzr

cd addbzr  (root/bzr)

bzr branch lp:magentoerpconnect

bzr branch lp:magentoerpconnect/openerp6-module

---
do

addons

do dependencies

su - postgres -c "createuser -s openerp" 2> /dev/null || true

Creating first Database as we speak.  (Ok, made it)

I need to get my hands around the "Super password" which I don't recall creating in this iteration.  It was filled in and I went with it....

I have a "first build" running.

My suggestion would be to either start a fresh thread and edit the top post (rather than making new posts) and any new info keep adding/editing the top post. That way the info is all at the top instead of users having to crawl through a whole thread...

I documented how I built an install (but have not patched)

https://blueprints.launchpad.net/turnkeylinux/+spec/openerp-appliance

Also a number of Patches are posted here.  It would be great if you could post yours and background about it both on the blueprints, and the patches site below:  (Patches takes Code it seems, or at least allows a good link to Code)

http://wiki.turnkeylinux.org/TKLPatch/Patches

I agree that Forums tend to meander.  Many of my posts were "on the way to a build"...  It is a great system for me but we really need a TKL Patch, then a TKL Build to get some more transportability and optimization in.

If you post a patch I'll bet that can promote a full build.

Thank you!

To answer you, Carlos directly (Patch or Build?)

It would be great to have your help to build a TKLDEV ISO for OpenERP.

OpenERP is working well now and it would be nice to have it in the Stable.

We could work w/ a Team over on GitHub or in the other Devo areas at TKL.  Can you ping in on that side?  I will ping back.