Linux Tech Support: yum

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="font-family: georgia;">
<b><span style="font-size: large;"> How to Prevent Yum update of some selected packages in Redhat/</span></b><b><span style="font-size: large;">Redhat</span></b></div>
<div style="font-family: georgia;">
<br /></div>
<div style="font-family: georgia;">
<br /></div>
<div style="font-family: georgia;">
<span style="font-size: 85%;">It is very Simple to exclude some selected packages not to update while using <span style="color: #3333ff; font-style: italic;">yum update</span> command</span></div>
<div style="font-family: georgia;">
<span style="font-size: 85%;">All you need to do is  add an exclude line to the end of your [main] section in /etc/yum.conf .</span></div>
<div style="font-family: georgia;">
<span style="font-size: 85%;">Your<b> /etc/yum.conf</b> should look something like this:</span></div>
<div style="font-family: georgia;">
<span style="font-size: 85%;">[main]<br />cachedir=/var/cache/yum<br />keepcache=0<br />debuglevel=2<br />logfile=/var/log/yum.log<br />exactarch=1<br />obsoletes=1<br />gpgcheck=1<br />plugins=1<br />installonly_limit=3<br /><b><span style="color: #000099;">exclude= hal  bash*</span></b></span> </div>
<div style="font-family: georgia;">
<br /></div>
<div style="font-family: georgia;">
<span style="font-size: 85%;">This will prevent upgrades of the hal  package as well as bash package while using <span style="color: #3333ff; font-style: italic;">yum update</span> cmd.  The list of apps in the exclude should be space sepeated.  Shell wildcards ( * ? ) can also be included.</span></div>
<div style="font-family: georgia;">
<br /></div>
<div style="font-family: georgia;">
<br /></div>
<div style="font-family: georgia;">
<br /></div>
<div style="font-family: georgia;">
<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></div>
<div style="font-family: georgia;">
<br /></div>
<div style="font-family: georgia;">
<span style="font-size: 85%;"><br /></span></div>
</div>

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

How to Prevent Yum update of some selected packages in Redhat/ Redhat It is very Simple to exclude some selected packages not to up...

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