Changelog 3.60-beta1

From ISP admin

Jump to: navigation, search

Contents

3.60 - beta1 - 15.12.2011 ENGLISH

BUGS

  • Fixed some minor bugs reported by users.
  • Fixed bug in Syslog where some records were not assigned to the router correctly and in this case it was not possible to find records by Router in the menu Statistic / Syslog.
  • Fixed bug in the menu Statistics / Data where the export of data to the CSV file contained only the first page, not all records.
  • When the setting "Suspended from - to" was defined (Client card / Internet service] with any argument so the system stopped client and in all cases redirected to Info page Non-payer. Now it will display Info page in accordance to selected option.

NEWS

  • Ping graph (e.g. in the menu Routers or in the Client card) now contains packet Ping size what is send to device or client.
  • In the menu Settings / Sys. settings / General there now possible to set value "2" for variable "user_ending_contract_send". This setting will affect sending of notification about ended contracts
    0 - disabled, it means that system will not send notification about ended contracts
    1 - enabled, system will send notification about ending contracts even after the contract validity date
    2 - enabled, system will send notification about ending contracts to the last contract validity date.
  • In the menu Statistics / Server stats / Graphs on the top of the page there is a table with new information like: Server Uptime, Core version, CPU type, Number of CPU cores, total memory, total SWAP, currently logged users and 10 last login to the server.
  • In the Client card / Active services there is for each service displayed the router where is the client connected in. By clicking on the name of the router it will display router like in the menu Routers. Below the name of the router there is information about router type (Mikrotik, UBNT, Canopy, Linux).
  • In the menu Statistics / Logger in the option from pop-up menu "History of changes at router" there is a new information about routers whicha has been deleted (in the bookmark Routers). This function logs Router ID, name of the router and the name of technician who deleted the router from the system.
  • In the menu Statistics / Logger in the option from pop-up menu "DB info" there are logged information about damaging and repairing of the SQL database.
  • In the menu Routers / Availability there is assigned icon with variable colors for each router to recognize packet lossing. Description about colors of icons and what does it mean is available in caption.
  • While adding or editing the service "Internet" there is possible to define "Access point". From the pop-up menu is also possible to choose UBNT access points. If the option "Search by SSID" is used, the system will set correct router when the appropriate Access point is chosen and it is not necessary to set it manually.
  • Discount is now possible to define even for CATV service. Discount can be set as fixed prices what is not depended on the service price or it can be set in percentage % and in this case the price always changes when the price of the service is changed.
  • Now in the menu Statistics / Wifi list there is the new column "Antenna" what contains information about Antenna on each Interface. Antennas are separated by "|" mark and contains the Name, type and antenna gain. This column is also possible to export to CSV file.
  • In the version 3.59 there was added a new function to add "external_link" in the Client card. In the last version there was displayed only the URL address what, in some cases, looked not very well arranged so now it is possible to set variable "'external_client_link_description" in the menu Settings / Sys. settings / General to fill description of this URL which will be displayed in the Client card instead of the whole URL address.
  • In the menu Settings / Contract there is now displayed the name of administrator who was edited the item (contract template) at last.
  • In the menu Other / Export there are new information which are send to the export file of "'Clients with Internet service". The new information are following: "Contract number", "Title of the service" and "Name of the Access point".
  • In the menu Other / Wiki it is now possible to move already created note to the different folder. Note can be moved while editing and Click on the button "Move" what is located on the header of the note on the right (blue background). By clickin on the icon it is possible to choose the folder where the note can be moved in.
  • In the case when MAC filter is enabled the system will display green icon "MAC filter" below the IP address of the router. By clicking on the icon it will display the list of clients assigned in. The latest version includes possibility to delete MAC address and also Clients' MAC addresses assigned in. If the MAC address is deleted so the MAC filter is deactivated and it will be enabled again only in the case when the MAC address is added manually or in the case of automatic searching for MAC address of the client what is done once per hour.

