hi<br><br>i have problem when i try insert data in mssql server, when i try run script, just 2 or 3 lines insert ok, but , insert stop .<br><br>I use pipe, my confs. <br><br>destination d_mssql {<br> pipe("/var/mssql.syslog-ng.pipe"<br>
template( "INSERT INTO logs (host, facility, priority, level, tag, datetime, program, msg ) VALUES ( '$HOST','$FACILITY','$PRIORITY','$LEVEL','$TAG','$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$PROGRAM','$MSG' );\n" ) template-escape(yes));<br>
template-escape(yes));<br>};<br><br><br>log {<br> source(s_all);<br> destination(d_mssql);<br>};<br><br>my script:<br><br>if [ -e /var/mssql.syslog-ng.pipe ]; then<br> while [ -e /var/mssql.syslog-ng.pipe ]<br>
do<br> #isql -v MSSQL "syslogng" "h0hYgbDB6Q" < /var/mssql.syslog-ng.pipe > /dev/null<br> isql -v MSSQL "syslogng" "h0hYgbDB6Q" < /var/mssql.syslog-ng.pipe<br>
done<br>else<br><br> mkfifo /var/mssql.syslog-ng.pipe<br>fi<br><br><br><br>when i try run script: <br><br>./syslog2mssql.sh <br>+---------------------------------------+<br>| Connected! |<br>
| |<br>| sql-statement |<br>| help [tablename] |<br>| quit |<br>| |<br>
+---------------------------------------+<br>SQL> SQLRowCount returns 1<br>SQL> +------------+<br>| |<br>+------------+<br>+------------+<br>SQLRowCount returns 0<br>SQL> SQLRowCount returns -1<br>SQL> SQLRowCount returns 1<br>
SQL> [ISQL]ERROR: Could not SQLPrepare<br>SQL> [ISQL]ERROR: Could not SQLPrepare./syslog2mssql.sh <br>+---------------------------------------+<br>| Connected! |<br>| |<br>
| sql-statement |<br>| help [tablename] |<br>| quit |<br>| |<br>+---------------------------------------+<br>
SQL> SQLRowCount returns 1<br>SQL> +------------+<br>| |<br>+------------+<br>+------------+<br>SQLRowCount returns 0<br>SQL> SQLRowCount returns -1<br>SQL> SQLRowCount returns 1<br>SQL> [ISQL]ERROR: Could not SQLPrepare<br>
SQL> [ISQL]ERROR: Could not SQLPrepare<br><br><br><br>someone have idea for this ?<br clear="all"><br><br>-- <br>Bely Silva Junior<br>