Skip to main content

Connect to the FairCom server

The FairCom server provides services over TCP/IP ports and shared memory. These services include APIs and browser-based applications for managing and exploring the server. The following tables contain common connection strings and ports.

Table 1. FairCom DB default connection strings

Protocol

Connection string

ADO.NET

User ID=ADMIN;Password=ADMIN;database=ctreeSQL;server=localhost;port=6597

Apps

http://localhost:8080

Apps secure

https://localhost:8443

ISAM

FAIRCOMS@localhost:5597

iSQL

isql -u ADMIN -p ADMIN 6597@localhost:ctreeSQL

iSQL secure

isql -u ADMIN -p ADMIN ssl:6597@localhost:ctreesql

JDBC

getConnection("jdbc:ctree://localhost:6597/ctreeSQL", "ADMIN", "ADMIN")

JSON APIs

POST a JSON document to http://localhost:8080/api"

JSON APIs secure

POST a JSON document to https://localhost:8443/api"

PHP SQL

ctsql_connect(":6597@localhost:ctreeSQL", "ADMIN", "ADMIN")

Python SQL

pyctree.connect(user='ADMIN',password='ADMIN',database='ctreeSQL',host='localhost',port='6597')



Table 2. FairCom Edge and FairCom MQ default connection strings

Protocol

Connection string

ADO.NET

User ID=ADMIN;Password=ADMIN;database=faircom;server=localhost;port=6597

Apps

http://localhost:8080

Apps secure

https://localhost:8443

ISAM

FairCom Edge: FAIRCOMS@localhost:5597 and FairCom MQ: FCEDGEMQ@localhost:5597

iSQL

isql -u ADMIN -p ADMIN 6597@localhost:faircom

iSQL secure

isql -u ADMIN -p ADMIN ssl:6597@localhost:faircom

JDBC

getConnection("jdbc:ctree://localhost:6597/faircom", "ADMIN", "ADMIN")

JSON APIs

POST a JSON document to http://localhost:8080/api"

JSON APIs secure

POST a JSON document to https://localhost:8443/api"

PHP SQL

ctsql_connect(":6597@localhost:faircom", "ADMIN", "ADMIN")

Python SQL

pyctree.connect(user='ADMIN',password='ADMIN',database='faircom',host='localhost',port='6597')



See also:

Troubleshoot Connections

If the port is not working, check the following:

  1. Ensure the FairCom server is running.

  2. Ensure your firewall is not blocking the port.

  3. Check to see if another application is already using the port.

Tip

If the localhost domain name does not work, use the IP Address 127.0.0.1.

Note

FairCom's JSON APIs and its browser applications run on ports 8080 and 8443.

If Google Chrome requires that the FairCom server needs a valid certificate, see Solve certificate security problems in Google Chrome.

Connect to the browser applications using http://localhost:8080/ or https://localhost:8443/.

Connect to JSON APIs using http://localhost:8080/api or https://localhost:8443/api.

Transport Layer Security (TLS) is a secure way for computers to communicate. It uses encryption, a certificate file , and a private key file to create secure communications between computers. TLS was formerly called Secure Sockets Layer (SSL). FairCom products support TLS 1.3, which is the latest version.

MQTTWS

WebSocket (WS) is a standard communication protocol for bidirectional exchange of data between computers, see RFC 6455. It works over TCP/IP and HTTP. It is often used by single page web applications because web browsers have built in support for WebSocket. It is also used by applications and servers that want to push messages to other computers in additional to using the request-response provided by HTTP.

Hypertext Transfer Protocol (HTTP) is a standard request-response protocol that works on top of TCP/IP. It allows a client computer to send a request to a server computer, which in turn, replies to the request. The purpose of HTTP is to allow software to ask questions and receive answers.