From ISP admin
Frequently Asked Questions
FAQ - General
Client number
Each client`s client number is stored in the databse of the system. TIt is a unique identifier which the system later uses and thus it must be under all circumstances unique. The client number, or also client ID, is used as a number of the contract, as a variable symbol stated on the invoice as a payment identifier, as well as the login name into the client interface. Technically, the client ID is used for marking and dealing with the client packets ( mangle ) during their passing through individual MikroTik routers.
Client number assigning
It is possible to set manual or automatical assigning of the identification numbers to clients within the system. Manual setting is used mainly when you keep the client numbers identical to the previous system. Another use of manual setting is keeping of certain client numbers for example according to the years. If you manually set an identification number while adding a new client, there will be a preset number higher by one for any next client. Newly added clients thus may simply be marked with numbers: 20090001, 20090002, 20090003, etc. Marking the clients in this was will thus enable you to say when was the cerain client connected, which may be useful regarding the client ID being at the same time the number of the contract.
Last but not least, you will thus make the listing in different screenshots with previews of users better-organized. You will use manual setting of the client number also in cases when you add once already removed client and you wish to set the same number to them such as was the previous one, which again is useful for browsing the history and earlier issued documents.
If you do feel the need to deal with the precedent ways of assigning client numbers, you can select automatic assigning of the client numbers and the system will take care of everything automatically. This choice cuts down on the possibility of human error because the box for setting the numbers will be hidden on the form. You can define the setting of client numbers in the menu of Settings / System settings / General item type_client_number. This item may be changed any time and both ways may thus be combined.
Clash of client numbers
In case when you use manual setting, the system will automatically watch for the clashes of the client numbers so that every client number is unique. Moreover, each change to a client number is recorded in the history of changes within the client card.
If you have chosen automatical setting of the client numbers, a clash of the client numbers can never occur, however, the system still watches for clashes of the variable symbols (or the specific symbols according to the invoice settings), so that these are assigned only to one and only contact.
IP address settings
A) Temporary IP address setting ( until the first restart ), enter only these two commands:
ifconfig eth0 192.168.1.100/24 # IP address setting and mask route add default gw 81.13.51.193 # default gateway setting
B) Setting of the permanent IP address, mask and the default gateway. Change the current addresses to desired ones in this file:
pico -w /etc/rc.local
Then it is necessary to state the new IP address as well as the configuration by the changing of these two files:
pico -w /etc/hosts
pico -w /etc/httpd/conf/httpd.conf
ISP admin operation at NAT
If your ISP admin is located in the inner network and you wish to access it also from the Internet, the easiest way is to set NAT 1:1 on the public address onto the inner ISP admin address.
In other case it is necessary to ensure redirecting of the chosen ports onto the inner ISP admin address:
- ssh TCP/22
- smtp TCP/25
- dns TCP/53, UDP/53
- http TCP/53
- ntp UDP/123
- https TCP/443
The inner and outer address on the ISP admin server
The system is typically connected into the network by only one network interface controller; public as well as the IP address from the inner network range may be used. Should you, however, wish to separate access from the Internet and from the private network, you can connect the system by through two network interface controllers. On the first one there will be the public IP ( the access will be handled from only selected number of IP addresses on the firewall due to security ), and the second one will be connected into the inner network (eg. for client interface ).
PING to the user does not work
The PING function to the user is defaultly off. The main reason for thus us lowering of the network load which increases together with the number of clients. Locating the router statuses and connected devices is of course still active and monitoring runs by PING as well as by the NAGIOS module.
This service activation is easy, you need only to discomment the following line in the file /etc/inittab:
#t1:23:respawn:/usr/local/script/ispadmin/cable_userping.pl
and then launch the command:
telinit q
Some of the system bookmarks cannot be displayed
This often happens when you yourselvers, or somebody with Master admin competence, change the parametres of the administrator account in the bookmark of ¨Settings / Administrators. First, please, check this settings.
The other possible way is to deactivation of the service (CATV, VoIP, General service), or of the function (SMS, ADLS, IPTV, NAGIOS) in the settings of the system. Browse the options of the settings in the bookmark of Settings / Active services, as well as in Settings / System settings / Public.
The last option is the installed extending module (NetFlow, RADIUS, Partnetrs), by which fact the related bookmarks and functions are not displayed.
Some of the columns of the Internet bookmark do not display
If you cannot display all the columns in the Users / Internet bookmark, you can edit this display in the menu of Settings / System settings / Internet bookmarks. Here, you can define displaying of desired columns in normal display as well as in for widescreen. Switching the modes for normal (4:3) and widescreen (16:9) may be easily set by using the icon of the monitor 
at the right part of the screen.
This is a system settings and column display will be applied onto all administrator accounts.
Creating ISP admin system administrators
Adding or managing the administrators and other user accounts is done in the bookmark of Settings / Administrators. It is recommended that several user accounts are created with different competences for the access to the ISP admin system. For your personal use, you can use following model:
|
Master admin Main administrator Technicians Scheduling manager Accountant |
All competences at the ISP admin system management may do everything. The limited view sees technical things but does not see invoicing; mainly the main technicians. Forbidden invoicing, limited scheduling functions, or routers only for reading. All in scheduling permitted but the rest forbidden or only for reading. Only invoicing permitted, all technical bookmarks and scheduling limited. |
Notes:
- 1/ If there are some tasks ( a technician ) assigned under the administrator account, it cannot be got rid of the Scheduling competense until all the tasks are
- sorted out or removed.
The client cannot log into the web interface
If the client cannot lof into the web interface, it means some of these situations:
- No access password is generated or set in the client card. You thus need to fill in the password.
- The client has no service assigned. In the menu of Client card - Active services add any arbitrary service to the client.
- If an e-mail address or a phone number is asked to be filled in, then a check is carried out after client`s being logged in. The check will find out if the contact data is filled in. If they are not, the client will be asked to enter these data otherwise the system will not let them to procede. See the bookmark of Settings / System settings / User interface
Spontaneous filling in of the form features
If you have spotted problems while editing the client card or routers, ie. spontaneous filling in of nonsense values into the form features
( especially of passwords ) on the pages for editing any form, switch off the function of automatical filling of the passwords of your Internet browser.
Making a contract
Create a template for the contract in the Open Office - Writer text editor. Save the final document in the RTF format and import into the system in the bookmark of Settings / Contracts. When creating a contract template, you can also use system variables which will make the work easier for you.
You can create a contract template for the client service easily in the menu of Client card - Contracts where you click on the button 
New contract. On the following screenshot from a roll-out menu you will select Contract template and the specific Service to which the new contract should relate. The contract will be created by clicking on the button of 
.
( Important warning! ) We do not recommend using of Microsoft - Word editor very much. In some cases, formatting marks may be inserted into the key word of the variable, which then causes its not copying into the ISP admin. Sometimes during creating of the contract, tags related to the text formating get between the sign of dollar "$" and the name of the reminder. Correct copy of the variables into the input texts has a condition in entering the correct variable. If one of the variables is not coppied into the created text, open Open Office - Writer again, delete the whole variable and create it again and without formating. After saving it and reloading it into the system, check the copying of the problematic variable.
System variables
The system variables are used for copying the items such as: the client`s name, address, tariff rate, price, etc. from the database into the bulk messages, reminders, or also for creating contracts.
An article has been created for this topic: System variables.
Notes:
1/ Since the 3.38 version, there has been a change in the name of the variable $FAKT_OBDOBI$ to $OBDOBI$. If you use this variable in some of your templates, it is necessary to change it so that it was copied correctly into the text.
2/ Using the Microsoft - Word editor is not recommended very much; in some cases formatting marks may be inserted into the key word of the variable, which then causes its not copying into the ISP admin system. When creating a contract, tags relating to text formating may get between the sign of the dollar "$" and the name of the reminder. There is a condition for correct copying of the variables into the set texts by correctly entered variable. If some of the variables is not copied into the creating text, open the Open Office - Writer again, delete the whole variable and create it again and without formating. After saving and reloading of the variable into the system, check copying of the problematic variable.
3/ For generating of the bulk e-mails, SMS messages and documents, you can use only the variable offered from the Client area.
System e-mails
Three types of e-mail addresses are used for sending e-mails in the system. Each of them has its own significance.
- System e-mail The main e-mail which the system uses for sending messages. You can edit in Settings / System settings / Public where in line 53 you will enter the e-mail address and in line 53 complete the label of the e-mail or the sender`s name, eg. System, Network admin, or Administrator. This is used mainly for the messages of some technical nature.
- Accounting e-mail E-mail from which invoices and reminders may be sent. Settings to be done in the bookmark of Invoicing / Settings / Public here line 1 to be filled in with the e-mail address and the line 2 to be filled in with the label of the e-mail, eg. Invoicing department, Invoicing, Accounting companies, etc.
- E-mails of the invoicing groups The invoicing groups are the next one who can contact the clients via e-mails. When creating each and every invoicing group, you give an e-mail address from which you can later also contact the clients. The e-mail address may be edited in the bookmark of Invoicing /Settings / Invoicing groups
For receiving of different notifications, you can define the following e-mail addresses in the bookmark of Settings / System settings / Public
- Admin e-mail line 1 the main ISP admin system manager contact
- FUP notification copy line 17 e-mail to which a copy of a notification of exceeding the transmitted data limit
- FUP notification line 18 e-mail from which a notification of exceeding the transmitted data limit, the name of the e-mail to be filled in on line 19, and then the following items of subject and the text of the e-mail
- Not finished tasks line 37 e-mail to which e-mails about not finished tasks are sent
- Scheduling line 39 fowarding of all e-mails from scheduling to the given e-mail address
- Ending contract line 58 e-mail to which information on the ending contract will be sent
Removing records from the system
Removing the client
The removed client is not directly deleted from the system but only removed from the list of active users and put into another part of the system Statistics / Disconnecting the user. Removed client accounts, their services and invoicing remain stored within the system, they are just not displayed. Here you can refresh the removed client again or delete them for good.
Removing the service
The removed service is not directly deleted from the system but only hidden from the list of active services. The choice of "Show removed services" will put also the already removed ones into the list of services.
Removing the invoice
Removing of all the generated invoices (only if these are unsent and unpaid for) Invoicing / Settings / Invoicing groups. "Invoicing period" - change only if there is a wrongly generated invoice and there is the need for a new one for the particular month.
- Cancelation cancelation possible only in the tax evidence; you cannot cancel invoices for the double-entry bookkeeping
- credit note
We can remove invoices only if none of them has been sent or even paid for. A wrongly entered invoice must be cancelled and then there must be a new one issued, or a a credit note must be made.
Removing the router
This will be deleted definitely, but there remains its ID in the databse so it is possible to create a new one with the same ID and then re-fill in the settings again.
Removing individual records
These records ( lines removed by the icon of 
) will be definitely removed from the database. The following data refreshing is possible only from the previous backups of the system.
the ISP admin as a DNS server
The ISP admin may be also used as a default DNS server for your network. The settings DNS Cache server is a part of the default configuaration, the system automatically asks the superior DNS servers in the Internet. It is thus enough to give only the ISP admin server OP address.
You can add your own DNS servers by these steps:
pico-w /etc/resolv.conf
search vase-domena.cz
nameserver 127.0.0.1
nameserver IP_DNS_of_the_used_server
in the end restart the services by the command of:
/etc/init.d/bind9 restart
If the ISP admin is located in the inner network, the operation on ports must be allowedTCP/53 a UDP/53.
The ISP admin as a SMTP server
The SMTP server is defaultly set in the way where it is possible to send mail only from the localhost, so the server may be put onto the public IP address and nobody will be able to send their mail through it ( no open relay ). The ISP admin thus does not send any mail outwards ( only locally ).
The Postfix does not allow verification so the ISP admin must be permitted to send mail without verification onto the superior SMTP server ( Setting the address for the relayhost ).
A section has been created relating to this topic within the article: Command line environment section Post server - Postfix.
If the ISP admin is located in the inner network, the operation on port TCP/25 must be permitted.
FAQ - Routers & MikroTik
Supported versions of ROS
As stable we consider versions 3.10, 3.13, 3.26, 3.30 and the lately issued one 4.5
We do not recommend Nedoporučujeme přecházet na některé verze, označené firmou MikroTik za stabilní. U verze 3.23 a 3.24 nefunguje rozhraní API zcela korektně. Počáteční verze řady 4, zřejmě také nepatří mezi nejstabilnější.
Shaping and MikroTik router options
The main advantage of the ISP admin is a full support of the MikroTik routers including the API interface. All changes done to the system administration are periodically copied to the MikroTik routers configurations, which always ensures up-to-date settings of all the network. All changes such as adding a client, setting the speed, tariff rate, FUP etc. may be easily entered to the system which will take care of all the router settings automatically. A new API interface allows more extended read-out of the information from the MikroTiks than the classical SSH, which for instance allows generating detailed graphs of WiFi signals on individual client routers.
An article has been created for this topic: Shaping and MikroTik router options.
This document depicts the major information necessary for the correct understanding of the ISP admin cooperation with MikroTik routers. Without the following knowledge, you will not be able to correctly define the important setting in the ISP admin.
Test of connection to the router
Routers / All - button 
Test connection
The test of the connection is a system function which verifies a successful login to the router. The test of connection may be carried out for one specific router as well as for all routers at one time. The basic test is the availability - Ping, whether the router has SNMP, SSH, nebo API services active, they will be tested too. When there are some independent Queue Trees on the router, even their settings are tested.
Preview of the screenshot of the test of connection together with the SNMP data results read out of the connected devices.
This is how an unsuccessful test looks like; it will be probably necessary to set or check the login information.
Example of verification of individual Queue Trees, if these are defined on the router.
MikroTik router binary backups do not work
If a problem arises, in which your binary backups do not save, verify that the account under which the ISP admin manages the configuration of the router has a flashdisc routboard record permitted. If not, you naturally cannot create binary backups even on the router itself. The backup is created by the command:
/system backup save name="ispadmin
This command must run with no problems otherwise the backup will not be carried out. If a following announcement appears:
Saving system configuration
Failed to save system configuration backup
not enough permissions (9)
The backup may be also launched manually by the command:
/usr/local/script/ispadmin/backup_conf.pl
The command mentioned will show potential errors:
25.2.2010 09:15:50 RTR_test Failed to create binary mikrotik configuration backup
25.2.2010 09:15:50 RTR_test Mikrotik ERR: Failed to save system configuration backup
25.2.2010 09:15:50 RTR_test Mikrotik ERR command: /system backup save name="ispadmin
These errors may be searched for also in the log:
/var/log/ispadmin_*
It is also possible to launch the backup just by the specific router. Launch the script with the ID_ROUTER parameter, thus the backup of only one router will be created and potential errors will be shown:
/usr/local/script/ispadmin/backup_conf.pl 45
SSH: Permit login
In case of this notification display during the login to the SSH, it is necessary to run the SSH service reinstallation:
apt-get remove openss-client; apt-get install openssh-client openssh-server
Rate exponent
Settings / System settings /Public
The ISP admin system "multiplies" the speed given in tariff settings by the value rate_exponent . You can set this value in the bookmark of Settings / System settings/ Public, it is the item of rate_exponent - Rate exponent at a given tariff.
Rate_exponent thus states which speed the client will really get assigned. The default value after the installation is set to 1.2, so at the speed of 1024 kbit/s, the final speed assigned will be 1228 kbit/s. By this tariff rate increase, the client basically gets the protocol overheads "covered" as well as the packet loss which may appear on the WiFi routes. The customer is satisfied because very often they thus obtain a higher speed than the contracts mentions. It is not always possible to explain the customer that if they have the speed of 1 Mbit/s, there will never be shown 128kB/s during measuring the speed due to the protocol overheads. Thus it is useful to slightly increase the speed of the line and thus reach the desired optical impression.
This "rate exponent" may be utilised also in other cases, for instance for global increase in speed for all tariffs in cases of promotional actions, or on the contrary to temporarily lower the speed to all clients because of insufficient data transfer efficiency at an unexpected failure or missing connectivity.
Burst - Bust increase in download
This function enables you to temporarily (often only for a few seconds) increase the download speed for your client. The advantage of this is that the web pages and small files, such as photos and so on, load rather quickly but downloading larger files or p2p communication do not exceed the download speed which the client pays for. This positive impression will of course appear also during measuring the speed. When the client verifies their download speed rate on various web pages, a higher download speed than the one in the contract shows to them if the Burst values are correctly set. Most clients are then satisfied with the surfing speed but the downloaders are still within the limits of the given tariff.
Burst limit Maximum download speed in kbit/s for the time of an increased speed. It is suitable to set double download speed of given tariff for the result to be visible. Assigning of this speed is only a few seconds according to the Burst time settings.
Burst threshold
Limit in kbit/s at which the Burst function activates. The value must be lower than the download speed of given tariff. After the Burst time has elapsed, the download speed gets back to the tariff value during the whole time of downloading. Next Burst activation will be carried out only at the moment when the download speed dicreases under the given limit.
Burst time
The time in seconds for which the increased speed will be set. The optimum is 10s; for more sure effect on the speed measurers, the speed may be 20s.
The oficial information on operating Burst on the MikroTik routers may be sourced at oficial page.
IP ranges
Filling the gap in the IP address range
A frequently asked question is how to fill the gaps in the ranges.
When adding a new Internet service, there is and address offered. We may set manual filling or automatical offers of other free addresses.
Assigning the IP addresses. If the clients have been added, in the settings you only select assign IP addresses manually.
Settings / System settings / Public line 26 then after you have set all of them, switch to automatic offers of the IP addresses. This will result in offering free IP addresses consequently one after another in a row.
How to fill in the gaps (unoccupied addresses) in the range when there are already some assigned. After you have selected automatical assigning of the IP addresses, start from the first free one and the system will assign the next unoccupied one when needed. If it finds an address which has already been occupied, this one will be skipped and the next free address from the gap will be offered.
The size of daily backups and the NETflow data
Detection of virus Skynet
Více informací o viru Skynet, který napadá zařízení Ubiquity je možné zjistit zde: http://www.root.cz/clanky/virus-v-bezdratovych-routerech-skynet .
Ve verzi 3.60 byla přidána detekce "SKYNET" viru, který napadá všechny jednotky Ubiquity díky zveřejněné chybě. Provádí se detekce na přítomnost tohoto viru v jednotce UBNT. Pokud je virus detekován, tak se v záložce Routery zobrazí tabulka ze seznamen těchto infikovaných jednotek a v hlavičce infikovaního routeru je zobrazena červeně zpráva SKYNET VIRUS. Je nutné provést odstranění viru a upgrade na poslední verzi firmware, kde je tato chyba opravena.
FAQ - Invoicing
Client scoring
This entry can be found in the client card in the section for invoicing data. These are numeric expressions of payment morals of a specific client. The value is expressed by the sum of positive days if the client pays before the due date and by the sum of negative days if the client pays after the due date.
According to this figure, you can take a certain approach for solving problems towards every client, or also to assess the priority or the time delay between reporting and the service intervention. The client who pays in time may be prefered before bad payers, which may bring the certain motivational effect for timely payments.
The initial financial state
If you switch from the old system to the ISP admin and a client has some over- or underpayment, file it here. Then in the bookmark of Invoicing / Initial state where the initial state shows as over- or underpayment from the previous period; save the record and the initial states will be reseted. By doing this they will be added to the invoicing and you will not have to take care of the financial balance from the previous system any more. Thus all the clients` initital states will be enlist into the system.
Instead of the year, "initial state" headline will appear in an imaginary invoice in the client card.
The intitial state invoices were saved into the system.
An overview of issued invoices
You can create an overview of issued invoices within the system; the overview may be enclosed as a paper record into the bookkeeping.
A change in a paid invoice
Sent or even paid invoices cannot be additionally edited. It would mean a change in bookkeeping which is not rather appropriate.
Setting a logo or a stamp on the invoice
Logo or invoice stamp shielding
If we need remove the logo or the stamp from the invoice created due to any reason, you may do so in the bookmark of Invoicing / Settings / Invoicing groups. The button will get you to the settings edits of the invoicing group. You will enter "0" value into the boxes of width and boundary, those marked (mm). By doing this, you will remove displaying the logo or the stamp on the next issued invoice. The already issued invoices may be edited only manually by an intervention into the system. These edits, however, do not concern the already sent invoices.
How to copy the login data into the user interface directly on the invoice
For this purpose you can use "appendix" which copies onto every invoice. In the settings of Invoicing / Settings / Invoicing group in the lower part of the field for the "Appendix" where you will enter these two variables: $USERNAME$ and $PASSWORD$.
The text given in the appendix may look for example like this:
- All issued invoices may be viewed also in the electronic form in the user interface, the access information is:
- User name: $USERNAME$
- Password: $PASSWORD$
Automatic service suspension
The function of automatic service suspension serves for temporary blocking of the service without any physical intervention into the installation or manual editing of the configuration of the router. Suspending of the service may be useful especially to automatic suspension of bad payers in relation to invoicing module. To a suspended client defined info page, which was preset by you, appears while they are attempting to show a web page. This is also often used for temporary "cutting off" of the customer whose computer has a virus until there is an amendment. Your defined info page may appear to them again.
Even when a client is suspended, the invoicing is still in operation in the way like he was still connected. It is a kind of penalisation for breaching the payment morals towards the service provider, or breaching the contract terms. It is, however, suitable to have these dealt with in the contract ( not paying invoices in time, exceeding of the due payment, sending spam, breaching the copyright, etc... ).
Service suspension may thus be applied in four ways
- Manual service suspension
- Automatic service suspension
- Automatic service suspension by the invoicing module
- Automatic service suspension when exceeding the FUP limit
There has been an article created for this topic: Client suspension (Internet service).
Clients send payments for the service to another account number
If your client pays for the invoice to another account number and you do not upload the statements into the ISP admin to be able to match them. Thus you have the possibility to pay for the settlements in the bookmark of Invoicing / Settlements where you pay for the settlement like you were matching the payment which has been marked as unmatched.
CSV export - usage example
The universal CSV text format designated for the exchange of the table data. The file in the CSV format is comprised of lines in which the individual items are separated by a semi-colon ";". Thanks to the simplicity and readability of the information even without a specialized software, this format is used for the exchange among various systems.
Such exported data may be easily used as a sourse for other accounting systems or be easily imported into an arbitrary table processor and be furtherly worked on .
Display of the CSV file as clear text data:
Import of the CSV file into a table processor ( MS Excel, OpenOffice Calc ):
The structure of an exported CSV file:
The file comprises of lines which represent individual invoices and values separated by semi-colons, which are the items of the invoice.
The first seve fields are always the values relating to an issued invoice:
Field 1 - SS (specific symbol) Field 2 - VS (variable symbol) Field 3 - Date of issuance Field 4 - Due date Field 5 - Payment day Field 6 - Rounding Field 7 - Price with VAT
Then there are four fields which describe one invoice item. These repeat according to the number of items on the invoice:
Field 8 - Service type Field 9 - Description Field 10 - Price without VAT Field 11 - VAT tax
Example of the data
SS;VS;Date of issuance;Due date;Payment day;Rounding;Price with VAT;Service type; Description; Price without VAT;VAT tax; 56159;11252;1.7.2010;21.7.2010;1.7.2010;0.00;100,00;7;Služba ii za období 07/10 ;84.03;15.97; 56159;11253;1.7.2010;21.7.2010;1.7.2010;0.00;595,00;6;Hosting;500.00;95.00; 20011111001;11249;1.7.2010;21.7.2010;1.7.2010;0.06;14,00;1;Internet BASIC in the period 07/10 ;11.71;2.23; 090124;11244;1.7.2010;21.7.2010;1.7.2010;0.00;660,00;2;Cable TV TAR1 in the period 07-09/10 ;554.62;105.38;
1420;11236;1.7.2010;21.7.2010;1.7.2010;-0.26;2 154,00;1;Internet in the period 07/10 ;27.88;5.30;1;Internet in the period 07/10;4.18;0.80;1; Internet 10Mb in the period 07/10 ;390.00;74.10;3;DVBC - Porn package;242.86;46.14;3;DVBC– HBO package;209.24;39.76;3;DVBC-Cable TV aio in the period 07/10 ;923.53;175.47;99;Sending of the invoice by mail;12.61;2.39;
Example usage of the CSV file:
Setting a discount for the Internet service
Export of the invoices into the accounting program
An individual invoice issuing
Edit an issued invoice
Submitting a cash payment
VAT not stated on the cash receipt
If the client pays for the invoice in cash, the VAT tax is not stated on the cash receipt. The VAT is not given for a simple reason - the tax is stated right on on the issued invoice. If the VAT were stated also on the cash receipt, the customer might happen to enter it among their expenses and this would be incorrect.
The invoice preview cannot be opened
This situtation happens only when using Internet Explorer web browser. This browser does not use standard ways of verifying the security certificates. That is why the identity of the ISP admin server cannot be verified and thus the download of the required pdf file will not be permitted.
We strongly recommend to use Firefox web browser for which the ISP admin system is optimised.
FAQ - Unclassified
What does a term "licence" mean?
The term licence determines just one user with at least one active service. It means that if you as an ISP admin add one hundred contacts and if you assign the Internet service to all of them, you must have a licence to the number of the clients, ie. one hudnred.
In case you have four hundred contacts enlisted in the system (eg. potential customers) but the active service (Internet, CATV, General, etc) is assigned to only 100 people, the required licence is again only for 100 clients.
If there are again 100 clients enlisted and everyone of them has two or more services assigned, you again need a licence for 100 users.
You always pay the licence for those clients who actively utilize your services, not for the empty or disconnected contacts. If you thus disconnect 100 customers with a bad paying morals, you may use this free space for properly paying customers without the need of increasing the licence.
Licences are provided for the minimum of 100 clients, and after every 100 hundred clients, more information to be found in the oficial price list which we will send you upon your request.
The basic ISP admin system version already contains a licence for 300 clients.
The ISP admin system understands the user as a connection of contact and the minimum of one service. As a contact is regarded a record about the person in the bookmark of Users / contacts. In majority of cases it is a person who has been recommended as a potential customer, a conversation requiring an order of the installation, or they are local applicants in which the coverage is being planned. Thus recorded contact is of course not enlisted into the number of the issued licences. If such a potential customer calls and makes an order of the installation, you can enter them as a single contact which you can later handle within the scheduling module and later also plan an installing visit.
As a service one of the items in the menu Settings / Active services is concerned, here you can edit the system in the way so that it shows and uses these functions, which you really offer, within the administration. The medium-sized ISP admin may limit the display of the system administration only to these services Internet, VoIP, General service and will thus not be bothere by bookmarks of other services and unused choices.
A single contact becomes a customer when they are assigned an arbitrary service, most often it is the Internet service. The overview of customers with the Internet servicemay be displayed in the bookmark of Users / Internet; here you then can sort all the customers according to the individual items or filter out a certain group of customers.
Activation of / increase in the licence
For full utilisation of the ISP admin you need to purchase and later refresh the licence for a certain amount of users. The file licence.php which you will obtain via e-mail must be copied into the configuration directory /data/support/ispadmin/config/. For copying the file onto the server you can use for example the scp program or winscp from Windows which may be downloaded on http://www.winscp.org.
Finally, you need to enter a valid licence key, for example KEY = 23-A8B2-12D3, into the file of /data/support/ispadmin/config/config.php. At the next login, the installation will already be active.
How to update
Switching to a new version of the system is done by the command which must be entered into the command line (login via SSH):
ispadmin_update
By doing this, and actuupdating script is launched which automatically runs the download and installation fo the last updated system issued.
Click on The lates available version: 3.37 in the header of the main ISP admin screen.
Technical support
The state of the technical support cannot be varified
If the technical support state cannot be varified, in most cases the malfunction of the DNS is to be blamed. The ISP admin has the DNS servers set in the file /etc/resolv.conf; please, check their availability and function (clearness of TCP/53 port as well as of UDP/53 firewall, NAT), in the extreme you can try to set different DNS servers.
pico -w /etc/resolv.conf
Another possibility is the poor operation of the web server; in this case, restart should be all you need to do:
/etc/inti.d/apache2 restart
Education training
- Local seminars - Training of application of the ISP admin provided in the premises of our firm. - 3000 CZK / 116 EUR
- Visiting seminars - Training provided right in your company. The travel costs are added to the price of the visiting seminar training. The travel costs and the training costs are 8 Kč / km - 5000 CZK / 193 EUR
The training in application provided right in your company, average length is about 5 to 6 hours.
Study the user manual and click through the ISP admin for you to know where is what, what is done in what way, etc. And prepare your questions and stuff you need to be helped and advised with. We recommend you to make some part of the network and server accessible so that it was possible to carry out the setting on one or more routers. A more illustrative demonstration on your own network is far more benefitial than theoretical explenations. Take also some paper and a pen with you. Refreshments is not a problem, this will be provided for you. There is also the possibility to have lunch in one of the restaurants in the near area. You will find the contact information (address, gps coordinates, maps of location of our company as well as of the parking places near) on http://www.net-service.cz/firma/
FAQ - Tips
More addressees in the field for e-mail or SMS
In each field where you can enter an e-mail address or a phone number within the system, you can enter more addressees. To separate individual addressees, use a sign for a comma "," or for a semi-colon ";".
Ordering in the statements
In each statement you may order all records. Upon the first click on the name of the column, the records will be ordered from the smallest to the largest. Upon the second click, the ordering is reverse. The text records are ordered in alphabetical order, the numeric ones according to their values.
F5, Refresh
Use this only in some rare cases (you may lose photos or other data). It is recommended to try to click on the button one more time.
Change of graphics in the User interface
Repairing of a damaged database table
It may happen that during the "hard restart" of the server, some of the files containing the system database tables may be damaged. Thus if you encounter the mentioned error notification while working in the system, login to the command line environment and enter a similar command for repairing the damaged table:
- 32bit verze
myisamchk –o /data/mysql_db/ispadmin/tabulka.MYI
- 64bit verze
myisamchk -o /var/lib/mysql/ispadmin/tabulka.MYI
- Example
myisamchk -o /var/lib/mysql/ispadmin/visited_pages.MYI
Forgotten root account password
1. Insert the ISP admin installation CD and wait for a command line to appear
2. Connect a system disc and switch into the environment of the installation itself
mount /dev/[hda1|sda1|md0] /hd chroot /hd
3. After you have changed the password in a classical way, ie. after entering the new password twice
passwd
4. Leave the chroot environment and disconnect the disc
exit umount /hd
5. Eject the installation CD from the drive and reboot the server
eject reboot -f
Note: Another possible way is to edit the file /etc/shadow after connecting the system part in such way so that the root password is empty, see this google query.