* apache

• /etc/php.ini
• /etc/httpd/conf.d/php.conf
• /etc/httpd/conf/httpd.conf

* vsftpd

• /etc/vsftpd/vsftpd.conf
• /etc/vsftpd.user_list

* web gui

• /var/www/html
  • webapps.tar.gz

* Zaptel

• /etc/zaptel.conf
• /etc/sysconfig/zaptel

* touch /etc/fxotune.conf

* mv /etc/asterisk/* /etc/asterisk/default/

* /etc/asterisk

• asterisk_config.tar

* /etc/logrotate.d/asterisk/asterisk.logrotate

* /etc/ez-ipupdate.conf

* /etc/amportal.conf

* touch /var/www/html/panel/op_buttons_additional.cfg

* touch /var/www/html/panel/op_buttons_custom.cfg

* cd /usr/src/AMP

• install_amp
• apply_conf.sh
  
  

* /etc/asterisk/rates.inc

* apache

• htpasswd -c -b /usr/local/apache/passwd/wwwpasswd wwwadmin password
• htpasswd -b /usr/local/apache/passwd/wwwpasswd maint password
  • -c: Create the passwdfile.
  • -b: get the password from the command line rather than prompting for it.

* vsftpd

• useradd -d /var/ftp -M -s /sbin/nologin ftpuser
• (echo asteriskftp; sleep 2; echo asteriskftp) | passwd ftpuser

* webmail

• adduser admin
• (echo sysmail; sleep 2; echo sysmail) | passwd admin
• echo "root: admin" >> /etc/aliases

* mysqladmin -u root password 'passw0rd'

* groupadd asterisk

• useradd -c "Asterisk PBX" -d /var/lib/asterisk -u 5060 -g asterisk asterisk

* /var/www/cgi-bin

• vmail.cgi

* /bin

• asterisk.reload

* /usr/local/sbin

• scripts.tar.gz

* /usr/local/bin

• resetmwi

* /var/lib/asterisk/agi-bin/

• /usr/local/sbin/festival-weather-script.pl
• /usr/local/sbin/festival-script.pl
• /usr/local/sbin/weather.agi
• /usr/local/sbin/wakeup.php
• /usr/local/sbin/wakeconfirm.agi
• a2billing.php

* Configuring MySQL

• /usr/bin/mysql < $LOAD_LOC/fix_sql.sql
• USE mysql;
• DELETE FROM user WHERE Host = 'asterisk1.local' and user = 'root';

* CDR

• /usr/bin/mysqladmin create asteriskcdrdb
• /usr/bin/mysql < $LOAD_LOC/asteriskcdr.sql
• GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO asteriskuser@localhost IDENTIFIED BY 'amp109';
• USE asteriskcdrdb;
• CREATE TABLE cdr ( );
• AMP/SQL/cdr_mysql_table.sql 의 table cdr 과 같음.

* Realtime

• /usr/bin/mysqladmin create asteriskrealtime
• /usr/bin/mysql < $LOAD_LOC/asteriskrealtime.sql
• GRANT ALL PRIVILEGES ON asteriskrealtime.* TO asteriskuser@localhost IDENTIFIED BY 'amp109';
• USE asteriskrealtime;
• CREATE TABLE extensions ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
• CREATE TABLE iax_buddies ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
• CREATE TABLE sip_buddies ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
• CREATE TABLE voicemail_users ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
• CREATE TABLE queue_member_table ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
• CREATE TABLE queue_table ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

* SugarCRM

• /usr/bin/mysql < $LOAD_LOC/sugar_crm.sql

* AMP

• /usr/bin/mysqladmin create asterisk
• /usr/bin/mysql < $LOAD_LOC/permissions_amp.sql
  • The GRANT statement enables system administrators to create MySQL user accounts and to grant rights to accounts.
  • permissions_amp.sql

GRANT ALL PRIVILEGES^M
ON asteriskcdrdb.*^M
TO asteriskuser@localhost^M
IDENTIFIED BY 'amp109';

GRANT ALL PRIVILEGES^M
ON asterisk.*^M
TO asteriskuser@localhost^M
IDENTIFIED BY 'amp109';

• mysql asterisk < /usr/src/AMP/SQL/newinstall.sql

* calling card

• echo "GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser'@'localhost' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -ppassw0rd
• mysqladmin create mya2billing -u a2billinguser -pa2billing
• mysql mya2billing -u a2billinguser -pa2billing < a2billing-mysql-schema-v1.0.0.sql

* install_amp

* #!/usr/bin/php -q

• We're using the '-q' switch so that the HTTP headers are suppressed.