From ISP admin
FAQ - General
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.