BILLmanager Troubleshooting

From ISPWiki

(Redirected from BILLmanager FAQ)
Jump to: navigation, search

This section provides troubleshooting information for users who are having trouble using and administering BILLmanager.


Where do I locate the sessions?

The sessions are located in the /usr/local/ispmgr/var/ binary file.

Understanding the icon “Roll back to the selected version"

Consider the example in BILLmanager:

You can roll back to the version that was originally installed on your server, however you cannot downgrade to an earlier version.

The backup copies are located in the /usr/local/ispmgr/var/backup/billmgr/ directory:

 -rw-r--r-- 1 root wheel 7081496 Aug 30 12:10 4.0.37
 -rw-r--r-- 1 root wheel 4853501 Aug 30 12:10 4.0.38
 -rw-r--r-- 1 root wheel 7227994 Aug 30 12:10 4.0.39
 -rw-r--r-- 1 root wheel 7360598 Aug 30 12:11 4.0.40
 -rw-r--r-- 1 root wheel 7785194 Aug 30 12:11 4.0.41
 -rw-r--r-- 1 root wheel 7550325 Aug 30 12:12 4.0.42
 -rw-r--r-- 1 root wheel 7483549 Aug 30 12:12

Once you have downgraded the control panel to a desired version, all previous backups will be automatically deleted.

Where do I locate the complete list of message variables?

You can locate it in the Message template module by clicking the icon Test template.

How do I reset a database?

Delete the selected database, execute the command killall billmgr and log in to the billing system. BILLmanager will automatically reset the database.


 *A customer is a person registering in the billing. You can locate him in the Customer management module. 
* A customer may add a system administrator, who for example will be able to submit trouble tickets to Support center. This system administrator is a user. 
There can be one or multiple individuals or companies paying for services (you cannot use their credentials to log in to the billing). They are payers. Their contact information is used when generating and paying invoices.

More information can be found in the following modules:

* Customer management - the module provides a number of functions for customer management. You can add new customers, edit parameters of existing ones, switch to their panel and use many other features.  
* User management - various functions for users' management. You can add new users, set their level of access to the billing modules, review the information about existing users and edit their parameters, if necessary.  
* Payer profile management - the module allows you to add new payers (both companies and individuals) who will effect payments for provided services, review and edit their parameters.

How do I change a billing type of the package?

You cannot do it via BILLmanager. You may make changes manually in the pricelist table -> the billtype field of the BILLmanager database.

Do not change this field in the table, because the packages' content is kept in the same table and this field has different values for them.

Possible values of the files:

enum addBill { abUnknown, abNone, abOrdered, abStat, abPeriod, abDaily, abMonthly, abYearly };

Use the following values:

abPeriod=4, abDaily=5, abMonthly=6, abYearly=7.

How do I pay in cash via BILLmanager?

Choose the "Wire transfer" payment method. You may rename it into "Pay in cash".

How do I redirect email from a domain to enable the gateway?

Open the /etc/alias file to specify the redirect:

virtuser_1014:  "|/usr/local/ispmgr/sbin/gatemail"

Where virtuser_1014 is a virtual user of a required mailbox.

How do I create a trial package?

Create a zero order period. You may use a trial period only once.

Upgrading to BILLmanager Corporate

Locate the doctemlp table -> select the account field to change its current value into 1 throughout the table. When you are done, delete the name unique key.

How do I reset admin password?

Execute the command below via shell:

/usr/local/ispmgr/sbin/mgrctl -m billmgr usrparam passwd=<password> recordlimit=100 sok=ok

The following is a series of common questions and answers on BILLmanager.

What should I do if a contract does not have formatting?

Check a contract template, locate the following line:

<xsl:template match="contract[@template='doc_###']">

A figure corresponding to that in the ID column of the templates tables should be used instead of ###. If this figure does not correspond to a template ID, formatting will not be applied to a document.

Cannot set up disk quota

On many virtual private servers only Provider (i.e. hosting provider) can activate the system file quota.


This error occurs when a client is trying to add funds to his personal account. The possible reason for this issue can be incorrect upgrade of the BILLmanager versions.

To resolve this issue, try changing the payment link in the dashboard file /usr/local/ispmgr/etc/billmgr_dashboard_5.xml

Valid values for the credit.add function:

  • BILLmanager Standard and BILLmanager RU-CENTER - credit.add.4
  • BILLmanager Advanced - credit.add.3
  • BILLmanager Corporate - credit.add.1

Delete all the users' copies upon modification:

rm -f /usr/local/ispmgr/var/userconf/billmgr.*.dashboard.xml

Restart BILLmanager:

killall billmgr

How to edit trial period manually

If the Periodic billing type is set for the service, you can prolong the trial period from the panel interface (change the "Expiration date" field). If Daily charges period is set, you can change the period only in the database (E.g. update item set billdate = adddate(billdate, 'number of days 00:00:00') where ...).

Was this helpful? Yes | No
Personal tools