Linux Tech Support

How to connect mssql with php using FEDORA

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<b><span style="font-size: large;"> How to connect mssql with php using FEDORA</span></b></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">Connecting to MSSQL  datbase </span><span style="font-size: 85%;">with php </span><span style="font-size: 85%;">from Fedora or any other Linux  flovour is a pretty much easy.</span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">In Linux Freetds Package provide libraries to connect to the MSSQL database, which can be installed with a yum command:</span></span></div>
<div style="color: #3333ff; text-align: justify;">
<br /></div>
<div style="color: #3333ff; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code># yum install php-mssql</code></span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">the above command asks to install <b>MSSQL </b>extension for PHP, but yum will take care of all the dependencies including Freetds.</span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">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):</span></span></div>
<div style="color: #3333ff; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code>[root@amit]# vim /etc/freetds.conf</code></span></span></div>
<div style="color: #3333ff; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code>[MSSQL]<br />host = 192.168.1.1<br />port = 1433<br />tds version = 8.0</code></span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">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:</span></span></div>
<div style="color: #000099; text-align: justify;">
<br /></div>
<div style="color: #000099; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code># tsql -S MSSQL -U user -P pass</code></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">that should give u a prompt like “1>”</span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">Now check whether PHP can connect:</span></span></div>
<div style="color: #000099; text-align: justify;">
<br /></div>
<div style="color: #000099; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code># php -r 'echo mssql_connect("MSSQL","user","pass");'</code></span></span></div>
<div style="color: #000099; text-align: justify;">
<br /></div>
<div style="color: #000099; text-align: justify;">
<br /></div>
<div style="color: #000099; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">From the desk of <a href="http://www.amitmaheshwari.in/" target="_blank"><span style="color: #006600; font-style: italic;">Amit Maheshwari</span></a></span><br /><span style="font-size: 85%;"><code></code></span></span></div>
<div style="color: #000099; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code><br /></code></span></span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"><br /></span></div>
</div>

How to connect mssql with php using FEDORA

How to connect mssql with php using FEDORA Connecting to MSSQL datbase with php from Fedora or any other Linux flovour is a pretty ...

9:51 PM

Using_mysqldump_Backup_&_Restore_MySQL_Database

Using_mysqldump_Backup_&_Restore_MySQL_Database

Backup and Restore MYSQL Databases Using mysqldump , you can backup a local database and restore it on a remote database at the same tim...

4:57 AM

How do I password-protect my website using .htaccess?

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-size: large;"><b>Htaccess can be used to password-protect directories on your web sites.</b></span><br />
<br />
You can do this Password Protection very easily by using below steps<br />
<span style="color: #003300;"><b><span style="color: black;">Step 1</span></b>.</span> Change to the directory that you wish to protect<br />
<br />
In the following example we wish to protect a directory called pvt in our htdocs directory.<br />
<span style="color: #000099;">[root@amit ]# cd /usr/local/apache2/htdocs/</span><br />
<span style="color: #000099;">[root@amit.htdocs] # mkdir pvt</span><br />
<br />
<b>Step 2</b>. Create a file named .htaccess<br />
Use your favourite editor to create a file called .htaccess . In the below example we will use vim.<br />
<span style="color: #000099;">[root@amit.htdocs] # vim .htaccess</span><br />Add <span style="color: #000099;"><i>following</i></span> lines in .htaccess file<br />
<br />
<i>AuthUserFile /usr/local/apache2/conf/.htpasswd</i> #### path of .htpasswd file<br />
<i>AuthName "My Private Password Protect Directory"</i> ### title for the username/password input box.<br />
<i>AuthType Basic</i><br />
<i>Require valid-user amit</i> #### vaild user name<br />
<br />
<b>Step 3.</b> Create the .htpasswd file by adding users<br />
<span style="color: #000099;">[root@amit.htdocs] # htpasswd -c /usr/local/apache2/conf/.htpasswd amit</span>New password:<br />
Re-type new password:<br />
Adding password for user amit<br />
<br />
This creates a file  .htpasswd  containing the username amit. Then it will be prompted for a password for amit, which will be stored in the .htpasswd file<br />
So, to create a new users and change the password for existing users, switch to the  directory that contain .htpasswd,  run this command<br />
<br />
 # <i>htpasswd -c .htpasswd username </i><br />
