ISPadmin wiki - ISPadmin 4.04

: 24 November 2015

ISPadmin 4.04

BETA3

fixes

New version of Chrome browser caused problems while administrator tried to accept payment in Cash. Source code has been customized, so it is no longer a problem to accept payment in Cash.

CMTS

CMTS headend CISCO UBR 10000 is now supported.

rewritten pages

Settings / Info Page / Inf. messages

scheduling / calendar

Fixed some minor bugs reported by clients about Calendar.
Currently displayed day in Calendar is saved to the database, so after next display the Calendar will show the date saved in database and not current day.
Closed tasks are green highlighted in the Calendar.
Weekly plan is again available to display. In previous version there were options to display Daily and Weekly plan only.

MIKROTIK

Firewall rules have been optimized.

SYSTem variables

$CENA_ZAKLADNI$ ($INT_BASE_PRICE$) - Will replace the basic price for the Internet service without discount and fixed price.
$TYP_SMLOUVY$ ($INT_CONTRACT_TYPE$) - Will be replaced by text "Time limited contract" or "No time limited contract".

invoicing

If there is any pro-forma invoice created with Postal money order on it, so there is not displayed Specific symbol (SS) as an Invoice number because pro-forma invoices have internal negative number and it should not be displayed on a Postal money order.

RADIUS

If the RADIUS is used to authenticate access on MikroTik routers, so it is necessary to have set up parameter "interim-update" on MikroTik ( /ppp aaa interim-update) to a value higher than 0. If not, the tab "Routers / Radius / Access log" does not display access logs and data transfered details. As a new function the system provides auto-check of the parameter setting and if it is not set correctly the system will set it up to number 30 automatically. By this setting the system will provide sending of account information from router to RADIUS every 30 seconds and displaying of logs in the system.

IPTV

Each IPTV package has now option to fill in time period FROM - TO. This setting will be used for Invoicing of the service.
Customized counting of discount for IPTV service for Invoicing. Total discount is now counted from all fixed prices and package prices

BETA2

fixes

Fixed some minor bugs reported by providers

BETA1

fixes

Fixed some minor bugs reported by clients
In the tab "Clients / Contacts" there were not counted IPTV services to the total number of assigned services
"Mobile phone" service newly releasy the SIM number when the service is deleted and it is possible now to assign this number to the different MSISDN.

news

The tab "Other / Export / Optional" newly includes option to export clients by optional parameters to specify exported columns (data) to PDF or CSV file.
The tab "Settings / Contracts / Types" newly contains option to create own type / category of contracts and documents. If the type is set it is possible to select it while creating or editing the contract template. It is prepared for higher usage in next versions of the system ISPadmin.

rewritten pages

Clients / Contacts
Client card / Invoicing / Detail (by clicking on the detail of created invoice)
Client card / Invoicing / Detail / Cash payment
Scheduling / Daily (Calendar)
Invoicing/ Invoices / Export invoices

inventory

Newly the system saves the date of items storage. In the tab "Settings / Code lists / Inventory / Goods type") there can be displayed information about the date of the last storage and option to sort records in this column.

INFO pages

Newly it is possible to display info pages for customers while they are trying to connect to internet. When the customer open browser and try to access to internet via port 80, so in the case of activated Info page the client will be able to see only tis pre-defined page with "OK" button to continue to access internet. Next time when the client wnats to access internet the Info page is not displayed again. This system of info pages is a good solution how to inform your customers about important notifications and to be sure that someone had read it before accessing internet.
In the tab "Settings / Info page / Info messages" there it is possible to define information messages. Each message can be assigned to any client to display. This selection is vailable by routers, Client groups and Client status.
Each message may contain text which will be displayed for customer.
Message for identified client - This message will be displayed to client which is found by IP address. In the matter of facts some clients might be behind NAT, so their IP addresses are not visible.
In these messages system variables are available to be used (e.g. Client name), to fill in client's details automatically.
Message for unidentified client - this message is displayed to customers which are not identified by IP address (e.g. clients behind NAT).
Only one Info page can be activated at the moment.

invoicing

The tab "Invoicing / Bank / Email" displays numbers of matched and unmatched payments divided by more contrasted colour background
The tab "Invoicing / Bank / Email" newly includes full-text searching option
Added new export type to EKONOM accounting system. In the tab "Invoicing / Settings / Universal" the key "export" with assigned number 22

New system variables

