For older version SQLFlow under MacOS
This page is for SQLFlow 5.x.x.x
Please refer to the latest install manual if you are using the latest SQFlow(version > 6.0.0.0):
pageMacOSYou can check this page for the SQLFlow berfore version
pageSQLFlow before Version 6Prerequisites
Java 8
Nginx web server.
Port needs to be opened. (80, 8761,8081,8083. Only 80 port need to be opened if you setup the nginx reverse proxy as mentioned in the below)
At least 8GB memory
Setup Environment
Install Nginx
Upload Files
create a directory :
upload your backend and frontend file to sqlflow
folder, like this :
set scripts permissions :
Start Backend Services
If your computer has more than 8G of memory, you can change the boot parameters to recommended
Please use the gspLive.sh, eureka.sh and sqlservice.sh under mac directory instead of the original one.
/wings/sqlflow/backend/bin/gspLive.sh
/wings/sqlflow/backend/bin/eureka.sh
/wings/sqlflow/backend/bin/sqlservice.sh
start service in background:
please allow 1-2 minutes to start the service.
use jps
to check those 3 processing are running.
Java service port
File | Port |
---|---|
eureka.jar | 8761 |
gspLive.jar | 8081 |
sqlservice.jar | 8083 |
Nginx Reverse Proxy
If we set the reverse proxy path of gspLive restful service to /api
1. Config Nginx
open your nginx configuration file ( at /usr/local/etc/ngin/nginx.conf
), add a server :
2. modify frontend configuration file config.private.json
Open the configration file "/wings/sqlflow/frontend/config.private.json"
Modify the ApiPrefix attribute
Start Frontend Services
start your nginx :
or reload :
open http://yourdomain.com/ to see the SQLFlow.
open http://yourdomain.com/api/gspLive_backend/doc.html?lang=en to see the Restful API documention.
Sqlflow client api call
Get userId from gudu_sqlflow.conf
Open the configration file "/wings/sqlflow/backend/conf/gudu_sqlflow.conf"
The value of anonymous_user_id field is webapi userId
Note: on-promise mode, webapi call doesn't need the token parameter
Test webapi by curl
test sql:
curl command:
response:
If the code returns 401, please check the userId is set or the userId is valid.
Last updated