How to Delete a NonIn Feburary 2016 30,

In Feburary 2016 30,
Open a command prompt window on a Windows computer or a terminal window on a Linux computer.
Type the command 'ftp hostname' to log into the FTP server. Replace 'hostname' with the host name or IP address of the FTP server.
Type the command 'delete dir_name/*' to delete the files within the directory. Replace 'dir_name' with the name of the directory that you want to delete.
Type the command 'rmdir dir_name' to remove the directory.
Type the command 'quit' to close the FTP session.
In Feburary 2016 30,

How to Use FTP to Transfer Directories in AIXIn Feburary 2016 29,

In Feburary 2016 29,
Open a terminal window and type 'ftp hostname' to connect to the remote FTP server. Replace 'hostname' with the name or address of the remote server.
Type 'mkdir directoryname' to create a new directory on the FTP server. Replace 'directoryname' with the name of the directory you want to create.
Type 'cd directoryname' to change to the directory you created. Replace 'directoryname' with the name of the directory you created.
Type 'put /path/to/directory/*' to copy the entire contents of the directory to the remote directory you created. Replace '/path/to/directory/' with the local path to the directory you want to transfer. The asterisk at the end is used to copy all files contained in the directory.
Type 'quit' to exit the FTP program.
In Feburary 2016 29,

How to Specify a Port on the FTP Command LineIn Feburary 2016 29,

In Feburary 2016 29,
Click 'Start.'
Type 'cmd' into the search box.
Press 'Enter' to open the command prompt.
Type 'ftp example.com xx' into the Command Prompt, with 'xx' being the port that you need to specify.
Press 'Enter' to connect to the remote server.
In Feburary 2016 29,

How to Add a Newline Character to the End of a Line in SedIn Feburary 2016 28,

In Feburary 2016 28,
Open a terminal. The procedure to do this will depend on your operating system. Most Unix and Linux systems either open a terminal immediately on start up or have a terminal icon somewhere on the desktop. In Mac OS X, click the 'Spotlight' button and type 'Terminal.' In Windows, click 'Start,' 'Run' and type 'cmd.'
Type the following :sed '/$/G'This tells sed to search the text for all end of lines ($) and add a new line (G), effectively double-spacing the file. Alternatively, if you want to insure that there is never more than one blank line between paragraphs, change the command to read:sed '/^$/d;G' This tells sed to match only completely blank lines (^$), delete those blank lines (d) and replace them with a single new line (G).
Feed the data from a text file into sed by typing the following:cat textfile.txt | sed '/^$/d;G'
In Feburary 2016 28,

How to Replace a Substring in Oracle SQLIn Feburary 2016 27,

In Feburary 2016 27,
Sign in to SQLPlus.
Type a 'select' command using the 'replace' function and press 'enter':select string_column, replace(string_column, 'co.', 'company') from string_table;This command retrieves the 'string_column' twice so that the user can see a before-and-after representation of the data. In this case, 'co.' is the target and 'company' is the replacement.
Inspect the results to see the replacement. If the 'string column' contained 'abc co.', it should now be converted to 'abc company.'
Translate Function
Sign in to SQLPlus.
Type a 'select' command using the 'translate' function and press 'enter':select string_column, translate(string_column, 'abc', 'xyz') from string_table;This command retrieves the 'string_column' twice so that the user can see a before-and-after representation of the data. The phrase 'abc' is the 'fromlist', and 'xyz' is the 'tolist.'
Inspect the results to see the replacement. If 'string column' contained 'abc co.', it is converted to 'xyz zo.'
In Feburary 2016 27,

How to Connect to a Secure FTP on WindowsIn Feburary 2016 27,

In Feburary 2016 27,
Right-click 'Start' and click 'Explore' to open a Windows Explorer window
Type 'ftp://yourftpaddress.com/' in the address bar at the top of the window, replacing the dummy address with the actual FTP address. The 'Log on as' security box appears.
Type in your FTP username and password and then click 'OK.' You should now have access to the hosted FTP files.
In Feburary 2016 27,

How to Update a Column in MySQLIn Feburary 2016 26,

