postgres sslmode = require

[ledo]

how are the settings for CRM server set to be require on sslmode?

 

[ledo]

I thought a new template with the sslmode parameter would work

Started scenario with empty id
Request text: ConnectionString: Server=servername;Port=25061;Database=postgres;User Id=doadmin;Password=password;sslmode=require;
Statement: SELECT id as contactid, firstname as firstname, lastname as lastname, email as email , phone as phonebusiness, mobile as phonemobile, x_fax as faxbusiness FROM public.res_partner WHERE replace(replace(replace(replace(phone,' ',''),'-',''),'(',''),')','') LIKE '%551234%' or replace(replace(replace(replace(mobile,' ',''),'-',''),'(',''),')','') like '%551234%' or replace(replace(replace(replace(x_fax,' ',''),'-',''),'(',''),')','') LIKE '%551234%';

but get the result:
Couldn't set sslmode
Parameter name: sslmode ---> System.ArgumentException: Requested value 'require' was not found.


System.ArgumentException: Couldn't set sslmode
Parameter name: sslmode ---> System.ArgumentException: Requested value 'require' was not found.
at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
at Npgsql.NpgsqlConnectionStringBuilder.set_Item(String keyword, Object value)
--- End of inner exception stack trace ---
at Npgsql.NpgsqlConnectionStringBuilder.set_Item(String keyword, Object value)
at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
at Npgsql.NpgsqlConnection.GetPoolAndSettings()
at CrmIntegration.PostgresqlDatabaseClient.CreateConnection()
at CrmIntegration.SqlDatabaseClient.Execute(String statement, CancellationToken token)
at CrmIntegration.ScenarioProcessorBase.ProcessSQLDatabaseQuery(ISQLClientFactory sqlClientFactory, ScenarioQuery query, IValueManager customManager, CancellationToken token)
at CrmIntegration.ScenarioProcessorBase.ProcessScenario(ProtocolScenario scenario, IValueManager customManager, CancellationToken token)
at CrmIntegration.ScenarioProcessorBase.Execute(ProtocolScenario scenario, CancellationToken token)
at CrmIntegration.CrmProcessor.GetContactInfoFromCrm(String contactNumber, String destinationEmail, Boolean createIfNotFound, CancellationToken token)

 

[ledo]

is this driver >=8.0?

https://www.connectionstrings.com/postgresql/

SSL
Secure sockets layer for this driver only works from version 8.0 and above.

Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=myDataBase;
Uid=myUsername;Pwd=myPassword;sslmode=require;
Please note that sslmode=require is case sensitive, it should be written in lower case letters.

 

[edossantos]

3CX uses the npgsql client library:
https://www.npgsql.org/doc/connection-string-parameters.html

Probably the problem is the casing, it should be "Require" and not "require"...