Energy Wars Display - Revision history

Craigje: /* links */

2015-05-17T22:53:44Z

links

← Older revision		Revision as of 22:53, 17 May 2015
Line 3:		Line 3:
	=links=		=links=
	These are the eDisplays.		These are the eDisplays.
	* [[http://proto.cs.earlham.edu/~energy/production/EnergyWars/Buildings.html Buildings]]		* [http://proto.cs.earlham.edu/~energy/production/EnergyWars/Buildings.html Buildings]
	* [[http://proto.cs.earlham.edu/~energy/production/EnergyWars/CollegeAvenue.html College Avenue]]		* [http://proto.cs.earlham.edu/~energy/production/EnergyWars/CollegeAvenue.html College Avenue]
	* [[http://proto.cs.earlham.edu/~energy/production/EnergyWars/NationalRoad.html National Road]]		* [http://proto.cs.earlham.edu/~energy/production/EnergyWars/NationalRoad.html National Road]

	=RPNL=		=RPNL=

Ghcrows13 at 16:32, 11 August 2014

2014-08-11T16:32:41Z

← Older revision		Revision as of 16:32, 11 August 2014
Line 46:		Line 46:
	#* this user must have the correct permissions (must be in the energy group)		#* this user must have the correct permissions (must be in the energy group)
	# rpnl_store.bash copies the tmp.csv into the electrical_energy_rpnl database		# rpnl_store.bash copies the tmp.csv into the electrical_energy_rpnl database
	#* we do it this way so that permissions are less of a hassle (local permissions are simpler than remote permissions)		#* we do it this way so that permissions are less of a hassle (local psql permissions are simpler than remote permissions)

	=Display=		=Display=

Ghcrows13: /* Transferring */

2014-06-26T13:29:10Z

Transferring

← Older revision		Revision as of 13:29, 26 June 2014
Line 17:		Line 17:
	# Create rsa keys and share them with the database server.		# Create rsa keys and share them with the database server.
	# Ensure that the owner, group, and permissions are appropriate for all files. Since you copied the files earlier it's likely they're still owned by me. Troubleshooting these issues is hard so cross your T's and dot your I's.		# Ensure that the owner, group, and permissions are appropriate for all files. Since you copied the files earlier it's likely they're still owned by me. Troubleshooting these issues is hard so cross your T's and dot your I's.
	# Edit mail.py's home_dir variable and cmd_store/cmd_process to reflect the new directory.		# Edit mail.py's home_dir variable and cmd_store/cmd_process variables to reflect the new directory.

	On the database server (proto) do the following:		On the database server (proto) do the following:

Ghcrows13: /* Transferring */

2014-06-26T13:28:03Z

Transferring

← Older revision		Revision as of 13:28, 26 June 2014
Line 12:		Line 12:

	On the email server do the following:		On the email server do the following:
	# Copy ~~the "~~rpnl~~" directory from my home directory~~.		# Copy ~ghcrows13/rpnl/ to your destination.
	# Copy my ".forward" file and ~~change~~ the ~~paths~~.		# Copy my ".forward" file to your destination and edit its filepaths to be correct.
			# Edit the ".forward" for testcs128 to forward email to the correct user.
	# Create rsa keys and share them with the database server.		# Create rsa keys and share them with the database server.
	# Ensure that the owner, group, and permissions are appropriate for all files. Troubleshooting these issues is hard.		# Ensure that the owner, group, and permissions are appropriate for all files. Since you copied the files earlier it's likely they're still owned by me. Troubleshooting these issues is hard so cross your T's and dot your I's.
			# Edit mail.py's home_dir variable and cmd_store/cmd_process to reflect the new directory.

	On the database server (proto) do the following:		On the database server (proto) do the following:
	# Copy		# Copy ~ghcrows13/important/rpnl_store.bash to your destination.
			# (on the email server) edit mail.py's cmd_store and cmd_process variables to reflect the new rpnl_store.bash location.
			# Ensure that the user is part of the energy group.

	==Methods==		==Methods==

Ghcrows13: /* Transferring */

2014-06-26T11:50:51Z

Transferring

← Older revision		Revision as of 11:50, 26 June 2014
Line 15:		Line 15:
	# Copy my ".forward" file and change the paths.		# Copy my ".forward" file and change the paths.
	# Create rsa keys and share them with the database server.		# Create rsa keys and share them with the database server.
	# Ensure that ~~owners~~, ~~groups~~, and permissions are appropriate.		# Ensure that the owner, group, and permissions are appropriate for all files. Troubleshooting these issues is hard.

	On the database server (proto) do the following:		On the database server (proto) do the following:
	# Copy		# Copy

	==Methods==		==Methods==

Ghcrows13: /* RPNL */

2014-06-26T11:50:10Z

RPNL

← Older revision		Revision as of 11:50, 26 June 2014
Line 8:		Line 8:

	=RPNL=		=RPNL=
			==Transferring==
			I (ghcrows13) believe that a HIP account should be used instead of my accounts. To transfer my work to another account you'd have to do a couple of things.

			On the email server do the following:
			# Copy the "rpnl" directory from my home directory.
			# Copy my ".forward" file and change the paths.
			# Create rsa keys and share them with the database server.
			# Ensure that owners, groups, and permissions are appropriate.

			On the database server (proto) do the following:
			# Copy

			==Methods==
	Currently this is how we're getting data from RPNL.		Currently this is how we're getting data from RPNL.

Ghcrows13: /* RPNL */

2014-06-26T11:45:45Z

RPNL

← Older revision		Revision as of 11:45, 26 June 2014
Line 8:		Line 8:

	=RPNL=		=RPNL=
	~~This~~ is how we're getting data from RPNL.		Currently this is how we're getting data from RPNL.

	# RPNL sends an email containing CSV to testcs128@cs.earlham.edu		# RPNL sends an email containing CSV to testcs128@cs.earlham.edu

Ghcrows13: /* RPNL */

2014-06-26T11:32:42Z

RPNL

← Older revision		Revision as of 11:32, 26 June 2014
Line 13:		Line 13:
	# testcs128 forwards it to ghcrows13@cs.earlham.edu from its .forward file		# testcs128 forwards it to ghcrows13@cs.earlham.edu from its .forward file
	# ghcrows13@cs.earlham.edu receives the email and does the following:		# ghcrows13@cs.earlham.edu receives the email and does the following:
	## ~~appended~~ to mail_longterm.csv		## appends it to mail_longterm.csv
	## mail.store overwrites mail.tmp		## mail.store overwrites mail.tmp
	## mail.py does the lionshare of the work		## mail.py does the lionshare of the work

Ghcrows13: /* RPNL */

2014-06-26T11:31:50Z

RPNL

← Older revision		Revision as of 11:31, 26 June 2014
Line 8:		Line 8:

	=RPNL=		=RPNL=
	~~Currently, this~~ is how we're getting data from RPNL.		This is how we're getting data from RPNL.

	# RPNL sends an email containing CSV to testcs128@cs.earlham.edu		# RPNL sends an email containing CSV to testcs128@cs.earlham.edu

Ghcrows13: /* RPNL */

2014-06-26T11:30:14Z

RPNL

← Older revision		Revision as of 11:30, 26 June 2014
Line 11:		Line 11:

	# RPNL sends an email containing CSV to testcs128@cs.earlham.edu		# RPNL sends an email containing CSV to testcs128@cs.earlham.edu
	# testcs128 forwards it to ghcrows13@cs.earlham.edu in its .forward file		# testcs128 forwards it to ghcrows13@cs.earlham.edu from its .forward file
	# ghcrows13@cs.earlham.edu ~~executes~~ mail.~~py (in home directory) from its~~ .~~forward file~~		# ghcrows13@cs.earlham.edu receives the email and does the following:
	# mail.py scrapes off CSV attachments		## appended to mail_longterm.csv
	# ~~mail.py pipes text into parse.py~~		## mail.store overwrites mail.tmp
	# ~~parse.py scrapes off~~ data, copies ~~tmp.csv~~ to ghcrows13@proto.cs.earlham.edu:/home/users/energy/contest/daily/tmp.csv		## mail.py does the lionshare of the work

			mail.py does the following:
			# scrapes off CSV attachments
			# scrapes data from the CSV
			# generates formatted data for long-term storage
			# copies formatted data to ghcrows13@proto.cs.earlham.edu:/home/users/energy/contest/daily/tmp.csv
	#* uses RSA keys to bypass passwords		#* uses RSA keys to bypass passwords
	#* usernames must be the same for RSA keys to work		#* usernames must be the same for RSA keys to work
	# ~~parse~~.~~py executes~~ /home/users/energy/contest/daily/rpnl_store.bash		# executes ghcrows13@proto.cs.earlham.edu:/home/users/energy/contest/daily/rpnl_store.bash
	#* uses RSA keys to bypass passwords		#* uses RSA keys to bypass passwords
	#* the script is executed by ghcrows13 on Proto		#* the script is executed by ghcrows13 on Proto