426 | | <application>MySQL</application> is supported but not documented for now. |
427 | | </para> |
| 428 | <application>MySQL</application> is a simple Relationnal DataBase |
| 429 | Management System distributed under a <firstterm>Free Software</firstterm> |
| 430 | license from the |
| 431 | <ulink url="http://www.mysql.org">http://www.mysql.org</ulink> |
| 432 | web site. |
| 433 | </para> |
| 434 | |
| 435 | <para> |
| 436 | To configure your database, you must have MySQL already working. |
| 437 | The complete installation of <application>MySQL</application> is not covered by |
| 438 | the present manual, please refer to your system's documentation or to |
| 439 | <ulink url="http://www.mysql.org">http://www.mysql.org</ulink> for |
| 440 | details. |
| 441 | </para> |
| 442 | |
| 443 | <para> |
| 444 | One thing you have to check, though, is that every Print Server on which you |
| 445 | want to install the print quota mechanism, must be able to connect to the |
| 446 | <application>MySQL</application> server. In the default installation of |
| 447 | <application>MySQL</application> this may not be the case for security reasons, except if both |
| 448 | servers are in fact the same machine. In any case, it is recommended that you |
| 449 | check the <filename>/etc/mysql/my.cnf</filename> file and modify it if |
| 450 | needed. |
| 451 | <tip> |
| 452 | <title>Tip</title> |
| 453 | <para> |
| 454 | Don't forget to restart <application>MySQL</application> if you modify |
| 455 | any of its configuration files, in order for the changes to take effect. |
| 456 | </para> |
| 457 | </tip> |
| 458 | </para> |
| 459 | |
| 460 | <para> |
| 461 | Be careful, you may be unable to connect from a Print Server to the <application>MySQL</application> |
| 462 | server even if the configuration is correct. Sometimes your connections may be blocked by |
| 463 | one or more network firewalls along the route from one machine to the other. If this |
| 464 | is the case, then the best thing you can do is to ask your <firstterm>Network Administrator</firstterm> |
| 465 | to not filter the IP port used by <application>MySQL</application>, which is |
| 466 | usually port <literal>3306/tcp</literal>. |
| 467 | <note> |
| 468 | <title>Note</title> |
| 469 | <para> |
| 470 | The TCP/IP network port used by MySQL may be different. When in doubt, ask your |
| 471 | <firstterm>System Administrator</firstterm> for the correct value. |
| 472 | </para> |
| 473 | </note> |
| 474 | </para> |
| 475 | |
| 476 | <para> |
| 477 | Now that your <application>MySQL</application> server is up and running, and |
| 478 | is waiting for your connections, you have to create the print quota database. |
| 479 | To do so, you'll have to feed <application>MySQL</application> with the |
| 480 | <filename>pykota-1.24_official/initscripts/mysql/pykota-mysql.sql</filename> file. |
| 481 | This file will create an empty |
| 482 | print quota database and set some permissions on it. |
| 483 | The database which will be created will be named <literal>pykota</literal> by default. |
| 484 | Two database users will be defined to have access in readonly and read+write modes under |
| 485 | the respective names <literal>pykotauser</literal> and <literal>pykotaadmin</literal>. |
| 486 | The <literal>pykotaadmin</literal> and <literal>pykotauser</literal> users by |
| 487 | default respectively have <literal>readwritepw</literal> and <literal>readonlypw</literal> |
| 488 | as their passwords. |
| 489 | <note> |
| 490 | <title>Note</title> |
| 491 | <para> |
| 492 | You can choose other names and passwords if you want by modifying the |
| 493 | <filename>initscripts/mysql/pykota-mysql.sql</filename> file |
| 494 | accordingly, and report your changes into <application>PyKota</application>'s |
| 495 | configuration files. |
| 496 | </para> |
| 497 | </note> |
| 498 | </para> |
| 499 | |
| 500 | <para> |
| 501 | To run this script, you can use the <command>mysql</command> frontend to |
| 502 | <application>MySQL</application>, but your priviledges must be sufficient |
| 503 | to be allowed to create databases. You can launch <command>mysql</command> |
| 504 | as the <literal>root</literal> user for example. |
| 505 | From a command line interpreter (i.e. shell), type the following commands : |
| 506 | <screen> |
| 507 | jerome@nordine:~$ cd pykota-1.24_official/initscripts/mysql |
| 508 | jerome@nordine:~/pykota-1.24_official/initscripts$ mysql <pykota-mysql.sql |
| 509 | </screen> |
| 510 | <note> |
| 511 | <title>Note</title> |
| 512 | <para> |
| 513 | If you use RPM or DEB packages, usually the |
| 514 | <filename>pykota-mysql.sql</filename> file gets installed into the |
| 515 | <filename>/usr/share/pykota/mysql</filename> directory, along |
| 516 | with a README file. |
| 517 | </para> |
| 518 | </note> |
| 519 | </para> |
| 520 | |
| 521 | <para> |
| 522 | To improve security further, you could encrypt your database connections, or |
| 523 | take any other step as needed. Please refer to <application>MySQL</application>'s |
| 524 | documentation for details. |
| 525 | </para> |
| 526 | |
| 527 | <para> |
| 528 | For more details, please see <filename>initscripts/mysql/README.mysql</filename>. |
| 529 | </para> |
| 530 | |
| 531 | <para> |
| 532 | If no error occured, then your print quota database is ready to be used. |
| 533 | Now you can let the print quota database server alone, the remaining work |
| 534 | will have to be done on each one of the print servers which will |
| 535 | use this particular print quota database server. |
| 536 | <tip> |
| 537 | <title>Tip</title> |
| 538 | <para> |
| 539 | If an error occured, maybe your MySQL version is too old, or |
| 540 | an unexpected problem (like a bug) happened. Please contact us via email so that we |
| 541 | can try to fix the problem. Thanks in advance. |
| 542 | </para> |
| 543 | </tip> |
| 544 | </para> |
| 545 | |