|
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.
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.
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
This directive is deprecated in favor of the URI form
of LogSQLLoginInfo.
This is defined only once in the
httpd.conf
file.
|