Is there a way to delete all IP addresses from database? Is there any plugin or any scripts to do that? Please do not ask why you want to do that, it is jsut requirement and I want to get it done.

I went to Ask.discourse.com and got this, which seems probably true. Deleting IP Addresses in Discourse with Rails AI pfaffman: Where are ip addresses stored. Can I delete them all from rails? DiscourseHelper: Searching Searching for: Where are user and post IP addresses stored in the Discourse database, and is it possible to delete all stored IP addresses using Rails or through a rake task for privacy or GDPR compliance? Reading Read: Problematic IP address fields Look up database schema incoming_links,search_logs,topic_link_clicks,topic_views,user_profile_views,user_auth_tokens,user_auth_token_logs,screened_ip_addresses Discourse stores IP addresses in several database tables, specifically: incoming_links (ip_address) search_logs (ip_address) topic_link_clicks (ip_address) topic_views (ip_address) user_profile_views (ip_address) user_auth_tokens (client_ip) user_auth_token_logs (client_ip) screened_ip_addresses (ip_address) You can delete IP addresses using Rails commands if you have terminal access (self-hosted installations). For each table, you can set the relevant column (like ip_address or client_ip) to NULL. Example for incoming_links: IncomingLink.update_all(ip_address: nil) You would run similar commands for each relevant table/column. For more details and context about privacy and potential implications, see this discussion: Problematic IP address fields Note: If you’re on Discourse’s hosted service, you do not have SSH or Rails console access; in such cases, contact Discourse support at team@discourse.org for guidance. Let me know if you need specific Rails commands for each table or further advice!

[画像] pfaffman: incoming_links (ip_address) search_logs (ip_address) topic_link_clicks (ip_address) topic_views (ip_address) user_profile_views (ip_address) user_auth_tokens (client_ip) user_auth_token_logs (client_ip) screened_ip_addresses (ip_address) Interestingly it doesn’t look like it’s included the main ones, ip_address and registration_ip_address from the users table. There are a couple of others too when I do a data explorer field search. screened_emails.ip_address screened_urls.ip_address user_histories.ip_address user_ip_address_histories.ip_address Not all of them have any records in on my test site, but probably worth a check of your own tables to make sure they’re empty for you too.

[画像] JammyDodger: Interestingly it doesn’t look like it’s included the main ones Ha! It was the best I could do in my phone. It seemed like a lot so I thought it must have gotten it. :rofl:

すべてのIPアドレスを削除する方法？

製品サポート

pfaffman (Jay Pfaffman) 2025 年 6 月 8 日午前 10:16 4

ハッ！携帯でできる精一杯でした。たくさんあったように見えたので、それが入っているに違いないと思いました。

トピック		返信	表示
How can I delete all of my PII user data? Product Support privacy	6	244	2025 年 12 月 17 日
Does "Delete User" remove IP addresses from everywhere? Product Support gdpr , privacy , anonymization	1	285	2024 年 9 月 10 日
Unable to log into my discourse - "You can't log in as xxx from that IP address." Product Support	5	3384	2015 年 4 月 3 日
Using Discourse without IP logins Product Support privacy	0	107	2025 年 6 月 8 日
How to disable logging IP address? Product Support	3	2112	2023 年 2 月 12 日

すべてのIPアドレスを削除する方法？

関連トピック