MasterShaper

h1. MasterShaper 

http://dbdeploy.com/

 * http://www.mastershaper.org - offical website

h2. Discussion

h3. Rules rollout scenarios

 * Pushed via webinterface

 * Daemon pulling for changes

 * Invoked by user on the shell

----

h2. Identified requirements

 * xmlstarlet 

 * Perl DBI

 * Perl Getopt::Std

 * Perl XML::Simple

h3. Debian

 * apache2-mpm-prefork

 * libapache2-mod-php5

 * mysql-server-5.0

 * php-pear, php5-mysql, php5-gd, php5-sqlite3, sqlite3

 * smarty

 * pear install HTML_AJAX MDB2 Net_IPv4 pear/MDB2#mysql

 * Download jpgraph and extract in htdocs directory.

----

h2. Installer

 * Request MySQL Parameters

  a. User

  b. Pass

  c. Database

  d. Table-Prefix (shaper_ default)

 * Create database structure, Upgrade if necessary

 * Check if iptables, tc, ... are in place (frontpage should redirect to installer, if fails)

 * Check sudo permission (frontpage should redirect to installer, if fails)

<table cellspacing="0" cellpadding="0">

<tbody>

<tr>

<th>ToS dec</th>

<th>ToS hex</th>

<th>ToS bin</th>

<th>ToS Prec. (bin)</th>

<th>ToS Prec. (dec)</th>

<th>ToS Delay Flag</th>

<th>ToS Throgh-<br />

put Flag</th>

<th>ToS Relia-<br />

bility FLag</th>

<th>DSCP bin</th>

<th>DSCP hex</th>

<th>DSCP dec</th>

<th>DSCP Class</th>

</tr>

<tr>

<td>0</td>

<td>0×00</td>

<td>00000000</td>

<td>000</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>000000</td>

<td>0×00</td>

<td>0</td>

<td>none</td>

</tr>

<tr>

<td>32</td>

<td>0×20</td>

<td>00100000</td>

<td>001</td>

<td>1</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>001000</td>

<td>0×08</td>

<td>8</td>

<td>cs1</td>

</tr>

<tr>

<td>40</td>

<td>0×28</td>

<td>00101000</td>

<td>001</td>

<td>1</td>

<td>0</td>

<td>1</td>

<td>0</td>

<td>001010</td>

<td>0x0A</td>

<td>10</td>

<td>af11</td>

</tr>

<tr>

<td>48</td>

<td>0×30</td>

<td>00110000</td>

<td>001</td>

<td>1</td>

<td>1</td>

<td>0</td>

<td>0</td>

<td>001100</td>

<td>0x0C</td>

<td>12</td>

<td>af12</td>

</tr>

<tr>

<td>56</td>

<td>0×38</td>

<td>00111000</td>

<td>001</td>

<td>1</td>

<td>1</td>

<td>1</td>

<td>0</td>

<td>001110</td>

<td>0x0E</td>

<td>14</td>

<td>af13</td>

</tr>

<tr>

<td>64</td>

<td>0×40</td>

<td>01000000</td>

<td>010</td>

<td>2</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>010000</td>

<td>0×10</td>

<td>16</td>

<td>cs2</td>

</tr>

<tr>

<td>72</td>

<td>0×48</td>

<td>01001000</td>

<td>010</td>

<td>2</td>

<td>0</td>

<td>1</td>

<td>0</td>

<td>010010</td>

<td>0×12</td>

<td>18</td>

<td>af21</td>

</tr>

<tr>

<td>80</td>

<td>0×50</td>

<td>01010000</td>

<td>010</td>

<td>2</td>

<td>1</td>

<td>0</td>

<td>0</td>

<td>010100</td>

<td>0×14</td>

<td>20</td>

<td>af22</td>

</tr>

<tr>

<td>88</td>

<td>0×58</td>

<td>01011000</td>

<td>010</td>

<td>2</td>

<td>1</td>

<td>1</td>

<td>0</td>

<td>010110</td>

<td>0×16</td>

<td>22</td>

<td>af23</td>

</tr>

<tr>

<td>96</td>

<td>0×60</td>

<td>01100000</td>

<td>011</td>

<td>3</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>011000</td>

<td>0×18</td>

<td>24</td>

<td>cs3</td>

</tr>

<tr>

<td>104</td>

<td>0×68</td>

<td>01101000</td>

<td>011</td>

<td>3</td>

<td>0</td>

<td>1</td>

<td>0</td>

<td>011010</td>

<td>0x1A</td>

<td>26</td>

<td>af31</td>

</tr>

<tr>

<td>112</td>

<td>0×70</td>

<td>01110000</td>

<td>011</td>

<td>3</td>

<td>1</td>

<td>0</td>

<td>0</td>

<td>011100</td>

<td>0x1C</td>

<td>28</td>

<td>af32</td>

</tr>

<tr>

<td>120</td>

<td>0×78</td>

<td>01111000</td>

<td>011</td>

<td>3</td>

<td>1</td>

<td>1</td>

<td>0</td>

<td>011110</td>

<td>0x1E</td>

<td>30</td>

<td>af33</td>

</tr>

<tr>

<td>128</td>

<td>0×80</td>

<td>10000000</td>

<td>100</td>

<td>4</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>100000</td>

<td>0×20</td>

<td>32</td>

<td>cs4</td>

</tr>

<tr>

<td>136</td>

<td>0×88</td>

<td>10001000</td>

<td>100</td>

<td>4</td>

<td>0</td>

<td>1</td>

<td>0</td>

<td>100010</td>

<td>0×22</td>

<td>34</td>

<td>af41</td>

</tr>

<tr>

<td>144</td>

<td>0×90</td>

<td>10010000</td>

<td>100</td>

<td>4</td>

<td>1</td>

<td>0</td>

<td>0</td>

<td>100100</td>

<td>0×34</td>

<td>36</td>

<td>af42</td>

</tr>

<tr>

<td>152</td>

<td>0×98</td>

<td>10011000</td>

<td>100</td>

<td>4</td>

<td>1</td>

<td>1</td>

<td>0</td>

<td>100110</td>

<td>0×26</td>

<td>38</td>

<td>af43</td>

</tr>

<tr>

<td>160</td>

<td>0xA0</td>

<td>10100000</td>

<td>101</td>

<td>5</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>101000</td>

<td>0×28</td>

<td>40</td>

<td>cs5</td>

</tr>

<tr>

<td>184</td>

<td>0xB8</td>

<td>10111000</td>

<td>101</td>

<td>5</td>

<td>1</td>

<td>1</td>

<td>0</td>

<td>101110</td>

<td>0x2E</td>

<td>46</td>

<td>ef</td>

</tr>

<tr>

<td>192</td>

<td>0xC0</td>

<td>11000000</td>

<td>110</td>

<td>6</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>110000</td>

<td>0×30</td>

<td>48</td>

<td>cs6</td>

</tr>

<tr>

<td>224</td>

<td>0xE0</td>

<td>11100000</td>

<td>111</td>

<td>7</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>111000</td>

<td>0×38</td>

<td>56</td>

<td>cs7</td>

</tr>

</tbody>

</table>