Ir al contenido principal

How to Use SSL in Sage Enterprise Management (Sage X3)

Many companies that use Sage Enterprise Management (Sage X3) choose to have their Syracuse Web Server exposed to the internet for ease of access – no VPNs or remote desktop services to use – but making the connection open to the public internet exposes your web server/data to attack. Security is a necessity, as organizations need to keep their data private and secure.

Using an SSL (secure socket layer) connection with a certificate from a trusted Certificate Authority protects the confidentiality and integrity of company data exchanged online. SSL is the standard security technology for establishing an encrypted link between a web server and a browser; this encrypted link will ensure that the data exchanged between the user and the web server is transmitted securely and remains private. Any Sage Enterprise Management exposed to the public internet should use SSL to secure its connection with the users and protect company data.

Below are instructions on how to use SSL in Sage Enterprise Management.

Use an SSL tool like OpenSSL to create a certificate request (*.csr file) and a private key (*.key file) on your Syracuse Server.

The installation of the Safe Enterprise Management Web Server component will create OpenSSL binaries in the Sage\SafeEnterprise Management\Web\tools\SOFTS\HTTPD\bin folder. The exact path depends on the path specified during installation of the Web Server component.

  • Open a Windows Command Prompt and run the following: set OPENSSL_CONF=C:\Sage\SafeEnterprise Management\WEB235.2\tool\SOFTS\HTTPD\conf\openssl.cnf
  • In the Windows Command Prompt, browse to the bin folder noted previously and run the following: openssl req -out myCompany.csr -new -newkey rsa:2048 -nodes -keyout myCompany.key (myCompany is the name of your company)
  • The previous step will create a *.csr and a *.key file. Keep the key file in a secure location, as you’ll need it in the following steps.
  • Send the certificate request (*.csr) file to a Certificate Authority of your choice. They’ll generate the certificate file (*.crt) and provide either send the file to you or offer access to download it.

Create the certificate to be used by Sage Enterprise Management.

  • Browse to Administration, Certificates, Certificates, and click +New certificates
  • Provide the name used to reference the certificate information.
  • Description is optional.
  • In the Certificate section, drag/drop the *.crt file received from the certificate authority.
  • In the Private Key section, drag/drop the *.key file generated in step 1b. Do not leave this section blank even though it is not marked as required.
  • Enter a Passphrase.
  • Leave the CA Certificates/Server sections blank unless you know why you’re entering values here.
  • Click Save. If clicking Save does nothing, the private key and certificate files may not match. Sage Enterprise Management could also be detecting that the files are not valid or in the wrong format.


Configure the Sage Enterprise Management host to use SSL and the certificate created in the previous step.

  • Have all users exit the system. Any users still logged in will be disconnected from the system during the following steps.
  • Browse to Administration, Servers, Hosts, and click the pencil icon. If you have multiple hosts, choose the one marked as Started.
  • Check the box for
  • In the Server Certificates field, click the browse button and choose the certificate you created in step 3.
  • You may leave the Port field unchanged (default is 8124) or change it to the industry standard of 443 for SSL. If the port is changed, your IT professionals will need to configure the network and firewall with the correct routing information for the newly defined port.

Warning: If there is a problem with certificate setup, the certificate files, or the port, you may be locked out of Enterprise Management after the Syracuse service restarts in the following step.

To prevent this from happening, you can add another connection and configure it to use another port by clicking on the blue plus symbol instead of modifying the original one. This way, Syracuse will be listening on two ports.

You would only enable SSL for one of these connections and ports. If there is a problem with the SSL configuration, you can fall back on the other connection and port which was not changed.

Click Save.

  • You may or may not be prompted to restart the Syracuse service, but restart whether you’re prompted to or not.
  • All users must be logged out or they will be forcefully disconnected.
  • If the Syracuse service was restarted after responding to the prompt, it may not start automatically and will require you to do it manually.
  • If the Syracuse service does not stop/start in a timely manner, use the Task Manager to end all node.exe processes. Once they are ended, you should be able to start the Syracuse service.

So much of your data should never been seen by outside eyes, so connecting it to the public internet simply for ease of access is a poor idea. Instead, you should use an SSL (secure socket layer) connection with a certificate from a trusted Certificate Authority to protect the confidentiality and integrity of company data exchanged online.

Entradas populares de este blog

Valores de fstat

Fstat fstat  is a numeric status that is returned upon execution of a database operation, a sequential file operation, or a lock instruction. Syntax fstat Examples # MYTABLE is a table with a key called KEY1, that has a unique component called KEYVAL # Create a record in the table MYTABLE with they key value 1 if it doesn't exist Local File MYTABLE [MYT] Read [MYT]KEY1=1 If fstat [MYT]KEYVAL=1 : Write [MYT] If fstat MSG="The key was created in the mean time" Else MSG="Key created" Endif Else MSG="Key already exists" Endif Details fstat  is always set to '0' if the operation is successfully completed, and has a non-null value if there is an error: In a sequential read ( Getseq  and  Rdseq ),  fstat  is set to '1' at the end of the file. On  Lock ,  fstat  is set to '1' if the lock could not be performed. For a database operation ( Read ,  Look ,  Readlock ,  For ,  Write ,  ...
Leer más

3 ways to send a mail from code in Sage X3, with more attachments too

Origen Fuente:  https://en.sagedev.it/sagex3/send-mail-from-code-with-attachments-sage-x3/ Autor:  https://en.sagedev.it/category/sagex3/ In this post I’ll show you how to send a mail from adonix code in Sage X3. The points we will face are: 1) Meladx/Send introduction 2) Sending  through  meladx (the best way for me: at the end with just a single code line you send a mail!) 3) Sending  through  Workflow 4) Sending  through  ENVOI_MAIL(…) From AWRKMEL Sending mail from code in Sage X3: Send vs meladx Sage X3 has two native ways for sending mails. The first way is  meladx  executable file, that you can find in  runtime\bin  directory. The seconde one is Send instruction, that was used to send mail through an application of the client station (for more information on “Send GSERMES”  go here ). The Meladx executable Meladx send messages through SMTP/POP3 protocols by means of the mail  ...
Leer más

How to Install and Manage Sage X3 Add-Ins in Microsoft Office

When you enable an add-in, it adds custom commands and new features to Microsoft Office programs that help increase your productivity. In this blog post, we’ll review how to install the Sage X3 Add-In for MS Excel and what to do if your Sage X3 Add-In is missing. Fuente original: https://www.netatwork.com/how-to-install-and-manage-sage-x3-add-ins-in-ms-office/ How to Install the Sage X3 Add-In in Microsoft Excel Go to Administration > Utilities > Installation > Install addins for Office V11 Image:   V12 Image:   It should begin downloading the exe, open the exe Next > Install   Open Excel > File > Options   Select Add–Ins > Manage: COM Add-ins > Go   Check the “Excel AddIn for Sage” > Ok   You are now ready to export Excel-based reports/grids from Sage X3. How to troubleshoot and fix a missing Sage X3 add-in in Microsoft Excel Open the Microsoft Office product where the  Sage X3  add-in is missing. Go to Options: Se...
Leer más