I.T. minded
In Powershell, you can also use a grep like you can do on Linux.In order to search for a string in a file, you can use the following command: If you want to have the output without filename, line number: If If you want to ‘grep’ multiple words, you can…
You can use the following mod_security rules for wordpress/joomla/drupal ## Rules for the CWP ## SecRuleRemoveById 910006SecRuleRemoveById 950000SecRuleRemoveById 950001SecRuleRemoveById 950005SecRuleRemoveById 950006SecRuleRemoveById 950117SecRuleRemoveById 950907SecRuleRemoveById 958039SecRuleRemoveById 958051SecRuleRemoveById 958291SecRuleRemoveById 959006SecRuleRemoveById 959151SecRuleRemoveById 960008SecRuleRemoveById 960010 SecRuleRemoveById 960011 SecRuleRemoveById 960012 SecRuleRemoveById 960035 SecRuleRemoveById 960335 SecRuleRemoveById 960904 SecRuleRemoveById 960915 SecRuleRemoveById 970003 SecRuleRemoveById 970015 SecRuleRemoveById 970903 SecRuleRemoveById 973301 SecRuleRemoveById 973302 SecRuleRemoveById 973306 SecRuleRemoveById 973316 SecRuleRemoveById 973330 SecRuleRemoveById 973331 SecRuleRemoveById 973332 SecRuleRemoveById 973334 SecRuleRemoveById 973335 SecRuleRemoveById 973336 SecRuleRemoveById 973344 SecRuleRemoveById…
The following t-sql statement returns the server name, server instance, instance, edition & version of the running SQL-Server.
When tracing with SQL profiler, it returned a query using ‘sp_cursorprepexec’. When executing the same query within SSMS, it failed with: sp_cursorprepexec: The value of the parameter XX is invalid. I managed to solve this by adding ‘+ 0x1000’ to the parameter
When running pre/post scripts, it is possible that you are getting the following error message: 2017-03-20 19:43:43 avtar Info <5916>: Executing run-at-start ‘/usr/local/avamar/etc/scripts/test.sh’2017-03-20 19:43:43 avtar Info <6033>: Begin STDERR from run-at-start:avspawn::spawn after execve errno:8 code 8: Exec format error In order to resolve that, ensure that you specified the…
There are different possibilities to run internet speed tests from Linux (and Unix based systems) command line. Personally I don’t always want to install extra applications on the servers.Because of that, I use the following command line. The only thing what is needed is wget & python, tools which you…
Add the following options to the java: -Dcom.sun.management.jmxremote-Dcom.sun.management.jmxremote.port=8010-Dcom.sun.management.jmxremote.local.only=false-Dcom.sun.management.jmxremote.authenticate=false-Dcom.sun.management.jmxremote.ssl=false
You can use the following command, as superuser, to clear the systemd logs: Keep the last 7 days: journalctl –vacuum-time=7d Keep the last 100Mb: journalctl –vacuum-size=100M
It is sometimes required to only have a mailbox in Ispconfig for login purposes. For example: to allow gmail to send email in the name of that person. But without actually saving the mail in the mailbox, and only forwarding the e-mail. In order to achieve this, you can use…
List running processes and sort by cpu Get-Process | Sort-Object -Property cpu -Descending
Within Powershell you can also see when a LOCAL user was last logged in. This can be done with the following one-liner: $([ADSI]”WinNT://$env:COMPUTERNAME”).Children | where {$_.SchemaClassName -eq ‘user’} | ft name,lastlogin example output: name lastlogin —- ——— {localadmin} {28/09/2016 08:57:19} {nx} {05/01/2017 19:52:58} {Visitor}
With Powershell you can also find files which are larger than a certain size. This can be accomplished with the command below. In this example we are looking for files larger than 100MB, on the C drive. Get-ChildItem c:\ -Recurse | Where-Object {$_.Length -gt 100MB}
If you want to test a firewall rule, while the application isn’t ready yet, you can start that port on the Windows server using Powershell. This way you can test the firewall functionality. Those actions can be done with the following commands: $Listener = [System.Net.Sockets.TcpListener]4444; $Listener.Start(); Where “4444” is the…
Performance issues. Everybody had them once, and more 🙂 If you are using Windows 2012+ and Powershell, you can use the Get-Counter command in order to provide you more information regarding the TCP connections. In the example below, we are getting the counters for IPv4 TCP: Get-Counter -Counter \TCPv4\* This…
If you want to configure the DNS suffix search list on Windows 2012+, you can use the set-DnsclientGlobalSetting command, as shown in the example below. This will set the DNS search list to “domain.local”: set-DnsClientGlobalSetting -SuffixSearchList @(“domain.local”)
Sometimes there are some applications which take the ‘first network card’ in order to send/receive traffic. If you have multiple network cards, this can be problematic of course. In case you want to resolve that, you can change the order of the network cards. In order to do that, first…
Is your postfix mail queue full of spam? You are not the only one 🙂 In that case it could be interesting to clear your queue, before the spam gets send out. In order to remove all mail from the postfix queue, execute the following command as superuser: #> postsuper…