Setting up a new site in the common Catglobe Administration database
From Catglobe Wiki
More actions
<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.