mod_log_sql 2.0 Documentation

Home » Projects » Apache » Mod_log_sql » Docs-2.0 » mod_log_sql 2.0 Documentation

Prev: Configuring What Is logged --- Up: Configuration Directive Reference

Deprecated Commands

LogSQLSocketFile [Deprecated]
LogSQLSocketFile filename

Example: LogSQLSocketFile /tmp/mysql.sock

Default: (database specific)

Default (MySQL): /var/lib/mysql/mysql.sock

Context: main server config

At Apache runtime you can specify the MySQL socket file to use. Set this once in your main server config to override the default value. This value is irrelevant if your database resides on a separate machine.

mod_log_sql will automatically employ the socket for db communications if the database resides on the local host. If the db resides on a separate host the module will automatically use TCP/IP. This is a function of the MySQL API and is not user-configurable.

[Note]

This directive is deprecated in favor of LogSQLDBParam socketfile [socketfilename]

This is defined only once in the httpd.conf file.

LogSQLTCPPort [Deprecated]
LogSQLTCPPort port-number

Example: LogSQLTCPPort 3309

Default: (database specific)

Default (MySQL): 3306

Context: main server config

Your database may listen on a different port than the default. If so, use this directive to instruct the module which port to use. This directive only applies if the database is on a different machine connected via TCP/IP.

[Note]

This directive is deprecated in favor of LogSQLDBParam tcpport [port-number]

This is defined only once in the httpd.conf file.

LogSQLDatabase [Deprecated]
LogSQLDatabase database

Example: LogSQLDatabase loggingdb

Context: main server config

Defines the database that is used for logging. "database" must be a valid db on the MySQL host defined in LogSQLLoginInfo

[Note]

This directive is deprecated in favor of the URI form of LogSQLLoginInfo.

This is defined only once in the httpd.conf file.