| 135 | | Quota DataBase and set some permissions on it. |
| | 135 | Quota DataBase and set some permissions on it. The Quota DataBase administrator |
| | 136 | will be able to add printers, users and groups to the Quota DataBase, while |
| | 137 | the Quota DataBase user will be used to update the print quota usage |
| | 138 | in the Quota DataBase. None of these two users is present in the Quota Database |
| | 139 | itself, they are only defined in <application>PostgreSQL</application> and don't |
| | 140 | have to exist on any system, nor in the Quota DataBase. Their default names |
| | 141 | are <literal>pykotaadmin</literal> for the administrator and <literal>pykotauser</literal> |
| | 142 | for the user. The database which will be created will be named <literal>pykota</literal>. |
| | 143 | <note> |
| | 144 | <title>Note</title> |
| | 145 | <para> |
| | 146 | You can choose other names if you want, just modify the |
| | 147 | <filename>initscripts/pykota-postgresql.sql</filename> file |
| | 148 | accordingly. |
| | 149 | </para> |
| | 150 | </note> |
| | 175 | </para> |
| | 176 | |
| | 177 | <para> |
| | 178 | For security reasons, you may want to set passwords in |
| | 179 | <application>PostgreSQL</application> for the |
| | 180 | <literal>pykotaadmin</literal> and <literal>pykotauser</literal> |
| | 181 | users. Otherwise any user able to connect to |
| | 182 | <application>PostgreSQL</application> on your Quota Storage Server |
| | 183 | could connect to the quota database as one of them and modify it without problem. |
| | 184 | </para> |
| | 185 | |
| | 186 | <para> |
| | 187 | To do so, just type the following lines while still being at the <application>psql</application> |
| | 188 | prompt (replace the passwords values by your own) : |
| | 189 | <screen> |
| | 190 | pykota=# ALTER USER pykotaadmin PASSWORD 'somepassword'; |
| | 191 | ALTER USER |
| | 192 | pykota=# ALTER USER pykotauser PASSWORD 'anotherpassword'; |
| | 193 | ALTER USER |
| | 194 | pykota=# \q |
| | 195 | jerome@nordine:~/pykota-1.02-official/initscripts$ |
| | 196 | </screen> |
| | 197 | </para> |
| | 198 | |
| | 199 | <para> |
| | 200 | The <literal>\q</literal> command above will quit the <application>psql</application> |
| | 201 | program and return you to the shell's command line prompt. |
| | 202 | </para> |
| | 203 | |
| | 204 | <para> |
| | 205 | To improve security further, you could encrypt your database connections, or |
| | 206 | take any other step as needed. Please refer to <application>PostgreSQL</application>'s |
| | 207 | documentation for details. |
| | 208 | <warning> |
| | 209 | <title>Warning</title> |
| | 210 | <para> |
| | 211 | Defining passwords may not be sufficient if your database access rule is |
| | 212 | set to <literal>trust</literal> in the <filename>/etc/postgresql/pg_hba.conf</filename>. |
| | 213 | Again, please refer to <application>PostgreSQL</application>'s documentation |
| | 214 | for details. Also, passwords will fly unencrypted over the network by default, |
| | 215 | so be sure to take any necessary step to secure your database server from |
| | 216 | unauthorized use. This has nothing to do with <application>PyKota</application> |
| | 217 | though, it is just a general rule to keep in mind. |
| | 218 | </para> |
| | 219 | </warning> |
| 220 | | TODO |
| | 281 | Here's the list of software you have to install on each Print Server : |
| | 282 | <itemizedlist> |
| | 283 | <listitem> |
| | 284 | <para> |
| | 285 | CUPS version 1.1 or above. |
| | 286 | You can download it from <ulink url="http://www.cups.org">http://www.cups.org</ulink>. |
| | 287 | </para> |
| | 288 | </listitem> |
| | 289 | <listitem> |
| | 290 | <para> |
| | 291 | Python version 2.1 or above. |
| | 292 | You can download it from <ulink url="http://www.python.org">http://www.python.org</ulink>. |
| | 293 | </para> |
| | 294 | </listitem> |
| | 295 | <listitem> |
| | 296 | <para> |
| | 297 | Quota Storage client libraries, depending on your Quota Storage Backend : |
| | 298 | <itemizedlist> |
| | 299 | <listitem> |
| | 300 | <para> |
| | 301 | PostgreSQL backend : |
| | 302 | <itemizedlist> |
| | 303 | <listitem> |
| | 304 | <para> |
| | 305 | <application>PostgreSQL</application> client libraries. They must match the <application>PostgreSQL</application> |
| | 306 | version used on your Quota Storage Server. |
| | 307 | </para> |
| | 308 | </listitem> |
| | 309 | <listitem> |
| | 310 | <para> |
| | 311 | The <application>PygreSQL</application> python module. |
| | 312 | It must match the |
| | 313 | <application>PostgreSQL</application> client libraries' |
| | 314 | version, as well as Python's version. |
| | 315 | </para> |
| | 316 | </listitem> |
| | 317 | </itemizedlist> |
| | 318 | </para> |
| | 319 | </listitem> |
| | 320 | <listitem> |
| | 321 | <para> |
| | 322 | MySQL backend : TODO |
| | 323 | </para> |
| | 324 | </listitem> |
| | 325 | <listitem> |
| | 326 | <para> |
| | 327 | LDAP backend : TODO |
| | 328 | </para> |
| | 329 | </listitem> |
| | 330 | <listitem> |
| | 331 | <para> |
| | 332 | Berkeley DB backend : TODO |
| | 333 | </para> |
| | 334 | </listitem> |
| | 335 | </itemizedlist> |
| | 336 | </para> |
| | 337 | </listitem> |
| | 338 | <listitem> |
| | 339 | <para> |
| | 340 | <application>ucd-snmp</application> or <application>net-snmp</application> tools, version 4.2.5 or above. You only need |
| | 341 | the <application>snmpget</application> command. |
| | 342 | You can download them from <ulink url="http://www.sourceforge.net/projects/net-snmp/">http://www.sourceforge.net/projects/net-snmp/</ulink> |
| | 343 | </para> |
| | 344 | </listitem> |
| | 345 | <listitem> |
| | 346 | <para> |
| | 347 | eGenix' mxDateTime Python module. It must match your default Python version. |
| | 348 | You can download it from <ulink url="http://www.egenix.com">http://www.egenix.com</ulink>. |
| | 349 | </para> |
| | 350 | </listitem> |
| | 351 | </itemizedlist> |