VERIFICATION OF TECHNICIANS TO THE MIKROTIK ROUTER VIA RADIUS

  • This function means that now it is no longer necessary to create special accounts with special rights to access routers for technicians and in the case when technicians leave the company (e.g. technician is fired) it is no longer needed to cancel their accounts to avoid them access to routers. The system now do the automatic configuration of accesses for the Radius server and it will allow login for technicians (via Winbox, SSH, etc. depends on permissions).
  • To activate management of Technicians' accesses to the routers it is necessary to set variable "service_mikrotik_login" to the value "1" in the menu Settings / Sys. settings / Mikrotik".
  • In the menu "Settings / Administrators / Mikrotik login" there is the bookmark "Groups" where is possible to define each groups with detailed permissions.
    • Permissions are following:

    • local - login via local console
    • telnet - login via Telnet
    • ssh - login via SSH
    • ftp - login via FTP. User with this permission can read, write or delete files
    • reboot - allow option to reboot router
    • read - Read only permission. User is not allowed to do any changes in configuration
    • write - permission to modify configuration out of the settings of rights for User management (creating of the User accounts to access the router). This permissions does not allo Read right, it is necessary to enable it separately.
    • policy - allow setting of another administrator accounts to access the router
    • test - allow to do PING, Traceroute, Bandwidth-text, Wireless scan, Sniffer and Snooper
    • web - allow accessing via Web Interface
    • winbox - allow accessing via Winbox
    • password - allow password change to individual User accounts
    • sensitive - allow to display "the most sensitive" information like passwords, Wireless keys, etc. are.
    • api - allow access via API
    • sniff - allow to execute Sniffer utility
  • There is no limitation for number of the Groups with different permissions
  • In the menu Settings / Administrators / Mikrotik login there is a bookmark "Users" where it is possible to create individual accesses for technicians. Each user has to be assigned to the group where are defined all permission for users.
  • If there is any access created to the router so in this case the administrator has default access to the all routers. Each router (menu "Routers") has a checkbox to enable / disable "accessing of technicians to the Mikrotik routers via Radius". If the checkbox is not enabled so no defined account in the menu "Mikrotik Login" is accessible.
  • If the settings is defined correctly and Radius is enabled on the server, so the system will enable communication via Radius at all routers automatically, set Groups to access routers. Each group permission is written directly in the router to allow access of technicians in accordance to their own permission.
  • Verification of technicians to the Radius depends on the settings of variable "server_ip" in the menu "Settings / Sys. settings" where has to be set the IP address of the server with running ISPadmin which is accessible from all routers. If this IP address is not valid the access to the routers via Radius will not be possible.
  • This function is possible only in the case when the Radius module is active on the server with running ISPadmin !

NAGIOS

  • System of sending of SMS and notifications from Nagios has been completely reprogrammed. Now it is possible to define template of the failure even for groups of contacts.
  • The menu Settings / Codebooks / Nagios is now separated to the submenus like Contacts and Templates.
  • In the menu Settings / Codebooks / Nagios / Templates there is now possible to define individual templates for sending notifications via email or via SMS (if the HW SMS Gateway is connected in). To create the template it is possible to use system variables which are displayed on the same page (e.g. IP, Host name, etc.). Each section (SMS or E-mail) has one default template which is used for sending of notifications if another template is not set.
  • In the menu Settings / Codebooks / Nagios / Contacts there is possible to set up default template which will be used for sending of notifications about device failure via E-mail or SMS. It means that each defined Contact group will receive own pre-defined template of notification.
  • Each router in the menu Routers now contains the icon for identification of the group where the routers is assigned to (SMS or E-mail).
  • In the menu Routers there is possible to set "extra contact" for SMS notification group. In the case of failure the system will send notification via SMS to all contacts defined in the menu Settings / Codebooks / Contacts and also it will send notification to this extra contact. This special telephone number can be represented for example as HW resetator and in the case of receiving SMS with exactly defined text the resetator will accept it and provide restart of the device.

TARIFF - MINIMAL GUARANTEED SPEED

  • In the menu Settings / Tariffs there is now possible to set minimal quaranteed speed which will be used to create QT at the router Mikrotik using the item "limit-at" at Queue tree. In the past this item was set as 1/10 of the client's speed from assigned tariff.
  • Apart from settings of Upload and Download speed there is an option to set minimal speed what is separated to the following choices Automatic and Manual.
  • In the case of Automatic mode the system set limit in QT to 1/10
  • In the Manual mode is possible to value as needed. The minimal speed must be the higher number then 0 value but lower number than the client's speed already is (maximal speed).

