The minimal database setup for a useful Comas system ==================================================== A Comas installation relies heavily on the database for basically everything it does. Before initializing the database, there is no point in even trying to get Comas working. Now, once that the database has been initialized (by calling schema.sql and functions.sql from within psql), there are still some things that should be set: The main system catalogs. You can find some basic defaults in the sample_data.sql file. The first table you should fill is 'config'. This holds the operative details for most system parameters. It has three columns - 'name' (the key under which the system will look for the configuration), 'descr' (a human readable description of this configuration key), and 'value' (obviously, the value for this configuration key). The configuration keys used by Comas are: attendees_recover_passwd_from: In case an attendee forgets his password, he can request the system to generate and mail him a new one. This key holds the sender e-mail address. max_authors_x_proposal: Here you can specify the maximum number of authors that can take part in a proposal. If this key is set to zero, there will be no limit set. max_proposals_x_person: The maximum number of proposals a single person can be listed as an author for. If this key is set to zero, there will be no limit set. priv_person_types: prop_files_path: The path name where will the material for the proposals be saved. This path must be writable by the user under which Apache runs. proposal_modif_mail_from: When the proposal is modified by the author, if this key and proposal_modif_mail_to are set, an e-mail will be sent to the academic committee. This key holds the sender address for this mail. proposal_modif_mail_to: When the proposal is modified by the author, if this key and proposal_modif_mail_from are set, an e-mail will be sent to the academic committee. This key holds the recipient address (i.e., the academic committee's or its chairman's) for this mail. proposal_new_mail_from: When a new proposal is received, a confirmation mail is sent to the author. When a new author is added to an existing proposal, a confirmation mail is sent to the new author. This is the sender address for this mail. proposal_revision_mail_from: proposals_accepted_id: proposals_new_max_date: smtp_host: tmpl_path: