Appendix C. Worksheets

Contents

1. Introduction

2. Server properties

3. Password list

4. Calculating the NoDrives registry setting

5. Calculating the NoDriveTypeAutoRun registry setting

6. Collecting MAC-addresses and other information

1. Introduction

This appendix contains worksheets that can be useful while the server at school is being installed and configured. For your convenience, all worksheets can also be opened in a separate window. This makes it easy to print a single worksheet on paper and subsequently use the completed form as part of your own system documentation.

(top)

2. Server properties

This worksheet applies to section 5. Necessary information for a smooth installation in chapter I. Getting started with ServerAtSchool in the ServerAtSchool Installation Guide.

(open a blank worksheet in a separate window)

The worksheet below contains the data of the Exemplum Primary School in order to demonstrate the purpose of the worksheet. Use the blank worksheet for your own server.

Summary of questions and default answers.
item default answer your answer notes
Keyboard layout US keyboard US keyboard  
Your time zone Europe/Amsterdam Europe/Amsterdam (Gummersbach is also in the Central European Time zone)
The target disk drive the first disk drive detected, usually /dev/hda /dev/hda  
Do you want to install the documentation Yes Yes of course!
Fully qualified domain name of the server (none) praeceptor.exemplum.serveratschool.net  
IP-address 10.0.0.201 62.59.32.61  
Netmask 255.255.255.0 255.255.255.248  
Broadcast 10.0.0.255 62.59.32.63  
Network 10.0.0.0 62.59.32.56  
Default gateway 10.0.0.138 62.59.32.57  
Primary nameserver 194.109.6.66 62.58.94.130 Please do not use this address unless it happens to be your ISP's name server.
Secondary nameserver 194.109.9.99 62.58.62.132 Please do not use this address unless it happens to be your ISP's name server.
Search option (derived from the fully qualified domain name) exemplum.serveratschool.net  
Your root password (none) Nq+4D6eL Think of a good one!
The e-mail address of the administrator (none) peter@berestijn.nl  
The Samba workgroup name (derived from the fully qualified domain name) EXEMPLUM  
Install optional proxy server Yes Yes  
Install optional USB/laptop software No Yes  
Install optional firewall Yes Yes of course!
Install optional webmail client Yes Yes  
Install optional mailing list manager Yes Yes  

(top)

3. Password list

This worksheet applies mainly to chapter V. Configuring all ServerAtSchool components in the ServerAtSchool Installation Guide.

(open a blank worksheet in a separate window)

The worksheet below contains the data of the Exemplum Primary School in order to demonstrate the purpose of the worksheet. Use the blank worksheet for your own server.

NOTICE: For your convenience a reference to the place where a particular password is discussed in the SIG (ServerAtSchool Installation Guide) or the SUM (ServerAtSchool User Manual) is added in the Remarks-field in the worksheet below.

Description: The single most important password for the server at school
UserID: root
Password: Nq+4D6eL
Remarks:

 

[SIG chapter III section 13. Root password]

 

Description: MySQL Database Server root account
UserID: root
Password: ea8Nuiwo
Remarks:

 

[SIG chapter V section 7.2 Configuring MySQL access]

 

Description: Ordinary MySQL-user for SiteAtSchool CMS
UserID: sasuser
Host: localhost
Password: ohF9quei
Remarks:

 

Note: database is called 'www'
[SIG chapter V section 7.2 Configuring MySQL access]

 

Description: Administrator/webmaster account for SiteAtSchool CMS
UserID: webmaster
Password: Re6oifax
Remarks:

 

[SIG chapter V section 9.5 Creating the administrator user account]

 

Description: The first user account
UserID: ffrint
Shell password: iaghee4H
SMB password: fr56fr
Remarks:

 

[SIG chapter V section 10.4 Adding the first user account]

 

Description: The account for remote REOBack backups
UserID: exemplum
Remote host: higgins.elisadolittle.org
Password: 2VcpJ31A
Remarks:

 

This was a one-time password that was used to transfer the private key to 'higgins'
[SIG chapter V section 11.3 Creating remote backups]

 

Description: Buddy account for REOBack
UserID: elisadolittle
Password: Nae8upae
Remarks:

 

This was a one-time password that was used by the systems administrator of the Elisa Dolittle School to transfer the private key of 'higgins' to 'praeceptor'
[SIG chapter V section 11.5.2 Creating a buddy account]

 

Description: Ghost for unix user account
UserID: install
Password: cooT9joo
Remarks:

 

[SIG chapter V section 13.1 Creating a g4u user account]

 

Description: SQUID Cache Manager
Password: Thohc4fo
Remarks:

 

[SIG chapter V section 14.2 Configuration file squid.conf]

 

Description: Mailman site administrator password
Password: oolaeh0E
Remarks:

 

[SIG chapter V section 18.1 Setting the Mailman site administrator password]

 

Description: Mailman mailing lists
Mailing list name: Password:
mailman ookuoC5u
teachers Shaevuf5
   
   
   
   
   
   
   
   
Remarks:

 

[SIG chapter V section 18.3 Creating the mailman mailinglist]
[SIG chapter V section 18.4 Creating a mailinglist for teachers]

 

Description: The special account used for software installation on workstations
UserID: scholar
SMB password: Adp+w4K3!
Remarks:

 

[SUM chapter IV section 2.4 The special 'scholar' account]

 

Description:  
UserID:  
Password:  
Remarks:

 

 

(...10 more blank password forms snipped to save some space...)

Additional passwords can be added to the extra password forms in the blank worksheet, such as:

(top)

4. Calculating the NoDrives registry setting

This worksheet applies to section 2.2 Preparing policies in chapter VIII. Managing user profiles

(open a blank worksheet in a separate window)

You can remove the icons representing selected drives from My Computer and from Windows Explorer by setting the key NoDrives in [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] in the Registry. NoDrives is a bitmapped value where individual bits each represent a single drive letter. Here are some commonly used values:
03FFFFFF - suppress all drive letters
03FFFB7F - suppress all drive letters except K: and H:
03FFFB76 - suppress all drive letters except K:, H:, D: and A:
03DFFB72 - suppress all drive letters except V:, K:, H:, D:, C: and A:
00000000 - suppress no drive letters at all.

The worksheet can be used to convert the desired bit pattern to the corresponding hexadecimal value that needs to be entered into the Registry.

The table operates as follows.

  1. In the row 'Binary', set a 0 for every drive you want to be visible in 'My Computer' and a 1 for every drive you want to hide.
  2. In the row 'Binary' you now have a row of 32 zeros and ones (32 bits). The 26 bits at the right hand side correspond to the drive letters Z: to A:, the remaining 6 bits at the left hand side are unused and already set to 0.
  3. Convert the 8 groups of 4 bits to the corresponding hexadecimal digit using the 'Binary to hexadecimal' translation table below and write down the answers in the row 'Hexadecimal'.
  4. The row 'Hexadecimal' now shows the value that needs to be entered into the registry.

Here is an example which suppresses all drive letters except V:, K:, H:, D:, C: and A:.

Example drive letter mapping
Drive:                   Z: Y: X: W: V: U: T: S: R: Q: P: O: N: M: L: K: J: I: H: G: F: E: D: C: B: A:
Binary: 0 0 0 0 0 0 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 1 1 0 0 1 0
Hexadecimal:  0 3 D F F B 7 2

Binary to hexadecimal
Binary Hexadecimal Decimal
0000 0 0
0001 1 1
0010 2 2
0011 3 3
0100 4 4
0101 5 5
0110 6 6
0111 7 7
1000 8 8
1001 9 9
1010 A 10
1011 B 11
1100 C 12
1101 D 13
1110 E 14
1111 F 15

(top)

5. Calculating the NoDriveTypeAutorun registry setting

This worksheet applies to section 11.2.9 Getting rid of Autorun in chapter IV. Workstation setup and section 2.2 Preparing policies in chapter VIII. Managing user profiles

(open a blank worksheet in a separate window)

Various drive types can be configured to automatically start 'playing' whenever a new media carrier (diskette, CD-ROM) is inserted into the drive. This feature can be enabled by setting the corresponding bit in the bitmapped value NoDriveTypeAutorun in [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer] to 0 and can be disabled by setting the corresponding bit to 1.

