[error] DatabaseError: (1146, "Table 'irdbd.app_alert' doesn't exist")

[sraustein]

ignore second half which lies about a make install problem {{{ ca0/freebsd - [Mon Apr 15 22:45:58 2013] [error] ERROR 2013-04-15 22:45:58,445 django.request Internal Server Error: /rpki/ [Mon Apr 15 22:45:58 2013] [error] Traceback (most recent call last): [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 111, in get_response [Mon Apr 15 22:45:58 2013] [error] response = callback(request, _callback_args, _callback_kwargs) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/contrib/auth/decorators.py", line 20, in _wrapped_view [Mon Apr 15 22:45:58 2013] [error] return view_func(request, _args, _kwargs) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/rpki/gui/decorators.py", line 30, in _tls_required [Mon Apr 15 22:45:58 2013] [error] return f(request, _args, _kwargs) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/rpki/gui/app/views.py", line 93, in wrapped_fn [Mon Apr 15 22:45:58 2013] [error] return f(request, _args, _kwargs) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/rpki/gui/app/views.py", line 236, in dashboard [Mon Apr 15 22:45:58 2013] [error] 'clients': clients, [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/shortcuts/init.py", line 44, in render [Mon Apr 15 22:45:58 2013] [error] return HttpResponse(loader.render_to_string(_args, _kwargs), [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/loader.py", line 176, in render_to_string [Mon Apr 15 22:45:58 2013] [error] return t.render(context_instance) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 140, in render [Mon Apr 15 22:45:58 2013] [error] return self._render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 134, in _render [Mon Apr 15 22:45:58 2013] [error] return self.nodelist.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 823, in render [Mon Apr 15 22:45:58 2013] [error] bit = self.render_node(node, context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 837, in render_node [Mon Apr 15 22:45:58 2013] [error] return node.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 123, in render [Mon Apr 15 22:45:58 2013] [error] return compiled_parent._render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 134, in _render [Mon Apr 15 22:45:58 2013] [error] return self.nodelist.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 823, in render [Mon Apr 15 22:45:58 2013] [error] bit = self.render_node(node, context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 837, in render_node [Mon Apr 15 22:45:58 2013] [error] return node.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 123, in render [Mon Apr 15 22:45:58 2013] [error] return compiled_parent._render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 134, in _render [Mon Apr 15 22:45:58 2013] [error] return self.nodelist.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 823, in render [Mon Apr 15 22:45:58 2013] [error] bit = self.render_node(node, context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 837, in render_node [Mon Apr 15 22:45:58 2013] [error] return node.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 62, in render [Mon Apr 15 22:45:58 2013] [error] result = block.nodelist.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 823, in render [Mon Apr 15 22:45:58 2013] [error] bit = self.render_node(node, context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 837, in render_node [Mon Apr 15 22:45:58 2013] [error] return node.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/defaulttags.py", line 281, in render [Mon Apr 15 22:45:58 2013] [error] return nodelist.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 823, in render [Mon Apr 15 22:45:58 2013] [error] bit = self.render_node(node, context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 837, in render_node [Mon Apr 15 22:45:58 2013] [error] return node.render(context) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/template/base.py", line 1107, in render [Mon Apr 15 22:45:58 2013] [error] return func(_resolved_args, _resolved_kwargs) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/rpki/gui/app/templatetags/app_extras.py", line 41, in alert_count [Mon Apr 15 22:45:58 2013] [error] unread = len(qs) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 85, in len [Mon Apr 15 22:45:58 2013] [error] self._result_cache = list(self.iterator()) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 291, in iterator [Mon Apr 15 22:45:58 2013] [error] for row in compiler.results_iter(): [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 763, in results_iter [Mon Apr 15 22:45:58 2013] [error] for rows in self.execute_sql(MULTI): [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 818, in execute_sql [Mon Apr 15 22:45:58 2013] [error] cursor.execute(sql, params) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 114, in execute [Mon Apr 15 22:45:58 2013] [error] return self.cursor.execute(query, args) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-freebsd-9.1-PRERELEASE-amd64.egg/MySQLdb/cursors.py", line 174, in execute [Mon Apr 15 22:45:58 2013] [error] self.errorhandler(self, exc, value) [Mon Apr 15 22:45:58 2013] [error] File "/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-freebsd-9.1-PRERELEASE-amd64.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler [Mon Apr 15 22:45:58 2013] [error] raise errorclass, errorvalue [Mon Apr 15 22:45:58 2013] [error] DatabaseError: (1146, "Table 'irdbd.app_alert' doesn't exist") }}}

Trac ticket #510 component gui priority blocker, owner melkins, created by randy on 2013-04-15T22:48:21Z, last modified 2013-07-02T04:09:34Z

[sraustein]

Every time you update svn, you should run: {{{ rpki-manage syncdb rpki-manage migrate }}}

See https://trac.rpki.net/wiki/doc/RPKI/CA/UI/GUI/Upgrading

Trac comment by melkins on 2013-04-15T22:51:33Z

[sraustein]

were you able to get past this problem?

Trac comment by melkins on 2013-04-16T18:34:14Z

[sraustein]

yes, i thought i had responded that, if those had to be run after an update, why did the update not do it? why does the user need to do it manually?

Trac comment by randy on 2013-04-16T18:39:09Z

[sraustein]

I did not see your reply come through.

Rob is working on making the install-from-source perform the same post-install steps as the packaged versions, but we are not there yet.

Trac comment by melkins on 2013-04-16T18:46:54Z

[sraustein]

At Tue, 16 Apr 2013 18:46:54 -0000, Trac Ticket System wrote:

Rob is working on making the install-from-source perform the same post- install steps as the packaged versions, but we are not there yet.

install-from-source will need to prompt for mysql root password to do things like this. We can do it without that on Ubuntu and Debian because they stash an (sql) root-equivalent password where only (unix) root can read it, for just this sort of thing.

Not sure how to handle it for things like FreeBSD package install, either we can't do the full setup or we have to prompt.

Trac comment by sra on 2013-04-16T19:08:38Z

[sraustein]

i do not mind a prompt if i get a seamless install/upgrade

Trac comment by randy on 2013-04-16T19:12:42Z

[sraustein]

i do not mind a prompt if i get a seamless install/upgrade

I think this means we need to be really careful to distinguish between things needed for initial install and things needed for upgrade. Eg:

• It is reasonable to stop and prompt for MySQL root password if necessary during initial install, because we must have that to create databases.
• It is not reasonable to stop and prompt for MySQL root password when we're just doing an upgrade and need to do a Django South database migration; assuming we set up rights correctly in the first place, the ordinary irdbd database user should be able to perform the migration, and rpki.conf (already set up, since this is an upgrade) should know how to act on MySQL as that user.

Etcetera.

Trac comment by sra on 2013-04-16T19:44:39Z

[sraustein]

makes sense. only ask if you need it :)

Trac comment by randy on 2013-04-16T21:22:26Z

[sraustein]

As of a week or two ago, installation from source attempts the same database maintenance and upgrade commands as packaged installation.

Trac comment by sra on 2013-05-07T21:05:27Z

[sraustein]

I think this can be closed. Reopen if anyone disagrees.

Trac comment by sra on 2013-07-02T04:09:34Z

[sraustein]

Closed with resolution fixed