+sipb-xen-database (2) unstable; urgency=low
+
+ * Fix the postinit and prerm scripts to create a sipb-xen user
+
+ -- Nelson Elhage <nelhage@mit.edu> Thu, 16 Aug 2007 16:27:36 -0400
+
sipb-xen-database (1) unstable; urgency=low
* Initial Release.
Package: sipb-xen-database-server
Architecture: all
-Depends: ${misc:Depends}, postgresql-8.1, python-sqlalchemy, python-psycopg2, sipb-xen-database-common
+Depends: ${misc:Depends}, ${python:Depends}, postgresql-8.1, python-sqlalchemy, python-psycopg2, sipb-xen-database-common
Description: Installs the SIPB Xen database server
This tracks all the user VMs and is accessed from the VM host
# Don't fail if the user/database already exists
su postgres -c 'createuser sipb-xen -S -d -R' || true
su postgres -c 'createdb sipb_xen -O sipb-xen' || true
- PG_HBA=/etc/postgresql/8.1/main/pg_hba.conf
- perl -ni -e 'print unless /^# ===BEGIN ADDED BY sipb-xen-dabase server$/ ..
- /^# ===END ADDED BY sipb-xen-dabase server$/' \
- "$PG_HBA"
- cat<<EOF >> "$PG_HBA"
-# ===BEGIN ADDED BY sipb-xen-dabase server
-# DO NOT EDIT
-host sipb_xen sipb-xen 127.0.0.1/32 trust
-local sipb_xen sipb-xen trust
-# ===END ADDED BY sipb-xen-dabase server
-EOF
-
- if hash invoke-rc.d; then
- invoke-rc.d postgresql-8.1 restart
- else
- /etc/init.d/postgresql-8.1 restart
- fi
-
- sipb-xen-database-tables create
+ adduser --system sipb-xen
+
+ su sipb-xen -s /bin/sh -c 'sipb-xen-database-tables create'
;;
abort-upgrade|abort-remove|abort-deconfigure)
# This will destroy data -- do we want to do this?
# su postgres -c 'dropdb sipb_xen'
# su postgres -c 'dropuser sipb-xen'
- PG_HBA=/etc/postgresql/8.1/main/pg_hba.conf
- perl -ni -e 'print unless /^# ===BEGIN ADDED BY sipb-xen-dabase server$/ ..
- /^# ===END ADDED BY sipb-xen-dabase server$/' \
- "$PG_HBA"
-
- if hash invoke-rc.d; then
- invoke-rc.d postgresql-8.1 restart
- else
- /etc/init.d/postgresql-8.1 restart
- fi
+ deluser sipb-xen
;;
failed-upgrade)
if len(sys.argv) == 1:
usage()
-connect('postgres://sipb-xen@localhost/sipb_xen')
+connect('postgres://sipb-xen@/sipb_xen')
if sys.argv[1] == "create":
meta.create_all()