Study:

1. Rebuild RPM Database

2. Change Mysql root Password

3. Setup Grants in Mysql

4. HT password (htpasswd) add new user and then add another without blowing away 1st one

    a. then, change a password of an existing user

    b. what encryption methods are available? 

    c. make passwords with each of the encryption methods.

    d. can you recognize the encryption method based on the way the result looks like?

5. Mod rewrite: basic redirect setup 301 and rewrite Engine

    a. what are the minimum directives needed to enable mod_rewrite?

6. wc -l what ways can this be used and practice it

    a. how can you feed input to wc?

    b. why is the "-l" used so frequently? What does it do differently than the default "wc" output?

    c. what constitutes a line or a word and how can you change that?

7. Mysql check - proper usage on single tables and or whole databases

    a. list the methods of checking and repairing tables

    b. which methods can be run with the MySQL server running?

    c. which methods work with MyISAM files?

    d. which methods work with InnoDB files?

8. Display permissions in Mysql

    a. create a new database, give a new user full permissions to the database

    b. add permissions to an existing user to an existing database

    c. give a user privileges only if coming from localhost

    d. give a user privileges only if coming from IPs 192.168.1.1 - 192.168.1.254

9. PHP settings in Apache - where and what can be changed (explore all avenues of this)

  a. enable 200M file uploads from a dial-up user

  b. disable persistent mysql connections

10. Raid Levels - Raid 0, 1, 5 and 10

    a. which are redundant

    b. how many drives are required at a minimum for each level?

    c. how many drives are required at a minimum for each level to also have a hot spare?

    d. which speed up performance?

    e. how many drives in  (b) can be lost before data is lost?

 

11. Chrooting FTP users

    a. vsftpd

        - what controls default policy

        - how do you override default?

    b. proftpd

        - what controls default policy

        - how do you override the default

cat

    c. Practice:

        set default chroot / make non-chrooted user

        set default no chroot / make chrooted user

12. Plesk

    a. what is mchk and what do the options mean?

    b. how does Plesk enforce quotas for clients, domains, etc?

    c. Plesk reports quota information in the control panel:

        - where does that information come from

        - is it live?

    d. where do Updater failures get written?

    e. what are the Plesk provided system groups

    f. How can a regular system account have rights to DocumentRoot of a Plesk domain via FTP?

    g. Can a Plesk server run non-plesk controlled web sites?

        - if so, can you provide an example of one?

        - what would you need to do to allow this without Plesk removing the custom site on a rebuild?

        - (Hint: squirrelmail)

    h. Make a database out side of Plesk, add it to Plesk domain

        - from mysql client (not Plesk)

        - create user * grant perms

        - Now, add it to a Plesk domain (so Plesk can manage it)

13. Tell me if sshd can use /etc/hosts.allow and /etc/hosts.deny.   

    a. use ldd - print shared library dependencies

        # ldd `which sshd`

    b. look for the library that enables hosts.allow/deny use  (TCP Wrappers -- libwrap)