clio | Community Creatio

Idea

Discussion

Development

clio

#MacOs

Clio is not just for Windows

clioX

01:07 Nov 03, 2023

Clio explorer this is extension for VS Code, which provides convenient user interface over clio. Both tools are compatible with MacOS and Linux.

P.S. Also we added in clio 6.0.2.8 basic yaml for GitLab CICD pipelines

Do you like this idea?

0 comments

Show all comments

Question

clio

docker

7.18

Running clio in Docker on Ubuntu 20.04

Alex

22:50 Jun 27, 2023

Hi there!
I'm trying to run clio in Docker on Ubuntu Server 20.04.
Following instructions provided here - https://github.com/Advance-Technologies-Foundation/clio#installation-an…, I have downloaded the source code, and executed "docker build -f ./install/Dockerfile -t clio ."
But I got unexpected output, and, seems, clio container did not even started:

DEPRECATED: The legacy builder is deprecated and will be removed in a future release.
            Install the buildx component to build images with BuildKit:
            https://docs.docker.com/go/buildx/
 
Sending build context to Docker daemon  2.899MB
Step 1/13 : FROM mcr.microsoft.com/dotnet/sdk:3.1 as base
 ---&gt; 1e8401d05dea
Step 2/13 : WORKDIR /app
 ---&gt; Using cache
 ---&gt; 18f52a48e0a5
Step 3/13 : FROM mcr.microsoft.com/dotnet/sdk:3.1 AS build
 ---&gt; 1e8401d05dea
Step 4/13 : WORKDIR /app
 ---&gt; Using cache
 ---&gt; 18f52a48e0a5
Step 5/13 : COPY clio clio
 ---&gt; Using cache
 ---&gt; fa0fb42a25ec
Step 6/13 : COPY clio.sln clio.sln
 ---&gt; Using cache
 ---&gt; d8527c9fcc93
Step 7/13 : WORKDIR /app/clio
 ---&gt; Using cache
 ---&gt; f4ae3f90ec62
Step 8/13 : RUN dotnet publish -c Release -o /app/published
 ---&gt; Running in 432ba7ef38dd
Microsoft (R) Build Engine version 16.7.3+2f374e28e for .NET
Copyright (C) Microsoft Corporation. All rights reserved.
 
  Determining projects to restore...
/app/clio/clio.csproj : error NU1202: Package DocumentFormat.OpenXmlSDK 2.0.0 is not compatible with net6.0 (.NETCoreApp,Version=v6.0). Package DocumentFormat.OpenXmlSDK 2.0.0 supports: net35 (.NETFramework,Version=v3.5)
  Failed to restore /app/clio/clio.csproj (in 6.4 sec).
The command '/bin/sh -c dotnet publish -c Release -o /app/published' returned a non-zero code: 1

2 comments

Alex

22:49 Jun 28, 2023

Anybody, please, help!

Alla Blinova

10:48 Jul 05, 2023

Hi!

Based on the issue you are experiencing with running Clio Docker on Ubuntu 20.04, it seems to be related to compatibility or configuration problems. To address this, I would recommend following these steps:

Make sure you have met the minimum system requirements for running Clio Docker on Ubuntu 20.04. Check the official documentation for any specific prerequisites.
Double-check that you have correctly followed the installation steps outlined in the documentation or guide provided by Clio.
If the issue persists, I suggest visiting the Clio GitHub repository for more information and possible solutions. You can access the repository at the following link: GitHub Repository. Please search for any existing issues that match your problem or consider opening a new issue to report your specific problem. GitHub representatives and the community can provide further assistance and guidance in troubleshooting the issue.

Remember to provide as much detail as possible when reporting the issue, including any error messages or logs you have encountered. This will help the GitHub community understand and address your problem more effectively.

I hope this helps.

Show all comments

Idea

Discussion

clioX

18:09 Jan 31, 2023

Hi everyone! We have released a new version of Clio and Clio Explorer.

What's new:

.NET 6 is supported and Clio is now compatible with iOS on M series processors.
OAuth settings are supported in the UI for easy connection with the Creatio trial version.
Quick access to all Clio settings in Clio Explorer for advanced users.
Support for working with auto-generated code in the package assembly for local development in workplaces.

