Sfrgttk

Why there is no EEPROM in STM32F4 MCUs

Negotiating 1-year delay to my Assistant Professor Offer

Subcaptions in subfigures

How to draw these kind of adjacent ovals with arrows in latex?

How to explain one side of Super Earth is smoother than the other side?

Publication rates for different areas of mathematics?

How to play song that contains one guitar when we have two guitarists (or more)?

Does a star need to be inside a galaxy?

Is the "hot network questions" element on Stack Overflow a dark pattern?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

How bad is a Computer Science course that doesn't teach Design Patterns?

What happens if you declare more than $10,000 at the US border?

Is it possible to detect 100% of SQLi with a simple regex?

Why does calling Python's 'magic method' not do type conversion like it would for the corresponding operator?

Someone wants me to use my credit card at a card-only gas/petrol pump in return for cash

Was Opportunity's last message to Earth "My battery is low and it's getting dark"?

Have any astronauts or cosmonauts died in space?

How to make clear what a part-humanoid character looks like when they're quite common in their world?

Is 'bad luck' with former employees a red flag?

Is it possible to 'install' an operating system by putting the EFI/boot & system files in the right place?

Substitute ./ and ../ directories by actual names

Headless horseman claims new head

Why is autolanding ILS a thing, but not autotakeoffing ITS?

Run a command that requires sudo after a time has passed

Logs from Syslog-ng to MySQL

How do I output MySQL logs to syslog?innodb_flush_method=O_DIRECT vs O_DSYNC performance impact on ext3 with LVM disk partitionSlow Queries Not LoggingWhy are simple SELECTs on InnoDB 100x slower than on MyISAM?Mysql Optimization suggessionsMysql Server 5.6 high memory consumptionMySQL intermittent slow queriesMysql Crash SIGSEGV signal 11, recovered after killing apportThousands of MySQL connections with no visitorsDisable Binary Logs in MySQL 8.0

1

• Syslog-NG ver 3.18


• MySQL ver 8.0.15

I configured my Syslog-ng as follows:

source s_network {

        udp();

        tcp();

};



destination d_file { file("/var/log/app_network.log"); };



destination d_mysql {

        sql(

                type(mysql)

                host ("127.0.0.1")

                username("root")

                password("Danilo90XYZ!?")

                database("syslog")

                table("logs")

                columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")

                values("${HOST}", "${FACILITY}", "${PRIORITY}", "${LEVEL}", "${TAG}","${YEAR}-${MONTH}-${DAY} ${HOUR}:${MIN}:${SEC}","${PROGRAM}", "${MSGONLY}")

                indexes("datetime", "host")

        );

};





log { source(s_network); destination(d_file); destination(d_mysql); };

Syslog-ng captures the logs and writes them into the file but not into MySQL.

Can someone help me?

mysql mysql-8.0

share|improve this question

edited 8 mins ago

dezso

22.1k116096

asked 19 hours ago

DspiDspi

62

New contributor

Dspi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

1

• Syslog-NG ver 3.18


• MySQL ver 8.0.15

I configured my Syslog-ng as follows:

source s_network {

        udp();

        tcp();

};



destination d_file { file("/var/log/app_network.log"); };



destination d_mysql {

        sql(

                type(mysql)

                host ("127.0.0.1")

                username("root")

                password("Danilo90XYZ!?")

                database("syslog")

                table("logs")

                columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")

                values("${HOST}", "${FACILITY}", "${PRIORITY}", "${LEVEL}", "${TAG}","${YEAR}-${MONTH}-${DAY} ${HOUR}:${MIN}:${SEC}","${PROGRAM}", "${MSGONLY}")

                indexes("datetime", "host")

        );

};





log { source(s_network); destination(d_file); destination(d_mysql); };

Syslog-ng captures the logs and writes them into the file but not into MySQL.

Can someone help me?

mysql mysql-8.0

share|improve this question

edited 8 mins ago

dezso

22.1k116096

asked 19 hours ago

DspiDspi

62

New contributor

Dspi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

• Syslog-NG ver 3.18


• MySQL ver 8.0.15

I configured my Syslog-ng as follows:

source s_network {

        udp();

        tcp();

};



destination d_file { file("/var/log/app_network.log"); };



