How To Add a Welcome Message for SSH Users

Here is a very easy tip on how to add a welcome message for your SSH users

If you want that when users connect to your SSH server, they see a banner welcome message after connecting. Then you need to turn on the banner configuration of SSHd in its config file and then create a banner file.

Step 1:

Create a banner file that contains text you want people to see when connecting to your SSH server.

Create and open the banner file:

[root@amit]# vim /home/username/banner

put your message inside it

*****************************************************************
*This is a private SSH Server. You are not supposed to be here. *
*Your information has been logged and a report has been emailed *
*to the admin concerning your unauthorized attempts. *
*****************************************************************

then save & quit by using :wq!



Step 2:

Edit /etc/ssh/sshd_config to set a default banner path.

[root@amit]# vi /etc/ssh/sshd_config

then add the following to the config file:

Banner /path/to/banner

Save the file and quit: :wq

Step 3:

Restart the sshd server.

[root@amit] # /etc/init.d/sshd restart

Step 4:

Try SSH to your server and check Welcome banner on login


From the desk of Amit Maheshwari

Read More

How to connect mssql with php using FEDORA

Connecting to MSSQL datbase with php from Fedora or any other Linux flovour is a pretty much easy.

In Linux Freetds Package provide libraries to connect to the MSSQL database, which can be installed with a yum command:

# yum install php-mssql

the above command asks to install MSSQL extension for PHP, but yum will take care of all the dependencies including Freetds.

Once installed you can use a low level tool like tsql which comes with Freetds to check you setup, but before that edit the Freetds config file (/etc/freetds.conf):

[root@amit]# vim /etc/freetds.conf


[MSSQL]
host = 192.168.1.1
port = 1433
tds version = 8.0

above is a simple configuration that I use to connect to SQL2005/2000 databases. The braces contain a name (any name you like) to refer to the connection from Linux, and host is the IP of the MSSQL Server, port is the port MSSQL is listening on and the tds version is the TDS Protocol Version to use when connecting with database. Now regarding the port, MAKE SURE that you are connecting to the correct MSSQL port. OK, Lets check with tsql now:

# tsql -S MSSQL -U user -P pass

that should give u a prompt like “1>”

Now check whether PHP can connect:

# php -r 'echo mssql_connect("MSSQL","user","pass");'


From the desk of Amit Maheshwari




Read More

How to Prevent Yum update of some selected packages in Redhat/Fedora

It is very Simple to exclude some selected packages not to update while using yum update command

All you need to do is add an exclude line to the end of your [main] section in /etc/yum.conf .

Your /etc/yum.conf should look something like this:

[main]
cachedir=/var/cache/yum
keepcache=0
debuglevel=2
logfile=/var/log/yum.log
exactarch=1
obsoletes=1
gpgcheck=1
plugins=1
installonly_limit=3
exclude= hal bash*

This will prevent upgrades of the hal package as well as bash package while using yum update cmd. The list of apps in the exclude should be space sepeated. Shell wildcards ( * ? ) can also be included.

From the desk of Amit Maheshwari

Read More