ISPadmin 4.11 stable

ISPadmin 4.11 beta2

FIXES

  • Fixed some minor bugs reported by providers.
  • Reading errors in RAM and HDD size for MikroTik version 6 and higher are now fixed.

INVOICING

  • Optimization of payment read-outs in the tab Invoicing Overviews Invoices and Client card / Invoicing, resulting in a speed increase.
  • If issuing a new invoice in (Client card / Invoicing), a new option Mark invoice as sent was added. It can mark an issued invoice as sent by E-mail.
  • New in tab Invoicing Invoices Invoices: it is now possible for the current year and invoicing group to set the option Mark invoices as sent.
  • If issuing a new invoice in (Client card / Invoicing), it is now possible to select all months for one service at once.

SEPA IMPORT

  • New Tab Invoicing Bank SEPA added.
  • So now there is also supported to import returned SEPA payments with error payments.

MOVING GRAPHS TO RAMDISK

The main usage load for disks, on which the system is installed on, is the generation of graphs in 5 minute intervals. For each client at minimum 2 graphs are created. For the routers at minimum 5 graphs are created in relation to the count of interfaces. Graphs are stored in binary form on the HDD and take up to 500KB of space. Therefore in practice the system needs to work with a large number of small files in which every 5 minutes informations about transmitted data and measured values are written. For a larger number of graphs SAS disk drives are recommended. SAS drives are significant faster, in working with small files, then SATA drives. Basically it is about the IOPS that the disks are able to provide to the system. In practice SATA disks are able to provide up-to 100 IOPS , SAS on the other hand are able to provide up-to 150-180 IOPS (depending on whether it is a 10k or 15k disk). The sum of IOPS can only be increased by the number of disks in RAID or by installing SSD disks for system graphing. IOPS is the main limitation for working with graphs. If the sum of IOPS is insufficient, the system latency is going to be increased and in some cases sites may load slower because the system is waiting for the HDD to be able to read and write. In this case an increase of RAM or CPU upgrade will not help. The only possibility is to increase the number of disks ( or replace the slow SATA drives with faster 15k SAS drives ).

  • It is now possible to move generated graphs to a RAMDISK. A Ramdisk is a self-contained part in memory, that behaves like a disk but Access times are several times faster than a conventional HDD, because it only uses RAM memory to store the data. If graph generation is run within RAMDISKS the IOPS and the disk usage will be significantly reduced. This is the most noticeable in large installations ( 1000 clients or more). In this cases we recommend moving graphs to a RAMDISK.
  • To work with RAMDISK, run this utility
/usr/local/script/ispadmin/rrd_ramdisk.pl
  • To display a help message, run it without any parameters
  • Usage:
/usr/local/script/ispadmin/rrd_ramdisk.pl initialize - Initialize RAMDISK
/usr/local/script/ispadmin/rrd_ramdisk.pl destroy - Destroy RAMDISK permanently
/usr/local/script/ispadmin/rrd_ramdisk.pl start [force] - Start RAMDISK
/usr/local/script/ispadmin/rrd_ramdisk.pl stop - Stop RAMDISK
/usr/local/script/ispadmin/rrd_ramdisk.pl save [force] - Save RAMDISK data to backup
/usr/local/script/ispadmin/rrd_ramdisk.pl check - Check RAMDISK usage
/usr/local/script/ispadmin/rrd_ramdisk.pl set - Set RAMDISK in MByte
/usr/local/script/ispadmin/rrd_ramdisk.pl restore [backup.file] - Restore RAMDISK from last backup.file
  • You may use the following parameters:
    • initialize - Initializes the RAMDISK and moves the data to the RAMDISK.
    • destroy - Unistalls the RAMDISK and moves the data back to the drive.
    • start - For an automatic start after booting. Use [force] to initialize RAMDISK even if the size of the restored backup is smaller by more than 5% than the previous ramdisk size, or if RAMDISK initialization was not successful after server reboot, and you need to initialize RAMDISK from the console.
    • stop - Makes an automatic backup of the data in RAMDISK, copies the backup to a Hardrive, and stops RAMDISK. !!! We strongly recommend that you perform it every time you restart/switch off the system !!!
    • save - Makes a backup of data of the RAMDISK to a Hardrive - performed automatically once a day, 10 backups are done retrospectively, and you may restore them later. Moreover, 2 monthly backups (as of 28th of each month) are stored.
      (It backups into /usr/local/script/ispadmin/rrd_data_backup/. Use [force] to make a backup of ramdisk which is smaller than the previous ramdisk in size, e.g. if you deliberately delete more files with graphs. A check on 5%-difference compared to the original size is performed.)
    • check - Checks the utilization of the RAMDISK and if needed, it automatically increases the RAMDISK.
    • set - Set RAMDISK size in MB to increase it according to your needs.
    • restore - Insert name of backup file from backup directory for rrd ramdisk to restore a daily backup of rrd data. If no name is inserted, the system will restore the last known backup from this directory. You may use data restore if you loose it, or the data is incomplete. The only must is initialized RAMDISK.
  • When RAMDISK is installed, you need to run the following command:
