Comments (4)
GuikiPT
commented on August 28, 2024
1
Ok, I let the server for the night open and updating, and for some reason the dns flushed somehow and start working.
For the wss:// I will try to set it in nginx, but these is in my side.
Will close these as the problem is fixed somehow.
For doc about the issue here's is my config for who is having same issues in the future:
cloudbeaver.conf:
{
server: {
serverPort: 8978,
workspaceLocation: "workspace",
contentRoot: "web",
driversLocation: "drivers",
sslConfigurationPath:"${CLOUDBEAVER_SSL_CONF_PATH:workspace/.data/ssl-config.xml}",
rootURI: "/",
serviceURI: "/api/",
productSettings: {
# Global properties
core.theming.theme: 'light',
core.localization.localization: 'en',
plugin.sql-editor.autoSave: true,
plugin.sql-editor.disabled: false,
# max size of the file that can be uploaded to the editor (in kilobytes)
plugin.sql-editor.maxFileSize: 10240,
plugin.log-viewer.disabled: false,
plugin.log-viewer.logBatchSize: 1000,
plugin.log-viewer.maxFailedRequests: 3,
plugin.log-viewer.maxLogRecords: 2000,
plugin.log-viewer.refreshTimeout: 3000,
sql.proposals.insert.table.alias: PLAIN
},
expireSessionAfterPeriod: 1800000,
develMode: false,
enableSecurityManager: false,
sm: {
enableBruteForceProtection: "${CLOUDBEAVER_BRUTE_FORCE_PROTECTION_ENABLED:true}",
maxFailedLogin: "${CLOUDBEAVER_MAX_FAILED_LOGINS:10}",
minimumLoginTimeout: "${CLOUDBEAVER_MINIMUM_LOGIN_TIMEOUT:1}",
blockLoginPeriod: "${CLOUDBEAVER_BLOCK_PERIOD:300}",
passwordPolicy: {
minLength: "${CLOUDBEAVER_POLICY_MIN_LENGTH:8}",
requireMixedCase: "${CLOUDBEAVER_POLICY_REQUIRE_MIXED_CASE:true}",
minNumberCount: "${CLOUDBEAVER_POLICY_MIN_NUMBER_COUNT:1}",
minSymbolCount: "${CLOUDBEAVER_POLICY_MIN_SYMBOL_COUNT:0}"
}
},
database: {
driver: "h2_embedded_v2",
url: "jdbc:h2:${workspace}/.data/cb.h2v2.dat",
initialDataConfiguration: "conf/initial-data.conf",
pool: {
minIdleConnections: 4,
maxIdleConnections: 10,
maxConnections: 100,
validationQuery: "SELECT 1"
},
backupEnabled: "${CLOUDBEAVER_DB_BACKUP_ENABLED:true}"
}
},
app: {
anonymousAccessEnabled: true,
anonymousUserRole: "user",
defaultUserTeam: "user",
grantConnectionsAccessToAnonymousTeam: false,
supportsCustomConnections: false,
showReadOnlyConnectionInfo: false,
systemVariablesResolvingEnabled: "${CLOUDBEAVER_SYSTEM_VARIABLES_RESOLVING_ENABLED:false}",
forwardProxy: true,
publicCredentialsSaveEnabled: true,
adminCredentialsSaveEnabled: true,
resourceManagerEnabled: true,
resourceQuotas: {
dataExportFileSizeLimit: 10000000,
resourceManagerFileSizeLimit: 500000,
sqlMaxRunningQueries: 100,
sqlResultSetRowsLimit: 100000,
sqlResultSetMemoryLimit: 2000000,
sqlTextPreviewMaxLength: 4096,
sqlBinaryPreviewMaxLength: 261120
},
enabledAuthProviders: [
"local"
],
disabledDrivers: [
"sqlite:sqlite_jdbc",
"h2:h2_embedded",
"h2:h2_embedded_v2",
"clickhouse:yandex_clickhouse"
],
disabledBetaFeatures: [
]
}
}
docker-compose.yml:
services:
cloudbeaver:
container_name: cloudbeaver
tty: true
stdin_open: true
restart: always
volumes:
- ./cloudbeaver.conf:/opt/cloudbeaver/conf/cloudbeaver.conf
image: dbeaver/cloudbeaver
network_mode: hostnginx:
server {
listen 443 ssl;
server_name dbeaver.guikipt.pt;
ssl_certificate /etc/nginx/certs/fullchain.pem;
ssl_certificate_key /etc/nginx/certs/privkey.pem;
ssl_protocols TLSv1.2 TLSv1.3;
ssl_ciphers HIGH:!aNULL:!MD5;
location / {
proxy_pass http://localhost:8978;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
}
}
server {
listen 80;
server_name dbeaver.guikipt.pt;
return 301 https://$host$request_uri;
}
Nginx proxy is missing webshocket that I will make it now, can update these comment later.
thx for the help.
from cloudbeaver.
Wroud
commented on August 28, 2024
Hi, I can open your host, and it works fine. The only issue that I noticed is that websocket is not connected (if you still get these errors after finishing the configuration, then you will probably need to configure nginx)
Also, I would strongly suggest not exposing your server globally before finishing the configuration.
from cloudbeaver.
GuikiPT
commented on August 28, 2024
Update, solve the webshocket issues by updating my nginx config with
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
Final version:
server {
listen 443 ssl;
server_name dbeaver.guikipt.pt;
ssl_certificate /etc/nginx/certs/fullchain.pem;
ssl_certificate_key /etc/nginx/certs/privkey.pem;
ssl_protocols TLSv1.2 TLSv1.3;
ssl_ciphers HIGH:!aNULL:!MD5;
location / {
proxy_pass http://localhost:8978;
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
}
}
server {
listen 80;
server_name dbeaver.guikipt.pt;
return 301 https://$host$request_uri;
}
from cloudbeaver.
EvgeniaBzzz
commented on August 28, 2024
Thank you for your update!
from cloudbeaver.
Related Issues (20)
- Global default setting for commit behavior HOT 3
- shared connections HOT 1
- UUID type trino - no icon HOT 1
- Allow filtering Query manager based on fields HOT 1
- Needed full timestamp for date columns in "Result view/Data view" (milliseconds precision 6+) HOT 1
- [Documentation] Where I can find the specification of data-sources.json HOT 1
- CloudBeaver container with TimescaleDB HOT 3
- QMDB - housekeeping HOT 5
- Results 'XX' not found in context XXXX@XXXX HOT 3
- Issue with SQL Editor Disconnecting While Editing Saved Script HOT 10
- Add configuration for full-name parameter from auth proxy HOT 5
- Support for multiple LDAP hosts HOT 1
- Container becomes inaccessible after restarting container after setting reverse proxy header authentication HOT 2
- Reverse proxy header authentication does not work HOT 5
- LDAPS support ? HOT 7
- HTTP ERROR 403 Forbidden HOT 5
- Export TXT replaces newline character HOT 1
- SQL Error [S1000]: arraycopy: last source index 128 out of bounds for byte[108] HOT 3
- Unable to add cockroachdb-driver in cloudbeaver-ce HOT 5
- set default schema on the connection definition HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cloudbeaver.