Online Testing System

2008-03-21T05:30:42Z

<pre> <h2>Prt.Sc taken during development</h2> pic01: http://skitch.com/dscape/eki7/ubuntu pic02: http://skitch.com/dscape/efsc/the-db2-on-campus-portal-question-2 pic03: http://skitch.com/dscape/efip/the-db2-on-campus-portal-failed-you-will-have-to-try-again pic04: http://skitch.com/dscape/efsx/the-db2-on-campus-portal-failed-you-will-have-to-try-again pic05: http://skitch.com/dscape/efu9/the-db2-on-campus-portal-question-1 pic06: http://skitch.com/dscape/87fx/the-db2-on-campus-portal-prepare-yourself-for-the-certification-exam pic08: http://skitch.com/dscape/87fb/the-db2-on-campus-portal-recover-your-password pic09: http://skitch.com/dscape/87fy/the-db2-on-campus-portal-create-your-own-profile pic10: http://skitch.com/dscape/87r6/the-db2-on-campus-portal-prepare-yourself-for-the-certification-exam pic11: http://skitch.com/dscape/87r7/the-db2-on-campus-portal-changing-your-password pic12: http://skitch.com/dscape/87rh/the-db2-on-campus-portal-update-your-profile pic13: http://skitch.com/dscape/87r4/the-db2-on-campus-portal-changing-roles pic14: http://skitch.com/dscape/87r2/the-db2-on-campus-portal-welcome-to-the-students-lounge pic15: http://skitch.com/dscape/87ra/the-db2-on-campus-portal-welcome-to-the-students-lounge pic16: http://skitch.com/dscape/87rw/the-db2-on-campus-portal-welcome-to-the-students-lounge pic17: http://skitch.com/dscape/8arq/the-db2-on-campus-portal-prepare-yourself-for-the-certification-exam <h2>Installation Instructions</h2> { project home: http://gitorious.org/projects/online-testing-system/ } { made on Ubuntu Hardy Heron 8.04 latest beta } <h3>(db) Instructions for Installing DB2 Express-C</h3> db1: Download DB2 Express-C for Linux to ~/Desktop ref: ftp://ftp.software.ibm.com/software/data/db2/express/latest_debs/ db2: Install dependencies $ sudo apt-get install libstdc++5 $ sudo apt-get install libaio-dev db3: Install and Configure $ cd ~/Desktop && sudo gdebi-gtk db2exc_9.5.0-1_i386.deb ( wait a minute/hour and hit install package ) further instructions at: * http://tldp.org/HOWTO/DB2-HOWTO/ubuntu704.html * http://caos.di.uminho.pt/~db2/blog/17/2007/12/06/express-c-starting/ db4: export PATH (not necessary with deb installer, considering you use db2inst1 as your db2 username) $ export IBM_DB_DIR=/home/db2inst1/sqllib $ export IBM_DB_LIB=/home/db2inst1/sqllib/lib <h3>(d) Instructions for Development Environment:</h3> d1: Install dependencies $ sudo apt-get install build-essential $ sudo apt-get install ruby irb rdoc rubygems ruby1.8-dev curl $ sudo apt-get install git-core $ cd ~/Desktop $ git clone http://git.gitorious.org/online-testing-system/mainline.git $ sudo gem update --SYSTEM (for proxy use option: -p http://someproxy.ibm.com:3128 *) $ sudo gem update (**) $ sudo gem install rails mongrel ruby-debug d2: Create database/schema in DB2 $ db2start $ db2 $ db2 => create database ots_db using codeset UTF-8 territory en-US $ db2 => connect to ots_db $ db2 => create schema ots_schema d3: Install IBM_DB $ sudo gem install ibm_db --include-dependencies d4: Create environment.rb and database.yml $ cd mainline && vim config/environment.rb EXAMPLE FILE - Thinking about production? CHANGE THE SECRET # EXAMPLE :: ENVIRONMENT.RB RAILS_GEM_VERSION = '2.0.2' unless defined? RAILS_GEM_VERSION require File.join(File.dirname(__FILE__), 'boot') Rails::Initializer.run do |config| config.action_controller.session = { :session_key => '_ibm_ots_session', :secret => '6fefb53efedf98e70177ecc529f4852cf4ff19d1b87e7dfb5fa66646141369' } end require 'lib/actionpack_ext.rb' # EOF :: ENVIRONMENT.RB $ vim config/database.yml # EXAMPLE :: DATABASE.YML development: adapter: ibm_db database: ots_db schema: ots_schema username: someuser password: isasecret testing: adapter: ibm_db database: ots_test_db schema: ots_test_schema username: someuser password: isasecret production: adapter: ibm_db database: ots_prod_db schema: ots_prod_schema username: someuser password: isasecret # EOF :: DATABASE.YML d5: Configure the SMTP mail server Configure the config/initializers/mail.rb to use the server you desire. (it's commented for now) Not necessary for development. Simply check the mongrel server for the activation key. Colaboration from Arvind Gupta For smtp configuration I have followed instruction on http://www.prestonlee.com/archives/63 I have added a file smtp_tls.rb in lib folder with the code # EXAMPLE :: SMTP_TLS.RB require "openssl" require "net/smtp" Net::SMTP.class_eval do private def do_start(helodomain, user, secret, authtype) raise IOError, 'SMTP session already started' if @started check_auth_args user, secret, authtype if user or secret sock = timeout(@open_timeout) { TCPSocket.open(@address, @port) } @socket = Net::InternetMessageIO.new(sock) @socket.read_timeout = 60 #@read_timeout check_response(critical { recv_response() }) do_helo(helodomain) if starttls raise 'openssl library not installed' unless defined?(OpenSSL) ssl = OpenSSL::SSL::SSLSocket.new(sock) ssl.sync_close = true ssl.connect @socket = Net::InternetMessageIO.new(ssl) @socket.read_timeout = 60 #@read_timeout do_helo(helodomain) end authenticate user, secret, authtype if user @started = true ensure unless @started # authentication failed, cancel connection. @socket.close if not @started and @socket and not @socket.closed? @socket = nil end end def do_helo(helodomain) begin if @esmtp ehlo helodomain else helo helodomain end rescue Net::ProtocolError if @esmtp @esmtp = false @error_occured = false retry end raise end end def starttls getok('STARTTLS') rescue return false return true end def quit begin getok('QUIT') rescue EOFError end end end # EXAMPLE :: SMTP_TLS.RB And added this code to config/environment.rb # PARTIAL EXAMPLE :: ENVIRONMENT.RB require "smtp_tls" ActionMailer::Base.smtp_settings = {:address => "smtp.gmail.com", :port => 587, :authentication => :plain, :user_name => "arvindfakeemail@gmail.com", :password => 'someonesPassword'} # EOF :: ENVIRONMENT.RB d6: Start the server $ rake db:migrate $ ./script/server ( browse to http://localhost:3000 to check the site ) d7: Give yourself root $ ./script/console $ >> u = User.find_by_login 'dscape' # replace dscape for your login name $ >> u.roles << Role.find_by_name('root') ( now just refresh the webapp and you are root! ) <h3>(t) Instructions for Testing Environment:</h3> TDB <h3>(p) Instructions for Production Environment:</h3> ref: http://www.modrails.com/ TDB <h3>Notes:</h3> * in event of error consult: http://elia.wordpress.com/2007/07/18/gems-through-the-proxy-or-the-undefined-method-error/ As you are not in Mac OS X you should simply: sudo vim /usr/lib/ruby/1.8/rubygems/config_file.rb and then do the things he says. ** in event of error consult: http://www.nickpeters.net/2007/12/31/fix-for-uninitialized-constant-gemgemrunner-nameerror/ Don't forget to sudo vim or you won't be able to change the file. <h3>Thank you</h3> * <a href="http://www.vitorrodrigues.com" target="_blank">Vítor Rodrigues</a> for the support, articles and samples on pureXML. * <a href="http://www.alcidesfonseca.com" target="_blank">Alcides Fonseca</a> for the prototype support. * <a href="http://db2expressc.blogspot.com/" target="_blank">Raul Chong</a> for the help with the documentation and testing. * <a href="http://www.linkedin.com/in/bernaulli" target="_blank">Arvind Gupta</a> for the help with gmail mailer.rb. </pre>

MIT License

online-testing-system Online Testing System

true

dscape 388 mainline dscape git://gitorious.org/online-testing-system/mainline.git