Making Library Databases

From Staffwiki

Jump to: navigation, search

Library Databases on the CSU Library Web Site

Manipulating Databases

Databases are produced from access metadata maintained in mySQL on the web server. See the detail pages for SQL access information.

The database can be accessed from on campus sites using Webmin. The LISTS Director and Digital Initiatives Coordinator share the access information

The database is: librarydatabases The tables are: linkage,subjects,types

The name in linkage is a key to finding multiple records for subjects and/or types so that multiple instances of other fields can be displayed. This allows one database (via its name) to belong to more than one subject, e.g. psychology, and biology. The same goes for types, which is little used.

The records in the database must be maintained frequently. When changed, all pages on the web site which can access the changed database will be updated when written. This supports alphabetical and by-subject listing and collections of databases.

The scripts detect the "on campusness" of the user agent (browser), and add the bluestem proxy information and program reference to the link address so that a seamless connection will be made from on- or off-campus. The databases are IP-authenticated.

The bluestem server prompts for membership in the campus community (staff, faculty, students) to allow access to its passed URL. The user need authenticate only one per browser session.

PHP and Python scripts can access these data and produce descriptions and/or links on the cgi interface of the web server. The ezProxy.cfg file is also produced from this database by running the script from the command line and writing the configuration to standard output as in the following.

  • log in to the web server
  • attach to /home/webs/test/eresources [cd /home/webs/test/eresources]
  • type python > ezproxy.cfg
  • type sftp
  • When prompted, enter the password
  • type put ezproxy.cfg
  • type exit

This is all you need to do. The daemon and server will send you a report. Define the email information with ITD.

Send the file to the setup area on the bluestem server in ITD. A daemon there will awaken periodically, move the configuration file to the usage area, and restart the exproxy server to re-read the configuration file for changed directives.

Personal tools