System/Apache - Revision history

Eadam: /* openssl */

2012-07-06T09:20:15Z

openssl

Eadam: /* openssl */

2012-06-27T08:29:50Z

openssl

Eadam at 14:16, 29 May 2012

2012-05-29T14:16:35Z

Eadam at 15:13, 5 January 2012

2012-01-05T15:13:42Z

Eadam: Created page with "== RPAF == == MySQL logging == Install the module apt-get install libapache2-mod-log-sql-mysql Create database and grant access to mysql user: CREATE DATABASE apachelog..."

2012-01-05T15:13:00Z

Created page with "== RPAF == == MySQL logging == Install the module apt-get install libapache2-mod-log-sql-mysql Create database and grant access to mysql user: CREATE DATABASE apachelog..."

New page

== RPAF ==

== MySQL logging ==

Install the module

apt-get install libapache2-mod-log-sql-mysql

Create database and grant access to mysql user:

CREATE DATABASE apachelogs;
GRANT INSERT,CREATE ON apachelogs.*
TO apachelogger@localhost
IDENTIFIED BY 'insert_passwd_here';
FLUSH PRIVILEGES;

In apache config, add the configuration for the module:

LogSQLLoginInfo mysql://apachelogger:insert_passwd_here@localhost/apachelogs
LogSQLCreateTables on
LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock
LogSQLTransferLogFormat AabfHhmRSsTUuvI

In each Virtual Host, add this line:

LogSQLTransferLogTable this_site_com

@@ Line 4: / Line 4: @@
   openssl rsa -in server.key -out server-nopass.key
 Generate a self signed certificate in one step:
-  openssl req -new -newkey rsa:4096 -days 730 -nodes -x509 -subj "/C=US/ST=There/L=Town/O=Region/CN=my.domain.fr" -keyout my.domain.fr.key  -out my.domain.fr.cert
+  openssl req -new -newkey rsa:4096 -days 730 -nodes -x509 -subj "/C=US/ST=State/L=Town/O=Organisation/CN=my.domain.fr" -keyout my.domain.fr.key  -out my.domain.fr.cert
 == RPAF ==

← Older revision		Revision as of 08:29, 27 June 2012
Line 4:		Line 4:

	openssl rsa -in server.key -out server-nopass.key		openssl rsa -in server.key -out server-nopass.key
		+
		+	Generate a self signed certificate in one step:
		+
		+	openssl req -new -newkey rsa:4096 -days 730 -nodes -x509 -subj "/C=US/ST=There/L=Town/O=Region/CN=my.domain.fr" -keyout my.domain.fr.key -out my.domain.fr.cert

	== RPAF ==		== RPAF ==

← Older revision		Revision as of 14:16, 29 May 2012
Line 1:		Line 1:
		+	== openssl ==
		+
		+	Remove passphrase from key:
		+
		+	openssl rsa -in server.key -out server-nopass.key
		+
	== RPAF ==		== RPAF ==

@@ Line 11: / Line 11: @@
   CREATE DATABASE apachelogs;
   GRANT INSERT,CREATE ON apachelogs.*
-   TO apachelogger@localhost
+   TO apachelog@localhost
-   IDENTIFIED BY 'insert_passwd_here';
+   IDENTIFIED BY 'password';
   FLUSH PRIVILEGES;
 In apache config, add the configuration for the module:
-  LogSQLLoginInfo mysql://apachelogger:insert_passwd_here@localhost/apachelogs
+  LogSQLLoginInfo mysql://apachelog:password@localhost/apachelogs
   LogSQLCreateTables on
   LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock
@@ Line 24: / Line 24: @@
 In each Virtual Host, add this line:
-  LogSQLTransferLogTable this_site_com
+  LogSQLTransferLogTable table_name_for_this_vhost