EdLab & Gottesman Libraries Technology Resources November 24, 2008 Prepared by Anthony Cocciolo

1. EdLab & Gottesman Libraries Technology Resources November 24, 2008 Prepared by Anthony Cocciolo

2. Information Technology at Teachers College • EdLab & The Gottesman Libraries – Anthony Cocciolo (manage/maintain websites and Windows & UNIX servers, new developments, R&D) • Others involved in IT at the Library- Frank Webster & Adolfo Bon (OPAC & library applications) • Christine Jacknick – Computers in the building, Imaging of Computers • Computing & Information Services – Ena Haines • - Academic Computing- George Schuessler - Desktop, LAN, Servers, and Helpdesk- Daniel Aracena • - Administrative Computing- Barbara Torney • - Classrooms, Telecomm & Media Services- Maureen Coughlin • - Network Systems – M. T. Torres

3. General IT Information • Server rooms • Main Server room, Horace Mann 45 • Disaster Recovery server room, Russell Hall 4th Floor • If you need access, please contact me. • Network Information • 10/100/1000 MB Ethernet connections • 10 GB Fiber to Columbia (ISP) • From CU to Internet is 1GB • Different VLANS with different permissions (Admin, Wild Wild West, etc.)

4. Servers • Webservers: • - Windows • - Lois (Library website, Levees, DocDel, Collab Support System, Ticket system, Moodle, DLP Admin Zone, CSG website, Backchat, Edlab website)- Clark (Blackboard, Online MA) • Rogue (Development server) • Gambit (AfterEd, DocLife) • PocketKnowledge • Tcrecord.org (Hosted at Rackspace, Dallas, TX) • PeterParker (running Vista, Meety) • Free BSD • Jay (Development Server, Survey Sidekick) • Silentbob (Survey Sidekick, OJS) • Database Servers (Win 2k3): • ClarkDB (MySQL 4, 5, MSSQL) • Maryjane (MSSQL, PocketKnowledge)

5. Other Servers • LibData (High-end data storage) • EdLabnas (Low-end data storage, currently unavailable) • EDUCAT (OPAC) • New Purchases • Please contact me if need to purchase new server or discuss how existing server can be used with an application.

6. Server Access • For a username and password access, please send me email to cocciolo@tc.edu and I’ll give you a handout with your username and password. • Please do not email or store your username and password in an unsecured location. • When connecting to a Windows server, use Remote Desktop Connection • Remember to select “Log Off” when done with a Remote Desktop Connection session because the session will continue to run if you don’t. • Only 2 connections allowed on each server- only stay connected when you need to. • For all servers (including Rackspace), must be on-campus or over VPN to connect • You can connect via VPN to tunnel.tc.columbia.edu with your domain username and password, and then remote connect.

7. New Developments • For new applications developed, please use development servers • Awareness of increase in SQL Injection attacks and other types of attacks on public web applications. • When a development application is ready to be launched live, I’ll do a quick review to ensure there are no obvious security vulnerabilities, and then it can be moved to a production server. • If you need to upgrade a application used by another applications (e.g., PHP, MySQL) and it may have repercussions on other applications, please let me know and we can try out the upgrades on a development server first.

8. Supporting Existing Applications • Please try out any changes on a development server first before rolling out onto production server. • Priority is uptime, do not restart or bring down any servers during 8AM-12AM, unless absolutely necessary. • Restart should be scheduled for very early morning (3AM, etc.)

9. FERPA • Family Educational Rights and Privacy Act • Do not share any student data or take off-campus/download for any reason (e.g., laptops) • Please contact me if you have any questions about FERPA

10. thank you! EdLab / 525 W. 120th Street / 5th Floor / New York, NY / 10027 / T: 212 678 3069 / F: 212 678 6619