PING? Anyone know how to solve this issue? So far I have been unsuccessful at finding a solution or workaround. I did try and hack the sqlResources.xml file, modifying the SQL template statements there, related to this query, but no joy. The documentation tells me that this file has been deprecated so it may not be even getting used/referenced anywise. So my guess is that these SQL queries are now generated inside actual code rather than via XML code? If so that makes it even harder for a user such as myself to correct this sort of problem unless there is some other path that I am unaware of..
The symptoms of this problem is that it looks like it is causing log in attempts to the smtp server, by users wanting to send email, to fail, and that is a showstopper. Marc... On 01/25/2019 07:36 PM, Marc Chamberlin wrote: > I have no way to grok what the intent is, nor the details of what this > query is expecting in the database, but upon a first look through the > SQL documentation I changed this query by putting quotes around the > question marks '?' in the LIKE clauses and MariaDB accepted it. i.e. - > > SELECT t0.DOMAIN_NAME, t0.USER_NAME, t0.TARGET_ADDRESS FROM > JAMES_RECIPIENT_REWRITE t0 WHERE (t0.USER_NAME LIKE '?' ESCAPE '\\' AND > t0.DOMAIN_NAME LIKE '?' ESCAPE '\\') ORDER BY t0.DOMAIN_NAME DESC; > > This is just a guess on my part, but me thinks this might be a bug in > how Apache James is constructing this query? Marc... > > > On 01/25/2019 01:25 PM, Marc Chamberlin wrote: >> SELECT t0.DOMAIN_NAME, t0.USER_NAME, t0.TARGET_ADDRESS FROM >> JAMES_RECIPIENT_REWRITE t0 WHERE (t0.USER_NAME LIKE ? ESCAPE '\\' AND >> t0.DOMAIN_NAME LIKE ? ESCAPE '\\') ORDER BY t0.DOMAIN_NAME DESC; > -- Linux Counter
