Access Metadatabases

From Staffwiki

Revision as of 14:38, 23 July 2008 by Delonix (Talk | contribs)
Jump to: navigation, search


Web Site Databases

The alphabetical list of databases, subject list of databases, and ezProxy configuration file all depend upon a "database of databases." Actually, the records in this database contain fields to support the needs of the scripts which create the above displays and files.

A Note on Scripts

The scripts are written in the Python language preferentially if formatting maintenance is of less concern than functionality or if snappy performance is needed. In most cases efficient performance is preferential to the use of source-level scripting. Python scripts support CGI, and are developed on the server. PHP scripts are much wordier and are embedded within XHTML (HTML) pages maintained with Dreamweaver. Python scripts are maintained in a character-based text editor such as vi or emacs.

Both of these programming languages have support within modules of the Apache web server.

Database and Tables

Log in to the graphical user interface

  • Enter (where xxxxxx is the port for the Webmin® interface. This number is kept with the password list for library resources in the secure area.) This port can be found in the possession of the systems administrator, by choosing "Networking" in Webmin, and in the iptables configuration in /etc.
  • Current user = root and password=pppppp (where pppppp is the password for the Webmin user. This number is kept with the password list for library resources in the secure area.)

Select the Webmin Function Supporting the Databases

The databases are not fully normalized and must therefore be updated with care for logical relationships among records and fields.

  • Select "Servers"
  • Then select "MySQL Database Server"
  • Then select the "librarydatabases" database. This is the "database of databases."
  • Then select the "linkage" table
    • linkage is the most important table of the four and contains most information
    • AssociatedHosts is used to generate extra entries for a host in linkage. These are needed for some databases to support ezProxy. Some databases require multiple hosts to support their own virtual server names. This complex subject is best understood by training oneself in ezProxy and examining the current entries.
    • subjects is used as a basis for selecting linkage records for subject oriented output. You should add records as needed to match linkage and include a unique subject. If the web page lacks an entry after adding a record to linkage, you should examine this table to make sure an entry has been created for that key field.
    • types is similar to subjects and should be similarly maintained (add a matching record(s) when linkage is updated)
Personal tools