Do you like this idea?

3 comments

clioX

23:11 Jan 31, 2023

Links on Clio explorer and clio

Damien Collot

14:42 Feb 22, 2023

You might want to reclassify as "Article" :)

Sasori Oshigaki

15:31 Feb 22, 2023

Clio explorer seems awsome. Kudos to the team

Show all comments

Question

clio

404

Clio - execute-sql-script - Error

Uriel Nusenbaum

03:51 Jul 12, 2022

Hi Community!

I'm expericing an error when using clio utility to run SQL in SQL Server or PostgreSQL cloud enviroments

Below the error:

System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Creatio.Client.ATFWebRequestExtension.GetServiceResponse(HttpWebRequest request)
at Creatio.Client.CreatioClient.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)
at Clio.Common.CreatioClientAdapter.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)
at Clio.Common.SqlScriptExecutor.Execute(String sql, IApplicationClient applicationClient, EnvironmentSettings settings)
at Clio.Command.SqlScriptCommand.SqlScriptCommand.Execute(ExecuteSqlScriptOptions opts)

Everything works as expected in local enviroments. I tried using the sql command directly or using sql file.

I found this article (https://community.creatio.com/questions/clio-error-when-running-sql-que…) with the same issue but the answer suggest to try the same in local enviroments. I did it and it works in local enviroments.

Regards.

1 comments

Best reply

Oleg Drobina

13:50 Jul 13, 2022

Hi Uriel,

Before executing the SQL query in the cloud-based app you need to also install clio-gate that is not installed in the cloud apps by default. To do this execute the following command in clio:

clio.exe install-gate -e DemoTest

where DemoTest should be replaced with your registered environment name (more information can be found using

clio install-gate --h

command). Once the gate is installed you need to perform a restart using this command:

clio restart -e DemoTest

once again DemoTest should be replaced with your registered environment name. And finally, demo applications are deployed using PostgreSQL and you need to use the file with the command to properly execute it. So after that you need to execute:

clio execute-sql-script -f C:\Users\O.Drobina\Documents\clio\Contact.sql -e DemoTest

where C:\Users\O.Drobina\Documents\clio\Contact.sql should be replaced with the directory where the needed file with SQL query is located, DemoTest - use your registered environment name.

After that you will be able to get the result of the query.

Best regards,

Oscar

Oleg Drobina

13:50 Jul 13, 2022

Hi Uriel,

Before executing the SQL query in the cloud-based app you need to also install clio-gate that is not installed in the cloud apps by default. To do this execute the following command in clio:

clio.exe install-gate -e DemoTest

where DemoTest should be replaced with your registered environment name (more information can be found using

clio install-gate --h

command). Once the gate is installed you need to perform a restart using this command:

clio restart -e DemoTest

clio execute-sql-script -f C:\Users\O.Drobina\Documents\clio\Contact.sql -e DemoTest

where C:\Users\O.Drobina\Documents\clio\Contact.sql should be replaced with the directory where the needed file with SQL query is located, DemoTest - use your registered environment name.

After that you will be able to get the result of the query.

Best regards,

Oscar

Show all comments

Question

clio

7.18

Clio error when running sql query

Javier Collazo

21:31 Feb 23, 2022

Hi,

When trying to run a sql query in clio against a Creatio cloud environment I'm getting this eror:

System.Net.WebException: The remote server returned an error: (404) Not Found.

at System.Net.HttpWebRequest.GetResponse()

at Creatio.Client.ATFWebRequestExtension.GetServiceResponse(HttpWebRequest request)

at Creatio.Client.CreatioClient.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)

at Clio.Common.CreatioClientAdapter.ExecutePostRequest(String url, String requestData, Int32 requestTimeout)

at Clio.Common.SqlScriptExecutor.Execute(String sql, IApplicationClient applicationClient, EnvironmentSettings settings)

at Clio.Command.SqlScriptCommand.SqlScriptCommand.Execute(ExecuteSqlScriptOptions opts)

Any thoughts?

1 comments

Oleg Drobina

09:07 Feb 24, 2022

Hi,

