Title: [BUG] "PostgreSQL query failed: host resolves to a blocked IP address" · Issue #4319 · simstudioai/sim · GitHub
Open Graph Title: [BUG] "PostgreSQL query failed: host resolves to a blocked IP address" · Issue #4319 · simstudioai/sim
X Title: [BUG] "PostgreSQL query failed: host resolves to a blocked IP address" · Issue #4319 · simstudioai/sim
Description: Describe the bug Im trying to connect an AI agent to a local postgres DB but keep getting stuck on this error To Reproduce Create a block for PostgreSQL and use a local container name in the same docker network Expected behavior Connecti...
Open Graph Description: Describe the bug Im trying to connect an AI agent to a local postgres DB but keep getting stuck on this error To Reproduce Create a block for PostgreSQL and use a local container name in the same d...
X Description: Describe the bug Im trying to connect an AI agent to a local postgres DB but keep getting stuck on this error To Reproduce Create a block for PostgreSQL and use a local container name in the same d...
Opengraph URL: https://github.com/simstudioai/sim/issues/4319
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] \"PostgreSQL query failed: host resolves to a blocked IP address\"","articleBody":"**Describe the bug**\nIm trying to connect an AI agent to a local postgres DB but keep getting stuck on this error\n\n**To Reproduce**\nCreate a block for PostgreSQL and use a local container name in the same docker network\n\n**Expected behavior**\nConnection OK\n\n**Screenshots**\n\n\u003cimg width=\"1290\" height=\"828\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/e0f33ddf-f440-435c-b7ec-9943050f52f7\" />\n\n**Additional context**\nDocker stack im using via Swarm:\n```\nservices:\n simstudio:\n image: ghcr.io/simstudioai/simstudio:${VERSION}\n restart: unless-stopped\n ports:\n - '3010:3000'\n deploy:\n resources:\n limits:\n memory: 8G\n placement:\n constraints:\n - node.labels.env != db\n - node.labels.env != dmz\n environment:\n - NODE_ENV=production\n - DATABASE_URL=postgresql://${POSTGRES_USER:-postgres}:${POSTGRES_PASSWORD:-postgres}@db:5432/${POSTGRES_DB:-simstudio}\n - BETTER_AUTH_URL=${NEXT_PUBLIC_APP_URL:-http://10.10.144.81:3010}\n - NEXT_PUBLIC_APP_URL=${NEXT_PUBLIC_APP_URL:-http://10.10.144.81:3010}\n - BETTER_AUTH_SECRET=${BETTER_AUTH_SECRET}\n - ENCRYPTION_KEY=${ENCRYPTION_KEY}\n - API_ENCRYPTION_KEY=${API_ENCRYPTION_KEY:-}\n - INTERNAL_API_SECRET=${INTERNAL_API_SECRET}\n - REDIS_URL=redis://redis:6379/0\n# - COPILOT_API_KEY=${COPILOT_API_KEY}\n# - SIM_AGENT_API_URL=${SIM_AGENT_API_URL}\n - SOCKET_SERVER_URL=${SOCKET_SERVER_URL:-http://realtime:3002}\n - NEXT_PUBLIC_SOCKET_URL=${NEXT_PUBLIC_SOCKET_URL:-http://10.10.144.81:3002}\n - ADMISSION_GATE_MAX_INFLIGHT=${ADMISSION_GATE_MAX_INFLIGHT:-500}\n depends_on:\n - db\n - migrations\n - realtime\n healthcheck:\n test: ['CMD', 'curl', '-fsS', 'http://127.0.0.1:3000']\n interval: 90s\n timeout: 5s\n retries: 3\n start_period: 10s\n networks:\n - ssoc-soar-v2\n \n realtime:\n image: ghcr.io/simstudioai/realtime:${VERSION}\n restart: unless-stopped\n ports:\n - '3002:3002'\n deploy:\n resources:\n limits:\n memory: 1G\n placement:\n constraints:\n - node.labels.env != db\n - node.labels.env != dmz\n environment:\n - NODE_ENV=production\n - DATABASE_URL=postgresql://${POSTGRES_USER:-postgres}:${POSTGRES_PASSWORD:-postgres}@db:5432/${POSTGRES_DB:-simstudio}\n - NEXT_PUBLIC_APP_URL=${NEXT_PUBLIC_APP_URL:-http://10.10.144.81:3010}\n - BETTER_AUTH_URL=${BETTER_AUTH_URL:-http://10.10.144.81:3010}\n - BETTER_AUTH_SECRET=${BETTER_AUTH_SECRET}\n - INTERNAL_API_SECRET=${INTERNAL_API_SECRET}\n - REDIS_URL=redis://redis:6379/0\n depends_on:\n - db\n healthcheck:\n test: ['CMD', 'curl', '-fsS', 'http://127.0.0.1:3002/health']\n interval: 90s\n timeout: 5s\n retries: 3\n start_period: 10s\n networks:\n - ssoc-soar-v2\n \n migrations:\n image: ghcr.io/simstudioai/migrations:${VERSION}\n deploy:\n placement:\n constraints:\n - node.labels.env != db\n - node.labels.env != dmz\n restart_policy:\n condition: none\n working_dir: /app/packages/db\n environment:\n - DATABASE_URL=postgresql://${POSTGRES_USER:-postgres}:${POSTGRES_PASSWORD:-postgres}@db:5432/${POSTGRES_DB:-simstudio}\n depends_on:\n - db\n command: ['bun', 'run', 'db:migrate']\n networks:\n - ssoc-soar-v2\n \n db:\n image: pgvector/pgvector:pg17\n restart: unless-stopped\n deploy:\n placement:\n constraints:\n - node.labels.env != db\n - node.labels.env != dmz\n environment:\n - POSTGRES_USER=${POSTGRES_USER:-postgres}\n - POSTGRES_PASSWORD=${POSTGRES_PASSWORD:-postgres}\n - POSTGRES_DB=${POSTGRES_DB:-simstudio}\n - POSTGRES_HOST_AUTH_METHOD=scram-sha-256\n - POSTGRES_INITDB_ARGS=--auth-host=scram-sha-256\n volumes:\n - /mnt/nfs_share/ssoc/sim/postgres_data:/var/lib/postgresql/data\n healthcheck:\n test: ['CMD-SHELL', 'pg_isready -U postgres']\n interval: 30s\n timeout: 60s\n retries: 5\n networks:\n - ssoc-soar-v2\n \n postgres-alerts:\n hostname: soar-db-alerts\n image: postgres:18\n deploy:\n mode: replicated\n replicas: 1\n restart_policy:\n condition: on-failure\n delay: 15s\n max_attempts: 3\n placement:\n constraints:\n - node.labels.env == db\n environment:\n - POSTGRES_DB=alerts\n - POSTGRES_NON_ROOT_USER=n8n\n - POSTGRES_NON_ROOT_PASSWORD=REDACTED\n - POSTGRES_PASSWORD=REDACTED\n - POSTGRES_USER=root\n - TZ=Europe/Rome\n volumes:\n - /mnt/iscsi-n8n-dbalerts:/var/lib/postgresql/\n healthcheck:\n test: ['CMD-SHELL', 'pg_isready -h localhost -U root -d alerts']\n interval: 15s\n timeout: 5s\n retries: 10\n networks:\n - ssoc-soar-v2\n\n redis:\n hostname: soar-redis\n image: redis:7-alpine\n deploy:\n mode: replicated\n replicas: 1\n restart_policy:\n condition: on-failure\n delay: 5s\n max_attempts: 3\n placement:\n constraints:\n - node.labels.env != db\n - node.labels.env != dmz\n volumes:\n - /mnt/nfs_share/ssoc/n8n/redis_storage:/data\n healthcheck:\n test: ['CMD', 'redis-cli', 'ping']\n interval: 5s\n timeout: 5s\n retries: 10\n networks:\n - ssoc-soar-v2\n\n qdrant:\n image: qdrant/qdrant:${QDRANT_VERSION}\n hostname: qdrant\n deploy:\n mode: replicated\n replicas: 1\n restart_policy:\n condition: on-failure\n delay: 5s\n max_attempts: 3\n placement:\n constraints:\n - node.labels.env == db\n volumes:\n - \"/mnt/iscsi-qdrant:/qdrant/storage:z\"\n networks:\n - ssoc-soar-v2\n - waf\n\nnetworks:\n ssoc-soar-v2:\n external: false\n name: \"ssoc-soar-v2\"\n waf:\n external: true\n name: waf-cld_waf\n```","author":{"url":"https://github.com/xBounceIT","@type":"Person","name":"xBounceIT"},"datePublished":"2026-04-28T09:53:45Z","url":"https://github.com/simstudioai/sim/issues/4319"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:3733fc4b-6723-6492-a558-48ba0791d528 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | B89C:15DF38:72EA5C:9DAD57:6AFB42B3 |
| html-safe-nonce | 128195df4012fd573cc4d17bf09f6983581ad6dba01d3822b42b1b1ef2372e4d |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCODlDOjE1REYzODo3MkVBNUM6OURBRDU3OjZBRkI0MkIzIiwidmlzaXRvcl9pZCI6IjM4NjU3ODA1MDkxODg1OTQ0NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 9f23fa98aca778fe4c2c2bc1fc26406606a4f4e80c004e0d33b9bbdd34770f60 |
| hovercard-subject-tag | issue:4342177457 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/simstudioai/sim/4319/issue_layout |
| twitter:image | https://opengraph.githubassets.com/12a42df19394587eab4cf49ac352307f4dc6018c3e11e82b08dfcb9b8d8879ae/simstudioai/sim/issues/4319 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/12a42df19394587eab4cf49ac352307f4dc6018c3e11e82b08dfcb9b8d8879ae/simstudioai/sim/issues/4319 |
| og:image:alt | Describe the bug Im trying to connect an AI agent to a local postgres DB but keep getting stuck on this error To Reproduce Create a block for PostgreSQL and use a local container name in the same d... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | xBounceIT |
| hostname | github.com |
| expected-hostname | github.com |
| None | d849b928f455c800985398e7f1b659425adb312a5fa14fba5d9a14e62e9fe5dd |
| turbo-cache-control | no-preview |
| go-import | github.com/simstudioai/sim git https://github.com/simstudioai/sim.git |
| octolytics-dimension-user_id | 199344406 |
| octolytics-dimension-user_login | simstudioai |
| octolytics-dimension-repository_id | 912559512 |
| octolytics-dimension-repository_nwo | simstudioai/sim |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 912559512 |
| octolytics-dimension-repository_network_root_nwo | simstudioai/sim |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | a6c2f87cbcb6414452377b4967858ed6a66f1109 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width