Custom Query (894 matches)

• Create a new sqlite database like this

  $ python src/lib/Server/Reports/manage.py syncdb
  

• Fire up bcfg2-info or bcfg2-server

This is the resulting traceback:

Jan 13 13:52:48 unstable bcfg2-server[13827]: Searching for new models to add to the statistics database
Jan 13 13:52:48 unstable bcfg2-server[13827]: Running upgrade of models to the new one
Jan 13 13:52:54 unstable bcfg2-server[13827]: Presently at version 0 updated the 2009-01-13T10:46:01.871063
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update <function _merge_database_table_entries at 0x1c68488>#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 78, in rollupdate#012    _fixes[i]()#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 21, in _merge_database_table_entries#012    """)#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_extra
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update drop table reports_bad;#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_bad
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update drop table reports_bad_interactions;#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_bad_interactions
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update drop table reports_extra;#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_extra
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update drop table reports_extra_interactions;#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_extra_interactions
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update drop table reports_modified;#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_modified
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update drop table reports_modified_interactions;#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_modified_interactions
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update drop table reports_repository;#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_repository
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update drop table reports_metadata;#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql, params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: no such table: reports_metadata
Jan 13 13:52:54 unstable bcfg2-server[13827]: Failed to perform db update alter table reports_interaction add server varchar(256) not null default 'N/A';#012Traceback (most recent call last):#012  File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 76, in rollupdate#012    connection.cursor().execute(_fixes[i])#012  File "/var/lib/python-support/python2.5/django/db/backends/util.py", line 19, in execute#012    return self.cursor.execute(sql,params)#012  File "/var/lib/python-support/python2.5/django/db/backends/sqlite3/base.py", line 168, in execute#012    return Database.Cursor.execute(self, query, params)#012OperationalError: duplicate column name: server
Jan 13 13:52:54 unstable bcfg2-server[13827]: Error while updating the database
Jan 13 13:52:54 unstable bcfg2-server[13827]: Traceback (most recent call last):
Jan 13 13:52:54 unstable bcfg2-server[13827]:   File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 135, in update_database
Jan 13 13:52:54 unstable bcfg2-server[13827]:     new_version = rollupdate(know_version.version)
Jan 13 13:52:54 unstable bcfg2-server[13827]:   File "/usr/lib/python2.5/site-packages/Bcfg2/Server/Reports/updatefix.py", line 84, in rollupdate
Jan 13 13:52:54 unstable bcfg2-server[13827]:     return ret
Jan 13 13:52:54 unstable bcfg2-server[13827]: UnboundLocalError: local variable 'ret' referenced before assignment
Jan 13 13:52:54 unstable bcfg2-server[13827]: TGenshi properties disabled

One of the first things a new user will see is the Quickstart wiki page. We should spiffy it up and add a few more simple examples.

It would be nice to be able to also query groups based on the probe results in probed.xml.