It's impossible to determine the reason without reviewing the logs. You need to try running the same command using a local copy of the app hosted in cloud, get the error message and review the application logs. Also sine this is a PostgreSQL command review the command itself and check if all tables and columns in the query are double-quoted and the register is correct.

Best regards,

Oscar

Show all comments

Question

clio

cloud sites with clio

Federico Buffa

14:26 Feb 01, 2022

Hi Teams,

Somebody knows if there is a way to user clio with cloud sites? or install packages without using UI?

1 comments

Anastasiia Lazurenko

19:30 Feb 02, 2022

Hello Federico,

Thank you for your question.

Please, refer to the following:

clio push-pkg <package name here> --uri https://mysite.creatio.com --Login UserLogin --Password UserPassword

Please, replace <package name here> with your package name, https://mysite.creatio.com with the URL to the target app, UserLogin with the login to the target app, UserPassword with the target app password.

The information about Clio can be found on the github of its developers: https://github.com/Advance-Technologies-Foundation

We recommend testing it on your development instance/sandbox etc first before doing it on your production website.

Best regards,

Anastasiia

Show all comments

Question

clio

compile all site using clio.exe

Federico Buffa

14:52 Jan 10, 2022

Hi Teams.

There is a way to perform a compile all using clio.exe?

1 comments

Anastasiia Lazurenko

18:56 Jan 10, 2022

Hello Federico,

All the information about Clio can be found on the github of its developers: https://github.com/Advance-Technologies-Foundation

Please, refer to the article below which you might find useful:

https://github.com/Advance-Technologies-Foundation/clio/wiki/Build-work…

Kind regards,

Anastasiia

Show all comments

Question

clio

package

Sales_Creatio_enterprise_edition

Command-line interface for Creatio DotNet Core Package

Anupama

18:37 Sep 16, 2021

Hello Team,

Facing some issues while registering DotNet Core Package on version 7.18. Currently all our development activities were performed in Windows OS and later we would have to package it and deploy in Client OS which is Linux.

So the blocker right now is we are getting error while registering our local instance and it gives 404 error. I understand that the Clio tool is compatible with DotNet Framework so would like to know if there is any other methodology for generating package in DotNet Core.

Appreciate your immediate response. Thank you!

File attachments

clio_Reg_error.jpg

4 comments

Oleg Drobina

13:33 Sep 17, 2021

Hello Anupama,

I tried replicating the same error message on my side, tried several configurations (including deleting Terrasoft.WebApp reference in IIS, different URLs with the / at the end and port numbers, localhost and actual domain name). I wasn't able to receive the same error:

Are you using the latest clio binary files (they can be found here)? Also can you login to the application from the browser directly? And have I understood you right that you are trying to login to the .NET Core app (localhost:5020)?

Anupama

17:24 Sep 17, 2021

Oscar Dylan,

Thanks Oscar for your response.

Yes I am using Dotnet core package and as it is not hosted on IIS and on Kestrel, I am wondering if that is the reason why I am getting 404. To check how the clio command works, I tried hosting dotnet framework package on IIS and the clio command responded successfully.

Is there any settings that I am missing for the clio to respond for Dotnet Core package.

Thanks

Anupama

Oleg Drobina

17:34 Sep 17, 2021

Anupama,

I've also successfully logged into the .NET Core app (but it's hosted on Linux) using clio:

There shouldn't be any specific setting. Can you try re-deploying your local app using .Net Core and hosted on Linux? Also don't you receive any errors in the application logs at the moment of the connect? Logs of the .Net Core app are located in the Logs folder of the root application directory:

Anupama

18:06 Sep 17, 2021

Oscar Dylan,

It seems to be the Url format which is different for Creatio Dotnet Core and Dotnet Framework package.

I tried by removing the forward slash from the Url and it did worked and I am able to generate the package.

Thanks for the suggestion shared earlier in of your messages.

Now we are experiencing another issue. We are running the SonarQube in our project file to do a code quality analysis. So the package includes an Object Code along with the source Code and which is hindering the successful installation of the package.

Is there any way to ignore that file as I didn't find any ignore command in the github .

Show all comments

Subscribe to clio