hi
i have syslog-ng 2.O.9-27 on sles11 32bite (SUSE Entreprise server 11) on 3 virtual machine

i use the following syslog organisation

a syslog client (read error log and sends them to a relay)

the relay frorwords the message to a syslog-server

The syslog server writes the messages in a pipe binde to a mysql database

untill now everithing is working perfectly

but

in the  syslog server i olways founf the relai host name ip adress

i tried HOST_FROM in the template writing to the pipe it is always the same the relay's hostname

destination d_mysql {
pipe("/opt/topnet/mnt/mysql.pipe"
template("INSERT INTO logs (host, facility, priority, level, tag, date,
time, program, msg) VALUES ( '$HOST_FROM', '$FACILITY', '$PRIORITY', '$LEVEL','$TAG',
'$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n") template-escape(yes));
};


imagine if i have aot of cilents with each one a diiferent error log i will see nothing but the relai's hostname
need hepl here

thks