I’m having a bit of trouble connecting Razuna with a backend MS SQL instance. Basically what is happening is this: when I walk through the custom installation screens, I choose the option for MS SQL, plug in my server, port, db/schema info, username, password, etc, check connectivity to the DB (which passes), fill out the info on the remaining screens, and when prompted to Finalize the Setup, I click the button to do so.
At this point, the progress bar pretty much sits there doing nothing indefinitely. In SQL, I am seeing several tables being created, so something is working right, but the setup never in fact completes. If I switch to the embedded H2 DB, everything is golden and the finalize step completes super quick.
In the background, I’m seeing this in catalina.out:
±----------------±-
{ts ‘2017-04-04 21:20:20’} ---------------------- Creating new collections
{ts ‘2017-04-04 21:20:20’} — Executing Remove from Cron
{ts ‘2017-04-04 21:20:20’} ---------------------- Starting removal
{ts ‘2017-04-04 21:20:20’} ---------------------- Config Error. Aborting… !!!
±----------------±-
| type | Database
| detail | When connecting to the Database this error was reported: Feature not supported: "autoServerMode && (r
| message | General SQL Error
| errorcode | errorCode.sqlError
| extendedinfo |
| tagcontext | {CFML Type::array}
| sql | SELECT opt_id, opt_value
FROM options
WHERE opt_id LIKE ?
| nativeerrorcode | 50100
| sqlstate | HYC00
| queryError | Feature not supported: "autoServerMode && (readOnly || fileLockMethod == NO || fileLockMethod == SERI
| datasource | RAZUNA_SERVER
| tagname | CFQUERY
| template | /opt/razuna_tomcat_1_9_1/tomcat/webapps/razuna-searchserver/api/authentication.cfc
| line | 71
| column | 4
±----------------±-
{ts ‘2017-04-04 21:20:20’} — Executing Indexing from Cron
{ts ‘2017-04-04 21:20:20’} ---------------------- Config Error. Aborting… !!!
±----------------±-
| type | Database
| detail | When connecting to the Database this error was reported: Feature not supported: "autoServerMode && (r
| message | General SQL Error
| errorcode | errorCode.sqlError
| extendedinfo |
| tagcontext | {CFML Type::array}
| sql | SELECT opt_id, opt_value
FROM options
WHERE opt_id LIKE ?
| nativeerrorcode | 50100
| sqlstate | HYC00
| queryError | Feature not supported: "autoServerMode && (readOnly || fileLockMethod == NO || fileLockMethod == SERI
| datasource | RAZUNA_SERVER
| tagname | CFQUERY
| template | /opt/razuna_tomcat_1_9_1/tomcat/webapps/razuna-searchserver/api/authentication.cfc
| line | 71
| column | 4
±----------------±-
…over and over and over again until I back out of the process in the web UI and/or shutdown Tomcat. From what I can tell, it almost seems like it’s relying on H2 features despite choosing the option for MS SQL…I don’t know.
Everything so far has been relatively pain free and works as expected, but for some reason this one piece is really driving me crazy!
Platform is Ubuntu 16.04 LTS, Java 8