Changes

Jump to: navigation, search

SRA840 Lab7

409 bytes added, 21:33, 11 April 2009
no edit summary
This should also be enabled from the server side too.
* What are the exact sequence of steps that you need to take so that Apache logs can be read in from MySQL:
Install mod_log_sql module and issue following commands.
 
mysqladmin CREATE apache_logs
mysql apache_logs < access_logs.sql
mysql alache_logs
GRANT INSERT,CREATE ON apache_logs.* TO 'root'@'localhost' IDENTIFIED BY 'password';
 
Add following lines to httpd.conf:
<IfModule mod_log_sql.c>
LogSQLLoginInfo mysql://webserver:password@mysqldb.example.com/apache_logs
LofSQLCreateTables on
</IfModule>
* Name two security measures that MySQL recommends:
1
edit

Navigation menu