Recent Questions - Super User most recent 30 from 2022-04-07T08:42:29Z 0 How to use zsh in flatpak vscode Hamza Ince 2022-04-07T08:30:55Z 2022-04-07T08:30:55Z <p>I have <code>Visual Studio Code</code> installed in flatpak, I run it with:</p> <blockquote> <p>flatpak run --command=sh com.visualstudio.code</p> </blockquote> <p>I want to change the shell to <code>zsh</code>, but I can't find how to, I tried multiple thing in my <code>settings.json</code>:</p> <pre><code>... &quot;;: &quot;/usr/bin/flatpak-spawn&quot;, &quot;terminal.integrated.shellArgs.linux&quot;: [&quot;--host&quot;, &quot;run&quot;, &quot;env&quot;, &quot;TERM=xterm-256color&quot;, &quot;zsh&quot;], ... </code></pre> <p>And</p> <pre><code>&quot;terminal.integrated.profiles.linux&quot;: { &quot;bash&quot;: { &quot;path&quot;: &quot;/usr/bin/flatpak-spawn&quot;, &quot;args&quot;: [&quot;--host&quot;, &quot;--env=TERM=xterm-256color&quot;, &quot;zsh&quot;] } } </code></pre> <p>None works.</p> 0 How to modify Notion CSS on browser? I have the pieces, but need help putting them together Dan 2022-04-07T08:23:47Z 2022-04-07T08:23:47Z <p>I would like to modify Notion's CSS on Brave/Chrome browser so that it would show guidelines for indented text (and potentially more, if I can get that working).</p> <p>Basically what I would want is similar to the image here, which also shows some CSS code to make it work: <a href="" rel="nofollow noreferrer"></a></p> <p>I have also tried to follow this guide on how to modify the CSS on a site, by using the extension Stylus: <a href="" rel="nofollow noreferrer"></a></p> <p>I have tried copying that CSS from the first link into Stylus, but it doesn't seem to work. I don't know how to modify it to make it work though, unfortunately. Yet I think the ingredients should be all there if someone has enough expertise to piece them together. Can you help me make it work?</p> 0 VMWare VM does not see a Shared Folder ZedZip 2022-04-07T08:05:48Z 2022-04-07T08:05:48Z <p>My OS Windows, I have VMWare and VM with Ubuntu 21.10 inside.</p> <p>All works fine. But I'd like to have a Shared folder to exchange files. I have created in Windows the folder: SharedUFolder.</p> <p>Then go to VM Settings-&gt;Options: Shared Folders: Enabled (Always) , then Add and added Windows SharedUFolder. Ok. How to access this Shared folder in Ubuntu? I do not find it.</p> 0 Removing enterprise enrollment from chromebook [duplicate] Jens Nicolai Bruvik 2022-04-07T07:32:28Z 2022-04-07T08:21:04Z <p>I recently moved and my school said I would keep my Chromebook. The only problem is that they left the enterprise enrollment on. They told me to remove it, but I didn't manage. I have an Acer cb5 312t. I have already tried this. I have done it twice and I unplugged the battery connector and even the entire battery. It still wouldn't work. I even had it without the batter for over an hour. Is there some screw or something I am missing? Is there maybe a CMOS battery of sorts I have to remove or something? Please help me! I know I can replace the SSD, but I don't wanna invest SSD money into it. Another thing is that it has a take-home policy of sorts which allows it to unblock during non-school hours, but I have moved timezones so it doesn't work well. Any help would be apreciated!</p> <p>Make sure your Chromebook is off.</p> <p>Unscrew your Chromebook back cover.</p> <p>Unscrew the battery and unplug the power cord connecting the battery and the motherboard.</p> <p>Open your Chromebook and press the power button for 30 seconds. This should bypass the admin block.</p> <p>Place the battery back in and connect the power cords. Put the back cover on.</p> <p>Turn your Chromebook on and press esc + refresh + power It may take 9-15 minutes to boot based on your device. Do not follow this step until you reach the chrome screen.</p> <p>When you reach the &quot;Chrome Os is missing or damaged&quot; screen press Ctrl + d.</p> 0 How to upload a local map into PowerBI Remus Rigo 2022-04-07T07:26:58Z 2022-04-07T07:26:58Z <p>I am trying to load a custom map (svg) into Power BI and the local map button doesn't do anything. Is there a setting that enables this or is it blocked by some company policy?</p> <p><a href="" rel="nofollow noreferrer"><img src="" alt="enter image description here" /></a></p> 0 threejs autocompletion on nvim ANDuser 2022-04-07T07:26:39Z 2022-04-07T07:26:39Z <p>i want autocompletions for <a href="" rel="nofollow noreferrer">three.js</a> in nvim , kind of like the autocompletions we get if we open three.js file on a split window on vim [still not good], i searched in coc language plugins list, i cant find a plugin which satisfy my needs.<br> like,<br><br> <a href="" rel="nofollow noreferrer">image1</a><br><br> :spl path/to/three.js <br> ^W ↓<br> i<br><br> <a href="" rel="nofollow noreferrer">image2</a><br><br> this is just recommending random words from the file on the other window,<br> but what i need is sord of like,<br></p> <pre><code>THREE.| [Scene] [PerspectiveCamera] [WebGLRenderer] [Mesh] </code></pre> <p>sorry for not putting the images, because i cant [im a new user on superuser]</p> <p>i posted this same question on <a href="">stackoverflow</a> <strong>with images</strong></p> <p>since, that is the place for development and programming language related questions and i believe this is a place for Linux and Linux commands/software related doubts and questions</p> 0 Internet Explorer Mode in Microsoft Edge in Windows 11 Rauf 2022-04-07T07:13:35Z 2022-04-07T07:13:35Z <p>Some of our applications heavily depend on the ActiveX controls. As Microsoft discontinued support for Internet Explorer, we give a try for Microsoft Edge.</p> <ul> <li>Solution 1 : Using Microsoft Edge -&gt; Settings -&gt; Default browser</li> </ul> <p>This method works fine. But the added links will expire within 30 days. I have about 25 links, so every month I have to re-add ( the expiry can be adjusted to 90 days)</p> <ul> <li>Solution 2 : Using Enterprise Site List configured in Group Policy</li> </ul> <p>We have tried as in the below link but it is not working. We also tried in a standalone PC which is not connected to our domain.</p> <p><a href="" rel="nofollow noreferrer"></a></p> <p>After trying Solution 2 and could not succeed we have reverted all the adjustment done. But now the solution 1 itself is not working. After adding the link to &quot;Internet Explorer mode pages&quot; and restarting the Edge browser, the link is cleared.</p> <p>So what is the best option to use Internet Explorer in Microsoft Edge in Windows 11.</p> 0 Why has my phone started charging slowly from my laptop's USB port? Blaine 2022-04-07T06:56:45Z 2022-04-07T06:56:45Z <p>I understand that not all USB ports are created with power delivery in mind, and therefore some charge devices slower than others. What confuses me is the change in behavior. I swear around two years ago I could charge my phone at a reasonable speed from my laptop (around 3 hours maybe?). However, recently, it takes over five hours if I'm not using my phone at all simultaniously. Could there be some sort of USB driver that was updated and broke quicker charging?</p> <p>Laptop: MSI GS63<br> Phone: Galaxy S8</p> 1 Windows Search bar fills background with black color Yuriy Kirel 2022-04-07T06:38:22Z 2022-04-07T07:57:52Z <p>Today I launched my laptop, and when I hit the 3-finger gesture to open the search box, it blacked out the whole screen and then popped in the left part of my screen, taking more space than usual. It seemed weird to me, so I restarted. After restart, the problem seems to have gone, but not completely. Now I was able to capture a little bit of it. Once I again use a 3-finger gesture to pop up the search menu, it first fills up the space needed with black colour and then proceeds to animate. Here is a screenshot: <a href="" rel="nofollow noreferrer">Screenshot</a></p> <p>As you can see here, gray background is filling up blank black space. Is there something wrong with my pc or just random bug of windows? My laptop is pretty fresh so I wouldn't like to allow any kind of virus or something into it.</p> <p>EDIT</p> <p>Oh okay, I got first case after restarting explorer <a href="" rel="nofollow noreferrer">first case screenshot</a></p> 0 How to edit legends of a chart from cell range im_vutu 2022-04-07T05:55:59Z 2022-04-07T05:55:59Z <p>I have a list of legends and plot data in separate file. When I plot the data it creates legends as series1, series2, and so on. Now I want to replace the legends from cell list in other file. I can do that one by one from select data. But is there any way to replace all at once.</p> <p><a href="" rel="nofollow noreferrer">Chart from data</a> <a href="" rel="nofollow noreferrer">Legend list</a></p> 0 Please assist if possible for a file /folder issue Maize 2022-04-07T05:54:45Z 2022-04-07T06:06:30Z <p>I have a problem with a folder. I transferred it from a drive in order to zip it then archive it, How ever once I zipped the folder, and transferred the zipped contents back. I went to delete the unzipped counterpart of the folder. (I have attached a photo of the folder) but it says windows cannot locate the files/folder, there are no files left in the folder though, just remnants of the folder structure, but it simply wont go away, I really don't want to reformat the drive in order to get to it, because that would mean purchasing a drive to transfer the other data over. is there any way to get rid of this, I have tried numerous powershell, and cmd commands but its just persistent. I have scanned the folder but the comodo AV says it cannot locate the file/folders. I have tried a free file deleter but that didnt work (didnt think it would but you never know) I'm at a loss.</p> <p><img src="" alt="This image shows the folder and properties" /></p> <p><img src="" alt="This image of delete window output" /></p> 0 calling a flow from a function Twilio user2317446 2022-04-07T05:54:23Z 2022-04-07T05:54:23Z <p>I have a simple flow that posts incoming sms messages to slack. I also have a function that allows me to send SMS messages and receive them. (I.E if the sms is from MY_NUMBER and the message starts with +12121212: then it will send the message to +12121212. If the message is not from MY_NUMBER it will forward the sms to MY_NUMBER)</p> <p>I would like the function to trigger a flow instead of forwarding a message to MY_NUMBER</p> <p>I would like to trigger my flow after the function has run:</p> <p>e.g</p> <pre><code>exports.handler = function(context, event, callback) { const MY_NUMBER = '+0000000000000'; let twiml = new Twilio.twiml.MessagingResponse(); if (event.From === MY_NUMBER) { const separatorPosition = event.Body.indexOf(':'); if (separatorPosition &lt; 1) { twiml.message('You need to specify a recipient number and a &quot;:&quot; before the message.'); } else { const recipientNumber = event.Body.substr(0, separatorPosition).trim(); const messageBody = event.Body.substr(separatorPosition + 1).trim(); twiml.message({ to: recipientNumber }, messageBody); } } else { ***MY FLOW SHOULD BE TRIGGERED HERE*** // the above line should replace `twiml.message({ to: MY_NUMBER }, `${event.From}: ${event.Body}`);` } callback(null, twiml); }; </code></pre> 0 Excel cell becomes input or output depending on another cell Riccardo 2022-04-07T05:22:49Z 2022-04-07T05:36:00Z <p>I have a situation where depending if cell C5 is BUY or SELL, cell D14 respectively shows the outcome of a formula or I have to input a number. How can simply achieve it hopefully with programming?</p> <p><img src="" alt="enter image description here" /></p> 1 How do I convert an Excel calculation into a spilled dynamic array Weylin Piegorsch 2022-04-07T05:10:19Z 2022-04-07T08:37:59Z <p>I'm not even sure how to ask what I'm looking for, without describing the full question.</p> <p>if I have this table (CSV form at the bottom if anyone wants it):</p> <pre><code> A B C D E F G H I J | Date Performed | Hours | Pay Date | Pay Period | Pay Type | Verification | Period 1 | Pay Type | Period 2 | Pay Type | 1-Oct-2021 | 1.5 | 24-Sep-2022 | 1 | base pay | 1-May-2022 | 4.0 | base pay | 4.0 | base pay | 29-Oct-2021 | 1.5 | 24-Sep-2022 | 1 | retirement | 2-May-2022 | 2.5 | base pay | | | 29-Nov-2021 | 1.5 | 24-Sep-2022 | 2 | retirement | 19-May-2022 | 4.0 | base pay | 4.0 | base pay | 23-Dec-2021 | 1 | 24-Sep-2022 | 1 | retirement | 22-Sep-2022 | | | 2.5 | retirement | 23-Dec-2021 | 2 | 24-Sep-2022 | 2 | retirement | 23-Sep-2022 | 4.0 | retirement | 4.0 | retirement | 27-Jan-2022 | 0.5 | 24-Sep-2022 | 2 | retirement | 24-Sep-2022 | 4.0 | inconsistent | 4.0 | retirement | 2-Feb-2022 | 0.5 | 23-Sep-2022 | 1 | retirement | 25-Sep-2022 | | | 4.0 | retirement | 22-Feb-2022 | 2 | 23-Sep-2022 | 1 | retirement | 27-Feb-2022 | 2.5 | 23-Sep-2022 | 2 | retirement | 28-Feb-2022 | 0.5 | 23-Sep-2022 | 2 | retirement | 2-Mar-2022 | 0.5 | 23-Sep-2022 | 1 | retirement | 3-Mar-2022 | 1 | 23-Sep-2022 | 1 | retirement | 4-Mar-2022 | 0.5 | 25-Sep-2022 | 2 | retirement | 6-Mar-2022 | 1 | 23-Sep-2022 | 2 | retirement | 6-Mar-2022 | 2 | 1-May-2022 | 1 | base pay | 7-Mar-2022 | 2 | 1-May-2022 | 1 | base pay | 8-Mar-2022 | 0.5 | 2-May-2022 | 1 | base pay | 8-Mar-2022 | 1.5 | 25-Sep-2022 | 2 | retirement | 9-Mar-2022 | 1 | 22-Sep-2022 | 2 | retirement | 10-Mar-2022 | 1 | 1-May-2022 | 2 | base pay | 13-Mar-2022 | 1.5 | 1-May-2022 | 2 | base pay | 14-Mar-2022 | 1.5 | 1-May-2022 | 2 | base pay | 15-Mar-2022 | 1 | 2-May-2022 | 1 | base pay | 17-Mar-2022 | 1 | 2-May-2022 | 1 | base pay | 17-Mar-2022 | 2 | 25-Sep-2022 | 2 | retirement | 18-Mar-2022 | 1 | 22-Sep-2022 | 2 | retirement | 24-May-2022 | 0.5 | 22-Sep-2022 | 2 | retirement | 19-May-2022 | 4 | 19-May-2022 | 1 | base pay | 19-May-2022 | 4 | 19-May-2022 | 2 | base pay </code></pre> <p>F2: <code>=SORT(UNIQUE(FILTER(C:C,ISNUMBER(C:C))))</code></p> <p>G2: <code>=LET(x,F2#,SUMIFS(B:B,C:C,x,D:D,1))</code></p> <p>I2: <code>=LET(x,F2#,SUMIFS(B:B,C:C,x,D:D,2))</code></p> <p>One complete pay period is 4hr; there can be up to two pay periods in a day. But, if there are only a handful of hours used, they can be incrementally combined into another arbitrary day, and get paid-out when a pay period aggregates to 4hr.</p> <p>I get get H2 to work as: <code>=IF(--G2=0,&quot;&quot;,LET(x,FILTER(E:E,(C:C=F2)*(D:D=1)),IF(AND(EXACT(x,@x)),@x,&quot;inconsistent&quot;)))</code></p> <p>Essentially it ensures that everything in a given pay date/pay period is funded from the same pool, either the base pay pool or the retirement pool.</p> <p>I can copy/paste that just fine. But, is there a way H2 can be re-formulated to yield a dynamic spilled range the same length as F2# and G2#?</p> <p>(In case anyone is curious, this is how US Military Reserve pay works, this is a tracker I'm using to make sure I'm being honest in what I'm claiming.)</p> <p>CSV form of the above table:</p> <pre><code>Date Performed,Hours,Pay Date,Pay Period,Pay Type,,Verification,Period 1,Pay Type,Period 2,Pay Type 1-Oct-2021,1.5,24-Sep-2022,1,base pay,1-May-2022,4.0,base pay,4.0,base pay 29-Oct-2021,1.5,24-Sep-2022,1,retirement,2-May-2022,2.5,base pay,, 29-Nov-2021,1.5,24-Sep-2022,2,retirement,19-May-2022,4.0,base pay,4.0,base pay 23-Dec-2021,1,24-Sep-2022,1,retirement,22-Sep-2022,,,2.5,retirement 23-Dec-2021,2,24-Sep-2022,2,retirement,23-Sep-2022,4.0,retirement,4.0,retirement 27-Jan-2022,0.5,24-Sep-2022,2,retirement,24-Sep-2022,4.0,inconsistent,4.0,retirement 2-Feb-2022,0.5,23-Sep-2022,1,retirement,25-Sep-2022,,,4.0,retirement 22-Feb-2022,2,23-Sep-2022,1,retirement,,,,, 27-Feb-2022,2.5,23-Sep-2022,2,retirement,,,,, 28-Feb-2022,0.5,23-Sep-2022,2,retirement,,,,, 2-Mar-2022,0.5,23-Sep-2022,1,retirement,,,,, 3-Mar-2022,1,23-Sep-2022,1,retirement,,,,, 4-Mar-2022,0.5,25-Sep-2022,2,retirement,,,,, 6-Mar-2022,1,23-Sep-2022,2,retirement,,,,, 6-Mar-2022,2,1-May-2022,1,base pay,,,,, 7-Mar-2022,2,1-May-2022,1,base pay,,,,, 8-Mar-2022,0.5,2-May-2022,1,base pay,,,,, 8-Mar-2022,1.5,25-Sep-2022,2,retirement,,,,, 9-Mar-2022,1,22-Sep-2022,2,retirement,,,,, 10-Mar-2022,1,1-May-2022,2,base pay,,,,, 13-Mar-2022,1.5,1-May-2022,2,base pay,,,,, 14-Mar-2022,1.5,1-May-2022,2,base pay,,,,, 15-Mar-2022,1,2-May-2022,1,base pay,,,,, 17-Mar-2022,1,2-May-2022,1,base pay,,,,, 17-Mar-2022,2,25-Sep-2022,2,retirement,,,,, 18-Mar-2022,1,22-Sep-2022,2,retirement,,,,, 24-May-2022,0.5,22-Sep-2022,2,retirement,,,,, 19-May-2022,4,19-May-2022,1,base pay,,,,, 19-May-2022,4,19-May-2022,2,base pay,,,,, </code></pre> 3 Excel - Need formula help for project at work Rebecca Krouse 2022-04-07T02:25:58Z 2022-04-07T06:57:47Z <p>I am working on a project at work where I am pulling a report each week from one of our systems and pasting it into a &quot;DATA&quot; tab in a workbook.</p> <p>There are then 6 other tabs that are specified by region - &quot;Midwest&quot;, &quot;Northeast&quot;, etc. The report I pull does not have the region located in the data, so I've contemplated creating another tab as a sort of look-up table, but I'm not sure how to connect all of this.</p> <p>Basically, when I paste the report data into the DATA tab, I need formulas on the region tabs that will determine if the State is a member of that region and populates all of the rows and columns on the corresponding tab.</p> <p>I'm posting a screenshot of what the DATA tab looks like (confidential information removed) and an example of what the region tab should like. Any help is greatly appreciated!</p> <p>Example of DATA tab:</p> <p><a href="" rel="nofollow noreferrer"><img src="" alt="Example of DATA tab" /></a></p> <p>Example of what region tab should like:</p> <p><a href="" rel="nofollow noreferrer"><img src="" alt="Example of what region tab should like" /></a></p> 0 Ffmpeg GPU encoding not speeding up processing madderek 2022-04-06T18:39:29Z 2022-04-07T08:27:36Z <p>ffmpeg -framerate 29.97 -hwaccel cuda -start_number 200000 -i %06d.tif -c:v libx264 -preset veryslow -tune film -profile:v high -pix_fmt yuv420p -level 4.1 -crf 17 -r 29.97 -threads 2 -frames:v 5000 ade-20000_202559_ArtemisHQ_tiff.mkv</p> <p>I’m using the above command line to join together TIFF files that have been produced by a video enhance program, to produce a final video. I’m using a 2080ti GPU on Linux ver 20. Ffmpeg has been compiled using an online tutorial for Nvidia video encoding. My problem is that running the command with the -hwaccel cuda doesn’t increase the speed of processing much. I have used NVTOP to check that the GPU is being used. It shows 1% GPU and 200% CPU. Without the -hwaccel cuda NVTOP obviously doesn’t show any data.</p> <p>Yes, it is to speed up the encoding. As the second answer says, maybe it can't be done because of the frequent read of files. I will still try the replacement with the nvenc command.</p> <p>Thanks for all three prompt replies.</p> <p>So I tried:</p> <p>ffmpeg -framerate 29.97 -hwaccel cuda -start_number 200000 -i %06d.tif -c:v h264_nvenc -preset veryslow -tune film -profile:v high -pix_fmt yuv420p -level 4.1 -crf 17 -r 29.97 -threads 2 -frames:v 5000 ade-20000_202559_ArtemisHQ_tiff.mkv I got:</p> <p>Codec AVOption crf (Select the quality for constant quality mode) specified for output file #0 (ade-20000_202559_ArtemisHQ_tiff.mkv) has not been used for any stream. The most likely reason is either wrong type (e.g. a video option with no video streams) or that it is a private option of some encoder which was not actually used for any stream. Codec AVOption tune (Tune the encoding to a specific scenario) specified for output file #0 (ade-20000_202559_ArtemisHQ_tiff.mkv) has not been used for any stream. The most likely reason is either wrong type (e.g. a video option with no video streams) or that it is a private option of some encoder which was not actually used for any stream. When the command ran I got:</p> <p>[h264_nvenc @ 0x559577472b40] [Eval @ 0x7ffd3759cc40] Undefined constant or missing '(' in 'veryslow' [h264_nvenc @ 0x559577472b40] Unable to parse option value &quot;veryslow&quot; [h264_nvenc @ 0x559577472b40] Error setting option preset to value veryslow. Error initializing output stream 0:0 -- Error while opening encoder for output stream #0:0 - maybe incorrect parameters such as bit_rate, rate, width or height Conversion failed!</p> <hr /> <p>So I tried:</p> <pre class="lang-bsh prettyprint-override"><code>ffmpeg -framerate 29.97 -hwaccel cuda -start_number 200000 -i \%06d.tif -c:v h264_nvenc -preset veryslow -tune film -profile:v high -pix_fmt yuv420p -level 4.1 -crf 17 -r 29.97 -threads 2 -frames:v 5000 ade-20000_202559_ArtemisHQ_tiff.mkv </code></pre> <p>I got:</p> <pre><code>Codec AVOption crf (Select the quality for constant quality mode) specified for output file #0 (ade-20000_202559_ArtemisHQ_tiff.mkv) has not been used for any stream. The most likely reason is either wrong type (e.g. a video option with no video streams) or that it is a private option of some encoder which was not actually used for any stream. Codec AVOption tune (Tune the encoding to a specific scenario) specified for output file #0 (ade-20000_202559_ArtemisHQ_tiff.mkv) has not been used for any stream. The most likely reason is either wrong type (e.g. a video option with no video streams) or that it is a private option of some encoder which was not actually used for any stream. </code></pre> <p>When the command ran I got:</p> <pre><code>[h264_nvenc @ 0x559577472b40] [Eval @ 0x7ffd3759cc40] Undefined constant or missing '(' in 'veryslow' [h264_nvenc @ 0x559577472b40] Unable to parse option value &quot;veryslow&quot; [h264_nvenc @ 0x559577472b40] Error setting option preset to value veryslow. Error initializing output stream 0:0 -- Error while opening encoder for output stream #0:0 - maybe incorrect parameters such as bit_rate, rate, width or height Conversion failed! </code></pre> <p>Could this be where I've placed the command? You'll probably guess that I am not good at Linux or ffmpeg.</p> 0 How to delete all files (or the entire content of all files) with less than 250 words with Regex? Hellena Crainicu 2022-04-06T15:12:08Z 2022-04-07T05:51:51Z <p>Is it possible to delete all files (or the entire content of all files) with less than 250 words?</p> <p>I try this regex, but needs to be improved a little bit. Can anyone help me?</p> <ul> <li>Find: <code>(?s)(.*?(\w+\s?){1,250}).*$</code></li> <li>Replace with: <code>(EMPTY)</code></li> </ul> 0 Can not delete read-only file on mac Деревянко Сергей 2022-04-06T07:56:10Z 2022-04-07T07:55:57Z <p>I have a problem with the deletion read-only file, i have disabled csrutil, but it still problem. <a href="" rel="nofollow noreferrer"><img src="" alt="enter image description here" /></a></p> <p>How i can delete /usr/bin/ruby file ?</p> 0 Add a IP to another rule matching hex in iptables linux Amey Mhatre 2022-04-05T18:24:53Z 2022-04-07T07:16:58Z <p><strong>iptables -t raw -A PREROUTING -p udp --dport 4578 -m string --hex-string '|fefffffffffffffffff77f12|'</strong></p> <p>How can I whitelist the IP having the above hexx string automatically on Iptables.</p> <p>I'll be dropping all incoming traffic on iptables and allowing only the packet with above hex string. Whenever we receive a packet with above hex string the I want to whitelist his IP on Iptables immediately. So that all traffic from that particular IP gets passed</p> <p>Thanks in Advance</p> 0 How to get a running sum - floating above the cell CIsForCookies 2022-04-05T06:58:35Z 2022-04-07T07:05:16Z <p>I have a column of natural numbers (1, 2, 3...) and I want to know the sum up until a certain point <strong>without opening a new column that would calculate the sum</strong>.</p> <p>Basically, I want to have a floating label, that pops whenever I hover on a cell, with a formula in it - where the formula is <code>sum(A1:A&lt;current_index&gt;)</code></p> <p>Is that possible? (I'm also fine with the having that data pop on the column's header instead)</p> <p><em>I'm working in google sheets, so some of MSExcel functions won't be available I guess</em></p> 1 How to restrict mouse and graphics tablet to primary monitor? Matthew Johnson 2021-01-17T12:13:44Z 2022-04-07T07:06:14Z <p>I have a MacBook connected to a monitor as an extended display. I am using a wacom graphics tablet. I want to restrict the wacom to the primary display only and not move onto the secondary display.</p> <p>The graphics tablet is small so using it across two display is difficult.</p> <p>Can the same be done with a mouse?</p> 2 Transparent windows in Windows 10 Pro over videos & color shift while browsing Ameed Abu Ghazal 2020-11-29T12:16:20Z 2022-04-07T07:07:15Z <p>I recently bought a new MSI laptop and after installing windows 10 pro I am facing some issues with the screen. First of all, it goes to night mode (shifts color tune) when I am browsing the internet or any light-colored pages like Microsoft Word, it keeps getting warmer and lighter so often when scrolling or changing the window size.</p> <p>Second, I have a transparency issue whenever I play a video on youtube or on windows, all the windows over the video become transparent and I can't figure out how to solve these issues.</p> <p>I appreciate all your help.</p> <p>My device is: MSI GE75 Raider 10SGS-444XES<br /> Intel Core i7-10875H/32GB/1TB SSD/<br /> RTX 2080 SUPER/17.3&quot;/ 240Hz/ intel UHD Graphics<br /> Windows 10 Pro</p> <p><a href="" rel="nofollow noreferrer">color-shift &amp; nightmode problem - YouTube video</a></p> <p><img src="" alt="transparency 1" /> <img src="" alt="transparency 2" /></p> 14 How to connect wsl to a windows localhost? ygy 2020-03-24T03:48:59Z 2022-04-07T08:39:26Z <p>I'm trying to let WSL use a localhost proxy(actually its Fiddler) on my windows, but I can't see any connection like that, and downloads usually fail, how do I fix that?</p> <p>I know that I can connect to Linux localhost from the windows one, but how can I reverse this?</p> <p>WSL is Ubuntu 18.04</p> 1 Heroku Error: ENOENT: no such file or directory, stat '/app/client/build/index.html' user1017131 2019-04-04T21:31:38Z 2022-04-07T08:02:45Z <p>App repo: <a href="" rel="nofollow noreferrer"></a></p> <p>To preface, my web app has been pushed to Heroku.</p> <p>I'm trying to successfully build my MERN web application onto Heroku, but when I visit my app page (<a href="" rel="nofollow noreferrer"></a>), it just returns the error "Not Found" from the root GET response. When I view the logs for my Heroku app, this error displays when a root request is sent:</p> <p><code>Error: ENOENT: no such file or directory, stat '/app/client/build/index.html'</code></p> <p>So, I went into my local CLI and ran <code>heroku run bash</code>, viewed the current files and directories, and found that /app/client/build/ didn't exist. This leads me to believe that it isn't being generated using my heroku-postbuild script defined in my <a href="" rel="nofollow noreferrer">package.json</a> (no idea why it isn't running when I <code>git push heroku master</code>). Out of desperation, I ran <code>npm install &amp;&amp; npm run build</code> inside my client folder (where my react app is located), and now the build folder containing index.html is on my heroku app. When I try to view the app however, I still get an error of "Not Found".</p> <p>I've been trying to debug this for hours, no idea what is wrong. The static files (build folder) are being defined inside <a href="" rel="nofollow noreferrer">server.js</a> if you'd like to take a look.</p> <hr> <p>EDIT: I just removed build from .gitignore and pushed to heroku, and my app works now. So the main problem is that my heroku-postbuild script isn't running even though the name is clearly defined in this documentation: <a href="" rel="nofollow noreferrer"></a></p> 1 Auto confirm eject usb device using powershell command Tobi Obadiah 2018-05-18T05:05:48Z 2022-04-07T05:03:55Z <p>I have to use this PowerShell command to eject USB drive</p> <pre><code>$driveEject = New-Object -comObject Shell.Application $driveEject.Namespace(17).ParseName("E:").InvokeVerb("Eject") </code></pre> <p>Whenever I do Windows always ask me to confirm, How can I get it to force eject or auto confirm using this command? I have explored some suggestions like <a href="">here</a> but none seem to work with this particular command.</p> 0 Find unique or duplicate values between two worksheets WebUserLearner 2017-02-28T22:40:02Z 2022-04-07T07:04:40Z <p>I have multiple worksheets with the results from various searches on a database. I'd like to compare them to find any unique hits (or duplicates if that's easier). Each worksheet has the same column headings but the data in the rows may or may not be different and may be in a different order. For example, if Search1 finds ROGER and ROGER is on row 27, and I compare that with the result of Search2, which finds ROGER but puts him on row 6, I'd like a method that would know that row 6 and 27 are the same data even though the position is different.</p> 4 Are there motherboards that support dual PSUs connections? user1028270 2015-10-09T15:15:20Z 2022-04-07T08:02:45Z <p>I was thinking about how I would build myself a server with redundant power supplies.</p> <p>Now they sell redundant PSU units, but they are proprietary. If one PSU in the unit fails and you want to replace it you have to buy a replacement PSU that unit supports.</p> <p>Do they make motherboards that have two PSU connections- the idea being you plug any two PSU into the motherboard and when one fails the mobo will intelligently switch over to the other.</p> <p>I couldn't find any that do this which makes me think there is something inherently bad/unrealistic about this idea.</p> 1 Setting up a transparent proxy on Mac OS X Zimm3r 2013-11-10T18:46:12Z 2022-04-07T06:00:10Z <p>I have a proxy running that I can successfully use with both Firefox and Safari. However flash is less amiable and from what I read it will not use a system proxy unless if cannot connect directly. Is there a way on Mac OS X to force everything through a proxy. That is only allow the proxy access to the outside internet?</p> <p>Edit:</p> <p>Ran route this is what I got and then all internet stopped working even with the proxy running</p> <pre><code>Mac:~ user$ sudo route flush Password: default xx.xx.xx.xx done route: write to routing socket: No such process got only -1 for rlen Mac:~ user$ sudo route add route: writing to routing socket: Invalid argument add host Invalid argument </code></pre> <p>Then I launch TCPCatcher and run it on port 8200 with monitor SSL enabled and Transparent Proxy unchecked.</p> <p>I then set my Proxy in System Preferences to</p> <p>After that I set firefox to use the System Proxy</p> <p>I then attempt to connect to a website and it fails.</p> 1 Arch Linux booting with read only filesystems user1659754 2012-09-10T18:00:51Z 2022-04-07T06:00:10Z <p>I installed Arch today and when I logged in I noticed that my filesystem is read only.</p> <p>How can I fix this?</p> 0 Sharing Template emails in public folders clang1234 2010-01-27T22:51:52Z 2022-04-07T07:04:40Z <p>I have a template email I've created and saved on my local templates folder. How do I share my template so anyone on my domain can use it?</p>