Shared address book configuration


This configuration is optional, but allows you to view in AsterSwitchboard a shared address book at the enterprise level in addition to your personal directory.

AsterSwitchboard attempts to automatically create the table for contacts 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 the contacts to be shared:

-- Database: `asterswitchboard`
-- Structure of table `shared_addressbook`
CREATE TABLE IF NOT EXISTS `shared_addressbook` (
`id` int(11) NOT NULL,
`COMPANY` varchar(32) NOT NULL,
`TEL1` varchar(32) NOT NULL,
`TEL2` varchar(32) NOT NULL,
`TEL3` varchar(32) NOT NULL,
`Email` varchar(32) NOT NULL,
`SURNAME` varchar(32) NOT NULL,
`NAME` varchar(32) NOT NULL,
`NOTE` text NOT NULL,
`TYPE` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Once the table shared_addressbook is created you can set the parameters so that the shared address book is available in AsterSwitchboard.

From the "File" menu select "Settings" and then the tab "DB Server".

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 to the shared address book.

Remember to save.

In AsterSwitchboard contacts from the shared address book are displayed along with local ones, the column "Type" shows the origin:

Type Description
local
shared
Local contacts can be added, edited and deleted.
While you can not perform that operations on shared contacts.