Monday, September 17, 2007

install asterCRM on Trixbox

download and install astercrm

get astercrm source code from http://sourceforge.net/projects/asterisk-crm/

mv astercrm-X.XXXX.zip /var/www/html

cd /var/www/html

unzip astercrm-X.XXXX.zip

mv astercrm-X.XXXX astercrm
mkdir -p /opt/asterisk/scripts/events

mv /var/www/html/astercrm/proxyman/* /opt/asterisk/scripts/events

chmod +x /opt/asterisk/scripts/events/*.py

create asterCRM tables

mysql < /var/www/html/astercrm/astercrm.sql -u root -p passw0rd

modify /var/www/html/astercrm/config.php

$config['database']['username'] = ‘asteriskuser’;
$config['database']['password'] = ‘amp109′;

$config['asterisk']['server'] = ‘localhost’;
$config['asterisk']['port'] = ‘5038′;
$config['asterisk']['username'] = ‘admin’;
$config['asterisk']['secret'] = ‘admin111′;

$config['asterisk']['outcontext'] = ‘from-internal’;
$config['asterisk']['incontext'] = ‘from-trunk’;

install MySQL-python

yum install MySQL-python

run ProxyMan.py

modify /opt/asterisk/scripts/events/ProxyMan.py

USERNAME = ‘admin’
SECRET = ‘amp111′
SQLdb = ‘asterisk’
SQLuser = ‘asteriskuser’
SQLpass = ‘amp109′

start ProxyMan

/opt/asterisk/scripts/events/ProxyMan.py

test

http://TRIXBOX-ADDRESS/astercrm
login with admin/admin

add cron job

modify /opt/asterisk/scripts/events/delete_events.py

db = MySQLdb.connect(host=”localhost”,
user=”asteriskuser”,
passwd=”amp109″,
db=”asterisk”)

add crontab job

crontab -e

add line

*/2 * * * * /opt/asterisk/scripts/events/delete_events.py >/dev/null 2>&1

Normal Questions

  • why the browser redirect login page after I login.

if you are turn back to login page even enter the right username and password, the problem occurs probably because php session doest works, the settlement is that you can download login.common.php and portal.common.php from svn, the next release will fix this debug.

applicable version: <0.0441

Posted by solo at 05:32:20 | Permalink | No Comments »