---
# System prepended metadata

title: Cacoo database

---

# Cacoo database
Command:

Check all of port
ps aux | grep postgres

start Nulab account server
./gradlew cargoRunLocal --debug

lsof -i tcp:8080

New database:
```sql
ALTER TABLE public.slack_credential OWNER TO postgres;
ALTER sequence public.slack_credential_id OWNER TO postgres;
```
For database dev: Grant permission
```sql
CREATE ROLE "cacoo-service-legacy" with login PASSWORD "cacoo-service-legacy-password";
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ALL TABLES IN SCHEMA public to "cacoo-service-integration";
GRANT USAGE ON ALL SEQUENCES IN SCHEMA public to "cacoo-service-integration";

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO username;
GRANT ALL PRIVILEGES ON DATABASE "cacoo_activitylog" TO "cacoo-service-activitylog";



GRANT USAGE ON ALL SEQUENCES IN SCHEMA public to "cacoo-service-activitylog";
```

create error page when a logged managed account attempts to sign up

Remote login to Dev
```
psql -h cacoo.cwqrjfhptuuf.us-east-1.rds.amazonaws.com -p 5432 -U postgres cacoo

lDHol7BK9eAXM1dec07kVqvHqsQrvOdb
```