?
Solved

Second Question about Syslog-NG and MySQL DataBase

Posted on 2004-11-19
15
Medium Priority
?
911 Views
Last Modified: 2013-12-09
I have installed MySQL and Syslog-NG on a OpenBSD 3.4 Box.

when i run the following command:
 mysql -u root --password='secret' syslog </tmp/mysql.pipe
i get the following error:
/etc/syslog-ng/syslog-pipe[9]: cannot open /tmp/mysql.pipe: Interrupted system call

Why ..??
0
Comment
Question by:ColinWebdesign
  • 7
  • 6
14 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 12628663
What do you want to accomplish ???
0
 

Author Comment

by:ColinWebdesign
ID: 12633186
with the following command line:
mysql -u root --password='secret' syslog </tmp/mysql.pipe
mysql imports the syslog-ng database.
but when i run it, i got the error. what is wrong. what is a "Interrupted system call"?
0
 
LVL 62

Expert Comment

by:gheist
ID: 12633883
Freom what i see I can explain:
You read socket as file which will never happen.
Or you rewrote socket with common file to knowingly break mysqld
"Interrupted system call" is expected, when mysql command opens and closes named pipe used by output of syslog-pipe.

So: Waht are you trying to accomplish???
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:ColinWebdesign
ID: 12633992
i just want to know now, how to pipe the syslog logs to mysql
0
 
LVL 62

Expert Comment

by:gheist
ID: 12634264
1) OpenBSD 3.4 is no longer supported ....
2) you make your syslog-ng use unix-stream output to /tmp/mysql.sock  with appropriate template to generate SQL statements that insert data into right tables....
0
 

Author Comment

by:ColinWebdesign
ID: 12634332
1) okay
2) what do you mean exactly
0
 
LVL 62

Expert Comment

by:gheist
ID: 12635033
(2) I do not know how you installed syslog-ng, so I cannot help much with configuring it.
look here
http://vermeer.org/display_doc.php?doc_id=1
for
"This script is used to pipe syslog-ng to mysql"

it says "broken pipe" for every record, that is expected...
0
 

Author Comment

by:ColinWebdesign
ID: 12652362
gheist: that was the script i used... but that isn't working.
0
 
LVL 62

Expert Comment

by:gheist
ID: 12652507
it kind of inserts in table...
0
 

Author Comment

by:ColinWebdesign
ID: 12656226
still isn't working :(
installed the latest stable version of syslog-ng (1.6.5), but no futher results. stil the same stupid error:

cannot open /tmp/mysql.pipe: Interrupted system call
0
 
LVL 62

Expert Comment

by:gheist
ID: 12657821
try changing two lines in that script ( which looks quite illogical btw )

#!/bin/ksh

( cat /tmp/mysql.pipe && tail -F  /tmp/mysql.pipe) | mysql -u theuserid --password=thepassword syslogdb
0
 

Author Comment

by:ColinWebdesign
ID: 12664336
Table of MySQL was broken.. dropped the table, created the table and it worked..

thanks for all your help
0
 

Author Comment

by:ColinWebdesign
ID: 12679373
Close this thread please...
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 14353873
PAQed with points refunded (125)

modulo
Community Support Moderator
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question