cs3.calstatela.edu

The server supports remote access through SecureShell (SSH). To logon to the server, you need to use an SSH client such as PuTTY.  For file transfer, use WinSCP or FileZilla or other software that supports the SSH File Transfer Protocol (SFTP). Note that Telnet and FTP are NOT supported.

[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://cs3.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):

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

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

Note that you should replace <username> with your actual login name on the server, and the ServletName depends the <servlet-mapping> settings in your web.xml file, i.e. it's not necessarily the name of the servlet class.

[MySQL]

To access the MySQL database, you may log on the CS3 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 cs3.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 the CS3 server, you may omit the -h, -D, and -u options and simply use

mysql -p

If you prefer a GUI client, you may use MySQL Workbench. Note that you do not have to have administrator privilege to install MySQL Workbench, you can download the zip package, unzip it, then run the program MySQLWorkbench.exe.

In MySQL Workbench, use the following for the database connection:

• Hostname: cs3.calstatela.edu
• Port: 3306
• Username: your login name on CS3
• Password: your password on CS3
• Default Schema: same as the username

And finally, you can also use phpMyAdmin to access your MySQL database. phpMyAdmin is a web application, so no additional software installation is required. Simply point your browser to http://cs3.calstatela.edu/phpMyAdmin, enter your username and password, and that's it.

[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 cs3.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.

[Subversion]

You may access your Subversion repository using a Subversion client, e.g. the command line client svn or the Eclipse plugin Subclipse, at the following URL:

svn://cs3.calstatela.edu/<course>/<quarter>/<username>

For example, if you are taking CS520 in Spring 2007, and the username of your account is cs520stu31, the URL for your repository is svn://cs3.calstatela.edu/cs520/s07/cs520stu31.