Presence configuration


This configuration is optional, but allows you to view in AsterSwitchboard the presence status of the extensions.
In addition to the status you can set a message that the other extensions can read by positioning the mouse on the other image below the presence image.
Set your presence status and your message Displays extensions presence status and messages


AsterSwitchboard attempts to automatically create the table for presence if the account specified in the settings for the MySQL database connection has sufficient privileges.
However you can use the following MySQL query to manually create the table structure that will contain presence status and messages:

-- Database: `asterswitchboard`
-- Struttura della tabella `asb_presenza`
CREATE TABLE IF NOT EXISTS `asb_presenza` (
`interno` varchar(8) NOT NULL,
`msg` varchar(255) NOT NULL,
`status` varchar(32) NOT NULL,
`data_ora` datetime NOT NULL,
PRIMARY KEY (`interno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Once the database named 'asterswitchboard' with the table asb_presenza is created you can set the parameters so that the presence is available in AsterSwitchboard.

From the "File" menu select "Settings" and then the tab "DB Server".
They are the same parameters that are used to optionally configure the shared address book.

DB IP Address IP address of MySQL server
DB Port MySQL port, the defaul is 3306
DB Name Database name
DB Username Log in DB username
DB Password Password
You can check the correctness of the parameters entered by executing a connection test to the database via the button labeled "Test database connection".
A message will confirm the results of the connection.

Remember to save.

Presence status and related images:
Image Presence status
Present
At lunch
Meeting
Offsite
Holiday