beaker-init failed with SQL errors for me. The 2 patches below fixed it. This is
with PostgreSQL server.
[root@beaker server]# rpm -q beaker-server
beaker-server-0.6.8-5.el5
[root@beaker server]# pwd
/usr/lib/python2.4/site-packages/bkr/server
[root@beaker server]# diff -u model.py.orig model.py
--- model.py.orig 2011-04-14 22:44:52.000000000 +0300
+++ model.py 2011-04-14 22:45:19.000000000 +0300
@@ -516,7 +516,7 @@
)
beaker_tag_table = Table('beaker_tag', metadata,
- Column('id', Integer, primary_key=True, nullable = False),
+ Column('id', Integer, primary_key=True, nullable = False, unique=True),
Column('tag', Unicode(20), primary_key=True, nullable = False),
Column('type', Unicode(40), nullable=False),
UniqueConstraint('tag', 'type'),
@@ -524,7 +524,7 @@
)
retention_tag_table = Table('retention_tag', metadata,
- Column('id', Integer, ForeignKey('beaker_tag.id', onupdate='CASCADE',
ondelete='CASCADE'),nullable=False, primary_key=True),
+ Column('id', Integer, ForeignKey('beaker_tag.id', onupdate='CASCADE',
ondelete='CASCADE'), nullable=False, primary_key=True),
Column('default_', Boolean),
Column('needs_product', Boolean),
mysql_engine='InnoDB',
[root@beaker server]# diff -u tools/init.py.orig tools/init.py
--- tools/init.py.orig 2011-04-14 22:42:56.000000000 +0300
+++ tools/init.py 2011-04-14 22:43:07.000000000 +0300
@@ -176,7 +176,7 @@
NAK = Response(response=u'nak')
if RetentionTag.query().count() == 0:
- SCRATCH = RetentionTag(tag=u'scratch', is_default=1)
+ SCRATCH = RetentionTag(tag=u'scratch', is_default=True)
SIXTYDAYS = RetentionTag(tag=u'60days', needs_product=False)
ONETWENTYDAYS = RetentionTag(tag=u'120days', needs_product=False)
ACTIVE = RetentionTag(tag=u'active', needs_product=True)
--
Alexander.