<br />
<b>Step 4.</b> Set the permissions on your .htaccess and .htpasswd file<br />
Now use chmod command to chage permission of .htaccess & .htpasswd to make it world-readable<br />
<br />
<span style="color: #000099;">[root@amit.htdocs] # chmod 644 /usr/local/apache2/htdocs/pvt/.htaccess</span><br />
<span style="color: #000099;">[root@amit.htdocs] # chmod 644 /usr/local/apache2/conf/.htpasswd</span><br />
<br />
Now you done everything !!!!<br />
Now, anytime you attempt to view your password protected directory (pvt ), any file within it, or recursively any subdirectory of it, you will be prompted for a username and password,<br />
<br />
From the desk of <a href="http://www.amitmaheshwari.in/" target="_blank"><i><span style="color: #000099;">Amit Maheshwari</span></i></a></div>

How do I password-protect my website using .htaccess?

Htaccess can be used to password-protect directories on your web sites. You can do this Password Protection very easily by using below st...

10:25 AM

How To Add a Welcome Message for SSH Users

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: verdana; font-size: 85%;">Here is a very easy tip on <span style="font-weight: bold;">how to add a welcome message for your SSH users</span><br /></span><br />
<br />
<span style="font-family: verdana; font-size: 85%;">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.<br /></span><br />
<div style="font-family: verdana;">
<span style="font-size: 85%;"><b><span style="color: #000066;">Step 1</span>:</b></span></div>
<div style="font-family: verdana;">
<span style="font-size: 85%;">Create a banner file that contains text you want people to see when connecting to your SSH server.</span></div>
<div style="font-family: verdana;">
<span style="font-size: 85%;">Create and open the banner file:</span></div>
<div style="color: #000099; font-family: verdana;">
<span style="font-size: 100%;"><code>[root@amit]# vim /home/username/banner</code></span></div>
<span style="font-family: verdana; font-size: 85%;">put your message inside it<br /><br /><code>*****************************************************************<br />*This is a private SSH Server. You are not supposed to be here. *<br />*Your information has </code><code>been logged and a report</code><code> </code><code>has been emailed </code><code>*<br />*to the admin </code><code>concerning your unauthorized attempts.</code><code>            *   <br />*****************************************************************<br /><br />then save & quit by using <span style="color: #3333ff;"><span style="font-size: 100%;">:wq!</span><br /></span></code></span><br />
<div style="color: #000099; font-family: verdana;">
<span style="font-size: 85%;"><b>Step 2:</b></span></div>
<div style="font-family: verdana;">
<span style="font-size: 85%;">Edit  /etc/ssh/sshd_config to set a default banner path.</span></div>
<div style="color: #000099; font-family: verdana;">
<span style="font-size: 100%;"><code>[root@amit]# vi /etc/ssh/sshd_config</code></span></div>
<div style="font-family: verdana;">
<span style="font-size: 85%;">then add the following to the config file:</span></div>
<div style="color: #000099; font-family: verdana;">
<span style="font-size: 100%;"><code>Banner /path/to/banner</code></span></div>
<div style="font-family: verdana;">
<span style="font-size: 85%;">Save the file and quit:<code>  <span style="color: #3333ff; font-size: 100%;">:wq</span></code></span></div>
<div style="color: #000099; font-family: verdana;">
<span style="font-size: 85%;"><b>Step 3:</b></span></div>
<div style="font-family: verdana;">
<span style="font-size: 85%;">Restart the sshd server.</span></div>
<div style="color: #000099; font-family: verdana;">
<span style="font-size: 100%;"><code>[root@amit] # /etc/init.d/sshd restart</code></span></div>
<div style="color: #000099; font-family: verdana;">
<span style="font-size: 85%;"><b>Step 4:</b></span></div>
<span style="font-family: verdana; font-size: 85%;">Try SSH to your server and check Welcome  banner on login<br /><br /><br />From the desk of <a href="http://www.amitmaheshwari.in/" target="_blank"><span style="color: #006600; font-style: italic;">Amit Maheshwari</span></a><br /><br /></span></div>

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 ...

7:05 AM