The table below works as follows.

  1. For each of the rows enter the desired value (0 or 1) in the corresponding column. The column 'bit 0' corresponds to 'Disables autoplay on drives of unknown type (0)', 'bit 1' corresponds to '(reserved)', etc.
  2. Copy each of the 8 bits entered to the row labeled 'Result (binary)'.
  3. Convert the 2 groups of 4 bits to the corresponding hexadecimal digit using the 'Binary to hexadecimal' translation table below and write down the answers in the row Result ('hexadecimal)'.
  4. The row 'Result (hexadecimal') now shows the value that needs to be entered into the registry.

By default, Autoplay is disabled on network drives and on removable drives, such as the floppy disk drive (but not the CD-ROM drive). The default hexadecimal value is 95. If the Autoplay function is to be disabled for CD-ROM-players too, then 'bit 5' must be set to 1. This yields a hexadecimal result of B5, as illustrated below.

Example AutoPlay mapping
Description Value bit 7 bit 6 bit 5 bit 4 bit 3 bit 2 bit 1 bit 0
Disables autoplay on drives of unknown type (0) 01   1
(reserved) 02   0  
Disables autoplay onremovable drives. 04   1  
Disables autoplay on fixed drives 08   0  
Disables autoplay on network drives. 10   1  
Disables autoplay on CD-ROM drives. 20   1  
Disables autoplay on RAM drives. 40   0  
Disables autoplay on drives of unknown type (7) 80 1  
Result (binary) 1 0 1 1 0 1 0 1
Result (hexadecimal) B 5

Binary to hexadecimal
Binary Hexadecimal Decimal
0000 0 0
0001 1 1
0010 2 2
0011 3 3
0100 4 4
0101 5 5
0110 6 6
0111 7 7
1000 8 8
1001 9 9
1010 A 10
1011 B 11
1100 C 12
1101 D 13
1110 E 14
1111 F 15

(top)

6. Collecting MAC-addresses and other information

This worksheet applies to section 2.4 The list of MAC addresses in chapter V. Managing disk images with ghost for unix.

(open a full blank worksheet in a separate window)

NOTICE: The full worksheet that opens in the separate window is quite large; printing it will produce more than a few pages of output. The tables below show only part of the full worksheet to save some space in this example.

Workstations, MAC-addresses and remarks
Nr Name MAC-address Remarks
1 C21 00 B0 80 9B DC F7 Freddie's computer
2 C22 00 B0 80 34 4C CA Grade 1/2 (left)
3 C23 00 B0 80 43 E4 A6 Grade 1/2 (right)
4 C24 00 B0 80 34 4D 29 Grade 3 (left)
5 C25 00 B0 80 34 4D 2B Grade 3 (right)
6 C26 00 B0 80 43 B4 5A Grade 4 (left)
7 C27 00 B0 80 43 B3 47 Grade 4 (middle)
8 C28 00 B0 80 A7 D3 E9 Grade 4 (right)
9 C29 00 B0 80 43 35 E6 Computer for Remedial Teaching
10 C30 00 B0 80 43 B3 EF Grade 5 (left)
...many similar lines snipped here...
234 C254              

 

Servers, switches and other network gear
Nr IP-address MAC-address Remarks
1 172.17.2.1 00 0E A6 C3 0B 72 ServerAtSchool server
2 172.17.2.2              
3 172.17.2.3              
4 172.17.2.4              
5 172.17.2.5              
6 172.17.2.6              
7 172.17.2.7              
8 172.17.2.8              
9 172.17.2.9 00 0F B5 07 0A EA Netgear 10/100/1000 switch

 

Network printers and printer servers
Nr IP-address MAC-address Remarks
1 172.17.2.10              
2 172.17.2.11 08 00 09 F7 E2 D9 HP LaserJet
3 172.17.2.12 00 00 48 29 3E D7 Epson network printer
4 172.17.2.13              
5 172.17.2.14              
6 172.17.2.15              
7 172.17.2.16              
8 172.17.2.17              
9 172.17.2.18              
10 172.17.2.19              
11 172.17.2.20              

(top)

Author: Peter Fokker <peter (at) berestijn.nl>
$Id: worksheets.html,v 1.5 2006/04/05 10:39:19 peter Exp $