NginxProxyManager / NginxProxyManager/nginx-proxy-manager
warning: insert into `certificate` (...) - ER_DATA_TOO_LONG: Data too long for column 'nice_name' at row 1
Open
Nobody has claimed this yet.
bug
- Dominant language
- TypeScript
- Stars
- 34.2k
- Forks
- 3.9k
- Avg merge
- 21h 12m
- Merged PRs (30d)
- 20
Description
Describe the bug
Occurs when too much Domain Names are configured in Proxy host and trying to create ssl cert.
Nginx Proxy Manager Version
v2.9.18
To Reproduce
Steps to reproduce the behavior:
- Create proxy host with 13 domains
- Create new SSL certificate
- See error in logs
Expected behavior
Should insert fine in database.
Additional context
app_1 | [5/14/2022] [11:46:00 PM] [Express ] › ⚠ warning insert into `certificate` (`created_on`, `domain_names`, `expires_on`, `meta`, `modified_on`, `nice_name`, `owner_user_id`, `provider`) values (NOW(), '[\"DOMAINS Removed\"]', NOW(), '{\"letsencrypt_agree\":true,\"dns_challenge\":false,\"nginx_online\":true,\"nginx_err\":null,\"letsencrypt_email\":\"MAIL REMOVED\"}', NOW(), 'DOMAINS REMOVED', 1, 'letsencrypt') - ER_DATA_TOO_LONG: Data too long for column 'nice_name' at row 1
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the failure by configuring a proxy host with 13 domains and creating an SSL certificate. Inspect the certificate insert path and database schema for the nice_name column; done means the certificate is saved successfully without an ER_DATA_TOO_LONG error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, typescript
- Domain
- backend, database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 50/100