-
Check the total number of active connections on the MSSQL Database server
Please use the query below to check the total number of active connections at a time, on the MSSQL database server :- ################################################################# SELECT DB_NAME(dbid) as elitemoving, COUNT(dbid) as NumberOfConnections, loginame as LoginNameFROM sys.sysprocessesWHERE dbid > 0GROUP BY dbid, loginame############################################################# ]]>
-
Check space for a particular table in the MSSQL Database
Use gosp_spaceused Note : It works with MSSQL 2000/2005/2008/2012 ]]>
-
Setup a custom header for the H-Sphere Horde webmail client
Login to the mail server through SSH [root@mailServer ~]# vi /hsphere/shared/apache/htdocs/horde/imp/config/header.php /* Add your custom entries below this line. */$_header[‘X-Horde-User’] = Auth::getAuth(); ]]>
-
How to make ASP.NET MVC 4 or 5 work
If the user is facing trouble with ASP.NET MVC 4 or 5, then please add the below content in his/her domain webconfig file under the configuration section to make it work. ============================================================================================ ============================================================================================= If module is already define in user domain web config then only need to add below context. ====================================================================================================================================================== ]]>
-
Deleting folders at various locations using Single Script on Windows
One may find a malicious folder created in mulitple domains under various folders/subfolders. It is hard to delete those folders one by one. So you can use the script below to delete those folders recursively FOR /D /R D:\folder %%X IN (PUMA) DO RMDIR /S /Q “%%X” In the “%%X” flie, you will need to […]
-
Plesk 12 FTP issue- FTP connecting but files not showing
A) We have to add a port on the Plesk server for passive FTP. [root@plskl1 ~]# cd /etc/proftpd.d/[root@plskl1 proftpd.d]# cp -pvf 50-plesk.conf 50-plesk.conf_orig[root@plskl1 proftpd.d]# vi 50-plesk.confAdd the line below in the global section- PassivePorts 57000 58000 B) Setup a custom firewall rule in the Plesk control panel. Log in as “root” to the server shell […]
-
How to discard all the emails for non-existing mailboxes (Qmail server)
1. Login onto the Qmail server. 2. Create a catchall mailbox like [email protected] 3. Find out the domain directory with the command below-[root@mail ~]# ~vpopmail/bin/vdominfo .com 4. Edit the .qmail-default file as below:[root@mail ~]# vi /home/vpopmail/domains/.com/.qmail-default===================================================================================Replace the line-| /home/vpopmail/bin/vdelivermail ” bounce-no-mailbox With this line-| /home/vpopmail/bin/vdelivermail ” delete=================================================================================== 5. Restart the qmail services[root@mail ~]# /etc/init.d/qmaild restart […]
-
How to setup a catch-all account on the Qmail server
1. Login onto the Qmail server 2. Create a catchall mailbox like [email protected] 3. Find out the domain directory with the command below-[root@mail ~]# ~vpopmail/bin/vdominfo .com 4. Edit the .qmail-default file as below: [root@mail ~]# vi /home/vpopmail/domains/.com/.qmail-default===================================================================================Replace the line-| /home/vpopmail/bin/vdelivermail ” bounce-no-mailbox With this line-| /home/vpopmail/bin/vdelivermail ” /home/vpopmail/domains/.com/catchall=================================================================================== 5. Restart the qmail services[root@mail ~]# /etc/init.d/qmaild […]
-
The use of the undefined constant REQUEST_URI
$_SERVER[REQUEST_URI] is syntactically incorrect and AFAIK will not run on a default installation of PHP 5. The array index is a string so it needs to be passed strings. I know PHP 4 converted undefined constants to strings inside the square brackets but it’s still not good practice. EDIT: Well unless you define a constant called […]
-
Setting up the check_mk agent on Linux
1. Verify if the server already has the check_mk agent installed, using the command below:[root@cpannneltest ~]# rpm -qa | grep check_mk If this returns any matching package name, this means that the check_mk agent is already installed. 2. If no result is returned by the command above, check_mk is missing, and can be set up […]