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
From the "File" menu select "Settings" and then the tab "DB Server".
|DB IP Address
||IP address of MySQL server
||MySQL port, the defaul is 3306
||Log in DB username
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:
Local contacts can be added, edited and deleted.
While you can not perform that operations on shared contacts.