cs.calstatela.edu

The server supports remote access through SecureShell (SSH). To access the server, it is recommended that you use the non-commercial version of SSH Secure Shell for Workstations, which can be downloaded from http://www.ssh.com/support/downloads/secureshellwks/non-commercial.html free of charge. This is the same SSH software installed on the lab machines, and it includes both a Secure Shell client which can be used to log on to the server, and a Secure File Transfer client which can be used to transfer files to and from the server. Note that Telnet and FTP are NOT supported.

	CS320	CS422	CS491	CS520
Apache/PHP			Y	Y
Tomcat	Y		Y	Y
MySQL	Y	Y	Y	Y
PostgreSQL		Y	Y	Y
Oracle		Y	Y	Y

[Apache/PHP]

Once you log on to the server, you will see a public_html directory under your home directory. You may place your HTML and PHP files under this directory, and access them using the URL http://cs.calstatela.edu/~<username>/filename. Note that you should replace <username> with your actual login name on the server.

[Tomcat]

Once you log on to the server, you will see a www directory under your home directory. Under www, the following directories are created for you (the directory names are case sensitive):

Directory	Description
WEB-INF
WEB-INF/classes	for servlets and unpacked supporting classes.
WEB-INF/lib	for packed classes and libraries.

You may place your servlet class files and JSP files in proper subdirectories, and access them using the following URLs:

For servlets: http://cs.calstatela.edu:8080/<username>/servlet/ServletName
For JSPs: http://cs.calstatela.edu:8080/<username>/JSPName.jsp

Note that you should replace <username> with your actual login name on the server.

[MySQL]

To access the MySQL database, you may want to log on the server, and use the command line client mysql. The general syntax for mysql is

mysql -h hostname -D dbname -u username -p

e.g. mysql -h cs.calstatela.edu -D cs320stu31 -u cs320stu31. Note that the database name is the same as the user name, and if you are already logged on to server, you may omit the -h, -D, and -u options and simply use

mysql -p

[PostgreSQL]

To access the PostgreSQL database, you may want to use either the command line client psql, which comes with the official PostgreSQL distribution, or some GUI client such as pgAdmin III. The general syntax for psql is psql -h hostname -d dbname -U username, e.g. psql -h cs.calstatela.edu -d cs422stu31 -U cs422stu31. Note that

the database name is the same as the username, and
if you are already logged on to the server, you may omit the -h, -d, and -U options and simply use psql.

[Oracle]

The easiest way to access the Oracle database is using iSQL*Plus, a web-based Oracle database client available at http://cs.calstatela.edu:5560/isqlplus/. You can connect to the database this way without installing any additional software, as long as you have access to a browser and the internet. The only catch is that you may need to use .txt as the file extension of your SQL scripts, unless you know how to add MIME types to your favorite browser.

For those of you who prefer the old-fashioned command-line client SQL*Plus, you may download the Oracle Instant Client from Oracle Technology Network (free registration required) or here, and follow these steps:

Unzip all the files. By default all the uncompressed files go into the same directory, for example, c:\instantclient10_1.
Download tnsnames.ora and put it under the same directory. This file tells SQL*Plus where to look for the database server.
Still under the same directory, create a shortcut for sqlplus.exe. Modify the shortcut (right-click it and select Properties) so the Target field looks like c:\instantclient10_1\sqlplus.exe cs422stu31@orc. Note that you should replace cs422stu31 with the actual Oracle account name assigned to you.
Double click on th shortcut, enter the password, and you are connect to the Oracle server.

If you are sure that nobody else can access the shortcut, you may even add the account password to the Target field, e.g., c:\instantclient10_1\sqlplus.exe cs422stu31/abcd@orc, so you don't have to type in the password every time.

And of course, you can always log on to the server, and use the SQL*Plus client there by typing sqlplus.