In Feburary 2016 26,
Open MySQL monitor and log in with your username and password.
Select the database you wish to update. For example, to use the database named TARDIS, type in the following at the command prompt:use TARDIS;
Type in the SQL statement to update your column. To update the Date column of a table named 'Destination' where the Location is equal to 'Gallifrey' you can use the following SQL statement:UPDATE DestinationSET Date='2011-11-11'WHERE Location='Gallifrey';If updating more than one column, for example 'Date' and 'Time,' you can use the following statement:UPDATE DestinationSET Date='2011-11-11', Time='11:11:11'WHERE Location='Gallifrey';
Press Enter to submit the changes.
Update Columns Using phpMyAdmin
Open phpMyAdmin and log in.
Click the name of the database you wish to update columns for.
Find the table you'd like to change, and click on the 'Browse' icon next to it.
Put a check mark on all the records that need to be updated and click on the pencil icon or the 'Change' icon.
Edit the text on all the columns you wish to update and click on 'Go.'
In Feburary 2016 26,

How to FTP a Zip FileIn Feburary 2016 25,

In Feburary 2016 25,
Create a folder on your desktop or in a location that you can easily find.
Copy the ZIP files to this newly created folder.
Open a command prompt by typing 'CMD' without the quotes from the RUN line in windows. This same command will work from the windows search bar.
Type 'FTP' into the newly opened command window. The prompt has changed to say 'ftp'. You are now ready to connect to your ftp server.
Type 'ftp.myservername.com' without quotes at the ftp prompt. Replace myservername with the name of your server.
Successful completion of step 5 will present you with a connection to the ftp server. Type your user name at the 'user' prompt.
Successful completion of step 6 will present you with a password prompt. Type your password at the 'Password' prompt.
Successful completion of step 7 will present you with a basic 'ftp' prompt. You are now ready to upload your zip files. Navigate to the folder which you stored your files by typing 'lcd Folder Name' without quotes. Substitute folder name with the folder name you created. The lcd command allows you to change directories locally.
Create a folder on the ftp server for your ZIP files by using the 'MKDIR' command. Type 'MKDIR Myfiles' without the quotes and substitute myfiles with your desired folder name.
Change directories to the folder you just created by typing 'CD Your New Name' without the quotes. Substitute your new name for the name of your folder.
FTP your files by typing 'PUT myfile.zip' without the quotes. Substitute myfile.zip with the name of your ZIP file. Once this step is completed you will be presented with a confirmation step and a new 'ftp' prompt. You can now repeat this step for additional files.
Type 'bye' without the quotes at the ftp prompt to log off of the ftp server.
Type 'exit' without the quotes at the command prompt to close this window.
In Feburary 2016 25,

How to Back Up a Website Using an FTP ClientIn Feburary 2016 24,

In Feburary 2016 24,
Open the 'Start' menu and type 'Command Prompt' in the search field, click on the shortcut that appears in the search results. Type 'cd C:\location\of\files' without the quotes and press 'Enter' to change to the backup directory. Replace 'C:\location\of\files' with the folder you plan to use to back up your site.
Type 'ftp ftp.yourwebsite.com' and press enter. Replace 'yourwebsite.com' with the URL of your site. Type in your user name and password when prompted.
Type 'cd /path/to/website' and press 'Enter' to change the directory to your website directory if necessary. In most cases you will already be in your website's directory. If in doubt, ask your Web host.
Type 'mget
' and press 'Enter' to back up all your website files in the local computer. To restore them instead, type 'mput
' and press 'Enter.'
In Feburary 2016 24,

How to Export Windows Event Logs to ExcelIn Feburary 2016 24,

