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 Secure 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 URL mapping specified in the @WebServlet annotation of the servlet, 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]

You can use two client tools to access a PostgreSQL database:

• The command line client psql
• The GUI client pgAdmin

Both psql and pgAdmin are included in the PostgreSQL distribution. Note that in any case, the name of your database on CS3 is the same as your login name.