What is the highest average charisma skill check a solo character can get, without using magic?

I was building a character that had levels in Feywanderer ranger, that gains Otherworldly Glamour which allows you to add wisdom to charisma checks, and then I noticed Samurai fighters get Elegant Courtier which has the same bonus.

Emboldened by the fact they stack, I started to look for other class features that let you reroll failed intimidation checks or gain advantage.

It made me wonder, what is the highest possible charisma skill check by a solo character?

(This means no spells, or magic items and no outside assistance except by summoned/created creatures, e.g. a familiar using the help action is ok, but a party member using flash of genius is not.).

Can’t connect to postgresql database with SSL using GSSAPI

With postgresql 12.4, I’ve got this in pg_hba.conf:

hostssl all all 192.168.0.0 255.255.0.0 gss map=myrealm 

but whenever I try to connect with:

psql 'postgresql://hostname/database?sslmode=require' 

I get

2020-11-26 16:03:37.934 GMT [9585] FATAL:  no pg_hba.conf entry for host "192.168.215.220", user "username", database "database", SSL off 

If I replace hostssl with host I can connect (with GSSAPI).

How do I get psql to connect with SSL? I have ssl = on in my postgresql.conf and I have valid server.crt and server.key in the PGDATA directory.

Thanks

Who can use spell-scrolls done by a bard using his ‘Magic Secrets’ ability?

When a bard learns a Magic Secrets, it counts as a bard-spell. Of note, should they abandon any Secret-spell at later level, he can only replace it with one from the BARD list. Lord Crawford actually did rule-rulings on this, so this is clear: replacing one’s Magic Secrets is easily done, it is just somewhat unwise to do so.

Say a bard picks Find Familiar as a spell. Massive boon! For dirt cheap he can print them off as scrolls. Now who can use the scroll? Three possibilities:

  1. This is a wizard spell on the wizard list – designed for wizards. Clearly only a wizard can use a wizard spell on the wizard list designed specifically for wizarding ways, right? So obvious: a wizard buying this spell can transcribe it into their book (with a good roll on a good day) – or simply use it and get themselves a familiar.

  2. Any Magic Secrets spell, no matter which list it once came from, counts as a BARD spell for all intents and purposes (i.e. ‘learning, casting and recording’). Should a bard make such a scroll, any other bard can use it. A ‘secret’ no longer! But to be clear, if it IS a ‘bard’ spell, only bards could use this magic item. A wizard would not ever figure it out. A druid would have no chance. A barbarian would accidentally use this scroll as a fire-starter.

  3. You can use any scroll if the spell is on your class list. So almost anyone can use that Charm Person scroll. Thus, the bard writing such a scroll cannot even use it themselves. Imagine the ignominy with scribing any Magic Secret: ‘I cannot read any of what i just wrote down.’


The third one sounds the least fun and least logical, so probably that one. If this is a repeat of a previous question, please allow me to delete this / i did search before posting.

My thanks.

using a column that references an object_id in your own table

Is it safe to use OBJECT_ID() as a reference in your own tables, with the assumption that the value will always refer to the same database object no matter what?

The msdn states

All metadata functions are nondeterministic. This means these functions do not always return the same results every time they are called, even with the same set of input values.

so that would indicate it’s not safe, but I couldn’t find any (other) hard facts that it shouldn’t be done, and, to be fair, no examples of people actually doing it, which in itself might be evidence not to do it.

But the value OBJECT_ID() is (or seems to be) used in the system tables and views as keys from one object to another, so there must be some form of integrity and reliability.

For the record: I don’t necessarily need it, but it just popped into my mind as an option while designing my system, and got curious.

Is there a risk to hosting service if hot-potato site is using cloudflare?

Picture a politically hot website that might be subject to a DDOS attack. If that site is hosted at examplehosting.com and then uses cloudflare or another CDN, is the hosting service vulnerable to a DDOS attack on the site?

I do understand that the host could be discovered via DNS settings and attacked directly unless something was done to obscure the host IP address.

How does Arcane Armor’s removal of Strength requirements apply at a table using the Encumbrance variant?

The Armorer Artificer’s Arcane Armor feature says:

If the armor normally has a Strength requirement, the arcane armor lacks this requirement for you.

This is in reference to the following regarding certain heavy armors:

If the Armor table shows "Str 13" or "Str 15" in the Strength column for an armor type, the armor reduces the wearer’s speed by 10 feet unless the wearer has a Strength score equal to or higher than the listed score. [PHB, pg 144]

However, the Encumbrance variant says, in part:

When you use this variant, ignore the Strength column of the Armor table in chapter 5.

If you carry weight in excess of 5 times your Strength score, you are encumbered, which means your speed drops by 10 feet. [PHB, pg 176]

Is there guidance for how to apply the Arcane Armor feature at a table that uses the Encumbrance variant?

Why is MEMORYCLERK_SQLGENERAL using so much memory in SQL Server?

I have a production system running SQL Server 2019 Standard edition. It recently had a problem 3 times in 1 day where it became unresponsive until a reboot. Errors seem to point to memory limitations. 32GB is installed and the machine is dedicated to MSSQL. Max Memory set to 26GB.

The best lead I have so far is output of dbcc memorystatus that was automatically dumped to the log along with a FAIL_PAGE_ALLOCATION error. The full output is attached, but this part below caught my eye. It looks like MEMORYCLERK_SQLGENERAL wanted so much memory that it forced normal things like the buffer pool and query memory down to uselessly small levels.

I can’t seem to find any good info on what MEMORYCLERK_SQLGENERAL does, let alone why it would want so much memory.

11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLGENERAL (node 0)                  KB Pages Allocated                            22821672 SM Committed                                      0 SM Reserved                                       0 Locked Pages Allocated                       546740 VM Committed                                  75776 VM Reserved                                12867644 ---------------------------------------- ---------- 11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 0)               KB Pages Allocated                                3400 SM Committed                                      0 SM Reserved                                       0 Locked Pages Allocated                            0 VM Committed                                      0 VM Reserved                                       0 ---------------------------------------- ---------- 11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLQUERYPLAN (node 0)                KB Pages Allocated                                3632 SM Committed                                      0 SM Reserved                                       0 Locked Pages Allocated                            0 VM Committed                                      0 VM Reserved                                       0 ---------------------------------------- ---------- 11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLQUERYEXEC (node 0)                KB Pages Allocated                                1128 SM Committed                                      0 SM Reserved                                       0 Locked Pages Allocated                            0 VM Committed                                      0 VM Reserved                                       0 

Using wp_send_json_success instead of $result[‘message’], die, etc

My usual ajax function looks like this:

function get_modal_playlist_classplan( $  odv_video_id ) {     check_ajax_referer($  _REQUEST['nonce'], "my_cool_nonce", false);      $  result['type'] = "success";      $  result['message'] = "Booooo";      if ( $  some_test === true ) {         $  result['message'] = "Yay";     }      if (!empty($  _SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($  _SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {         $  result = json_encode($  result);         echo $  result;     } else {         header("Location: " . $  _SERVER["HTTP_REFERER"]);     }      die(); } 

How do I replace my approach with the use of wp_send_json_success (and wp_send_json_error)?

I tried replacing $ result['message'] = "yay" with:

$  return = array(     'message' => 'yay',     'some_other_data' => $  _REQUEST['hello'] . ' world' );  wp_send_json_success( $  return ); 

But the ajax request fails.