Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dyn+nginx+letsencrypt+wildcard certificate

d00cc79d-3fe2-4d19-b735-a62293cac15eAug 26 2019 — edited Nov 20 2019

Can you please elaborate on what I should change for the content not to be rejected?

Hi,

I'm thinking about using dyn+nginx+letsencrypt[1].

It looks like to use a wildcard certificate I need a DNS-01 challenge[2].

Also it looks like dyn is supported[3], say via acme.sh[4].

It's unclear to me what to configure on the dyn end and whether I need to buy additional things for it to work (I currently have Dynamic DNS Pro).

Thanks,

Robert

[1] https://letsencrypt.org/how-it-works/

[2] https://letsencrypt.org/docs/challenge-types/

[3] https://community.letsencrypt.org/t/dns-providers-who-easily-integrate-with-lets-encrypt-dns-validation/86438

[4] https://github.com/Neilpang/acme.sh/tree/master/dnsapi

Message was edited by: d00cc79d-3fe2-4d19-b735-a62293cac15e I am not sure what to change not to be rejected. Please advise.

This post has been answered by RotBlitz on Aug 26 2019
Jump to Answer

Comments

That's fixed in v4.0.2

Gamblesk

Just installed 4.0.2.15 and the same thing happens.

I put a select sysdate from dual into the child report and I get a new cursor for every refresh when the parent refreshes.

Maybe this will help. This does not appear to happen when the child is set to refresh. Only when the parent is.

I'm not seeing that behavior. I'm counting open cursors by going against v$statname where name = 'opened cursors current'

Gamblesk

I am not sure what is different about what I am doing but here is a child report showing the value of opened cursors current and it count goes up with refreshes.

This also only happens when the type is set to table. It does not happen if the type is set to script.

I can gather anything else you think would be useful but I am not sure what else to add.

cursor_count_1.png

cursor_count_2.png

Parent query

select \* from v$session where username = 'DBA\_MONITOR'

Child query - Hardcoded SID to make sure it was showing right one.

select sysdate, stat.sid,

stat.value, statname.name

from v$sesstat stat,

    v$session sess,

    v$statname statname

where stat.sid = 617

and stat.sid = sess.sid

and statname.statistic# = stat.statistic#

and statname.name = 'opened cursors current'

It took a few minutes to find the exact reproducible scenario - a bit different than the one originally reported that we did FIX.

But, two things:

  1. thanks for the effort here and reporting this
  2. I've reopened the bug with a high priority and hope to have it addressed for our next update
1 - 5

Post Details

Added on Aug 26 2019
2 comments
689 views