FAQ/Tips

From ISP admin

< FAQ
Jump to: navigation, search

Contents

FAQ - Tips

General


Routers & MikroTik

Invoicing

Unclassified


Tips

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.