[phpLogCon] Field 'host' does not display at the correct column

[luckydog xf]

Hi,

  I'm running MySQL and Rsyslog to analyze Switch logs. Below is the
original log entry.

==============================

 Nov 13 17:32:01 2017 AAA %%10SC/6/SC_AAA_SUCCESS(l):
-DevIP=10.10.3.241-AAAType=ACCOUNT-AAAScheme= radius-scheme
test-Service=login-UserName=h3c at system; AAA is successful.

===============================


/etc/rsyslog.conf is pretty simple:

local7.* :ommysql:127.0.0.1,Syslog,rsyslog,xxxx



===============================================
Date         Facility Severity Host Syslogtag ProcessID Messagetype Message

Today 17:42:14 LOCAL7          WARNING         2017    AAA
.........

================================================

Apparently,field "Host" should be AAA, while "2017" should be the first
column. So what's the probable reason causing problem?


Thanks a lot.