location not showing up such as city and country!

[csyedbilal]

MaxmindDB working fine but location not displayed #9852

any solution for this ?

[csyedbilal]

`# Retrieve the conversation and associated contact
conversation = Conversation.find(12)
contact = Contact.find(conversation.contact_id)

Geocode the IP address to get location data
ip_address = contact.additional_attributes['created_at_ip']
geo_data = Geocoder.search(ip_address).first

Extract city and country code from the geocoding result
city = geo_data.data.dig('city', 'names', 'en')
country_code = geo_data.data.dig('country', 'iso_code')

Update the contact record
contact.update(
location: city,
country_code: country_code
) //
`

[csyedbilal]

`root@chatwoot-test:~# docker exec -it 32beff13d8e3 /bin/sh
/app # bundle exec rails console

/gems/ruby/3.3.0/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32: warning: /usr/local/lib/ruby/3.3.0/mutex_m.rb was loaded from the standard library, but will no longer be part of the default gems since Ruby 3.4.0. Add mutex_m to your Gemfile or gemspec. Also contact author of activesupport-7.0.8.4 to add mutex_m into its gemspec.
DEPRECATION WARNING: Dotenv::Railtie is deprecated! Use Dotenv::Rails instead. (called from

at /app/config/application.rb:14)
Loading production environment (Rails 7.0.8.4)
irb(main):001> conversation = Conversation.find(11)
irb(main):002>
=>
#<Conversation:0x00007f42cd8a7e08
...
irb(main):003> contact = Contact.find(conversation.contact_id)
irb(main):004>
=>
#<Contact:0x00007f42cd5f39c8
...

irb(main):005> ip_address = contact.additional_attributes['created_at_ip']
irb(main):006>
=> "52.187.26.37"
irb(main):007> geo_data = Geocoder.search(ip_address).first
irb(main):008>
=>
#<Geocoder::Result::Geoip2:0x00007f42d86cd758
...
irb(main):009> city = geo_data.data.dig('city', 'names', 'en')
irb(main):010> country_code = geo_data.data.dig('country', 'iso_code')
=> "SG"
irb(main):011> city = geo_data.data.dig('city', 'names', 'en')
=> "Singapore"
irb(main):012> exit`