In Feburary 2016 24,
Right-click the 'Computer' icon on the desktop. If the 'Computer' icon is not on the desktop, click the 'Start' button to locate the 'Computer' icon from within the Start Menu programs.
Click 'Manage' from the options box to open the Computer Management Tools console.
Click the right-facing arrow in front of the group 'Event Viewer' to open the available Event Viewer logs.
Right-click the log to be exported, such as the 'Security event log.' From the available options, click 'Save all Events as... .'
Click the down arrow in the 'Save as type:' box and select 'CSV (Comma Separated Value) (*CSV).'
Click in the 'File name:' box and type a file name and save location for the file. For example: 'c:\SecurityEventLog' will save the file called SecurityEventLog and place it on the C: drive.
Click 'Save' to save the CSV file to the C: drive.
Close the Computer Management Console by clicking the 'X' in the upper right-hand corner of the console box.
Open CSV File in Excel and Sort by Event ID
Open Microsoft Excel by clicking 'Start,' 'All Programs,' 'Microsoft Office' and 'Microsoft Office Excel.'
Click the 'Office' button in the upper left-hand corner of the Excel application and click 'Open.'
Type 'C:\SecurityEventLog.cvs' in the 'file name:' box and click 'Open' to start the Text Import Wizard.
Select 'Delimited' on the first page of the Text Import Wizard and click 'Next.'
Select 'Comma' and deselect 'Tab' under the Delimiters options and click 'Next.'
Select 'General' under the Column data format box and click 'Finish' to open the Event Viewer log in Excel.
Click on the 'Event ID' column heading to highlight the entire column of Event IDs.
Click 'Data' from the menu options at the top of the Excel application.
Click 'Sort' from the Data menu tab, select 'Expand the selection' when the Sort Warning box appears and click 'Sort.'
Click 'Event ID' in the 'Sort by' drop-down box, specify the sort order by selecting from the available options under the 'Order' drop-down box and click 'OK.'
Review the list of Windows event IDs in Excel and save the file for future use.
In Feburary 2016 24,

How to Get Through a Proxy BlockerIn Feburary 2016 20,

In Feburary 2016 20,
Log onto the web browser.
Select one of the proxy blocker links in Resources. These sites will allow you to surf the web anonymously. However, there are certain websites that will not allow you access because of this.
Type in the web address of the site you want to go to and press 'Enter.'
Close out the advertisement if one appears. Also, the proxy blocker will occasionally take you to a third-party site initially. Click the 'Back' button on your web browser and you will be taken back to the website you wanted to navigate to.
In Feburary 2016 20,

How to Insert a Time Stamp in PHP MySQLIn Feburary 2016 19,

In Feburary 2016 19,
Create a new field in your database. Open the 'phpMyAdmin' utility for your MySQL databases. Select the database of your choice from the left-hand menu. Select the table in which you wish to place the new time stamp field and click on the 'Structure' action item. Hit the 'Go' button next to the 'Add One New Field' selection.
Set the attributes of the new field. Under the 'Field' input box enter your new field's name. Name the field 'Timestamp.' Select the 'Type' drop-down bar and tag the 'Timestamp' options. This defines your new field as a 'Time Stamp.' Click on the 'Default' drop-down bar. If desired, select the 'Current_Timestamp' option. If selected, this option automatically creates a new time stamp whenever a new record is entered into your database. Now, click the 'Attributes' drop-down box. Select the 'On Update Current_Timestamp' menu item. If this option is selected, the time stamp field will update every time a change is made to your database record.
Save the changes. Select the 'Save' option at the bottom right-hand corner of the window. The changes to your database structure are now saved. From this point on, the time stamp field automatically populates each time a new record is entered.
Using PHP
Capture the current time using the PHP date function and assign it to a PHP variable. The PHP date function takes the current time and formats it according to a set of values that you enter. Consider this example:$current_time = date ('Y-m-d H:i:s');In this line of code, it calls the date function and enters the values which format the output into the format of year, month, day, hour, minute and second or '2012-12-21 06:26:36.' This is the exact time stamp format used by MySQL. In this example, the date is assigned to the current-time variable.
Insert the time stamp into the MySQL time stamp field of the database table of your choice. Use 'PHP's mysql_query' function to complete this step. Here is the example.$query = 'UPDATE
yourDatabaseTable
SET
timestamp
= '$current_time' WHERE
yourPrimaryKey
='$primary_key_variable' ';mysql_query($query) or die('The new time was not inserted');
Upload the PHP file to your server.
In Feburary 2016 19,

How to Connect to FTP Through a ProxyIn Feburary 2016 18,

