A little something about everything

First things first, make sure you are up to date on all of your packages,

yum update -y

Now you should install the FTP module

yum install vsftpd -y

Start the service

service vstfpd start

Now you will need to install Perl for the webmin qui to manage vsftpd

yum install perl -y (this is most likely already installed)

yum install perl-CPAN -y

yum install perl-CGI -y

Install the vftpd module for webmin

login, go to webmin, Webmin configuration, Webmin modules, from URL and enter: http://blog.shawnhyde.com/FILES%2f2013%2f12%2fvsftpd-2009-04-30-1755.wbm.gz.axdx

refresh webmin, go to services and vsftpd to configure it.

In order to fix this bug you can simply run this command on the effected database after you have used the backup (sql2000) / restore sql2005/2008) or detach attach methods.

command to run:

 exec sp_change_users_login'Update_One','dbusername','dbusername'

Replace "dbusername" with the problem user account. both should be the same.

This will remove the ghost user from the sql 2000 server and replace it with the new user on your sql 2005 / 2008 server. Be sure to have the user created before running this command.

Errors associated with this are as follows:

"login name must be specified Database user"

"The database principal owns a schema in the database, and cannot be dropped"

"user group or role already exists in the current database"

"can't delete sql user in database"

After taking over an account from another firm, the customers site was getting errors like this? Generally I would rewrite the code into asp.net however I was in a hurry to find a quick solution.

Example of the errors:

PHP Notice: Undefined variable: city in path\dbconnect.PHP on line 3 PHP Notice: Undefined variable: state in path\dbconnect.PHP on line 4 PHP Notice: Undefined variable: ownership in path\dbconnect.PHP on line 5 PHP Notice: Undefined variable: priceMin in path\dbconnect.PHP on line 6 PHP Notice: Undefined variable: priceMax in path\dbconnect.PHP on line 7 PHP Notice: Undefined variable: bedMin in path\dbconnect.PHP on line 8 PHP Notice: Undefined variable: bedMax in path\dbconnect.PHP on line 9 PHP Notice: Undefined variable: bathMin in path\dbconnect.PHP on line 10 PHP Notice: Undefined variable: bathMax in path\dbconnect.PHP on line 11 PHP Notice: Undefined variable: sqftMin in path\dbconnect.PHP on line 12 PHP Notice: Undefined variable: sqftMax in path\dbconnect.PHP on line 13 PHP Notice: Undefined variable: acreMin in path\dbconnect.PHP on line 14 PHP Notice: Undefined variable: acreMax in path\dbconnect.PHP on line 15 PHP Notice: Undefined variable: yearMin in path\dbconnect.PHP on line 16 PHP Notice: Undefined variable: yearMax in path\dbconnect.PHP on line 17 PHP Notice: Undefined variable: garageMin in path\dbconnect.PHP on line 18 PHP Notice: Undefined variable: garageMax in path\dbconnect.PHP on line 19 PHP Notice: Undefined variable: listingID in path\dbconnect.PHP on line 20 PHP Notice: Undefined variable: ADDLISTING in path\dbconnect.PHP on line 21 PHP Notice: Undefined variable: UPDATELISTING in path\dbconnect.PHP on line 22 PHP Notice: Undefined variable: deletePhoto in path\dbconnect.PHP on line 23 PHP Notice: Undefined variable: deleteDisclosure in path\dbconnect.PHP on line 24 PHP Notice: Undefined index: priceMin in path\basic.PHP on line 4 PHP Notice: Undefined index: priceMax in path\basic.PHP on line 5 PHP Notice: Undefined index: state in path\basic.PHP on line 6 PHP Notice: Undefined index: city in path\basic.PHP on line 7 PHP Notice: Undefined index: ownership in path\basic.PHP on line 8

Obviously the site is using invalid code and the newer php5.x is more than happy to tell you about it.

You can fix your code or you can simply disable the error reporting:

 error_reporting(E_ALL ^ E_NOTICE);

Be sure to place the code inside your php tags:

 <?Php here ?>

First thing you will need to do is specify the scripting language, content type and endcoding type in a page element. Language will be visual Basic, content Type will be text/html and ecoding will be UTF-8

<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="utf-8" %>

Next you will want to specify the doctype, this will tell the browser exactly what type of HTML you are using in the page. We'll be using the following DTD HTML doc type.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

Now we need to import the System.Web.Mail asp.net namespace for use with our basic contact form

<%@ Import Namespace="System.Web.Mail" %>

Now that the page basics are setup we need to write some script that will handle the information browsers will provide when visiting your page. First you need to write the server side script call. Then include a runat="server" verable which will tell the server to run it locally on the server side so the browser cannot view the information. This is done to prevent souce view bots from gaining email address information in your contact form.

<script runat="server">

Server side code

Sub btnSubmit_Click(sender as object, e as EventArgs) Dim objEMail As New MailMessage() objEMail.To = "enter the email address you want to send to here" objEmail.From = txtFrom.Text objEmail.Subject = txtSubject.Text objEmail.Body = "Name: " &txtName.Text & vbcrlf & "Email: " &txtFrom.Text & vbcrlf & "Comments: " &txtBody.Text objEmail.Priority = MailPriority.High SmtpMail.SmtpServer = "Enter your mail server domain here" try SmtpMail.Send(objEMail) 'Uncomment if one of the following success options: 'Response.Write("success") 'Response.Redirect("/success page/") catch exc as Exception Response.Write("Send failure: " + exc.ToString()) End Try End Sub

then you need to end the runat=server code

</script>

add standard HTML elements

<html> <head> <title>Contact Form by Shawn Hyde</title> </head> <body>

Now the form, form fields and content

 <form id="ContactMain" runat="server"> <table width="600" border="0" align="center" cellpadding="3" cellspacing="0"> Name:<br /><asp:TextBox runat="server" Width="200px" ID="txtName"></asp:TextBox> Email: <br /><asp:TextBox runat="server" Width="200px" ID="txtFrom" ></asp:TextBox> Subject: <br /><asp:TextBox runat="server" Width="200px" ID="txtSubject" ></asp:TextBox> Comments : <br /><asp:TextBox runat="server" TextMode="MultiLine" Height="80px" Width="250px" ID="txtBody"></asp:TextBox> <asp:Button Runat="server" ID="btnSubmit" OnClick="btnSubmit_Click" Text="Submit"></asp:Button> <input type = "reset" value = "Clear" runat = "server"> </form>

You may want to add some validation to the above code in order to prevent bots from filling out your contact form.

Finally closing of page HTML elements

</body> </html>

Preventing comment spam on your blogging pages can be a hard task. However there is a way to prevent the spammers from benifiting by all the comment spam. You can simply include rel="nofollow" to all comment links.

Example: Visit my <a href="http://www.example.com/" rel="nofollow">some generic spam</a> site

ref: http://googleblog.blogspot.com/2005/01/preventing-comment-spam.html