# cd /var/www/html
# mkdir phonebook
# mkdir phonebook/upload
# wget http://www.a-enterprise.ch/ipline/phonebook/phonebook.tar.gz
# tar -xzvf phonebook.tar.gz
# chmod 777 /var/www/html/phonebook/upload
# echo "" > /etc/httpd/conf.d/charset

# mysql -p
Enter password:

mysql> use asterisk
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

CREATE TABLE `pbook` (
`id` int(11) NOT NULL auto_increment,
`calld` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`bemerkung` text NOT NULL,
`Diverses` int(1) NOT NULL default '0',
KEY `id` (`id`),
KEY `calld` (`calld`),
KEY `name` (`name`)
) ;

CREATE TABLE `pbook_director` (
`id` int(9) NOT NULL,
`tel` varchar(20) NOT NULL,
`name` varchar(50) NOT NULL,
`strasse` varchar(50) NOT NULL,
`ort` varchar(50) NOT NULL,
KEY `tel` (`tel`),
KEY `name` (`name`)
) ;

CREATE TABLE IF NOT EXISTS `events` (
`id` int(10) unsigned NOT NULL auto_increment,
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`event` longtext,
`uxtime` int(11) NOT NULL,
`DEST` varchar(20) NOT NULL,
`SRC` varchar(20) NOT NULL,
`UID` varchar(20) NOT NULL,
`CID` varchar(20) NOT NULL,
`CIDNAME` varchar(50) NOT NULL,
`IDdest` varchar(20) NOT NULL,
`IDsrc` varchar(20) NOT NULL,
`EVNT` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ;

mysql>exit

yum install MySQL-python

# cd /var/www/html/phonebook/events/bin
# chmod +x start.py stop.py ipline.py

# cd /var/www/html/phonebook/events/etc/init.d
# chmod +x events
# cp events /etc/init.d
# ln -s /etc/rc.d/init.d/events /etc/rc.d/rc3.d/S99events
# shutdown -r now

http://ip.pbx/phonebook/book.php?P=101&X=