/usr/local/script/ispadmin/rrd_ramdisk.pl initialize
    • This initializes and configures all that is needed. After rebooting the sytem it installs the RAMDISK again and the data are moved on to it.
    • Be aware that the data on a RAMDISK is saved in RAM and if a server malfunction occurs ( powersuply malfunction ) all data are lost. In the case of correct restart, the system automatically backs up data to the Hardrive an moves it onto the RAMDISK after booting. The system also makes an automatic backup onto a hardrive once a day. So in case of power supply outage, one-day data only is lost.
    • For RAMDISK creation it is absolutely necessary to have a sufficient amount of RAM. The maximum amount of RAM that can be used for the RAMDISK is 25%.
    • The necessary amount of RAM is calculated dynamically according to occupied disk space (mostly 510Mb - 5GB). If the calculation for RAM is resulting in a larger amount then 25%, the RAMDISK is not created and it is necessary to upgrade the amount of RAM. If RAMDISK capacity is more than 80% full, the system will try to increase the disk automatically (if RAM is sufficient). If it fails, you may increase RAMDISK manually using set option.

ISPadmin 4.11 beta1

FIXES

  • Fixed some minor bugs reported by providers.
  • Changed permission for Administrator management. Now Administrators can only be modified by administrators with the permission of MasterAdmin

NEWS

  • Added a check for the item "Allocate an IP address from the number" in the configuration of Routed Networks.
  • In Tab "Clients / IPTV"a filter was added for "Invoice Group".
  • In Tab "Clients / Home" service tasks were removed. Now they are available in the menu "Scheduling / Overview"

REWRITTEN PAGES

  • Settings / Administrators / Admin. groups
  • Clients / VoIP
  • Clients / Universal
  • Other / Documents
  • Client card / Information / Documents
  • Invoicing / Settings / Templates / Universal
  • Invoicing / Settings / Templates / Pending it.
  • Invoicing / Overviews / Opening Bal. - Show list of invoices in CSV
  • Invoicing / Overviews / Invoicing / clicking on the number of invoices - displaying a list of invoices in PDF and CSV
  • Client card / Information / History

INTERNET SERVICE

  • Maps are now displayed in Change service INTERNET, and loaded after the initial page load. The page is now able to load faster (up to 50%).
  • When editing the pop-menu "Router" it displays Active routers first and underneath are Monitored routers. They are separated by the title Active and Monitored.

IP NAT POOLS

  • In the tab "Settings / IP pools / IP pools NAT" an option in the table for clicking "Number of engaged IP addresses" was added, to display the list of engaged IP addresses.

TV

  • Now it's possible to use the service Sledovanitv.cz in combination with ISPadmin. Clients are identified by IP addresses in their Active Internet services. After the browser displays the URL of sledovanitv.cz, he is rerouted to ISPadmin (https://[isp.example.cz]/new/www/sledovani-tv/identify) , which identifies the client and invokes a reroute to the sign in form on sledovanitv.cz. If the Client needs an list of TV stations for VLC, their is the possibility of using the URL https://[isp.example.cz]/new/www/sledovani-tv/channels, which returns, after authentication, a list of TV channels.
  • After commissioning , it is necessary to agree on Rerouteing with sledovanitv.cz s.r.o from their URL sledovanitv.cz to ISPadmin ISPadmina https://[isp.example.cz]/new/www/sledovani-tv/identify

SCHEDULING

  • In the tabs "Scheduling / Overview" and "Client card / Information / Scheduled interventions" is an overview of scheduled tasks. Each technician is able to see all tasks, they only differ in who is able to edit and delete a specific task.
  • Now it's also possible, for technicians with the lowest permissions in scheduling, to set the ability to change technicians on existing tasks. The Configuration is set in Administrators Settings, with the check box "Cange technician task"
  • If in tasks a assigned technician is removed, the technician is informed, via E-mail, that the task was cancelled. The E-mail is automatically sent, if the technician has set a valid E-mail address. The Subject of the E-mail can be set in the tab "Settings / Syst. setting / Scheduling" with the key "planning_email_subject_unassign"
  • While saving a task in scheduling it's possible to send information of the task via email to the clients. In the tab "Settings / Syst. settings / Scheduling" there it is possible to set the subject with the key "planning_email_subject_ticket_to_client" and it will be automatically completed with the ID of the Task. This E-mail can be sent with each change in tasks by clicking "Send ticket to Client" in the edit Tasks.
  • While adding and editing tasks it is now able to save up to 5 people at once.
  • In the tab "Scheduling / Overview" last applied filters are saved and used after the page reloading.
  • In the tab "Scheduling / Overview" it is possibility in the Calender, to click on a month to display tasks only for that specific month.
  • In the tab "Client card / Information / Scheduled interventions" filters are not saved and after the page reloading there are no before used filters applied

