If you migrate from an old system, or transferring a bigger amount of clients (e.g. following an acquisition) to ISPadmin with client’s overpayment/debt, record it here. 

When editing / adding a new client, enter a certain amount into the Opening balance field.

You can generate opening balances on this page. Opening balances are displayed as overpayments or underpayments from the previous period. You save them and they are reset. In this way, they are added to the invoicing module and you do not have to take care of them any longer. An overview of opening balances can be found in Invoicing Overviews Opening Bal..

Read more ...

Database backup is done under ispadmin user account. If this account lacks administrator rights, the following error message of mysqldump could be displayed:

Got error: 1044: Access denied for user 'ispadmin'@'localhost' to database 'information_schema' when using LOCK TABLES

It is advisable to activate copying of backups to FTP server. In worst-case scenario of hardware breakdown (controller failure, burn-out etc.) or complete destruction of the installation (e.g. due to human error), the only salvation is to have backups placed away from the server. Also you should not rely solely on RAID. RAID1 is just a technical solution for a disk failure hence the need to have system backups safely on remote storage.

Set up backups according to the instructions in Settings System Settings Backups.

Problems

• Backup was not copied to FTP server.
• ISPadmin created one directory with date per day but nothing is stored to FTP.
• ISPadmin logged on FTP but did not store anything.
• A partial backup was created on FTP.

Solution

FTP backups work fine for all our customers. However, problems may appear. In order to be able to exclude ISPadmin as a possible source of the problem you may try to run a complete backup with subsequent transfer on FTP server. Enter your FTP access details to ISpadmin.

Server: admin.netbackup.cz

User: you will receive it from our personnel upon request (it is changed regularly).

Password: you will receive it from our personnel upon request (it is changed regularly).

The following command will create a backup and transfer it on FTP as defined in ISPadmin:

/usr/local/script/ispadmin/backup_system.pl backup all

Detected reasons for errors

• Not enough space was assigned for FTP backups
• FTP server not working
• Incorrectly defined rights on FTP server
• Incorrectly defined firewall on route to FTP server
• Incorrectly set root (/) directory on FTP server
• FTP server cannot/is not configured for passive mode which is required by ISPadmin

You can easily check the size of daily backups directly from: Other Backups System. Based on empty space on disk and detected size of daily backups you can

easily determine the number of archived backups in turns (Settings System Settings Backups).

Size of daily system backups (Full backup - Daily):

• Starting ISP: approx. 3GB/day
• Bigger ISP after a few years of operation: approx. 12GB/day

If you select Full backup - weekly - incremental backups are done and the size of each increment is significantly smaller. So you have to count with a total size of backups in individual backup sections.

You can use the same procedure for browsing directory structure of NETflow data: Other Backups Netflow. This way you will know the size and increment of stored data by NETflow module - this data is not backed up.
For more information - see NETflow module.

Size of NETflow data per month:

• Starting ISP: approx. 5GB/month
• The biggest ISP’s: approx. 20GB/month

Approximate size of binary backups of Mikrotik routers:

• Usual binary backup: approx. 25kB
• For main routers or shapers: approx. 5MB.

ISPadmin automatically imports call statements, not invoices.

Access to an older SOAP gateway for ISPadmin must be agreed with IPEX to enable VoIP import.
Then you have to enter access details to SettingsSystem settingsGeneral: ID voipex_username and voipex_password.

A new SOAP gateway access must be entered for mobile service import in
SettingsSystem SettingsGeneral: ID ipex_username, ipex_password, and enable ipex_import_mobile_service.

If the access details are correct call from switch board will be loaded automatically within 15 minutes.

OtherImportIPEX: import for mobile service
OtherImportVoIP Overviews: import for VoIP

Detail statistics of calls, SMS, MMS etc. are listed here. The statistic is grouped by months. Each month shows how many numbers are/are not paired with Mobile service. Click on the number to see detailed statistics, or set up Mobile service.

Why do you need access to both gateways? ISPadmin Invoicing module can bill VoIP from old import only.