Linked reports using http when I need them to use https

(12 posts) (4 voices)
  1. adamhaeder, Member

    We recently made a change on our primary mydbr webserver to all connections are now http:// instead of https://. It's the same hostname, the protocol has just changed.

    The problem I'm having is that linked reports are still using the http:// protocol, even though the URL that I'm using to access the report is https://. In other php based applications I've used, there is some system or environment variable I can set that is something like 'Site URL'. I can't find that in mydbr though?

    So my question is how can I have mydbr use relative links in the linked reports instead of 'hard coding' in http:// instead of https:// ?


  2. myDBR Team, Key Master

    Could you give an example where http is used instead of https? myDBR should use https on all links if the original report is accessed using https.

    myDBR Team

  3. adamhaeder, Member

    The URL for my MyDBR instance is under https://

    Here is the sql code in my stored procedure:

    SELECT 'dbr.text', CONCAT('
    <table border=0 width=60% align=center><tr><td><b>Direct Reports</b></td></tr>');
    SELECT '', 'sp_DBR_processlist_single_user', '4', 'employee=[id]', 'show_direct_report=1';
    SELECT 'dbr.hidecolumn', 'id';
    SELECT 'dbr.hidecolumn', 'answer';
    '1' as answer,
    CONCAT('"',, '"') as id,
    CONCAT('dbr.purehtml:') as Image,
    CONCAT (a.firstname,' ',a.lastname) as 'Employee Name',
    a.title as 'Title', as 'Unit',
    -- CONCAT(d.firstname, ' ', d.lastname) as 'Reports To',
    CONCAT('dbr.purehtml:', lower(, '') as 'Email',
    a.phone_office as 'Phone - Office',
    a.phone_mobile as 'Phone - Mobile',
    a.phone_other as 'Phone - Other', as 'Position'
    FROM datawarehouse.employees a
    JOIN processes.units b ON a.unit =
    JOIN processes.positions c ON a.position =
    LEFT JOIN datawarehouse.employees d ON a.reports_to_id =
    WHERE (a.deleted <> '1' OR a.deleted IS NULL)
    AND a.reports_to_id=REPLACE(employee,'"','')
    ORDER BY a.lastname ASC;

    The report it's linking to is sp_DBR_processlist_single_user. If I view-source this page, here is the html that is generated that shows the link to the linked report:

    <tr class="odd" data-set="0">
    <td class="ReportOutCell align_l" ></td>
    <td class="ReportOutCell align_l" >MacKenzie Frei</td>
    <td class="ReportOutCell align_l" >Marketing Specialist</td>

    As you can see, the link to 'mydbr/report.php' is http, not https.

    I can provide screenshots if that would help. Thanks

  4. myDBR Team, Key Master

    Sounds like a server configuration issue. myDBR checks the if page is using https via PHP's $_SERVER['HTTPS']-variable. The variable should contain "on" when https is used.

    Could you check what the variable contains when you access following code through https.


    myDBR Team

  5. adamhaeder, Member

    You're right, it is an issue on my end.

    Can I ask why you're having MyDBR create fully-qualified URLs for linked reports? Wouldn't it be easier (and more portable) for these to be relative URLs? That way it wouldn't matter what host or protocol was used, the URLs would just inherit those from the initial report.

  6. myDBR Team, Key Master

    It's due to the multiple ways myDBR is used. Sometimes myDBR generated code is used without the context making long URL's a neccessity. You are right that In normal cases the short urls would work just fine. On the other hand, it is not that common that fully-qualified URLs would cause any problems.

    myDBR Team

  7. adminslim, Blocked

    The toughest thing for a person who desperately needs to lose weight is to have to face a diet knowing there will nagging food cravings. It is especially tough for those people who are addicted to sugary foods (processed carbs: cookies, crackers, snack foods, candy, etc.)! If you eat a lot of sugar, you want more and more. The reason your body does that is when Zi Xiu Tang does not receive proper nutrition fruta planta , your brain sends signals to tell you that you need more food.

    How To Stop: Like someone who's trying to quit smoking might do, tell your friends and family that you're trying to stop cracking your knuckles, which will make you feel more accountable for changing your ways. And just as some dieters record what they eat each day, Zi Xiu Tang may be helpful to keep a tally of how many times you crack your knuckles. Then try to slowly cut back..

    Talk with your doctor, maybe there some help s/he can give. Check labels, you be surprise how much stuff is loaded with fat, calories or sodium. I sure you get more advice here. I liked the sounds of that. It's not a low carb or low fat diet and doesn't require you to count calories. And one day a week you get to eat whatever you want! Actually Lida daidaihua , I should rephrase that.

    Other Training ZonesIf you are in extremely poor health or are just starting a running program, exercise within a moderate activity zone, which is 50 to 60 percent of your maximum heart rate. You can calculate this range by multiplying your maximum heart rate by .5 and .6. If you would like to incorporate high-performance training so that you can handle short periods of high-intensity bouts, spend some time during your workout training at an anaerobic threshold training zone, which is 80 to 90 percent of your maximum heart rate and can be calculated by multiplying your maximum heart rate by .8 and .9..

    It very possibly could be you are awaiting to shed too much weight within a short amount of time. Besides you may be making major changes that are causing you stress. Small changes are best and will give you little rewards of dieting as you progress.

    Eggs also help you feel full, since your body produces a hormone called PYY when you eat high-protein foods. PYY tells your brain you're no longer hungry, so if you're trying to lose some pounds, opting for a high-protein snack like a boiled egg can really help you feel full (and it's only 75 calories). I personally like the organic eggs high in omega 3 fatty acids (the healthy fats), from chickens raised without hormones or chemicals.

  8. sjesal, Member

    Following up on the topic.

    We are using AWS infrastructure, Where https is managed via Elastic Load Balancer. We want to make sure that the linked reports are served via https and not http. We are getting following error.

    Mixed Content: The page at 'http[s]://' was loaded over HTTPS, but requested an insecure image 'http[]://'. This content should also be served over HTTPS.

    Any help will be appreciated in this matter.


  9. myDBR Team, Key Master

    Most likely the load balancer hides the $_SERVER["HTTPS"] from the web server causing myDBR to think it is operaring against a non-secure connection. Could you check if the server uses something else to show http / https protocol, for example HTTP_X_FORWARDED_PROTO or something like that?

    We'll take a look at this.

    myDBR Team

  10. myDBR Team, Key Master

    AWS Elastic Load Balancing configuration is now supported. Run the updater to get the latest build.

    As the updater will not touch files under mydbr/user-directory, download the package and copy the user/export_header_pdf.php-file into your installation. This way also the PDF generation respects the used protocol when used under AWS.

    myDBR Team

  11. sjesal, Member


    You are correct. ELB drops https and uses http, when talking to Webserver.

    Please let us know the next steps.


  12. myDBR Team, Key Master

    See the previous post.

    myDBR Team


You must log in to post.