bug while loading config.tdsl (#1385)

Closed

Activities

Unknown opened 5 years ago

in the config.tdsl, authRepository bean definition while using :

cls = 'tigase.db.jdbc.TigaseCustomAuth'

.. defining customer login query:

'user-login-query' = '{call tig_user_login(?,?,'domainname','suspend','true')}'

when the file is loaded, i can see all the properties are loaded successfully apart from the user-login-query, it is loaded like this !!: file: tigase-console.log

'user-login-query' = ')}'

and keep getting below exception

tigase.db.TigaseDBException: Problem accessing repository.
        at tigase.db.jdbc.TigaseCustomAuth.userLoginAuth(TigaseCustomAuth.java:995)
        at tigase.db.jdbc.TigaseCustomAuth.access$000(TigaseCustomAuth.java:79)
        at tigase.db.jdbc.TigaseCustomAuth$1.verifyPlainPassword(TigaseCustomAuth.java:379)
        at tigase.auth.impl.PlainCallbackHandler.handleVerifyPasswordCallback(PlainCallbackHandler.java:159)
        at tigase.auth.impl.PlainCallbackHandler.handleCallback(PlainCallbackHandler.java:117)
        at tigase.auth.impl.PlainCallbackHandler.handle(PlainCallbackHandler.java:65)
        at tigase.auth.mechanisms.AbstractSasl.handleCallbacks(AbstractSasl.java:72)
        at tigase.auth.mechanisms.SaslPLAIN.evaluateResponse(SaslPLAIN.java:80)
        at tigase.xmpp.impl.SaslAuth.process(SaslAuth.java:198)
        at tigase.server.xmppsession.SessionManager$ProcessorWorkerThread.process(SessionManager.java:2587)
        at tigase.util.processing.WorkerThread.run(WorkerThread.java:68)
Caused by: java.sql.SQLException: Could not set parameter at position 1

i tried to remove the line and adding it again, remove spaces add spaces, nnothing works.

Unknown commented 5 years ago

additional info:

i made another stored procedure to test : delimiter //

create procedure tig_user_loginp (in p_user_name varchar(200), in p_password varchar(100) )

when i used it, it loaded successfully.

i think there is bug when loading long procedure ?

Unknown commented 5 years ago

There is no issue with loading and using procedures, but TDSL keeps strings within ' chars and you've used unescaped ' chars within your SQL query, which confused TDSL parser and caused this issue.

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/server-core#1385