Changes between Version 4 and Version 5 of SysAdmin/ContinuousIntegration

Timestamp:

12/17/12 12:57:16 (12 years ago)

Author:

spM

Comment:

--

SysAdmin/ContinuousIntegration

@@ -27 +27 @@
 === Edit cron times: ===
  (Currently set to run Test Suite every 6 hours every day of every week of every month of every year)
-
+{{{#!sh
 crontab -e
+}}}
 
 === Location of Web2Py and Eden Directory ===
@@ -131 +132 @@
 }}}
 
-
-
+=== Postgresql Instance Details for CI Server ===
+
+'''Database name''': sahana
+
+'''Database user''': kunal
+
+'''Database user password''': eden
+
+'''Host''': localhost
+
+'''Port''': 5432
+
+
+==== How to Connect to Sahana Database from the console ====
+{{{#!sh
+psql -d sahana -U kunal
+}}}
+
+==== How to Restart Postgresql Server (You can give it a shot, if psql fails to connect) ====
+{{{#!sh
+sudo su - postgres
+/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
+}}}
+
+===  Other Useful Linux command sets ===
+
+* '''Pre-populate database (any type of db)''' :
+{{{#!sh
+cd ~web2py
+sudo python web2py.py -S eden -M -R applications/eden/static/scripts/tools/noop.py
+}}}
+* '''chmod directory recursively (chmod everything inside dir with -R):'''
+{{{#!sh
+chmod -R 777 /home/web2py
+}}}
+* '''start web2py'''
+{{{#!sh
+cd ~web2py
+python web2py.py -a root
+}}}
+* '''reboot server'''
+{{{#!sh
+sudo /sbin/reboot
+}}}
+* '''Restart Cherokee'''
+   {{{#!sh 
+   sudo /etc/init.d/cherokee restart
+   }}}
+* '''Restart Web2Py SSL'''
+   {{{#!sh
+   sudo /etc/init.d/uwsgi start
+   }}}
+* '''Recreate Sahana DB''' :
+{{{#!sh
+psql -U postgres -c "drop database sahana"
+psql -U postgres -c "create database sahana"
+psql -U postgres -c "GRANT ALL PRIVILEGES ON DATABASE sahana to kunal" #Assuming kunal is the name of the postgresql username which will be used by Sahana Eden instance
+psql -d sahana -U kunal
+}}}
+* '''Setup Cron''' :
+{{{#!sh
+crontab -e
+}}}
+'''Note''' : You can refer to examples of crontab expressions here : http://code.google.com/p/ncrontab/wiki/CrontabExamples
+* '''start Window based applications (x11)''':
+  * If the GUI window of the application is of no intrest to you
+  {{{#!sh
+  xvfb-run -a *test commands here*
+  }}}
+  For example : 
+  {{{#!sh
+  xvfb-run -a python web2py.py -S eden -M -R applications/eden/modules/tests/suite.py -A -V 2
+  }}}
+  '''Note''': Xvfb basically makes a virtual display which isn't displayed anywhere. Xserver itself actually requires a real display
+  * If you want to see the GUI interface of the application
+    * If your machine you use to ssh into the server, has X Server installed, then you can access the GUI window by using the -X flag when loggin into the server
+    {{{#!sh
+    ssh -X youraccount@82.71.213.53
+    }}}
+    And now, if you simply execute any application which has a Xserver attached to it, it will be displayed on your screen.