Project Support and Demos

Most of the projects systems use the client/server architecture. The application systems use a variety of database-related software, including different scripting languages, such as Cold Fusion, PHP, Perl, and JSP, to communicate with backend databases in Microsoft Access, MySQL, MS-SQL Server, and Oracle. Some projects also use Java-related software, such as Java servlets, and Tomcat is installed to handle the processing of that code.

This page contains information about the project development environment and the software that might be useful for developing the computer information system for your project.

Project Development Servers (Grad Center room 408)

Three Win2000 servers and three RedHat Linux 9 servers located in Graduate Center room 408, having access only within the university, provide development platforms for the student systems. These servers initially contain no development software, so the students must install software on these hosting platforms as required by their projects. All project files must be tested here before moving to the staging server.

When you first power on the server, use the Print Screen key to view a list of servers. Use the arrow keys to toggle between the different server names and select the one you would like to use.The server name indicates whether it is a Windows server or a Linux server. Press Enter to log on to it. The username and password of each of these servers is as described in the Server information table. You are not allowed to change the IP address for any of the systems.


Server Information
IP address
Name Userid
Password
172.20.138.21 Lab-Win2kSvr1 Administrator password
172.20.138.22 Lab-linuxsvr2 root password
172.20.138.23 Lab-Win2kSvr3 Administrator password
172.20.138.24 Lab-linuxsvr4 root password
172.20.138.25 Lab-Win2kSvr5 Administrator password
172.20.138.26 Lab-linuxsvr6 root password

To work on the Linux systems, it is preferred that you create a new user after you login and work under it. If the password for these servers are changed, it is advisable to inform Tom of the new password.

Important: The student is responsible for all the data backup.None of the workstations or the servers in Room 408 will have a backup of your files.All your data is erased on system restart.

Any software can be installed on these servers that you wish to use. Licenses are available for Coldfusion, Oracle and other softwares. Contact Tom Lombardi (tlombardi@pace.edu) to enquire about the availability of licenses for softwares you needto install. Almost any software you require for windows operating system is available as a part of the MSDNAA Program. Use the link http://utopia.csis.pace.edu/msdnaa/ to download the softwares you require.

The development servers can be accessed through matrix.csis.pace.edu. Matrix can be accessed through an application called Secure shell client. Secure shell is available for download in the Pace University support page through the link http://csis.pace.edu/support/resource.htm.The support page also answers FAQ's about Database connectivity, CGI etc. Teams need to contact Tom to obtain a username and password to logon to matrix.

To gain entry to room 408 during Pace office hours, keys have to be collected from Room-412, Office, School of Computer Science and Information Systems. During other times, security at the main entrance can help you open this door after veryfying your name in Dr.Tappert's student list.

Project Staging Server (outside access) FAQ

After the development phase, the students move their application systems to a staging server having access from outside the university. Students must FTP their project files to the staging server for further system development and testing, see Project Staging Server FAQ. Although all project systems should be finalized on the staging server, some may be moved to production servers within or outside the university. The development and staging servers are independent and separate from the CSIS production servers so that students cannot corrupt data or interfere with operations on those servers.

WS_FTP

This software allows you to easily upload files to and download files from a server. WS_FTP is available in two different versions, the Professional (Pro) version and the Limited Edition (LE) version. WS_FTP LE is shareware, available for free to educational users. Download WS_FTP

PHP/MYSQL Demo   Cold Fusion Demo

This is the same demo in two different scripting languages: PHP and Cold Fusion. The database consists of three tables: Courses, Students, and Students-Courses (which students are enrolled in which courses). There are initially three students: Mariano Rivera, Tino Martinez, and Derek Jeter; three courses: CS504, CS603, and CS615; and each student takes two courses. PHP provides a Web interface to the database.

If you login as the administrator (name and password = "admin") you can add a student, add a course, list the students in a course, list the courses taken by a student, reset the database to its initial data of three students and three courses, or logout. If you login as a student, you will see the courses in which you, the student, are enrolled, and you can add a course, drop a course, change the password, or logout.

That's the demo! From the initial Web page you can download a zipfile of the PHP or Cold Fusion code for the demo so that you can see how it works. These demos should be of help to many teams, and especially to those that have projects with a Web interface to a backend database.

PHP: Hypertext PreProcessor

PHP is a server-side, cross-platform, HTML embedded scripting language. If you are new to PHP and want to get some idea of how it works, try the Introductory tutorial. After that, check out the Online manual, and the example archive sites and some of the other resources available in the Links section.

The advantage of PHP over other scripting languages is that it is suppports Classes. It works with all Databases and especially makes a powerful combination when used with MYSQL as back-end.

Cold Fusion

Cold Fusion is a product that provides webpage tags similar to HTML but for interacting with a database -- for both populating the database and for extracting information from it. This is an easy way to interact with a database through webpages. The Cold Fusion software is installed on the server and it processes the Cold Fusion tags. It is installed on many of the Pace University servers and will be installed on the project development server.

Therefore, all you need to do is to learn the Cold Fusion tags and include appropriate ones in your webpages, which will now have the Cold Fusion file extension cfm, i.e. filename.cfm. Several books on Cold Fusion are on reserve in the library at the Graduate Center for your convenience. And here are the Allaire Cold Fusion help files.

Database Software

Microsoft Access should be sufficient unless other database software is specified by your client. The Database software suggested with PHP scripting is MYSQL. The Tutorial is available along with the Online documentation. The Database software can also be Downloaded for free for local use.

Help

For help with coding problems, particularly PHP and Cold Fusion, contact Naresh Trilok at pntrilok@hotmail.com.