Table of Contents

Expanded Contents Detailed Content List Section-1 Introduction Section-2 Installation Section-3 Security

Section-4 Information & Reports Section-5 Database Tools Section-6 Site Tools Revision History 2011 Versions 2010 Versions

Section - 5.1 Introduction

 Section rev Jan 1, 2011

This section covers the database tools that are available from the admin menu.

Section - 5.2 Demo database initialization

 Section rev Jan 1, 2011

This feature archives the current database into a folder named "archives" (the database is renamed with a date and time stamp), then creates a fresh copy of the demo database. The demo database is populated with fictitious bug reports, comments, etc. The Demo database has been used extensively for program development and debugging and is a varified stable working envirionment. The default database allows guest logins.

Other than the live database is empty, about the only differeance is the demo databse allows the guest login to edit. In live mode this is not allowed because all visitors could edit each others bug reports!

Guest login is...  User = guest   Password = leave blank
Admin login is...  User = admin  Password = admin

Section - 5.3 Live database initialization

 Section rev Jan 1, 2011

You really should play around with the demo db before using a working db. However, when the time comes to use a working db, here is the setup procedure.

a)  Initialize a live db [admin]->[init default db]
b)  Disable unwanted categories, and create your own new choices
   of categories [admin]->[Category]
c)  The default db allows guest logins and auto registration, change
   these if you want something else [admin]->[site]
d)  Add any users, admins, or leads [admin]->[Users]
e)  The default new user privileges are set by user id=2.
   Change any default privilege settings in the [user edit] for id=2 [admin]->[Users]
f)   Change the admin password [admin]->[Users]

Section - 5.4 Database structure

 Section rev Jan 1, 2011

This feature shows all fields and table structure for the entire database. This can be helpfull in understanding what data is being collected and where it is located. A sample of the report is shown below

Section - 5.5 Server variables

This feature shows all the server variables and is primarily used by the Buglite developers for debugging purposes. A sample of the report is shown below

Section - 5.6 Session variables

This feature shows all the Session variables and is primarily used by the Buglite developers for debugging purposes. A sample of the report is shown below

Section - 5.7 SqLite database manager

This feature shows all the Session variables and is primarily used by the Buglite developers for debugging purposes. A sample of the report is shown below