In Feburary 2016 18,
Click the 'Edit' menu at the top of the FileZilla window, and select 'Settings.'
Click 'Generic Proxy' under 'Connection' on the left side of the window.
Click a radio button to indicate whether your network uses an HTTP or SOCKS proxy server.
Type the address, port number, user name and password for your proxy server.
Click 'OK' to save your settings.
Internet Explorer or Windows Explorer
Click the Windows logo in the corner of the screen, and select 'Control Panel.'
Click 'Network and Internet,' and then click 'Internet Options.'
Select the 'Connections' tab at the top of the 'Internet Properties' window, and then click the 'LAN Settings' button.
Click the 'Use a proxy server for your LAN' check box.
Enter the address and port number of the proxy server.
Click 'OK' twice to save your settings.
FlashFXP
Click the 'Options' menu at the top of the FlashFXP window, and then click 'Preferences.'
Click 'Proxy' under the 'Connection' category on the left side of the window.
Click the 'New Entry' button at the top of the window.
Click the drop-down menu next to 'Type' and select the type of proxy server that you connect through, such as 'SOCKS 5' or 'HTTP.'
Enter the address and port number of the proxy server, along with your username and password if applicable.
Type the name that you would like to use to identify the proxy server. This feature is useful if you have more than one proxy server that you connect to.
Click 'OK' twice to save your settings.
In Feburary 2016 18,

How to Get TD Class Value in JqueryIn Feburary 2016 18,

In Feburary 2016 18,
Open the Web page in Notepad or a code editor, and look for the jQuery library file. If your code contains no reference to this file, add this code:Place this reference between the '
' tags of your Web page code or just above the closing '
' tag.
Add a pair of 'Write all jQuery code between the '
' tags.
Write a function to check for when the document finishes loading. This is also known as the 'document ready' function:$(function () {});The above code is short-hand for '$(document).ready()'.
Declare an array type variable that will hold the class values of your '' tags:var tdValue = [];Add this code between the curly braces of the 'document ready' function.
Iterate through each instance of '' in the Web page code by creating an 'each()' loop:$('td').each(function(i) {});This code goes after the array declaration. Note that 'each()' attaches to the 'td' selector, and a variable 'i' is passed as a parameter in the function. You need the 'i' variable to get values from the array.
Set your array equal to the results of the 'attr()' function inside the 'each()' loop:tdValue[i] = $(this).attr('class');The 'this' selector gets the parent selector, in this case 'td' from the selector in the line of code above it. Use 'class' inside 'attr()' to get the value of the class attribute for each '' tag.
Output the class name for each '' tag as text in each table cell by adding this line of code after the line containing your 'attr()' function:$(this).text(tdValue[i]);The finished script should look like this:$(function() {var tdValue = [];$('td').each(function(i) {
tdValue[i] = $(this).attr('class');$(this).text(tdValue[i]);
});});
In Feburary 2016 18,

How to Edit a Website Using Microsoft WordIn Feburary 2016 17,

In Feburary 2016 17,
Download or find the HTML page for each web page of a website you want to edit. You can edit a website one page at a time with Word but you must first have access to the page. If it is on your local computer then you are set. If the page is on a server, you must either FTP the HTML document and its images to your local computer or you can save the page from a web browser. When saving an HTML web page from a browser, just make sure you choose to save it as a web page and not a web archive.
Open Microsoft Word. Go to the File menu and choose Open. Select the HTML file for the web page that you want to edit.
Edit what you see. The way that Word opens the HTML document, it will be similar to what you see in a live web page, except some of the pictures may be missing. You can type directly on the page to change elements such as the text. You can also use the tool bar to do some basic editing, such as bolding items or changing the font size.
Edit links by right clicking on the link and choosing “hyperlink” and then “edit hyperlink.” You can also use the “Insert” menu to add or edit pictures and objects. If you want to change an existing picture, just click on that picture before selecting the “insert” menu.
Click on View and then “HTML source” to see the web page in HTML code. This will let you edit the web page in a much more powerful way, if you know and understand HTML.
Go to the “File” menu and choose “Save as” and then type a name and select “web page” as the file type. It will save the file at whatever location you choose and will also create a folder for any files that go with the page. You can now upload the page and the folder to your web host.
In Feburary 2016 17,

