kelbs Posts - Answer Overflow

kelbs

Explore posts from servers

CDCloudflare Developers KKysely DTDrizzle Team

•Created by kelbs on 3/10/2024 in #general-help

block malicious probing requests

my web app gets requests like these:

get myapp.com/wp-login.php
get myapp.com/sitemap.xml
get myapp.com/.git/config
get myapp.com/wp-content/themes/sketch/404.php

get myapp.com/wp-login.php
get myapp.com/sitemap.xml
get myapp.com/.git/config
get myapp.com/wp-content/themes/sketch/404.php

which seem to be probing for vulnerabilities since none of the urls exist and e.g. my site isn't a wordpress site. Is there any way to easily block these? I could create WAF custom rules but would that turn into wack-a-mole if I need to manually specify every invalid URL being requested? I'm currently on the free plan so I could upgrade to pro to enable more managed rules, but its unclear to me if that'll solve the issue. It's not a lot of traffic so its not hurting too much. The biggest annoyance for me is it creates errors in my observability data, making it harder to find real issues amongst these phantom issues.

7 replies

CDCloudflare Developers

•Created by kelbs on 3/9/2024 in #workers-help

Cloudflare workers vs pages

I'm building a full stack sveltekit app (svelte code on both frontend and backend). I'm confused whether I should deploy it to cloudflare workers or cloudflare pages? On one hand, it seems like pages is intended for static sites and workers is intended for dynamic backends. On the other hand, I see conflicting information where it seems sites deployed to pages can have dynamic backend content. What things should I consider when picking workers vs pages?

9 replies

DTDrizzle Team

•Created by kelbs on 4/2/2023 in #help

drizzle bug won't let me update mysql table

wrote a bug ticket on github describing the bug but just wanted to post here as well for visibility https://github.com/drizzle-team/drizzle-orm/issues/364 I think its because of reserved words in the table name

12 replies

DTDrizzle Team

•Created by kelbs on 4/2/2023 in #help

Generated Collate value

Not sure if this is relevant but I'm translating a Prisma schema into drizzle. Every Prisma table had COLLATE utf8mb4_unicode_ci; added to the generated MySQL. One of my drizzle tables instead has COLLATE utf8mb4_0900_ai_ci; I'm not good enough at dbs/sql to know if this is important, a bug, or irrelevant

8 replies

DTDrizzle Team

•Created by kelbs on 4/1/2023 in #help

What does MySQL bigint config mode do?

In a mysql schema, when creating a bigint, it wants a config object with a mode key where mode could be number. What does this do?

9 replies

DTDrizzle Team

•Created by kelbs on 4/1/2023 in #help

MySQL unique constraint

In the drizzle schema, is there a way to label a column with unique constraint in mysql? I'm only seeing uniqueIndex

5 replies

DTDrizzle Team

•Created by kelbs on 4/1/2023 in #help

Error querying planetscale db

Trying to get setup with drizzle and running into this error. There's not much info here so I'm not sure how to debug it

TypeError: fetch failed
    at fetch (/home/kelby/work/jobs_fe/node_modules/undici/index.js:113:13)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async postJSON (file:///home/kelby/work/jobs_fe/node_modules/@planetscale/database/dist/index.js:115:22)
    at async Connection.execute (file:///home/kelby/work/jobs_fe/node_modules/@planetscale/database/dist/index.js:75:23)
    at async load (/home/kelby/work/jobs_fe/src/routes/+page.server.ts:34:14)
    at async Module.load_server_data (/node_modules/@sveltejs/kit/src/runtime/server/page/load_data.js:33:17)
    at async eval (/node_modules/@sveltejs/kit/src/runtime/server/page/index.js:168:13)

TypeError: fetch failed
    at fetch (/home/kelby/work/jobs_fe/node_modules/undici/index.js:113:13)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async postJSON (file:///home/kelby/work/jobs_fe/node_modules/@planetscale/database/dist/index.js:115:22)
    at async Connection.execute (file:///home/kelby/work/jobs_fe/node_modules/@planetscale/database/dist/index.js:75:23)
    at async load (/home/kelby/work/jobs_fe/src/routes/+page.server.ts:34:14)
    at async Module.load_server_data (/node_modules/@sveltejs/kit/src/runtime/server/page/load_data.js:33:17)
    at async eval (/node_modules/@sveltejs/kit/src/runtime/server/page/index.js:168:13)

The query I'm trying to make at line 34 of +page.server.ts is:

  import { db } from "$lib/server/db";
  import { users } from "$lib/server/schema";
  const res = await db.select().from(users);

  import { db } from "$lib/server/db";
  import { users } from "$lib/server/schema";
  const res = await db.select().from(users);

15 replies

DTDrizzle Team

•Created by kelbs on 4/1/2023 in #help

db push connection error

getting the following error on my first db push attempt

Ignoring invalid configuration option passed to Connection: sslaccept. This is currently a warning, but in future versions of MySQL2, an error will be thrown if you pass an invalid configuration option to a Connection
/home/kelby/work/jobs_fe/node_modules/drizzle-kit/index.js:43680
      const createConnectionErr = new Error();
                                  ^

Error: unknown error: Code: UNAVAILABLE
server does not allow insecure connections, client must use SSL/TLS

Ignoring invalid configuration option passed to Connection: sslaccept. This is currently a warning, but in future versions of MySQL2, an error will be thrown if you pass an invalid configuration option to a Connection
/home/kelby/work/jobs_fe/node_modules/drizzle-kit/index.js:43680
      const createConnectionErr = new Error();
                                  ^

Error: unknown error: Code: UNAVAILABLE
server does not allow insecure connections, client must use SSL/TLS

How do I make the db connection secure? Is that a drizzle option or a @planetscale/database option? Or maybe my connection string is wrong?

6 replies

Gaming

Programming