[syslog-ng] message source hostname not displayed relay's hostname displaied instedd

[gatfi sami]

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 clien*t (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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20090417/30b80404/attachment.htm