Added new system variables for contracts
$IBAN_POSKYTOVATEL$ - Supplier's IBAN
$BIC_POSKYTOVATEL$ - Supplier's BIC

MIKROTIK - UPS status monitoring

If there is any UPS connected to the MikroTik router (driver is installed correctly) and UPS is recognized, so in that case the system is able to monitor UPS voltage and in the case of failure to send notification by e-mail.
In the case of correctly connected UPS the system displays current voltage in the tab "Routers / Router Status / Routers" at each router column "UPS [V]". By clicking on the value it will display detailed graph.
In the case of failure of electricity system will send notification by e-mail to the address of administrator which is pre-defined in the tab "Settings / Sys. settings / General" by the key "admin_email".

MIKROTIK

FIREWALL and NAT rules have been optimized to a tree structure. FILTER and NAT will begin to use tree structure of rule like MANGLE. The scheme is follows:

FIREWALL rules
FILTER -| My rules (not marked as ISPadmin)
| ispadmin_first_forward
| ispadmin_first_(order)_(comment)
.
.
| ispadmin_service_forward
| ispadmin_SSH_trust_server_(IP)
| ispadmin_SMTP_trust_server_(IP)
| rtr_(router name)_ispadmin_up
| rtr_(router name)_ispadmin_down
| dev_(device name)_ispadmin_up
| dev_(device name)_ispadmin_down
| switch_(switch name)_ispadmin_up
| switch_(switch name)_ispadmin_down
| ispadmin_services_mac_up
| ispadmin_services_mac_down
.
.
| ispadmin_basic_forward
| ispadmin_group_src_(IP range)
| iptel_(tel number)_(id)_ispadmin_up
| (Client name)_ispadmin_(id)_up
.
.
.
.
| ispadmin_group_dst_(IP range)
| iptel_(tel number)_(id)_ispadmin_down
| (Client name)_ispadmin_(id)_down
.
.
.
.
| ispadmin_last_forward
| ispadmin_last_(order)_(comment)
.
.
| ispadmin_drop_forward
| ispadmin_drop_NETWORK
| ispadmin_DROP_SSH
| ispadmin_DROP_SMTP
This structure provides very detailed process of firewall rules and an effective pass with increased performance (it is not necessary to process whole firewall tree e.g. with thousands of rules to find out rule at the end of the list) but the system search only in a few "jumps" in the tree structure where the rule can be found faster because the system search in the specific number of rules regarding the network mask. The mask number (ranges divided by blocks) is possible to set in the tab "Settings / Syst. settings / Mikrotik" by the key "mikrotik_mangle_net_block". Anyway it is also possible to apply your own set of rules processed globally for all routers (Tab "Settings / Syst. settings / Mikrotik" by the key "mikrotik_default_fw") for rules at begin of the tree (the key"mikrotik_default_fw_last" for the rules set located at the end of firewall). This default set of rules can also contains individual rules for each router, which is processed only for particular router. Rules can be set in the router edit page filling in the items "First FW rules on the router" and "Last FW rules on the router".
Newly the system creates the list of IP addresses on the MikroTik router in "address-list" (name - ispadmin_DROP_NETWORS) , where all networks of Clients' ranges are written in to drop traffic for non-registered customers. While updating routers, the system no longer delete the list to add these new ranges but only disable the chain (forbidden) "ispadmin_drop_forward".

MANGLE rules
NAT ----| My rules (not marked as ISPadmin)
| ispadmin_first_(chain name)
| ispadmin_first_(order)_(comment)
.
.
| ispadmin_first_dstnat
| ispadmin_remind
| remind
| ispadmin_info_pages
| info_pages
| ispadmin_service_dstnat
| ispadmin_trustserver_https__(domain)
.
.
| ispadmin_basic_forward
| ispadmin_disabled_user
| ispadmin_last_(chain name)
| ispadmin_last_(order)_(comment)
As in the previous case this structure provides very detailed process of firewall in NAT section and whole process is similar to process of FW rules. While editing router it is also possible to add specific "First MANGLE" and "Last MANGLE" on the router.
It is recommended in the tab "Settings / Syst. settings / Mikrotik" to use option "mikrotik_nat_disable_users" = 2, which provides applying of records of suspended customers in to the "address-list" and creates only 3 rules for each reason of ¨suspension in NAT instead of 3 rules for each suspended customer which, in the matter of fact, will decrease loading of routers while updating.

IPTV

