Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Unanswered
Connect-app-symphony-to-sql-server: problem with ODBC driver 17.


Hello Hermann,

Thank you for your question in the Symphony Forums.

After initialling reviewing your questions on the internet - it seems the issue might be more on the configuration of the SQL side. Most articles do point towards ensuring that you are enforcing all connections on your application with at least TLS 1.2.

Depending on the current configurations you are using at the moment it may fall back to a lower version of TLS 1.x - so you will need to make sure that all existing and future connections are TLS 1.2.

With security cipher protocols - it is advised to use TLS 1.2 - I have provided a example on the minimum configuration that Symphony related components would accept. You can review your existing congifuration and check if they are compliant.

--server.ssl.enabled-protocols=TLSv1.2
--server.ssl.protocol=TLS
--server.ssl.ciphers=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA,TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA

Please let us know should you have any further questions or feedback.

  
  
Posted one year ago
Kaosar Ahmed
310 × 3 Administrator
125 Views
0 Answers
one year ago
one year ago