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