Newly it is possible to assign unlimited number of Set Top Boxes to IPTV service
To create new IPTV service it is mandatory to assign at least one Set Top Box and next it is possible to add other boxes by clicking on the button "Add new Set Top Box".
Each Set Top Box can has own description
Each Set Top Box can has own information about locality, access point and IP address
Each router has option to assign IP range only for IPTV service (The tab "Routers / Routes". Next, while adding new Set Top Box, it is possible select IP address from the range assigned for IPTV service.
In the case when there is no IP range assigned for IPTV service, the system will offer IP address from the range for customers but only in the case when IP rage is the same for IPTV service and customers as well.
If the IPTV service is deleted, it is possible to display it in the Client card by click on the item from left menu "Active service" and next click on button "Show deleted services" and it is possible to re-activate it by click on the button "Restore".

ROUTERs - routes

In the tab "Routers / Routes" (Located at each router) there it is possible to add IP range with access point and assign IP address by this access point.
If "Access points" are pre-defined on a router, so it is possible to assing an access point to particular range (networks assigned for customers, voip, iptv ...). E.g. in the case of FFTx technology these access point may represent individual VLANs.
While adding new IPTV service it is possible to select router and access point. If the access point, which is assigned to IP ranges, is selected so the system will offer only those IP addresses for Set Top boxes which are assigned to this access point. It does make sense to use it e.g. in the case where there is 300 VLANs on the router where each of VLANs has own record in the tab "Routes".
This procedure of IP address selection by access point works for IPTV service now but in the next versions of the system it will be extended to other services as well.

scheduling - calendar

The tab "Scheduling / Calendar" has been completely rewritten and replace previous calendar which was available in the tab "Scheduling / Daily", "Scheduling / Weekly" and "Scheduling / Monthly".
In the right corner of the calendar it is possible to switch between Daily and Monthly preview.
In the left top corner of the calendar it is possible to switch Days by clicking on the right or left arrow.
Newly it is possible to drag and drop tasks in calendar by mouse and simply move tasks from one technician to another.
Each task can be extended by mouse to change or extend time of assigned task and it will also change the time of the task for technician where the task is assigned to.
Mouseover the displayed task will show detailed description of the task.
Click on the task will edit page of the task
Click on a technician name in a Daily plan (name of the column) will open following options:
- Show Daily plan - Will show Technician's Daily plan in PDF.
- Show Daily plan with finished tasks - Will show Technician's Daily plan including finished tasks
- Send Daily plan - Will send Daily technician's plan to an e-mail
- Show Weekly plan - Will show Technician's Weekly plan in PDF
- Send Weekly plan - Will send Weekly technician's plan to an e-mail
- Show service interventions - Will show service interventions of technician planned for this day
- Send service interventions - Will send scheduled service interventions to a technician's e-mail
There is a list of technicians in the left part of calendar where it is possible to mark technicians which will be the calendar displayed for. Click on the technician name will deactivate technician and their tasks will not be displayed in Daily calendar next click on the same technician name will re-activate displaying of tasks in the calendar. Pre-set is saved automatically and after next login to the system the calendar is displayed with the same settings of Daily plan display.
Under the list of technicians there it is possible to display coloured quide with description of particula task types and also "Statistiks of unfinished tasks", where are now displayed only unfinished tasks but in the next versions there will be additional details.

scheduling - head technician

Newly added "position" of head technician which is mentioned as supervisor of other technicians whose check tasks of subordinated technicians.
The tab "Settings / Administrators" newly has option to set up permission "Head technician" for the Scheduling part for each administrator. If set the system will display all technicians which are assigned to this Head technician.
In the case of "Head technician" authorization assigned the Head technician can see in the scheduling part only those technicians which are assigned to him. If the administrator has authorization as "Schedule admin" or "master admin" so in these cases they are able to see all tasks and all technicians and it is possible to display only those which they need.

CMTS

The tab "CMTS / CATV / CATV buildings" newly contains filter for better search by optional data inserted.
The tab "Settings / Code lists / CATV lines" newly contains filter for better search by optional data inserted.

LOKALIZAtion NZ

To separate decimal numbers in amount there is newly used decimal point instead of previous comma mark.

LOKALIZAtion HU

Invoicing of VoIP service newly includes prefixes 3620, 3630 and 3670 for "Mobile phones", other numbers have prefix 36 and are marked as "Internal calls". Other prefixes are marked as "International calls".

ISPadmin 4.04

ISPadmin 4.04

CONTACT

MENU