How to Reinstall MySQL for UbuntuIn Feburary 2016 17,

In Feburary 2016 17,
Click the 'System' menu.
Highlight the 'Administration' category.
Click the 'Synaptic Package Manager' menu option to open the Synaptic Package Manager. Type your password when prompted.
Type 'mysql' in the 'Search' text box at the top of the screen.
Click the check box next to the 'mysql-server' package.
Choose the 'Mark for re-installation' option in the menu that appears.
Click 'Apply' at the top of the screen.
Click 'Yes' in the confirmation dialog that appears. The MySQL server package will be reinstalled.
Command Line
Right-click anywhere on the desktop.
Choose the 'Terminal' option in the menu that appears to open a terminal window.
Type the command 'sudo apt-get install --reinstall mysql-server' to reinstall the MySQL software package.
Type your password when prompted.
Type 'Y' when prompted for confirmation.
In Feburary 2016 17,

How to Link to an Email AddressIn Feburary 2016 17,

In Feburary 2016 17,
Find the spot where you want to place the email link on your web page within your HTML code.
Type (link) in the place where you want the link. For example, if your email is bsmith@gmail.com and your link is 'email me,' then your code would be: email me.
Type (link) in the place where you want the link if you want to control the subject link. For example, if your email is bsmith@gmail.com, your link is 'email me' and your subject line is 'help,' then your code would be: email me.
Save and publish your HTML code. This depends on your web publishing system.
In Feburary 2016 17,

Kerberos StepIn Feburary 2016 16,

In Feburary 2016 16,
Before you begin setting up Kerberos on your system, you should know the name of your Kerberos, the hostname of the master and slave Key Distribution Centers (KDC) and how you are going to map your hostnames in the Kerberos realm. You will need to determine the ports that the KDCs and the database access (kadmin) services will use. You will also have to know how frequently the master and slave KDCs will fill the database.You will use the above information to configure the master KDC. The master KDC configuration files will be found at '/etc/krb5.conf' and '/usr/local/var/krb5kdc/kdc.conf' and can be edited in any text editor. The 'krb5.conf' file contains information about where to locate the KDCs and admin servers, as well as the host name mapping information. The 'kdc.conf' file contains the default information used when issuing Kerberos tickets. Open the '/etc/krb5.conf' and edit the 'login,' 'realms' and 'domain_realm' values so that they are correct for your system. Change the '/usr/local/var/krb5kdc/kdc.conf' so that it reflects the correct information for your KDC server.The next step is to create the database. Open a terminal and type the command 'kdb5_util.' You will be asked to provide a master key. This should be a string of letters, numbers and special characters similar to a password. This key will be stored in a stash file on the KDC's hard drive. If you would rather be prompted for the key whenever Kerberos starts, you can choose to not create the stash file.Finally, you will create the Access Control List (ACL) and add at least one administrator to it. The ACL is a user created text file that is called '/usr/local/var/krb5kdc/kadm5.acl.' This file should have the administrator listed in the form:
Kerberos_principal permissions [target_principal] [restrictions]
Once the ACL list is created, issue the command 'kadmin.local' and add each principal to the database. Start the Kerberos daemons with the command '/usr/local/sbin/krb5kdc; /usr/local/sbin/kadmin.'
Creating the Keytab File
The keytab file is used to decrypt the Kerberos tickets and determine whether the user should have access to the database. In order to create this file, type the command 'kadmin.local' again. This will provide you with a prompt where you will type the command: 'ktadd -k /usr/local/var/krb5kdc/kadm5.keytab kadmin/admin kadmin/changepw' to create the keytab file. Replace the section '/usr/local/var/krb5kdc/kadm5.keytab' with the keytab location that was specified in the '/usr/local/var/krb5kdc/kdc.conf' file. Type 'quit' to exit the 'kadmin' utility.
Configuring the Slave KDCs
To create the slave KDCs, you will issue the 'kadmin.local' command a third time. At the prompt, issue the command 'addprinc-randkey host/example.com' for the Master and each slave. Use the host name of each KDC in place of 'example.conf.' This will create host keys for each of the KDCs. Next, extract the keys on each of the slave KDCs by starting the 'kadmin' utility on each of the slaves and issuing the command 'ktadd host/MasterKDC.com.' Replace 'MasterKDC.com' with the host name of the master KDC.For the database to be propagated from the master KDC to the slave KDCs you will have to create a file called '/usr/local/var/krb5kdc/kpropd.acl.' This file must contain the principals for each of the KDCs in the form 'host/example.com.' Each principal should be placed on its own line. Next, edit the '/etc/inetd.conf' file on each of the KDCS and add the following lines:
krb5_prop stream tcp nowait root /usr/local/sbin/kpropd kpropd
eklogin stream tcp nowait root /usr/local/sbin/klogind klogind -k -c -eEdit the '/etc/services' file on each of the KDCs and add the following lines:
kerberos 88/udp kdc # Kerberos authentication (udp)
kerberos 88/tcp kdc # Kerberos authentication (tcp)
krb5_prop 754/tcp # Kerberos slave propagation
kerberos-adm 749/tcp # Kerberos 5 admin/changepw (tcp)
kerberos-adm 749/udp # Kerberos 5 admin/changepw (udp)
eklogin 2105/tcp # Kerberos encrypted rlogin
Propagating the Database
Propagating the database is done from the Master KDC. Issue the command '/usr/local/sbin/kdb5_util dump /usr/local/var/krb5kdc/slave_datatrans' to create a dump of the database. Next, issue the command ' /usr/local/sbin/kprop -f /usr/local/var/krb5kdc/slave_datatrans Slave-1.example.com' to manually propagate the database on each of the slaves. These steps will need to be completed on a regular basis. The easiest way to do this is to create as script and run the script as a cron job. The script should look like:!/bin/sh
kdclist = 'slave-1.example.com slave-2.example.com'/usr/local/sbin/kdb5_util 'dump
=> /usr/local/var/krb5kdc/slave_datatrans'for kdc in $kdclist
do
/usr/local/sbin/kprop -f /usr/local/var/krb5kdc/slave_datatrans $kdc
done
Of course, change the host names to reflect the values for your system.
Create Stash Files on the Slaves
The final step to setting up Kerberos is to create stash files on the slave KDCs. On each of the slave KDCs issue the command 'kdb5_util stash' and provide the master key when prompted. Once that is completed, you can start the 'krb5kdc' daemon on each slave with the command '/usr/local/sbin/krb5kdc/.'
In Feburary 2016 16,

