Setting up a new site in the common Catglobe Administration database

<accesscontrol>Main:MyGroup</accesscontrol>



Setting up a new site in the common Catglobe Administration database

Whenever we set up a new site we need to add a record to the common Catglobe Mail Administration database. Without having inserted the necessary information into this database, we cannot send and receive emails. Inserting a new record is done manually. The database is called "Catglobe Administration Database" and has only one table.

In case no Catglobe Administration database exists, since you are setting up a new server, you may run the script called MailDatabase.sq to set it up.

Necessary columns that you need to define for setting up a new site:

• ID: this value is generated automatically.
• Domain_Name: this value must be identical to the site key value in the web config file of your new site.
• Description: brief description about this site. This is not used actively and thus optional.
• Disabled: It prevents mail module from working during the time disabled is set true.
• Connection_String: the connection string that is used for connecting to the CatGlobe database. It must be exactly the same database connection string used in the webconfig file of your new site.
• Application_Path: the path where email attachments are stored. It must be exactly the same file path used in the webconfig file of your new site.
• Version: this value indicates the version of each CatGlobe site. It must use the allowed formats, currently "5.2, "5.1", "5.0", "4.9".
• Last_Email_Alive_Check: This column is updated by the serbice and should be kept empty when adding a new site. It tells us when the last live check was made for this site.