From ISP admin
3.61 beta1 - 13.1.2012 ENGLISH
BUGS
- Each UBNT device in the menu Routers contains the icon MACFILTER if it is enabled. By clicking on the icon the system displays all clients connected into this UBNT device.
NEWS
- The settings of the VoIP service now contains new fields for more detailed settings of the VoIP service. New fileds are following Portal login, Portal password, Company login, Company password and Month limit. All these new variables can be found in the menu Settings / Contracts / List of system variables
- In the menu Routers / Router status / WIFI links is now also possible to display Transfer graphs and Signal graph on both sides. Detail of the Graph can be displayed by clicking on the icon which is located on the right side of the row of the WIFI link.
- User Interface now contains option to enable or disable sending of Mass emails from provider which are defined in the menu Other / Mass / E-mail. Activation of this function for client (to be able see the checkbox in the UI) is possible to set in the menu Settings / Syst. settings / User interface using variable "tech_support_mass_email" and set to the value "1". Changes in this settings is logged in the History of changes in the client card.
MIKROTIK
- Fixed bug when while using the service MAC address (in the menu Settings / Administrators / Service MAC) for the non-existent Wireless interface of the Mikrotik router the system didn't write configuration correctly
- In accordance to the responses from ISP the settings of displaying of info pages AUTOMATIC NOTIFICATION OF CLIENT WHEN THE INVOICE IS AFTER DUE DATE has been changed. In the last version while the checkbox "Do not stop" was checked so the client didn't see the Info page but now there is a new checkbox Do not show Delay in payment in the Client card. This options allow to display the Info page to the user but in the same time to do not stop the user.
INVOICING
- In the case when issued invoice has 0 value (e.g. while minus value is added to invoice manually), it is possible to set invoice as paid in the Invoice detail by clicking on the icon Mark invoice as paid. This option is available only in the case when the Invoice has 0 amount on it.
- In the detail of the invoice in Client card there is History of payments what now contains the date of payment (e.g. in the case of partly payments). In the past there was only the date when the invoice was paid at all.
INVOICING - CASH BOOK
- The Cash book was added in the last version of the system ISPadmin and can be found in the menu Billing / Cash book. Newly is possible to filter the content by Category, Group, Income / Expense. This filter settings is also applied while printing records to PDF
- In the list of Incomes / Expenses of payments there is a total sum displayed on the right top of the table in accordance to the selected filter.
- In the list of payments there is a new column Subtotal what displays the current state for items
- If the payment is received by Cash using Cash desk so there is a new checkbox for this transaction Add to the Cash book. When the checkbox is selected the payment is displayed as Income in the Cash book.
- In the menu Billing / Cash book / Summary there is a overview by Categories, Invoicing groups or months.
CHANGELOG
- Displaying of Changelog has been customized. Now, after the success update and the first login to the system it will display current version from the website http://wiki.ispadmin.eu where is the text well arranged and graphically formated
- In the case of different localization than CZ or SK fo the system the Changelog is displayed in English
- In the case when Changelog is not available on the Wikipedia the system will display standard changelog from .TXT file.
RADIUS
- In the menu Settings / Tariffs / Radius there is now possible to set up rates for clients which are authenticated via Radius. In the past it was necessary to set up attribute Mikrotik-Rate-Limit manually to assign right speed to the client (download / upload) but now it is set automatically in accordance to the settings of tariff. If this attribute is already set manually so the system won't rewrite this record automatically.
LOCALIZATION
- Newly added RU (Russian) and UA (Ukraine) localizations
- These localizations are possible to display correctly in UTF8 charset only so it is available only for new installations where are all data now in UTF8 encoding
WIKI
- In the internal knowledgebase Others / Wiki there is now possible to define who is allowed to edit created article. Options are the Author of the article, User of the system with permission Masteradmin or all Users. All changes are saved in history and it is possible to display it whenever needed.
SYSTEM BACKUPING
- System of backuping has been completely reprogrammed. In the past system did full backups of all data only but it caused high usage of HDD space and creating of backups could took several hours for this process.
- Now it is possible to create of Incremental (differential) backups to save more time and HDD space while creating backups. These incremental backups saves only daily difference in backups and if there is no change so the system do not backup anything.
- Following functions are available:
- creating of incremental backups of the system ISPadmin (/data/support/*, graphs, scripts, backups of routers ...)
- creating of incremental binary backups of MySQL, Dump of all databases
- creating of directories predefined by users
- allow restoration of all backups to the predefined directory (e.g. /restore/backup/ ) or to the default location via terminal as super-user root
- allow restoration of backups via web interface to the special directories (e.g. for other user usage like preview, copy to PC, etc. ). Choosing the type the user can restore backups from each day only or last full backup to the current day or restore on these files which contains requested regular strings (using the search field) - Settings is available in the menu Settings / Syst. settings / Backups. After the update this option of saving of Incremental backups is disabled as default and the system will do full backups as in the past. In the pop-up menu is possible to set up period for creating of backups (daily / weekly / monthly). If Incremental backups are needed so it is necessary to mark checkbox Do Incremental backups daily. In this case is possible to set up doing of FULL backups e.g. Weekly to save space of HDD. For complete restoration is necessary to keep the last FULL backup and following Inremental backups from the last FULL backup !
- Backuping is executed daily in 3 AM
- System creates log about backup created which is sent to the email admin-email (possible to set in the menu Settings / Syst. settings / General)
- All saved backups is possible to display in the menu Others / Backups / System. There are displayed directories which are backuped and each one of them contains Full and Incremental backups
- If the encyrpting of backups is enabled so in this case all backups are encrypted via ZIP (encryption of backup is strongly recommended). Encryption is possible to set directly from command line using the command "/usr/local/script/ispadmin/ispadmin_backup_crypt.pl"
- Backup can be also easily done by clicking on the button Create backup in the web interface
- The basic structure of directories is following:
db - binary backups of SQL database ( directory /var/lib/mysql/ )
db_dump - dump ( mysqldump ) for individual databases
etc - backup of directory /etc
graph - history of graphs of transfered data to the client ( in time data like these takes more and more HDD space because graphs are saved as images ). Location of these data is in following path /data/support/ispadmin/client_images
ispadmin - backup of directory /data/support/ispadmin ( system data )
scripts - backup of directory /usr/local/script/ispadmin ( binary scripts and data ) - When the Full backup is done, other backups are Incremental and arranged to the new rows beloww the Full backup
- Each backup contains information about Number of files, if it is Full or Incremental backup, Date of backup creation and the size of backup
- Each backup contains following icons:
-- "diskette" - option to download backup to the local drive
-- "magnifying glass" - display the list of files saved in the backup including details like Filename, date of creation, size, etc.
-- "restoration" - option to restore file in accordance to defined parameters
-- "delete" - option to delete backup
SYSTEM BACKUPING - BACKUPS AND RESTORATION FROM BACKUP - COMMAND LINE
- To work with backups use the command "ispadmin_backup".
- When the command is executed it will display Help where is possible to use following parameters ispadmin_backup [help] [debug] [source-path=SRC-PATH] [path=PATH] MODE SCOPE
- help - display help
- debug - display detailed output of backuping
- source-path - if the BACKUP is provided by the system (parameter MODE has value backup) so it means directory where the backup will be saved. In the case of Incremental backups it is always directory /data/backup/incremental. If the different directory is needed so it is possible to change the path and create subdirectories there like etc, db, ispadmin, etc.
- in the case of system RESTORATION (parameter MODE has value restore) so it means directory where the backup will be restored from.In the case of automatic backup it is always directory /data/backup/incremental. It is possible to change the path if the backup is in different directory, of course. - path - if the parameter MODE is set to the value restore (restoration from backup) so in this case the path is a directory where the backup will be restored into. If the directory for restoration is defined e.g. /restore so the system will create subdirectories like /etc, /db, /ispadmin, etc.
- MODE - value "backup" - provide backuping, value "restore" - provide restoration
- SCOPE - option to restore full backup or individual directory only. If the full backup restoration is needed so use the parameter all. If the restoration of directory is needed only so in this case use the name of directory as parameter e.g. etc or script, etc.
SYSTEM BACKUPING - EXAMPLES
- Full system backup to the default directory /data/backup/incremental/
ispadmin_backup backup all
- Full system backup to the user directory e.g. /new/backup with optional extended listing [debug] (order of arguments is important)
ispadmin_backup [debug] path=/new/backup backup all
- Partial system backup (allowed are following options):
- ispadmin - system ISPadmin (/data/support/[ispadmin|admin])
ispadmin_backup backup ispadmin
- scripts - backup of executive scripts of the system ISPadmin
ispadmin_backup backup scripts
- graph - backup of all users' graphs
ispadmin_backup backup graph
- etc - backup whole linux config file
ispadmin_backup backup etc
- db - backup of binary DB - tables, system, mysql and creation of directory ./db_dump_last with dump files of all databases
ispadmin_backup backup db
- db_dump - backup of all dumped databases MySQL to the directory ./db_dump (created directory ./db_dump_last/, where are saved all current dumped files from the last backup
ispadmin_backup backup db_dump
SYSTEM RESTORATION - EXAMPLES
- Full system restoration to the directory /backup
ispadmin_backup [debug] restore all
- Full system restoration to the user directory e.g. /restore/new/ from user's directory with backups /download_new_backup/incremental/
ispadmin_backup [debug] source-path=/download_new_backup/incremental/ path=/restore/new/ restore all
- Partial system restoration
ispadmin_backup restore ispadmin all
- New directory "./restore_mysql_dump" is created in location according to defined source-path or in default directory for incremental backups (/data/backup/incremental/) where backuped dump databases are restored into and after restoration are moved to MySQL
ispadmin_backup restore db_dump all
SYSTEM BACKUPING - SAVING OF BACKUPS TO FTP
- Backups is also possible to save to FTP
- By clicking on the button Create FTP backup the system do standard system backup and send it to FTP if it is set. System creates complete log about this backuping option
- Settings of backuping to FTP is possible to set in the menu Settings / Syst. settings / Backups
- Newly is supported secured FTP transfer via FTP SSL