What is NocoDB, NocoDB is an open source platform that turns any database into a smart spreadsheet

NocoDB is an open source #NoCode platform that turns any database into a smart spreadsheet

Prerequisites

• Must haves

  • node.js >= 12 / Docker
  • MySql / Postgres / SQLserver / SQLite Database

• Nice to haves

  • Existing schemas can help to create APIs quickly.
  • An example database schema can be found here.

How to install on Ubuntu20.04

Step 1: git clone from github

root@SecondaryDataUse:~# pwd

/root

root@SecondaryDataUse:~# docker --version

Docker version 20.10.12, build e91ed57

root@SecondaryDataUse:~# git clone https://github.com/nocodb/nocodb

Cloning into 'nocodb'...

remote: Enumerating objects: 19393, done.

remote: Counting objects: 100% (19393/19393), done.

remote: Compressing objects: 100% (4904/4904), done.

remote: Total 19393 (delta 14256), reused 19179 (delta 14123), pack-reused 0

Receiving objects: 100% (19393/19393), 55.83 MiB | 11.48 MiB/s, done.

Resolving deltas: 100% (14256/14256), done.

Step 2: Install

root@SecondaryDataUse:~/nocodb# ls
docker-compose  lerna.json  LICENSE  package.json  package-lock.json  packages  README.md  scripts
root@SecondaryDataUse:~/nocodb# cd docker-compose/
root@SecondaryDataUse:~/nocodb/docker-compose# ls
letsencrypt  mssql  mysql  nginx-proxy-manager  pg  traefik
root@SecondaryDataUse:~/nocodb/docker-compose# pwd
/root/nocodb/docker-compose
root@SecondaryDataUse:~/nocodb/docker-compose# cd mysql/
root@SecondaryDataUse:~/nocodb/docker-compose/mysql# pwd
/root/nocodb/docker-compose/mysql
root@SecondaryDataUse:~/nocodb/docker-compose/mysql# ls
docker-compose.yml
root@SecondaryDataUse:~/nocodb/docker-compose/mysql# docker-compose up
Creating network "mysql_default" with the default driver
Creating volume "mysql_db_data" with default driver
Pulling root_db (mysql:5.7)...
5.7: Pulling from library/mysql
6552179c3509: Pull complete
d69aa66e4482: Pull complete
3b19465b002b: Pull complete
7b0d0cfe99a1: Pull complete
9ccd5a5c8987: Pull complete
2dab00d7d232: Pull complete
64d3afdccd4a: Pull complete
6992e58be0f2: Pull complete
67313986b81d: Pull complete
7c36a23db0a4: Pull complete
d34c396e3198: Pull complete
Digest: sha256:afc453de0d675083ac00d0538521f8a9a67d1cce180d70fab9925ebcc87a0eba
Status: Downloaded newer image for mysql:5.7
Pulling nocodb (nocodb/nocodb:latest)...
latest: Pulling from nocodb/nocodb
8572bc8fb8a3: Pull complete
1d839be1404d: Pull complete
856db2b5a5cb: Pull complete
288c08332050: Pull complete
f230aace0d23: Pull complete
Digest: sha256:349a00c8d0b09d9190c2daad29d56b63bd3300df3434a11aa76dc00d965abe15
Status: Downloaded newer image for nocodb/nocodb:latest
Creating mysql_root_db_1 ... done
Creating mysql_nocodb_1  ...
Creating mysql_nocodb_1  ... error

ERROR: for mysql_nocodb_1  Cannot start service nocodb: driver failed programming external connectivity on endpoint mysql_nocodb_1 (53120eddc397559f92e7eb94f38037307260044281a9b3ac2efa7c6f8352ec3e): Error starting userland proxy: listen tcp4 0.0.0.0:8080: bind: address already in use

ERROR: for nocodb  Cannot start service nocodb: driver failed programming external connectivity on endpoint mysql_nocodb_1 (53120eddc397559f92e7eb94f38037307260044281a9b3ac2efa7c6f8352ec3e): Error starting userland proxy: listen tcp4 0.0.0.0:8080: bind: address already in use
ERROR: Encountered errors while bringing up the project.
root@SecondaryDataUse:~/nocodb/docker-compose/mysql#

Fail reason: Because the port 8080 is using.

Check List Linux port with the command line:

root@SecondaryDataUse:~# netstat -ltnp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      562/sshd: /usr/sbin
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN      1864680/postgres
tcp        0      0 0.0.0.0:8088            0.0.0.0:*               LISTEN      1590294/docker-prox
tcp        0      0 0.0.0.0:8793            0.0.0.0:*               LISTEN      21740/gunicorn: mas
tcp        0      0 127.0.0.1:36829         0.0.0.0:*               LISTEN      1411629/uwsgi
tcp        0      0 127.0.0.1:8800          0.0.0.0:*               LISTEN      1402003/uwsgi
tcp        0      0 127.0.0.1:33060         0.0.0.0:*               LISTEN      703/mysqld
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      703/mysqld
tcp        0      0 127.0.0.1:6379          0.0.0.0:*               LISTEN      1394809/redis-serve
tcp        0      0 127.0.0.1:42989         0.0.0.0:*               LISTEN      1402003/uwsgi
tcp        0      0 127.0.0.1:8080          0.0.0.0:*               LISTEN      1411629/uwsgi
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      1402500/nginx: mast
tcp        0      0 0.0.0.0:8081            0.0.0.0:*               LISTEN      21678/gunicorn: mas
tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN      446/systemd-resolve
tcp6