Opening Balance

 

 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..

Database backup: Error 1044

 

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

Most common problems with FTP backups

 

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

 

Size of daily backups and NETflow data

 

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

icon info2 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.

 

Import from IPEX

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.

 

Tips on how to use this documentation

 

Search

Searching required information is possible either via structured menu which is divided into sections, or via full-text search of the entire contents of this on-line documentation.
Breadcrumbs

This aid will make it possible for you to find out where exactly you are at the moment.

If, for example, the following appears beneath the main menu - ISPadmin Wiki / ENG / Client management / Menu - CLIENTS / Clients / Message Board / Groups - it means that you are:

 

  • in the Wiki documentation of the ISPadmin system
  • in its English localization
  • in the Client management section
  • in the Clients tab
  • in the Message board subtab
  • in the Groups sub-subtab

Changelog

It contains newly added functionalities and modifications of the system which are displayed by versions and issue date. Changelog articles are also displayed in individual sections / pages of the documentation which relate to new functionality or modification. 

Basic orientation

You will find a welcoming menu with basic instruction on trying / implementing / using below. 

FAQ

Frequently asked questions along with most important procedures and settings are listed in FAQ section. 

Colours

Items which refer to real system menu are highlighted in corresponding colour, including their graphical background. Eg. Invoicing Settings Templates Reminders. This is also a working reference to an article. 

CONTACT

NET service solution, s.r.o.
Žerotínova 3056/81a
787 01 Šumperk
Czech Republic