MIKROTIK

  • Applying of rules to the routers has been optimized
  • In the menu Routers / Router Status there is now also information about RAM usage of the Router. By clicking on this information it will display detailed graph.
  • Disk usage information is now also drawn to the graph.
  • The version 3.59 contained new function Bad payer notification which have exceeded the due date of an invoice. This function informs clients by Info page and by clicking on OK button they are allowed to use internet service again. In the past the Mangle rules was applied to Prerouting but it caused that in some cases the Info page wasn't displayed. Now there is used Post routing to avoid this problem.

MIKROTIK - SERVICE MAC

  • The menu Settings / Administrators now contains new submenu Service MAC. This function is for technicians to allow them access to the provider's network. This defined MAC address is applied to all MK routers to the wireless access list and allowed on Firewall so technician can access the network and set needed IP address. If technician does not know the IP adres he can access Mikrotik router via Winbox and do necessary changes for connection, at least.
  • After connection of the device (notebook) with the service MAC address the system check the IP address and add it to the address list to be able allow this IP address on Firewall.

BACKUPING

  • In the menu Settings / Backups / Routers there is possible to do individual backup of the router whenever is needed by clicking on the icon Backup at the router.
  • Setting of system and routers backups was completely reprogrammed. In the past the setting was several variables and not well arranged. Now there is a new bookmark in the menu Settings / Sys. settings named as Backups where is possible to set all necessary parameters about system and routers backuping.
  • SQL table what contains information about all Clients' Internet services is backuped to the directory /data/backup/sl_internet_db/ . System stores last 30 backups of the SQL table. Table can be damaged e.g. in the case of Power failure and these backups are for fast renew of data.

INVOICING

  • The system now stores also history of automatic sent Original invoices by email if it is set in the "Billing / Settings" using variable "proforma_automatic_send". This History can be displayed in the Client card in the menu History from pop-up menu Sent emails.
  • In the menu Billing / Bank there is possible to print settled and unsettled payments in PDF format. Now this document contains summary of all amounts on the bottom of this document.
  • Newly added option to set templates for invoices, Continuous items and Universal service located in the menu Billing /Settings / Templates which are usable for most common used templates for Invoices and services with predefined items on it.

INVOICING - CASH BOOK

  • Nově přidána funkce "Peněžní deník". Peněžní deník slouží k evidenci příjmů a výdajů za dané období.
  • Pro správné použití je potřeba nastavit v záložce Fakturace / Nastavení "Kategorie" a "Skupiny" peněžního deníku, podle kterých se budou náklady a výdaje rozlišovat. Například pokud si přejeme vést náklady na používání osobních automobilů, tak v záložce Fakturace / Nastavení / Peněžní deník / Kategorie si vytvoříme kategorii "automobily", zvolíme do které fakturační skupiny bude zařazena a přednastavíme zda se jedná o výdej nebo příjem popř. zadáme i cenu. Dále v záložce Fakturace / Nastavení / Peněžní deník / Skupiny vytvoříme už jednotlivé automobily, které provozujeme.
  • V záložce Fakturace / Peněžní deník si poté můžeme výdaje i příjmy zadávat a sledovat. Například pokud do auta natankuji palivo, tak si zde přidáme výdaj do kategorie auta, do skupiny příslušný automobil a zaeviduji si částku za pohonné hmoty.
  • Nad seznamem jednotlivých položek je možné celý peněžní deník zobrazit v PDF a případně vytisknout.

SCHEDULING

  • While editing the Task it is possible to mark checkbox "Send copy of task to author" after that the Author of the task will receive copy of the email. If the task is edited by author himself this checkbox will not show.

IT LOCALIZATION

  • Export to the Italian accounting was added "Danea easyfatt". Export to the accounting (the result file is in the XML format) can be set in the menu "Billing / Settings" using the variable "export" and set to "15" value. This option is experimental for now, because is needed in practice to test if everything works properly.
  • VOIP import modified (menu "Others / VOIP import"), where the import script assign the Czech call prefix (+420) automatically and in this case it was not possible to import calls from Italian operator where is a different call prefix.

HU LOCALIZATION

  • Export to the Hungarian accounting was added "RLB60". Export to the accounting (the result file is in DBF format) can be set in the menu "Billing / Settings" using the variable "export" and set to "16" value. This option is experimental for now, because is needed in practice to test if everything works properly.


Translation is in progress. Please be patient.

Retrieved from "http://wiki.ispadmin.eu/index.php/Changelog_3.60-beta1"