CS6320:  SW Engineering of Web Based Systems

 

Server Account Usage

 

BBS Account
 

NOTE: I will be using this to communicate with you, including email, any important information. You are responsible for making sure you have an account and your information is accurate.

You will need to get an account on the BlackBoard System for our class. BlackBoard is a commercial product for course management. We may be using it for its Communication Features (virtual classroom). Hence you will need to get an account for our class.

IF ALREADY ENROLLED, YOU SHOULD HAVE AN ACCOUNT.

login and password is the same as horizon account

(If not:you need to enroll...if you need help email

Email: bbhelp@csueastbay.edu


To Alter Personel Information (e.g. email address)


select the Personal Information option on "My Info" page at the following URL: http://myinfo.csuhayward.edu

Oracle Server Account
 

You will need to get an account on the Oracle server.

Server= mcsdb1.sci.csueastbay.edu ( or mcsdb2.sci.csueastbay.edu ---see your account information emailed to you)

You will be given tablespace on the Oracle DB instance cs1db (or csdb2 --see account information emailed to you)

You can look for and download free SQLPlus application. Or use Navicat or free Toad --GUI database mangement tools. (search for them on web-- use what you like)

SQLPlus

  • program you download to your machine that lets you remotely connect (via telnet protocol...invisible to you), to the Oracle DB instance cs1db into your account.
  • You use SQL commands to manipulate your tablespace.
  • YOU CAN RUN SQLPlus from EBOX
    • /apps/oracle/OraHome1/bin/sqlplus  login@mcsdb2 (or whatever your sid is)
    • will prompt for your password
    • now you have command-line interface to type your commands in
  • ALTERNATIVELY --if not tnsnames.ora file
    • sqlplus login/pasword@host:port/SID
    • sqlplus login/pasword@mcsdb1.sci.csueastbay.edu:1521/MCSDB1
  • TO Download the SQLPlus and necessary configuration information:
    • ftp://bell.telecom.csuhayward.edu/APPS/Oracle/Windows/Sql%20Plus3.3/
      1. Read the ReadME file
      2. Retrieve the sqlplus.zip file and unzip and install
      3. UPDATE your tnsnames.ora file approapriately to reflect a cs1db instance!!!! So that it also points to the host = pizza.mcs.csuhayward.edu (or 134.154.14.22)
  • Once you have followed the directions to install SQLPlus.
      1. Launch SQLPlus application from your machine. You will get the following login/connect window. You should enter you UserName, Password and the Host String = cs1db






      2. If you are successfull in connecting you will see the following kind of message:
      3. You are now ready at the SQL> prompt to enter in your desired SQL commands.
      4. SQL COMMAND TO ALTER YOUR PASSWORD!!!!!!!!
        SQL> alter user your_user_name identified by new_password;

         

Puzzle Server (http://csweb01.csueastbay.edu)

HTML

  • create a subdirectory named public_html
  • place all of your HTML files in your public_html directory. This directory and any sub-directories should be of mode rwxr-xr-x
  • you can as desired make sub-directories inside of your public_html directory and I encourage you to do so for each project,etc.
  • The url leading up to your main public_html directory will be http://csweb01.csueastbay.edu/~login

Java Servlets, Java Server Pages,

  • place all of your files in your public_html directory
  • you can as desired make sub-directories inside of your public_html directory and I encourage you to do so for each project,etc.
  • see our class web materials on how to deploy using GlassFish

 

VCL
 

Virtual Computing Lab --- there is one there with Adobe Dreamweaver you may find useful for creating static webpages.

Microsoft Software

Visual Studio .NET,    Windows XP,      Windows Server

  • email msdnaa@mcs.csueastbay.edu and give the following:
    • name,
    • horizon email address
    • instructor name
    • software request

(old) Visual Studio

  • through library or bookstore (changes with changing policies) can get for roughly price of media

 


 
© Lynne Grewe