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
Answered
Connect-app-symphony-to-sql-server: problem with ODBC driver 17.

Hello guys,
Hope you are doing well at you looking this post.

I have some issue on my production environment. I want to connect app symphony to one remote sql server as https://ip_adress:1433 but i have some error like:

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746

I search solutions on multiple platform but anything solve it.

I think is TLS / SSL issue because when i curl http//ip_address:1433 i have error curl(56)....but when i curl https://ip_address:1433 i have some response.

So i want to know how configure connection secure between app symphony and sql server.

  
  
Posted 2 years ago
Votes Newest

Answers


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 2 years ago
Kaosar Ahmed
310 × 3 Administrator
5K Views
1 Answer
2 years ago
2 years ago
Tags