syslog-ng Open Source Edition 3.38 - Administration Guide

Complete the following steps to configure your Microsoft SQL Server to enable remote logins and accept log messages from syslog-ng.

Start the SQL Server Management Studio application. Select Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
Create a new database.
1. Figure 5: Creating a new MSSQL database 1.
  
  In the Object Explorer, right-click on the Databases entry and select New Database.
2. Figure 6: Creating a new MSSQL database 2.
  
  Enter the name of the new database (for example, syslogng) into the Database name field and click OK.

Create a new database user and associate it with the new database.

Figure 7: Creating a new MSSQL user 1.

In the Object Explorer, select Security, right-click on the Logins entry, then select New Login.
Figure 8: Creating a new MSSQL user 2.

Enter a name (for example, syslog-ng) for the user into the Login name field.
Select the SQL Server Authentication option and enter a password for the user.
In the Default database field, select the database created in Step 2 (for example, syslogng).

In the Default language field, select the language of log messages that you want to store in the database, then click OK.

Caution:

Incorrect language settings may result in the database converting the messages to a different character-encoding format. That way the log messages may become unreadable, causing information loss.

In the Object Explorer, select Security > Logins, then right-click on the new login created in the previous step, and select Properties.
Figure 9: Associating database with the new user

Select User Mapping. In the Users mapped to this login option, check the line corresponding to the new login (for example, syslogng). In the Database role membership field, check the db_owner and public options.

Figure 10: Associating database with the new user

Enable remote logins for SQL users.

In the Object Explorer right-click on your database server, and select Properties > Security, and set the Server Authentication option to SQL Server and Windows Authentication mode.

The syslog-ng OSE quick-start guide

Configuring syslog-ng on client hosts

Purpose:

To configure syslog-ng on a client host, complete the following steps.

Steps:

Install the syslog-ng application on the host. For details installing syslog-ng on specific operating systems, see Installing syslog-ng.
Configure the local sources to collect the log messages of the host. Starting with version 3.2, syslog-ng OSE automatically collects the log messages that use the native system logging method of the platform, for example, messages from /dev/log on Linux, or /dev/klog on FreeBSD. For a complete list of messages that are collected automatically, see system: Collecting the system-specific log messages of a platform.

To configure syslog-ng OSE, edit the syslog-ng.conf file with any regular text editor application. The location of the configuration file depends on how you installed syslog-ng OSE. Native packages of a platform (like the ones downloaded from Linux repositories) typically place the configuration file under the /etc/syslog-ng/ directory.

Add sources to collect the messages from your log files. File sources look like this:
```
source s_myfilesource {
    file("/var/log/myapplication.log" follow-freq(1));
};
```
Name every source uniquely. For details on configuring file sources, see file: Collecting messages from text files.

TIP: Many applications send log messages to logfiles by default (for example, the Roundcube webmail client, or the ProFTPD FTP server), but can be configured to send them to syslog instead. If possible, it is recommended to reconfigure the application that way.
NOTE: The default configuration file of syslog-ng OSE collects platform-specific log messages and the internal log messages of syslog-ng OSE.
```
source s_local {
    system();
    internal();
};
```
Create a network destination that points directly to the syslog-ng server, or to a local relay. The network destination greatly depends on the protocol that your log server or relay accepts messages. Many systems still use the legacy BSD-syslog protocol (RFC3162) over the unreliable UDP transport:
```
destination d_network { network("10.1.2.3" transport("udp")); };
```
However, if possible, use the much more reliable IETF-syslog protocol over TCP transport:
```
destination d_network {
    syslog("10.1.2.3" transport("tcp"));
};
```
Create a log statement connecting the local sources to the syslog-ng server or relay. For example:
```
log {
    source(s_local); destination(d_network);
};
```
If the logs will also be stored locally on the host, create local file destinations.
NOTE: The default configuration of syslog-ng OSE places the collected messages into the /var/log/messages file:
```
destination d_local {
    file("/var/log/messages");
};
```
Create a log statement connecting the local sources to the file destination.
NOTE: The default configuration of syslog-ng OSE has only one log statement:
```
log {
    source(s_local); destination(d_local);
};
```
Set filters, macros and other features and options (for example, TLS encryption) as necessary.
Example: The default configuration file of syslog-ng OSE

