6.3. Mysql

Users/Groups definitions are stored in a mysql database.

The default logging channel for the postgresql backend is 26.

Here are some instructions how to use MySQL as a backend for users/groups.

6.3.1. Installation

6.3.2. Uninstall

6.3.3. Schema and Constraints

The main tables are users and groups. They are related with a n:n relation, implemented using the ugr table (user-group relations).

Other tables are linked using 1:n relations to materialize the fact that one user or group can have several associated IP adresses. Users have userip, groups have groupip.

Finally, stats for users are implemented in a separate table, stats, with a 1:1 relation (users have only one stat line).

As MySQL does not yet support constraints (nor sequences), data integrity is not assured in case of problems. If a modification is interrupted; or if you connect several servers to the same database, wzdftpd cannot guaranty the safety of your data. That's why the PostgreSQL backend is preferable in most situations (that does not mean the MySQL backend has problems, nor that the PostgreSQL backend is perfect, only that PostgreSQL is potentially less subject to problems).