Menu

Permission-Question for XLSX

ART Help
Gerd S
2022-05-31
2022-06-02
  • Gerd S

    Gerd S - 2022-05-31

    Hi,

    i've tried now a lot settings, but i can't find it out, and in the forum i can't find anything to this. I'm missing a permission. but which one:

    I've created a report incl. parameter which is working correct, when i call it as "Browser (DataTable)". If I try to export as "Spreadsheed (xlsx)", I'll get an "Access denied".
    It worked before as an admin but not for an standard user. Then i tried to change some settings, now it's not working for admins anymore.

    Which setting should i check to get it working again?

    Permission should be: I have some usergroups, which are allowed to call some report groups. I think this is working generally, because i see the report in the "Reports"-Tab.

    Thanks,
    Gerd

     
  • Timothy Anyona

    Timothy Anyona - 2022-06-02

    Could you provide screenshots?

     
  • Gerd S

    Gerd S - 2022-06-02

    while preparing the screenshots, i found the cause: We have an apache as reverse-proxy and use it also for http-header-auth. But using this, somehow the link to the export-URL don't work:
    ... art/export/reports/Inventuren%20Offen-2022_06_02-09_03_40_726-Yalda-2-0.xlsx
    (just showing "access denied")
    using the direct access over tomcat, it works.

    I've i find out how to solve this, i'll post it here, perhaps it will help someone in future.

    regards
    gerd

     
  • Gerd S

    Gerd S - 2022-06-02

    Ok - it was a misconfiguration in apache: In the ART-Logs, i've found this:
    org.springframework.web.servlet.PageNotFound No mapping for GET /art//export/

    This lead me to the ProxyPass-Statement in apache-config, where i had a "/" at the end - i removed it, and now it's working. It looks like it didn't disturb any other areas in ART before, just the export.

    So it looks now like this without / at the end:

    ProxyPass "ajp://localhost:8009/art"
    ProxyPassReverse "ajp://localhost:8009/art"

     

Log in to post a comment.