Web Part connections on Classic pages – InfoPath Form Viewer ‘Send Parameter’ dialogue not showing

(Just asked this on MS Techcommunity, but it only shows to me when logged in – is there some kind of publishing approval there?)

I’ve been struggling with Web Part connections on a classic page on our SPO tenant and would appreciate any feedback.

Scenario: An InfoPath list form has been created, which handles data and sets some field values to be made available to other Web Parts on the same page with the ‘Send Data to Web Part’ rule action. A second web part (Library View) consumes these using ‘Get Parameters From’ to use as part of some filter conditions.

It was necessary to create these parameters manually in SPD2013 code view due to the longstanding interface bug in that software which prevents the ‘List View Tools’ tab from appearing.

When I establish a web part connection between two List/Library View web parts, the ‘Configure Connection — Web page Dialogue’ (…/_layouts/15/AspXform.aspx?pageUrl=…) appears correctly as long as no InfoPath Form Viewer web parts are present in the same page.

If any InfoPath Form Viewer web parts are present in the same page, even if they’re not the source or destination of the intended connection, this dialogue does not appear.

For web part pages which only use ‘Send Form To’ an InfoPath Form Viewer web part from a connected view of its same list, this is managable – as the relevant binding is automatically established without any dialogue. As long as the Form is the last web part to be added, it can be made to work.

For other requirements, however, it is necessary to bind fields from the Form against the Parameters in some way. I still have access to a 2010 on-prem environment for a few weeks, and will try to replicate/generalise the ‘<WebPartPages:SPProxyWebPartManager runat=”server” id=”spproxywebpartmanager”>’ syntax in SPO. This is not ideal and I expect to encounter further problems if this needs to be done at scale.

Is this a known bug/limitation with Classic Pages? I’ve tried various browsers – IE8-11, 32/64 bit, Edge/FF/Chrome, Compatibility Mode on/off, etc.

In principle we’d be willing to use Modern for this, but I’ve not found any Modern Page friendly way to inject the necessary pivoting we resolve with embedded InfoPath. If it needs to be said, yes, we are also aware that InfoPath is going EOL in a few years. PowerApps is not a viable solution in our environment at this time.

Thanks in advance for any recommendations.

lo.logic – The connections between Kolmogorov complexity and mathematical logic

We know that Kolmogorov Cmplexity (KC) has connections to mathematical logic since it can be used to prove the Gödel incompleteness results (Chaitin’s Theorem and Kritchman-Raz). Are there any other striking application of Kolmogorov complexity to mathematical logic (outside KC itself of course)?

Relatively simple examples like the ones I mentioned are preferred, but more complicated illustrations are also very welcome!

(This is cross posted from MSE, because I wasn’t getting any useful replies there)

php – Number of MySQL connections spikes, but no spike in number of queries

I am running LAMP stack with CakePHP and MySQL compatible AWS Aurora instance. The Aurora instance is set up with a writer and read replica. Using CakePHP request routing, the read replica is only set up to serve incoming web requests.

I am experiencing a strange intermittent spiking in the number of MySQL connections to the read replica. When this happens, it also causes a similar spike in CPU usage, and thus an increase in query latency that causes the server to become very slow. This lasts for perhaps only a few minutes at a time, and happens maybe once or twice per day intermittently.

Here a graph showing the correlation between number of connections and CPU utilization:

enter image description here

However, despite an increase in number of connections, there is no noticeable spike in the number of queries. Here is that same graph, but including the number of queries:

enter image description here

As you can see, there is basically no correlation.

What could cause a spike in the number of connections? The read replica is only being used to serve incoming web requests. Why would additional connections be opened, but there is no noticeable increase in the number of additional queries?

network – Have I been hacked ( netstat output too many dgrams and stream connections)

enter image description here

enter image description here

netstat output

These are the output images of the netstat command I ran it shows that they’re are too many outbound connection and many dgrams and stream . I also tried to capture the output using Wireshark and then reverse checking the IP address to whom does it belongs ( using www.arin.net) it showed up various organisation ( Google, Astricia).

I also tried to turnoff the wifi and then ran netstat but no change in the dgram and stream connections.

Please help , any input will be appreciated.

Can a returning Canadian take a stopover hotel in order to make connections the following day?

Can a returning Canadian citizen take a stopover hotel in order to make ground connections the following day?

ssl – Postfix PLAIN SASL auth over non-TLS connections for some IPs?

