I have configured an automatic lookup from a mysql table via web interface. When I configure two lookup input fields I get a mysql syntax error. Just configuring one does work sql wise.
From the recent db connect errors search:
com.splunk.dbx.lookup.DBLookupException: SQL error while performing lookup: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDportindex = 12' at line 1
mysql query log:
33409 Query SELECT slot,number,name FROM port WHERE switchdomain = 58 ANDportindex = 3
So there is missing a whitespace after the AND. Is there any workaround?
This should be fixed in the latest release (1.0.7)
Thanks, it works now.