有没有办法将Nginx网站访问日志直接写入MySQL或其它的数据库里

用软件读取Nginx网站访问日志 然后写入MySQL或其它的数据库 只要能读取，就能写入你的采纳是我前进的动力,还有不懂的地方,请继续“追问”。

如你还有别的问题,可另外向我求助;答题不易,互相理解,

新增一个event的appender名字叫event，新加一个logger，将其apender指定为event，指定其level为INFO，additivity="false"这个最重要，指定日志不向上一级输入。

之后，在类cncompanybaudesktopcompositeEventRealTimeComposite中，就可以用loggerinfo("xxx")输出日志，日志会记录到eventlog中，并按策略生成，以供分析

The answer by the first respondent is totally wrong ARCHIVELOG/NONARCHIVELOG has nothing to do with what you ask for ARCHIVELOG/NONARCHIVELOG is about the recoverbility of the database, but what you want is "Auditing" in Oracle, which is about monitoring users' activities in database

The auditing mechanism for Oracle is extremely flexible, so I'll only talk about performing full auditing on a single user

1 Database server setup

To allow auditing on the server you must:

Set "audit_trail = true" in the initora file

Run the $ORACLE_HOME/rdbms/admin/catauditsql script while connected as SYS

2 Audit Options

Assuming that the "AAA" user is to be audited:

CONNECT sys/password AS SYSDBA

AUDIT ALL BY AAA BY ACCESS;

AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY AAA BY ACCESS;

AUDIT EXECUTE PROCEDURE BY AAA BY ACCESS;

These options audit all DDL and DML issued by "AAA", along with some system events

DDL (CREATE, ALTER & DROP of objects)

DML (INSERT UPDATE, DELETE, SELECT, EXECUTE)

SYSTEM EVENTS (LOGON, LOGOFF etc)

3 View Audit Trail

The audit trail is stored in the SYSAUD$ table It's contents can be viewed directly or via the following views:

DBA_AUDIT_EXISTS

DBA_AUDIT_OBJECT

DBA_AUDIT_SESSION

DBA_AUDIT_STATEMENT

DBA_AUDIT_TRAIL

DBA_OBJ_AUDIT_OPTS

DBA_PRIV_AUDIT_OPTS

DBA_STMT_AUDIT_OPTS

The audit trail contains a lot of data, but the following are most likely to be of interest:

Username: Oracle Username

Terminal: Machine that the user performed the action from

Timestamp: When the action occured

Object Owner: The owner of the object that was interacted with

Object Name: The name of the object that was interacted with

Action Name: The action that occured against the object (INSERT, UPDATE, DELETE, SELECT, EXECUTE)

4 Maintenance

The audit trail must be deleted/archived on a regular basis to prevent the SYSAUD$ table growing to an unnacceptable size

5 Security

Only DBAs should have maintenance access to the audit trail Auditing modifications of the data in the audit trail itself can be achieved as follows:

AUDIT INSERT, UPDATE, DELETE ON sysaud$ BY ACCESS;

以上就是关于有没有办法将Nginx网站访问日志直接写入MySQL或其它的数据库里全部的内容，包括:有没有办法将Nginx网站访问日志直接写入MySQL或其它的数据库里、logback将日志文件存入数据库怎么弄、SCADA如何将 *** 作日志写入到oracle数据库中等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！