Thanks Garry, looks like some sort of syntax error is occurring.
Interesting thing is I set up the mariadb server to log all queries and
statements and I am seeing a lot of things coming in from the James
server, but not the particular statement that is causing problems...
Applying the statement directly by hand, while logged in to the database
server as James, this is what is happening -
MariaDB [mail]> 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;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near '? ESCAPE '\\' AND t0.DOMAIN_NAME LIKE ? ESCAPE '\\')
ORDER BY t0.DOMAIN_NAME DES' at line 1
Maybe an expert pair of SQL eyes can see what is wrong faster than I can
do a search through the documentation, in order to figure out what is
exactly wrong with this MySQL query.. I am by no means an expert at SQL
syntax!! ;-)
Marc
On 1/25/19 9:11 AM, Garry Hurley wrote:
okay, well, that aside, the problem is in the domain name being passed. Pull
the query out of the error message and try to run it against your database
(logged in using the same user credentials that james connects with). My
thoughts are that either your domain name that is passed contains an invalid
character or is null, or that the table is either not readable by james or does
not contain any values that match.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org
