1. 

   ajdjackson, Member

   Hi

   Decided to switch to using HTTPS and have come across an issue.

   Before I get to the issue it appears that all my other reports run from the mydbr report menu work fine including popups etc.

   My main_top.html contains the following:

   <script type="text/javascript"> embed_url("http://xxxx.com/mydbr/report.php?r=217&m=2&h=d4cdf53199a5f511d68ff21304c61a7bf996231a&i=1&hdr=0&embed=2", false); </script>

   With the above the home page loads fine but none of my linked reports run in that clicking any of the links results in nothing.

   The home page report has several of the same elements:

   select 'dbr.divify'; select 'dbr.rowclass', 'boxrow'; select 'dbr.hidecolumns','1'; select 'dbr.report', 'sp_DBR_Dashboard_Overdue_Num', 'popup', '[boxesrr]', 'event=click';

   select concat('dbr.html:<span class="data_line">', 'Over','','Due', '','', (select count(a.tblContractXIDJobNo) from hilmark.tblsitesplotsjake a where a.Plot_ExpHOD < date(now()) and a.tblContractXIDJobNo not in (select tblsalesinv_xidjob from hilmark.tblsalesinv_j)), '</span>') as 'boxesrr', 'boxrow';

   Strangely if I use https in the embed_url command the report does not display at all - only the mydbr report menu.

   I've checked the $_SERVER['HTTPS']) variable and it states that it's on.

   Another thing is that one of the linked reports opens in a new window and although this works it uses http not https.

   Hope you follow that

   Thanks

   Jake
2. 

   myDBR Team, Key Master

   Is your certificate a valid certificate or do you use a self-signed certificate? The embed_url does check that the certificate is valid.

   When you mix http and https your browser can block the http content in https page.

   We can add an option to allow use of self-signed certificates in embed_url.

   --
   myDBR Team
3. 

   ajdjackson, Member

   Hi

   Thanks for getting back.

   I assume it is a self-signed one.

   I'm running mydbr on a WHS2011 and access via mydomain.homeserver.com.

   An option to allow self-signed would be great.

   Thanks

   Jake
4. 

   myDBR Team, Key Master

   Jake,
   run the updater and add:

   $mydbr_defaults['embed_url']['CURLOPT_SSL_VERIFYPEER'] = false;

   into user/defaults.php

   --
   myDBR Team
5. 

   ajdjackson, Member

   Thanks - working :)

   Jake

Reply

You must log in to post.