Dear colleagues,

I'm having a problem running my Creatio local environment when use PostgreSQL.

When start the app, I'm getting this error Exception Details: Npgsql.PostgresException: 28000: no hay una l�nea en pg_hba.conf para �fe80::1c5:206f:bef4:e3e9%13�, usuario �dev-toledano�, base de datos �Toledano8010�, sin cifrado

I have app and db in the same machine.

I saw I need to change the pg_hba.conf file, I did it, but get the same error. This is my file

# TYPE  DATABASE        USER            ADDRESS                 METHOD
 
#host all all 0.0.0.0/0 trust
 
# "local" is for Unix domain socket connections only
local   all             all                                     trust
#scram-sha-256
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     trust
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

And my ConnectionStrings.config file looks like

<?xml version="1.0" encoding="utf-8"?>
<connectionStrings>
  <add name="db" connectionString="Server=NoCodeServicesT;Port=5432;Database=Toledano8010;User ID=dev-toledano;password=dev-toledano;Timeout=500; CommandTimeout=400;MaxPoolSize=1024;" />
  <add name="redis" connectionString="host=localhost; db=2; port=6379" />
  <add name="defPackagesWorkingCopyPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\TerrasoftPackages" />
  <add name="tempDirectoryPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\" />
  <add name="sourceControlAuthPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\Svn" />
  <add name="elasticsearchCredentials" connectionString="User=gs-es; Password=DEQpJMfKqUVTWg9wYVgi;" />
  <add name="influx" connectionString="url=http://10.0.7.161:30359; user=; password=; batchIntervalMs=5000" />
  <add name="messageBroker" connectionString="amqp://guest:guest@localhost/BPMonlineSolution" />
</connectionStrings>

Somebody have some idea?

I never worked with PostgreSQL before 

Thanks in advance,

Best regards

Hello Team,

I am trying to insert a null guid directly to the DB. I use the following snippet

	QueryColumnExpression nullParameter =
					Column.Parameter(DBNull.Value, new GuidDataValueType(UserConnection.DataValueTypeManager));
				update.Set("ResponseDetailsId", nullParameter);

I get the following exception

System.NotSupportedException: The CLR type Terrasoft.Core.DB.QueryColumnExpression isn't supported by Npgsql or your PostgreSQL. If you wish to map it to a PostgreSQL composite type you need to register it before usage, please refer to the documentation.

 

If this is not a suitable way, which is the proper way to insert a null guid directly in a PostgreSQL db from C# code ?

Hi Community,

We decided to install a new Creatio Application instance on our linux based servers. We would like to know if we could use the lastest version of PostgreSQL (13 or 14)?

Thanks in Advance.

Best Regards,

Pedro Pinheiro

Team,

Trying to look for the "Indexing for full-text Search" option for a custom section in 7.17.2.1728_SalesTeam_Softkey_PostgreSQL_ENU and 7.17.3.1377_SalesTeam_Softkey_PostgreSQL_ENU packages deployed on-site. Though I find "Indexing for full-text Search" option in 7.17.3.1377 cloud instance, I am not able to find the same options in the site locally hosted in my laptop. Is there a way by which we can enable it?

Screenshot attached.