The following is the default configuration file of syslog-ng OSE3.38. It collects local log messages and the log messages of syslog-ng OSE and saves them in the /var/log/messages file.
```
@version: 3.38
@include "scl.conf"
source s_local {
    system(); internal();
};
destination d_local {
    file("/var/log/messages");
};
log {
    source(s_local); destination(d_local);
};
```
Example: A simple configuration for clients

The following is a simple configuration file that collects local log messages and forwards them to a logserver using the IETF-syslog protocol.
```
@version: 3.38
@include "scl.conf"
source s_local {
    system(); internal();
};
destination d_syslog_tcp {
    syslog("192.168.1.1" transport("tcp") port(2010));
};
log {
    source(s_local);destination(d_syslog_tcp);
};
```

Configuring syslog-ng on server hosts

Purpose:

To configure syslog-ng on a server host, complete the following steps.

Steps:

Install the syslog-ng application on the host. For details installing syslog-ng on specific operating systems, see Installing syslog-ng.
Starting with version 3.2, syslog-ng OSE automatically collects the log messages that use the native system logging method of the platform, for example, messages from /dev/log on Linux, or /dev/klog on FreeBSD. For a complete list of messages that are collected automatically, see system: Collecting the system-specific log messages of a platform.
To configure syslog-ng OSE, edit the syslog-ng.conf file with any regular text editor application. The location of the configuration file depends on how you installed syslog-ng OSE. Native packages of a platform (like the ones downloaded from Linux repositories) typically place the configuration file under the /etc/syslog-ng/ directory.

Configure the network sources that collect the log messages sent by the clients and relays. How the network sources should be configured depends also on the capabilities of your client hosts: many older networking devices support only the legacy BSD-syslog protocol (RFC3164) using UDP transport:
```
source s_network {
    syslog(ip(10.1.2.3) transport("udp"));
};
```
However, if possible, use the much more reliable TCP transport:
```
source s_network {
    syslog(ip(10.1.2.3) transport("tcp"));
};
```
For other options, see syslog: Collecting messages using the IETF syslog protocol (syslog() driver) and tcp, tcp6, udp, udp6: Collecting messages from remote hosts using the BSD syslog protocol— OBSOLETE.

NOTE: Starting with syslog-ng OSE version 3.2, the syslog() source driver can handle both BSD-syslog (RFC 3164) and IETF-syslog (RFC 5424-26) messages.
Create local destinations that will store the log messages, for example, file- or program destinations. The default configuration of syslog-ng OSE places the collected messages into the /var/log/messages file:
```
destination d_local {
    file("/var/log/messages");
};
```
If you want to create separate logfiles for every client host, use the ${HOST} macro when specifying the filename, for example:
```
destination d_local {
    file("/var/log/messages_${HOST}");
};
```
For details on further macros and how to use them, see template and rewrite: Format, modify, and manipulate log messages.
Create a log statement connecting the sources to the local destinations.
```
log {
    source(s_local); source(s_network); destination(d_local);
};
```
Set filters, options (for example, TLS encryption) and other advanced features as necessary.

NOTE: By default, the syslog-ng server will treat the relayed messages as if they were created by the relay host, not the host that originally sent them to the relay. In order to use the original hostname on the syslog-ng server, use the keep-hostname(yes) option both on the syslog-ng relay and the syslog-ng server. This option can be set individually for every source if needed.

If you are relaying log messages and want to resolve IP addresses to hostnames, configure the first relay to do the name resolution.
Example: A simple configuration for servers

The following is a simple configuration file for syslog-ng Open Source Edition that collects incoming log messages and stores them in a text file.
```
@version: 3.38
@include "scl.conf"
options {
    time-reap(30);
    mark-freq(10);
    keep-hostname(yes);
};
source s_local {
    system(); internal();
};
source s_network {
    syslog(transport(tcp));
};
destination d_logs {
    file(
        "/var/log/syslog-ng/logs.txt"
        owner("root")
        group("root")
        perm(0777)
        );
    };
log {
    source(s_local); source(s_network); destination(d_logs);
};
```

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

syslog-ng Open Source Edition 3.38 - Administration Guide

Configuring Microsoft SQL Server to accept logs from syslog-ng

The syslog-ng OSE quick-start guide

Configuring syslog-ng on client hosts

Purpose:

Steps:

Example: The default configuration file of syslog-ng OSE

Example: A simple configuration for clients

Configuring syslog-ng on server hosts

Purpose:

Steps:

Example: A simple configuration for servers