Reference file from inside a service | Community
Skip to main content
Jeanmaradiaga
Jeanmaradiaga
Level 3
November 21, 2022
Solved

Reference file from inside a service

  • November 21, 2022
  • 2 replies
  • 950 views

I am trying to implement maxmind's geoip2 and I am at the step where I need to initialize the DatabaseReader, my database file is currently stored at ui.content/src/main/content/jcr_root/conf/<my-app>/geoip/GeoLite2-City.mmdb and I am trying to access it like this:

public Location getLocation(InetAddress ip) throws GeoIp2Exception { try { File database = new File(this.path); this.db = new DatabaseReader.Builder(database).build(); return db.city(ip).getLocation(); } catch (Exception e) { throw new GeoIp2Exception(String.format("Could not determine data for %s", ip)); } }

 

But I am getting the following error: java.io.FileNotFoundException: /conf/<my-app>/geoip/GeoLite2-Country.mmdb (No such file or directory)

 

I have verified the file is named correctly and that is shows up on the CRX so I am guessing I need something to actually access this.

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SantoshSai

Hi @jeanmaradiaga ,

There are few things might cause this problem,

  • I'm not sure what type of Session you are referring to access JCR repository, there are few options to get Session to access JCR repository. However, It is recommended to create System User in AEM for specific functionality. For more details please check [0].
  • Assuming you have service user created and you have dedicated service (best practice) or you have an JCR Session to access repository refer below code.
  • GeoLite2-City.mmdb File should have an nt:file node, which has a jcr:content node with jcr:data property. Use Node data as stream to read jcrContent.getProperty("jcr:data").getBinary().getStream();
     
    InputStream in = node.getNode("jcr:content").getProperty("jcr:data").getStream();
    Resource dataResource = resourceResolver.getResource("/path/to/db/file.mmdb"); 
Node jcnode = dataResource.adaptTo(Node.class).getNode("jcr:content");
InputStream is = jcnode.getProperty("jcr:data").getBinary().getStream();
StringBuilder sb = new StringBuilder();
    String line;
try {
    br = new BufferedReader(new InputStreamReader(is));
    while ((line = br.readLine()) != null) {
    sb.append(line);
    }
} catch (IOException e) {
            //do something
}
//do whatever with sb

[0]: https://one-inside.com/aem6-resourceresolver-access-in-services/

Hope that helps!

Regards,

Santosh

2 replies

Avinash_Gupta_
Community Advisor and Adobe Champion
Avinash_Gupta_Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
November 21, 2022

@jeanmaradiaga Please refer to the below article which explains about how you can access the file stored in JCR repo

 

http://www.wemblog.com/2011/10/how-to-read-external-file-in-cq.html 

 

Hope this helps!

    Jeanmaradiaga
    JeanmaradiagaAuthor
    Level 3
    November 22, 2022

    Thanks for the reply!

    I haven't had a chance to try it yet, but it seems a bit complicated because I would need to open the stream, get the file, convert it to a File object and then start the DB, this each time I want to loop up an user. Surely there must be a faster way since 2011 on AEM Cloud?

      SantoshSai
      Community Advisor
      SantoshSaiCommunity AdvisorAccepted solution
      Community Advisor
      November 22, 2022

      Hi @jeanmaradiaga ,

      There are few things might cause this problem,

      • I'm not sure what type of Session you are referring to access JCR repository, there are few options to get Session to access JCR repository. However, It is recommended to create System User in AEM for specific functionality. For more details please check [0].
      • Assuming you have service user created and you have dedicated service (best practice) or you have an JCR Session to access repository refer below code.
      • GeoLite2-City.mmdb File should have an nt:file node, which has a jcr:content node with jcr:data property. Use Node data as stream to read jcrContent.getProperty("jcr:data").getBinary().getStream();
         
        InputStream in = node.getNode("jcr:content").getProperty("jcr:data").getStream();
        Resource dataResource = resourceResolver.getResource("/path/to/db/file.mmdb"); 
Node jcnode = dataResource.adaptTo(Node.class).getNode("jcr:content");
InputStream is = jcnode.getProperty("jcr:data").getBinary().getStream();
StringBuilder sb = new StringBuilder();
        String line;
try {
    br = new BufferedReader(new InputStreamReader(is));
    while ((line = br.readLine()) != null) {
    sb.append(line);
    }
} catch (IOException e) {
            //do something
}
//do whatever with sb

      [0]: https://one-inside.com/aem6-resourceresolver-access-in-services/

      Hope that helps!

      Regards,

      Santosh

      Santosh Sai
        Terms & ConditionsAccessibility statement

        Loading footer...