1. 

   dalli, Member

   Hello myDBR Team,

   I'm trying to access a report by URL, according to http://mydbr.com/doc/content/manage.directurl.html.

   Assuming reportID is 34
   report folder is 1
   and url hash seed is 'secret'

   I got an sha1 value of 731694115dc5966f43345ba0f3824e81c9b23fe3.
   This one is actually working.

   The stored procedure has one parameter (someName varchar(30))

   This one I wanted to incorporate into the hash.

   Assuming reportID is 34
   report folder is 1
   and url hash seed is 'secret'
   and someName is 'name'

   then the string should be
   34m1p1namesecret (or is it something else indeed?) resulting in the sha1 value '642a98a02f4390fff32929e4e837db5d6eb27b9e'

   Here got the error message: "Report security hash does not match. Report execution aborted."
   when opening report: report.php?r=34&m=1&h=642a98a02f4390fff32929e4e837db5d6eb27b9e

   Whats wrong here?

   Regards
2. 

   myDBR Team, Key Master

   then the string should be
   34m1p1namesecret (or is it something else indeed?)

   There seems to be an error in the documentation, sorry about that. The optional m-parameter should be just before the seed value.

   So the correct sha1 string is:
   34p1namem1secret

   Note that you can also omit the m-parameter altogether.

   --
   myDBR Team
3. 

   dalli, Member

   Hi

   thanks for replying quick.

   Still didnt manage do get access working.

   with string 34p1namem1secret
   is have sha1 value e4fe06c7db8a3edb00fa0141a2bf1682b5e0d47f

   and request url
   report.php?r=34&m=1&h=e4fe06c7db8a3edb00fa0141a2bf1682b5e0d47f

   facing "Report security hash does not match. Report execution aborted." again, unfortunately

   Also tried omitting m-parameter but there has not been a difference.
4. 

   myDBR Team, Key Master

   Just a quick note. Your hash string does include parameter p1=name, but your url does not. Do you intend to pass 'name' as a parameter? If so, your url should be form of:

   report.php?r=34&p1=name&m=1&h=e4fe06c7db8a3edb00fa0141a2bf1682b5e0d47f

   --
   myDBR Team
5. 

   dalli, Member

   Thanks. Did it.

Reply

You must log in to post.