AstBill - Asterisk billing system

DESISTI DE USAR ISTO AQUI

Instalar mysql 5.0.13-rc

obter: http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-standard-5.0.13-rc-linux-i686.tar.gz/from/http://www.mirrorservice.org/sites/ftp.mysql.com/

#!/bin/sh 
tar -C /usr/local/ -xvzf mysql-max-5.0.13-rc-linux-i686-glibc23.tar.gz
cd /usr/local
ln -s mysql-max-5.0.13-rc-linux-i686-glibc23/ mysql
cd mysql
groupadd mysql
useradd -g mysql mysql
scripts/mysql_install_db --user=mysql
chown -R root  .
chown -R mysql data
chgrp -R mysql .
cp support-files/my-medium.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysql
cd /etc/mysql
mv my.cnf my.cnf_old
ln -s ../my.cnf .


#para o debian
update-rc.d mysql defaults
/etc/init.d/mysql start

# configurar senha do mysql
bin/mysqladmin -u root password 'senha do mysql'

Instalar apache + php (debian)

#!/bin/sh
apt-get install apache2 php4 php4-mysql php4-gd libapache2-mod-php4

Configuração do site no apache

<VirtualHost 143.107.161.163:80>
        ServerAdmin webmaster@local.com.br
        ServerName  astbill.local.com.br
        ServerAlias astbill
        ErrorLog /var/log/apache2/astbill.local.com.br-error.log
        CustomLog /var/log/apache2/astbill.local.com.br-access.log common

        DocumentRoot /var/sites/astbill/drupal

        <Directory /var/sites/astbill>
                Options -Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from 143.101.111.108
                allow from 143.109.3.0/255.255.255.128
        </Directory>

        ScriptAlias /cgi-bin/ /var/sites/astbill/cgi-bin/
        <Directory "/var/sites/astbill/cgi-bin">
                AllowOverride None
                Options ExecCGI -MultiViews +SymLinksIfOwnerMatch
                Order allow,deny
                Allow from all
        </Directory>
</VirtualHost>

Criar diretórios

#!/bin/sh
mkdir -p /var/sites/astbill/cgi-bin 

php mysql socket

editar o arquivo /etc/php4/apache2/php.ini, procurar por mysql.default_socket e trocar para: mysql.default_socket = /tmp/mysql.sock

Instalar drupal

#!/bin/sh
tar -C /var/sites/astbill/ -xvzf drupal-4.6.3.tar.gz
cd /var/sites/astbill/
ln -s drupal-4.6.3/ drupal

Instalar outros requerimentos

#!/bin/sh
apt-get install libdbd-mysql-perl

Instalar AstBill

#!/bin/sh
tar -C /var/sites/astbill/ -xvjf astbill-0.9.0.7.tar.bz2
cd /var/sites/astbill/
ln -s astbill-0.9.0.7/ astbill
mkdir logs

Tabelas mysql

#!/bin/sh
cd /var/sites/astbill/astbill
/usr/local/mysql/bin/mysqladmin create astbill -p
/usr/local/mysql/bin/mysql --user=root -p astbill < database/astbill.sql
/usr/local/mysql/bin/mysql --user=root -p astbill < database/astbill_proc.sql

Garantir acesso (coloque o usuario/senha corretamente, neste caso astbill/caganeira):

#!/usr/local/mysql/bin/mysql --user root -p
GRANT ALL PRIVILEGES ON astbill.* TO astbill@localhost IDENTIFIED BY 'caganeira';
SET PASSWORD FOR 'astbill'@'localhost' = OLD_PASSWORD('caganeira');

Default Astar Asterisk Files

AGI-BIN

#!/bin/sh
cd /var/sites/astbill/astbill
cp -fr agi-bin/* /var/lib/asterisk/agi-bin/
chmod +x /var/lib/asterisk/agi-bin/*

EXECUTAR PATCHS NOS AGI's

Arquivos de configuração padrão da Astar

#!/bin/sh
cd /var/sites/astbill/astbill
cp -fr etc/asterisk/* /etc/asterisk

Apache e Drupal

#!/bin/sh
cd /var/sites/astbill/astbill
cp -fr cgi-bin/* /var/sites/astbill/cgi-bin
chmod +x /var/sites/astbill/cgi-bin/*
cp -fr astbill.conf /var/sites/astbill/

EXECUTAR PATCHS NOS CGI's

Altere o astbill.conf para figurar a realidade quanto o usuario e a senha para o banco astbill do mysql.

Agora vamos configurar o drupal, abra o arquivo /var/sites/astbill/drupal/sites/default/settings.php e procure por $db_url e $db_prefix, nestas duas variáveis vamos configurar o usuario/senha/banco do mysql para a realidade, procure também por $base_url para configurar a url do servidor

#$db_url = 'mysql://USER:PASS@localhost/DATABASE';
$db_url = 'mysql://astbill:caganeira@localhost/astbill';
$db_prefix = 'pbx_';
$base_url = 'http://astbill.local.com.br';

Instalar agora arquivos do AstBill para o Drupal

cd /var/sites/astbill/drupal/
mkdir -p files/astar
cp -fr /var/sites/astbill/astbill/modules/astbill modules/
cp -fr /var/sites/astbill/astbill/themes/* themes/
cp -fr /var/sites/astbill/astbill/images/* files/astar/
chmod -R 777 files/

res_config_mysql.so modules.conf extconfig

Limpar tabelas (demo data)

#!/usr/local/mysql/bin/mysql --user root -p
delete from astaccount where accountcode like '7%';
delete from astcdr;
delete from astdialplan;
delete from astcreditres;
delete from astpayment;
delete from pbx_cache;
delete from pbx_sessions;
delete from asv_sip;
delete from asv_iax;
delete from asv_friend;
delete from astaccount;
delete from asthardware;
delete from asttenant;

d elete from asttrunk;
INSERT INTO asttrunk (name, tech, path, isdefault, serverid, comment, vat, vat2, usagecount, maxusage, trunkcost) VALUES ('Local','Local','',0,NULL,NULL,'0.00','0.00',0,9999,0);

INSERT INTO asttrunk (name, tech, path, isdefault, serverid, comment, vat, vat2, usagecount, maxusage, trunkcost) VALUES ('DEF', 'DEF', 'DEF', 0, NULL, 'This line must be in the table for CallRouting to work. DONT DELETE.', '0.00', '0.00', 0, 9999, 5);

-- IuriDiniz - 17 Oct 2005