Skip to main content

Log Into Linux Using Putty, WS_FTP or Oracle SQL

What is my Computer Username?

You must know your computer username and password in order to access any of your computer accounts, including Linux. If you do not know your username:

  1. Go to myUHD (http://www.uhd.edu/myuhd).
  2. Click on My Personal Profile & Emergency Alerts.
  3. Type in your Student ID number and your PIN.
  4. Scroll down to the bottom of your profile page to see your computer username.
  5. For detailed instructions click on the following link.
    /password

NOTE: The first time you access your Linux account, you need to use the Telnet option.

Table of Contents

How to login to Linux using Putty

 

  • If you are on-campus on a UHD computer choose “Putty” from the “Start > All Programs” menu and go to step 6.
  • If you are not on campus and do not have a Telnet client (such as Putty) installed on your off-campus computer, you can follow the instructions below to install Putty and login to your LINUX account from offsite.

 

  1. Logon to the following website: http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html.
  2. To download the Putty program, click on putty.exe.

    fig1.jpg

  3. At the File Download screen, choose where you want to save Putty, then click on the Save button.
  4. When the process is finished, a putty icon will be placed on your desktop. Double-click on the PuTTy icon.
  5. The PuTTY Configuration dialog box will be displayed.
    • At the Host Name (or IP address) field, type in gator.uhd.edu.
    • Choose SSH for Protocol.
      NOTE: The first time you access your Linux account, you need to use the Telnet option.
    • Click Open.
    • If you are not on campus but on your personal computer, you may type Gator into the Saved Sessions box and click Save to re-use this connection at a later time.

      fig2.png

  6. At the login as command, type in your username and press Enter.
  • At the password prompt, type in your password and press Enter.
  • The green cursor will not move, make sure to enter your password correctly.
  • When the system has completed its login, the following prompt will appear: [username@gator username]$

    fig3.png

 

Making your web pages viewable over the internet

Login to your Linux account by following the steps listed under the How to login to Linux using Putty section.

  1. Enter the following after the $: ls -l.
    The contents of your gator space will be displayed, followed by a command prompt line. The permissions are shown next to each item (r=read, w=write, x=execute).
  2. Enter the following after the $: chmod x ./
  3. Enter the following after the $: chmod 755 public_html/ and press the enter key. Then enter: ls -l and press the enter key.
  4. Enter the following after the $: cd public_html/ and press the enter key. Then enter: ls -l and press the enter key.
  5. Enter the following after the $: chmod 644 index.html/ and press the enter key. Then enter: ls -l and press the enter key.
  6. Others can now view your files.

 

Posting web pages to your Linux account using WS_FTP

 

  • If you are on-campus on a UHD computer choose “WS_FTP” from the “Start > All Programs” menu and go to step 1.
  • If you are not on campus and do not have a FTP client (such as WS_FTP) installed on your off-campus computer, you can download it from here http://www.wsftple.com/download.aspx.

 

  1. The Profile Name and Host Name/Address information should be pre configured.
    Note: If the information is absent, in the Session Properties window (see picture below), click on the New button.
    Enter gator.uhd.edu in the Profile Name field
    Enter gator.uhd.edu in the Host Name/Address field.

    fig4.png

  2. Enter your user name in the User ID field. Note: Verify that “Anonymous” is NOT checked.
  3. Enter your password in the Password field.
  4. Click the OK button.
  5. You are now connected to the University of Houston –Downtown’s Linux server and ready to copy files from your local drive to your personal web page UHD.

 

How to copy files from your local drive to your personal web page at UHD

 

  • If you are on-campus on a UHD computer choose “WS_FTP” from the “Start > All Programs” menu and go to step 1.
  • If you are not on campus and do not have a FTP client (such as WS_FTP) installed on your off-campus computer, you can download it from here http://www.wsftple.com/download.aspx.

 

  1. WS_FTP LE has two windows, Local System and Remote Site

    fig5.png

  2. First, locate the Local System path to the drive letter and folder on your PC that contains the file(s) you want to copy to your personal linux account.
    For example, double click on [-c-] if your local C:\ drive contains the files you want to transfer (use the scrollbars if necessary).
    Note: You move up the directory structure on either window by double-clicking on the green up arrow, and down by double-clicking on the appropriate folder/file icon.
  3. Change the Remote Site path to the "public_html" folder by double clicking on the public_html icon. Your WS_FTP LE gator.uhd.edu session should now display /home/student/d/username/public_html in the Remote Site window, as shown in the image below.
    Important!!! If the public_html folder is not displayed follow steps 6 and 7 under the How to login to Linux using Putty section.

    fig6.png

    Note: You may create new folders (directories) on either your Local System or Remote Site by clicking on the "MkDir" button, then enter the name you wish to give the new directory (folder) and click OK. Folder names are case sensitive. Folder_Names should NOT contain spaces. Use dashes or underlines instead.
  4. Select the file or files you want to transfer by clicking once on the file.
  5. Select the appropriate FTP mode (ASCII, Binary, or Auto) before copying or transferring files from the Local System to the Remote Site.
    • ASCII - FTP mode for .htm, .html, or .txt file extensions
    • Binary - FTP mode for most other file extensions including .jpg, .gif, .pdf and .doc
    • Auto - WS_FTP LE should automatically set the appropriate transfer mode
  6. Click on the right arrow button to transfer the file(s). When you are finished transferring files, close the WS_FTP session by clicking the Close button on the bottom left side of the session window, then close the window.
  7. To access the files you copied to your Linux account, open a web browser and enter the URL to your folder on the server. Example - "http://gator.uhd.edu/~username/", replacing username with your user name.

 

How to access Oracle SQL using your Linux account

 

  1. Login to your Linux account by following the steps listed under the How to login to Linux using Putty section.
  2. Enter the following command at the prompt: sqlplus / (include a space between “sqlplus” and the forward slash “/”)

    fig7.png

  3. Students who have access to the Oracle database will see a SQL> prompt.

    fig8.png

  4. Create your SQL program file using the Pico text editor as follows: $pico yourfile.sql <ENTER>
    Note that your program file must have the .sql suffix, and that LINUX is case sensitive.

    fig9.png

  5. Open the file containing the table creation SQL code and copy and paste the contents directly into the Putty session.
    • To exit and save hold down the <ctrl> key then <x> key then  <y>  & <ENTER>
    • To exit without saving hold down the <ctrl> key then <x> key then  <n>  & <ENTER>
      fig10.png
  6. Start the Oracle SQL shell as follows:
    Enter sqlplus / at the $ prompt: (include a space before the forward slash “/”)
    Students who have access to the Oracle database will see an SQL> prompt.

    fig11.png

 

  1. Execute your SQL program as follows:
    SQL> @yourfile.sql
    To kill the SQL shell and return to the bash $ prompt do as follows: <ctrl> <z> or type exit.

    fig12.png

Note: If you are prompted to enter a user name, contact the UHD IT help desk at 713-221-8031 and your instructor.

fig13.png