destination d_mysql {

        sql(

                type(mysql)

                host ("127.0.0.1")

                username("root")

                password("Danilo90XYZ!?")

                database("syslog")

                table("logs")

                columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")

                values("${HOST}", "${FACILITY}", "${PRIORITY}", "${LEVEL}", "${TAG}","${YEAR}-${MONTH}-${DAY} ${HOUR}:${MIN}:${SEC}","${PROGRAM}", "${MSGONLY}")

                indexes("datetime", "host")

        );

};





log { source(s_network); destination(d_file); destination(d_mysql); };

Syslog-ng captures the logs and writes them into the file but not into MySQL.

Can someone help me?

mysql mysql-8.0

share|improve this question

edited 8 mins ago

dezso

22.1k116096

asked 19 hours ago

DspiDspi

62

New contributor

Dspi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

source s_network {

        udp();

        tcp();

};



destination d_file { file("/var/log/app_network.log"); };



destination d_mysql {

        sql(

                type(mysql)

                host ("127.0.0.1")

                username("root")

                password("Danilo90XYZ!?")

                database("syslog")

                table("logs")

                columns("host", "facility", "priority", "level", "tag", "datetime", "program", "msg")

                values("${HOST}", "${FACILITY}", "${PRIORITY}", "${LEVEL}", "${TAG}","${YEAR}-${MONTH}-${DAY} ${HOUR}:${MIN}:${SEC}","${PROGRAM}", "${MSGONLY}")

                indexes("datetime", "host")

        );

};





log { source(s_network); destination(d_file); destination(d_mysql); };

share|improve this question

edited 8 mins ago

dezso

22.1k116096

asked 19 hours ago

DspiDspi

62

New contributor

Dspi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 8 mins ago

dezso

22.1k116096

asked 19 hours ago

DspiDspi

62

New contributor

Dspi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 8 mins ago

dezso

22.1k116096

edited 8 mins ago

dezso

22.1k116096

asked 19 hours ago

DspiDspi

62

New contributor

Dspi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 19 hours ago

DspiDspi

62

1 Answer
1

active

oldest

votes

0

Try starting syslog-ng in the foreground and check the output for any error messages. Alternatively, include the internal() source in a logpath, like this:

source s_local { internal(); };

log { source(s_network); source(s_local); destination(d_file); destination(d_mysql); };  

share|improve this answer

edited 11 mins ago

dezso

22.1k116096

answered 1 hour ago

Robert FeketeRobert Fekete

1011

New contributor

Robert Fekete is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

Dspi is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230144%2flogs-from-syslog-ng-to-mysql%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Try starting syslog-ng in the foreground and check the output for any error messages. Alternatively, include the internal() source in a logpath, like this:

source s_local { internal(); };

log { source(s_network); source(s_local); destination(d_file); destination(d_mysql); };  

share|improve this answer

edited 11 mins ago

dezso

22.1k116096

answered 1 hour ago

Robert FeketeRobert Fekete

1011

New contributor

Robert Fekete is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

Try starting syslog-ng in the foreground and check the output for any error messages. Alternatively, include the internal() source in a logpath, like this:

source s_local { internal(); };

log { source(s_network); source(s_local); destination(d_file); destination(d_mysql); };  

share|improve this answer

edited 11 mins ago

dezso

22.1k116096

answered 1 hour ago

Robert FeketeRobert Fekete

1011

New contributor

Robert Fekete is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Try starting syslog-ng in the foreground and check the output for any error messages. Alternatively, include the internal() source in a logpath, like this:

source s_local { internal(); };

log { source(s_network); source(s_local); destination(d_file); destination(d_mysql); };  

share|improve this answer

edited 11 mins ago

dezso

22.1k116096

answered 1 hour ago

Robert FeketeRobert Fekete

1011

New contributor

Robert Fekete is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

source s_local { internal(); };

log { source(s_network); source(s_local); destination(d_file); destination(d_mysql); };  

share|improve this answer

edited 11 mins ago

dezso

22.1k116096

answered 1 hour ago

Robert FeketeRobert Fekete

1011

New contributor

Robert Fekete is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 11 mins ago

dezso

22.1k116096

edited 11 mins ago

dezso

22.1k116096

answered 1 hour ago

Robert FeketeRobert Fekete

1011

New contributor

Robert Fekete is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 1 hour ago

Robert FeketeRobert Fekete

1011