4.4. mysql log

4.4.1. mysql_server_addr

This parameter set MySql server address.

Default: mysql_server_addr="127.0.0.1"

4.4.2. mysql_server_port

This set the Mysql server port.

Default: mysql_server_port=3306

4.4.3. mysql_user

This parameter set the name of the user used to log on MySQL server.

Default: mysql_user="myuser"

4.4.4. mysql_passwd

This set the MySQL password, associated with username.

Default: mysql_passwd="secret"

4.4.5. mysql_db_name

This is the name of MySQL database to connect to.

Default: mysql_db_name="nufw"

4.4.6. mysql_table_name

This set the name of table to connect to. It must belong to the chosen database. The specified user must have rights on this table.

Default: mysql_table_name="ulog"

4.4.7. mysql_users_table_name

This set the name of table to log users session into. It must belong to the chosen database. The specified user must have rights on this table.

Default: mysql_users_table_name="users"

4.4.8. mysql_use_ipv4_schema

Set to 0 if your MySQL database uses the IPV6 schema provided with NuFW 2.2.

Default: mysql_use_ipv4_schema=1

4.4.9. mysql_request_timeout

T This set the time in seconds we consider connection to the database to be lost if we have no answer.

Default: mysql_request_timeout=5

4.4.10. mysql_use_ssl

Set mysql_use_ssl to 1 to use SSL, else other ssl options will be ignored

Default: mysql_use_ssl=0

4.4.11. mysql_ssl_keyfile

Set mysql_ssl_keyfile to the full path of the file containing your PRIVATE key.

Default: mysql_ssl_keyfile="/etc/nufw/ssl/mysql.key"

4.4.12. mysql_ssl_certfile

Set mysql_ssl_certfile to the full path of the file containing your PUBLIC certificate

Default: mysql_ssl_certfile="/etc/nufw/ssl/mysql.cert"

4.4.13. mysql_ssl_ca

Set mysql_ssl_ca to the full path of the file containing your CA (Certificate Authority) file.

Default: mysql_ssl_ca="/etc/nufw/ssl/mysql.ca"

4.4.14. mysql_ssl_capath

Set mysql_ssl_capath to the full path of a DIRECTORY containing your CA Certificate Authority) files, in PEM format

Default: mysql_ssl_capath="/etc/nufw/ssl/mysql.cas/"

4.4.15. mysql_ssl_cipher

Set mysql_ssl_cipher to the list of ciphers you wish to use for Mysql connections. A complete cipher list on your system should be available if you issue "openssl ciphers" The default value here is "ALL:!ADH:+RC4:@STRENGTH", which is OpenSSL default, and means "Use any but give RC4 the lowest priority" For more info see : http://www.mkssoftware.com/docs/man1/openssl_ciphers.1.asp

Default: mysql_ssl_cipher="ALL:!ADH:+RC4:@STRENGTH"