INVOICING

  • In the tab "Invoicing / Invoices / Invoices" option "Lock Invoices" was added for a specific month and invoice group. If an invoice is locked in this way, it isn't possible to change, cancel, change dates and address and issue a new invoice in this particular period. Locking and unlocking can be only done by the MasterAdmin or MainAdmin.
  • Added support for exporting invoices to "BYZNYS" accounting system.
  • In the tab "Invoicing / Overview / Invoices" there it is possible to "View Statistics by Service" but each row has a new added icon to print out a statistic of every individual service
  • While adding common services it is now possible to choose an accounting code for each item. If accounting codes are permitted (the tab "Invoicing / Settings / Accounting") and in the tab of the service no accounting code is used, the system applies a global accounting code selected from the general service (the tab "Settings / Active services / General").
  • In the tab "Invoicing / Invoice / Invoice" by click on view or print invoices in PDF, an intermediate step appears with the option to choose a certain type of payment.
  • In The detail of each invoice it is now possible to generate SEPA data for the invoice (currently only possible for all invoices issued in a given month).
  • Now when generating files for SEPA (the Client card / Information / Invoicing and Invoicing / Invoices) the system automatically settle all invoices for which SEPA was generated. This feature is only available for localizations ES, IT, and IE (for other localizations available on demand).
  • Enabled reloading for erroneously processed e-mail from the bank. In some cases it may happen that the system marks one as processed, but couldn't read any payments. So now in the menu "Invoicing / Bank / E-mail" erroneously processed emails, can be marked as unprocessed with the icon at the end of the line and the system tries to precesses them again in regular 5-minute intervals.
  • A new system variable created invoice_offset_correspondence_address in the menu "Invoicing / Settings / Universal" , through which it is possible to move the mailing address on the invoices. The value indicates how many millimetres the address is moved downwards.

PAYPAL PAYMENTS

  • Automatic matching of incoming payments in PayPal now supported.
  • A new tab PayPal is now available in the tab "Invoicing / Bank", where all payments received via PayPal are displayed.
  • For proper functionality it is necessary to set following parameters:
    • In the tab "Settings / Syst. Settings / General" it's necessary to adjust the parameter ispadmin_server and insert an IP address or Domain of an ISPadmin server (eg. Demo.ispadmin.eu).
    • In the tab "Invoicing / Settings / General" it's necessary to adjust the parameter paypal to "1" and also into the paypal_account_id fill in the PayPal account ID.
    • In the firewall rules HTTPS must be allowed globally.
  • If everything is properly configured and enabled, after any payment of the invoice from Client portal (by clicking on the icon PayPal), the payment appear in the tab "Invoicing / Bank / PayPal" and the invoice is automatically set as paid.

Send and receive SMS via the protocol SMPP

  • Added support for sending and receiving SMS via the Internet protocol SMPP. If a SMS gateway (for example 2N VoiceBlue) supports the SMPP protocol, it is possible for the system to send and receive SMS. The gateway is connected via Ethernet and ISPadmin is communicating via the TCP / IP protocol. The main advantage is that the gate does not have to be placed directly next to the ISPadmin server, but can also be located anywhere (e.g., in another server room). So it can be used in combination with virtualization, where it is sometimes difficult to map a serial or USB port on an SMS gateway to a specific virtual installation.
  • In the tab Settings Syst. settings General, it is now possible to set up new parameters:
    • sms_notify: sett value to 3 for SMPP protocol usage.
    • sms_smpp_ip_address: IP address of the SMS gateway
    • sms_smpp_login: login name
    • sms_smpp_password: login password
  • Accordingly it is possible to send SMS to clients, send automatic system notifications and notices

GOOGLE MAPS

  • In the tab Other Map, a new filter All states of clients and All Routers is added. By selecting the filter states of clients all clients belonging to this state are displayed on the map and the same applies for the Router filter.

CONTACT

NET service solution, s.r.o.
Žerotínova 3056/81a
787 01 Šumperk
Czech Republic
  +420 588 887 777
  support@ispadmin.eu
  wiki@ispadmin.eu
  sales@ispadmin.eu