How to Upload Videos in Picasa WebIn Feburary 2016 14,

In Feburary 2016 14,
Download the latest version of the free Picasa software. Double-click on the installation file and follow the prompts to complete the installation. At the final setup screen, click 'Launch' to open the program.
Click 'Sign-in to Web Albums' in the upper-right corner of the screen. Sign in using your Web-Album account. If you don't have an account, click 'Sign-Up for Web Albums.' Type your email address, name, date of birth, and choose a password.
Click 'File' on the Picasa-menu bar. Select 'Import File.' This opens the browse-dialog box. Locate the video file you want to upload to your Picasa Web Album. Click 'Open.' The video is added to your desktop Picasa program.
Click on the video in your Picasa program. Click 'Tools,' and then select 'Upload.' Select 'Upload to Web Album.' This brings up the Picasa Upload tool. Click 'Upload' to add your video to your Picasa Web Album. When the upload is complete, click 'View Online' to visit your Picasa Web Album. This takes you straight to the video's URL.
In Feburary 2016 14,

How to Run IPTV in VLCIn Feburary 2016 12,

In Feburary 2016 12,
Open the VLC media player.
Click the “Media” button on the top navigation bar to show the File menu.
Click the “Open Network Stream” option.
Click the radio button next to the “HTTP/HTTPS/FTP/MMS” option and then type the following URL into the “URL” input box. http://avenard.org/iptv/playlist-tpg-vlc.m3u
Click “OK.” The Avenard playlist opens in VLC and the channels list down the left panel.
Click a channel in the left panel and then click the “Right” pointing arrow at the bottom of the viewing screen to play the channel.
In Feburary 2016 12,