Hosting Blog

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 LoginName
FROM
    sys.sysprocesses
WHERE
    dbid > 0
GROUP BY
    dbid, loginame
#############################################################

Check space for a particular table in the MSSQL Database

Use <Database Name>
go
sp_spaceused <Table Name>

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

[[email protected] ~]# 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

Read More

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 write the folder name which you want to delete.

D:\folder %%X = path by which you want to search those folders.

Open Notepad and then paste that script and save as a .bat file.

Plesk 12 FTP issue- FTP connecting but files not showing

A) We have to add a port on the Plesk server for passive FTP.

[[email protected] ~]#  cd /etc/proftpd.d/
[[email protected] proftpd.d]# cp -pvf 50-plesk.conf 50-plesk.conf_orig
[[email protected] proftpd.d]# vi 50-plesk.conf
Add 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 over SSH.
Go to Modules > Firewall > Edit Firewall Configuration.
Click Add Custom Rule.

Specify the details below:

1. Rule name - Passive FTP
2. Direction: select Incoming.
3. Action: select Allow.
4. Ports: in the Add Port input box, enter the value 57000-58000. Leave the TCP option selected, and click Add.
5. Click OK.
6. Click Activate, and then click Activate again.