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
  
 

AstBill-0.9.0.9 test results (long)

 
By ms at Fri, 2005-11-04 09:29 | AstBill Software - General and Support

So I upgraded to AstBill-0.9.0.9. There seems to be some major improvements over the 0.9.0.7 and some very usefull features are added.

AstBill development team: Keep up the good work!

Here are some of the problems that I have encountered. If these are specific to my installation, please let me know so that I can fix them. If they are bugs in the AstBill, please add them to bug tracking system for further investigation. I would be glad to provide more detailed debugging information, if you need.

1-VoIP Account-->View account results in "No Records for this Account". (Shouldn't this display some of the accounts attributes?)
2-VoIP Account-->"Top Up" gives "No Records for this Account". Shouldn't this allow us to add credit?
3-VoIP Account-->Settings-->Displays the password when the mouse hovers over the account number, but there seems to be no way to reset passwords. Also, why is account password different from voicemail password? Would someone please explain?
4-VoIP Account-->Settings-->Top Up-->"Page not found"

5-AstBill Admin-->"Calling Cards" results in the following error

user error: Table 'astbill.astactype' doesn't exist
query: SELECT COUNT(*) FROM astaccount WHERE tech in (select actype from astactype) in /home/www/html/drupal-4.6.3/includes/database.mysql.inc on line 66.

user error: Table 'astbill.astactype' doesn't exist
query: SELECT astaccount.accountcode, astaccount.secret, astaccount.ccserialno,
date(astaccount.ccfirstused) ccfirstused, date(astaccount.cclastused) cclastused,
round(astaccount.cccardvalue,2) cccardvalue, astaccount.creditlimit, astaccount.ccbatchno,
astaccount.active
FROM astaccount WHERE tech in (select actype from astactype) ORDER BY accountcode ASC LIMIT 0, 40 in /home/www/html/drupal-4.6.3/includes/database.mysql.inc on line 66.

Have I missed some of the instructions that would import the astactype tables schema, or is it missing from the installation instructions?

6-AstBill Admin-->Payment-->Edit results in the following error, I am assuming this is related to the above error and the absence of astactype table. Please advise how to fix.

user error: Table 'astbill.astactype' doesn't exist
query: SELECT accountcode FROM astaccount where tech in (select actype from astactype) ORDER BY accountcode in /home/www/html/drupal-4.6.3/includes/database.mysql.inc on line 66.

7-AstBill Admin-->Price List

I can view default, Hiper and Star price lists, but there seems to be no-way to modify the existing price plans and add new ones? Is this feature implemented? Do I need to apply a patch or what?
I think it would make sense if AstBill Admin-->Settings-->Brand is merged with AstBill Admin-->Price List

8-AstBill Admin-->Provider Routes gives the following error:

user error: Unknown column 'routename' in 'field list'
query: SELECT id, pattern, routename, cost FROM astroute WHERE (countrycode LIKE '886') ORDER BY pattern ASC in /home/www/html/drupal-4.6.3/includes/database.mysql.inc on line 66.

9-AstBill Amind-->Provider Trunks gives the following error:

user error: Unknown column 'static' in 'field list'
query: SELECT isdefault, tid, name, tech, static, path, serverid, trunkcost, usagecount FROM asttrunk where name 'DEF' and name 'Local' order by name in /home/www/html/drupal-4.6.3/includes/database.mysql.inc on line 66.

10-AstBill Admin-->Settings-->Brand

First, as I said before, I think this should be merged with AstBill Admin-->Price List
Secondly, This feature only allows fixed markup for the entire route. I believe a better approach would be to allow price adjustment per route, this would allow the providers to adjust prices based on the market demand rather than the cost.

11-AstBill Admin-->Tenants

I am assuming this is for resellers, but I haven't figured out the difference/similarity between this and the User/Owner when creating the accounts. Perhaps someone can explain this to me.

That is it for now.

Cheers,
Massoud

AstBill Database Problems

By london3 on Fri, 2005-11-04 11:27

Looks like you are still using 0.9.0.7 database or that you did not upgraded the database using the file upgrade.sql

I am going for a meeting now. Will give you more feedback later.

PS. THANKS for your expelent write up. This is the type of feedback we need to make AstBill better.

ARE --
http://astartelecom.com - Independent VOIP Telecoms Broker. Consulting in Asterisk and Drupal

» login to post comments
  
BerliOS Developer LogoSourceForge.net Logo Drupal.org Logo