When Postfix runs with a following configuration:

smtpd_sasl_security_options = noanonymous, noplaintext
smtpd_sasl_tls_security_options = noanonymous

it won’t permit authentication over a non-TLS connection. That is good but we have some dumb automated software which doesn’t supports TLS for SMTP. As long as we are running these on some static IPs I would like to permit SASL authentication over non-TLS connections for these. Or for some specific user logins.

I could do a workaround by setting another smtpd process in master.cf on another listening port where I will provide an options with -o to allow SASL over unencrypted SMTP. And then I can restrict it required IPs via firewall or other postfix options. But that sounds like an ugly hack for me. I assume there might be a more convenient way to do this over a default ports. Probably with some client class “magic”. Any ideas?

Concurrent connections calculated in Mongodb Atlas

I’m considering using mongodb for a mobile backend database, and I’m slightly confused at something I haven’t found an answer to in the documentation. Are the concurrent connections for each tier in Atlas calculated on a per cluster basis, or per shard within each cluster? How does sharding affect the limits on the number of reading/writing operations per second? Have a feeling I’m misunderstanding something crucial since haven’t found questions related to this online at all.

ubuntu – Getting current number of connections in mysql

I want to know if there is any parameter to show the current number of mysql connections (or peak value in the past 10 minutes or something else). Right now, I only see max and max_used connections.

mysql> show global status like '%connection%';
+-----------------------------------+---------------------+
| Variable_name                     | Value               |
+-----------------------------------+---------------------+
| Connection_errors_accept          | 0                   |
| Connection_errors_internal        | 0                   |
| Connection_errors_max_connections | 434                 |
| Connection_errors_peer_address    | 0                   |
| Connection_errors_select          | 0                   |
| Connection_errors_tcpwrap         | 0                   |
| Connections                       | 2380515             |
| Max_used_connections              | 152                 |
| Max_used_connections_time         | 2020-07-09 19:28:43 |
+-----------------------------------+---------------------+
9 rows in set (0.00 sec)

mysql> show global variables like '%connection%';
+--------------------------+-------------------+
| Variable_name            | Value             |
+--------------------------+-------------------+
| character_set_connection | latin1            |
| collation_connection     | latin1_swedish_ci |
| max_connections          | 300               |
| max_user_connections     | 0                 |
+--------------------------+-------------------+

pg hba.conf – postgresql only allows connections via unix socket even though my pg_hba.conf lists 127.0.0.1/32?

I have the following pg_hba.conf:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     trust
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

With the above I assume host all all 127.0.0.1/32 trust would allow TCP connections from localhost. However this does not seem to be the case

(root@XenonKiloCranberry:~)# psql -U postgres
psql (11.7)
Type "help" for help.

postgres=# q

(root@XenonKiloCranberry:~)# psql -U postgres -h 127.0.0.1
psql: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "postgres", SSL off

Where am I going wrong?

postgresql – How to prevent different connections treating bytea in same query differently?

I find that identical postgresql queries issued by two different clients are handled differently. Specifically, bytea values are inserted differently.

A query that demonstrated the behaviour is this:

INSERT INTO "TestTable" ("Input") VALUES (decode('74657374', 'hex'))

74657374 is hexadecimal for ‘test’. In one client, ‘test’ is inserted into the “Input” field, whether that field is text/varchar or bytea. That is the behaviour I desire. In another client, ‘x74657374’ is inserted into the “Input” field, whether it is text/varchar or bytea. This string is the postgresql literal representation of the bytea bytes of ASCII ‘test’. But the sql literal syntax itself is inserted. I do not desire this behaviour.

I use a single piece of hand-written SQL, the bytea value only occurs “within” the query (if column “Input” has type Text then none of literals nor the receiving column have bytea type), and it seems unlikely to me that either client is parsing then rebuilding the query. Therefore it seems that the difference must be happening on the server where the query is executed. That means there must be some connection specific configuration setting which is altering the server behaviour.

Can anyone please tell me what connection specific settings could be altering this behaviour?

I know the queries are really behaving differently and it is not a display issue etc., because I can see the rows in the same table having different values (‘test’ and ‘x74657374’). I have tried various alternative bytea handling methods, but they are all affected by this problem. For those who are interested, the “good” client is pgAdminIII and the “bad” client is Ruby PG gem. Though for the reason I gave above I believe there must be some built-in feature of postgresql supporting this behaviour.