nextcloud / bruteforcesettings

šŸ•µ Allow admins to configure the brute force settings
https://apps.nextcloud.com/apps/bruteforcesettings
GNU Affero General Public License v3.0
49 stars 13 forks source link

DbalException An exception occurred while executing a query: SQLSTATE[22001]: String data value too long for type character varying(255) #662

Open Nothing2024 opened 1 month ago

Nothing2024 commented 1 month ago

How to use GitHub


Steps to reproduce

  1. Share a link to others
  2. Enter a wrong password following the shared link.

Expected behaviour

The failing attempt should have been logged to oc_bruteforce_attempts.

Actual behaviour

DbalException in the log. Failed to add record to oc_bruteforce_attempts

[index] Error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR:  value too long for type character varying(255)
    GET /s/SomeRandomString&data=05%7C02%7Cuser@domain.com%7Cb8e7d5ae03d1492e7ddd08dcdc73886a%7Cdd3be02229ab444490efbbee7374acee%7C1%7C0%7C638627636026167027%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0=%7C0%7C%7C%7C&sdata=Q5bXmOfXehZ+j1LwJJM0++dS1XKzy8yLhe7MmCKjWao=&reserved=0
    from 172.167.1xx.xxx by -- at Sep 24, 2024, 4:34:17 PM

No record was added to oc_bruteforce_attempts table.

Server configuration

Web server: Apache/Nginx Apache (docker)

Database: PostgreSQL

PHP version: 8.2.23 (docker)

Nextcloud version: (see Nextcloud admin page) 29.0.6 (docker image nextcloud:29.0)

List of activated apps ``` Enabled: - activity: 2.21.1 - bruteforcesettings: 2.9.0 ```