Free Billing, Routing and Management software for Asterisk and VOIP
Home | Forums | Wiki | Manual | Open Source | Billing and BSS | My Blue Heart | astbss.org
DownLoad | Bugs | Help Wanted | Numbering Plan
  
 

Changing the name of the AstBill database

 
By london3 at Sun, 2005-11-13 19:37 | AstBill Software - General and Support

I was doing and install today where I had to use a different name on the AstBill Database in MySQL.

It was not a problem but a few things to remember so I created a Wiki Entry.

http://wiki.astbill.com/wiki/Change_database

There are 4 files to edit if you want to change the name of the AstBill Database.

/home/astbill/astbill.conf
/etc/asterisk/res_mysql.conf
/etc/asterisk/extconfig.conf
sites/default/settings.php

We are changing the name from astbill to voipbilling

astbill.conf
dbhost = localhost
dbname = voipbilling
dbuser = astbilluser
dbpass = astbill419

res_mysql.conf
[general]
dbhost = localhost
dbname = voipbilling
dbuser = astbilluser
dbpass = astbill419
dbport = 3306
; For Debian
dbsock = /var/run/mysqld/mysqld.sock
; For Asterisk @ Home
; dbsock = /var/lib/mysql/mysql.sock

extconfig.conf
;example => odbc,asterisk,alttable
iaxusers => mysql,voipbilling,asv_iax
iaxpeers => mysql,voipbilling,asv_iax

sipusers => mysql,voipbilling,asv_sip
sippeers => mysql,voipbilling,asv_sip
voicemail => mysql,voipbilling,asv_voicemail
;extensions => odbc,asterisk
;queues => odbc,asterisk
;queue_members => odbc,asterisk

settings.php
Make sure the $db_url line matches the database defined in the previous steps:

$db_url = "mysql://username:password@localhost/database";
where 'username', 'password', 'localhost' and 'database' are the
username, password, host and database name for your set up.

The correct example for this guide is :
$db_url = 'mysql://astbilluser:astbill419@localhost/voipbilling';

  
BerliOS Developer LogoSourceForge.net Logo Drupal.org Logo