LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-08-2009, 04:17 AM   #1
kchakrak
LQ Newbie
 
Registered: Sep 2008
Location: Kent, UK
Distribution: Ubuntu
Posts: 11

Rep: Reputation: 0
Smile Starting a postgres database at boot


I'm attempted to get a TinyERP (which uses PostgreSQL database engine) to start at boot. Essentially at the moment you need to log in and start the TinyERP server manually by typing in 'sudo su postgres -c tinyerp-server'. There is also another command called 'start-tinyerp' which is the web front end service, which also needs to be started at boot.

I've added the processes themselves to the rc*.d directories (where * is the runlevel) and also tried scripts (although extremely basic ones). The best i've got is entering the processes themselves, but the problem this presents is that the boot process stops once the tinyerp-server boots, due to the way the process has been configured.

Any Idea's? Anything welcome.

OS: Ubuntu 8.04

Kieran
 
Old 01-08-2009, 05:49 AM   #2
slack12ware
Member
 
Registered: Mar 2008
Location: Deep in the Jango(Africa)
Distribution: Slackware 12, Fedora 8
Posts: 46

Rep: Reputation: 15
youre looking fore a TinyERB init startup script right ? Correct me iof am wrong

anyway here is a Slackware version which I think with a little or no twitch might do the trick.
-----
#!/bin/sh
#
# Slackware startup script for TinyERP Server
# Written by Francis David <contato@fdavid.com.br> on 07 March 2008
# Last revision on --
#
# Based on startup script fro PostgresSQL
# Original author: Ken Zalewski <kennyz@nycap.rr.com>
#
# NOTES:
# This script can be run directly from a root command sheel, using:
# root# /etc/rc.d/rc.tinyerp-server start
# or
# root# /etc/rc.d/rc.tinyerp-server stop
#
# For automatic startup, it should be added to /tc/rc.d/rc.M, just
# beneath the MySQL startup. A sample startup line:
#
# [ -x /etc/rc.d/rc.tinyerp-server ] && /etc/rc.d/rc.tinyerp-server start
#
# or more traditionally:
#
# if [ -x /etc/rc.d/rc.tinyerp-server ]; then
# /etc/rc.d/rc.tinyerp-server start
# fi
#
# Note that this script should NOT be sourced (using the "." command),
# since it contains "exit" statements which would cause rc.M to exit
# prematurely. This is similar to rc.cups, which also cannot be sourced.
#

PGUSER=postgres

TINY="/usr/lib/python2.4/site-packages/tinyerp-server"
BIN="tinyerp-server.py"
PARAM="-without-demo=all"
DAEMON="$TINY/$BIN $PARAM"

LOG="$TINY/tinyerp-server.log"

if [ ! -e "$LOG" ]; then
touch "$LOG" || exit 1
chmod go-rwx "$LOG"
fi

start() {
echo -n "Starting TinyERP Server: "
su - $PGUSER -c "$DAEMON" >> $LOG &
[ $? -eq 0 ] && echo "ok" || echo "failed"
}

stop() {
echo "Stoping TinyERP Server"
killall "$BIN"
}

restart() {
stop
start
}

case $1 in
start)
start
;;
stop)
stop
;;
restart)
restart
;;
*)
echo "Usage: $0 {start|stop|restart}" 1>&2
exit 1
;;
esac

exit 0

----

If not helpful post all the commands you enter to sucessfully start TinyERB sucessfully, might try to cook up a simplified 1 for you.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Scripts updating a postgres database ethnicme Programming 1 07-15-2006 10:21 AM
create table in postgres database kranti Linux - Newbie 1 11-15-2005 06:52 PM
Problem with Postgres Database Connection anjani.78 Linux - Software 1 10-07-2005 02:06 AM
changing password for postgres database anjani.78 Linux - Software 1 07-18-2005 10:58 PM
Starting up a service (Postgres) on boot aa2bi Linux - Newbie 1 06-15-2004 05:34 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:45 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration