Prototype as part of After Money project based at University of Edinburgh. Experimenting with digital currencies. GPS based bitcoin transactions using electrum.
there are three applications, Basic Geocoin, Marriage web app and Charity web app.
Due to back-end and database changes the Basic Geocoin and Charity web app needs to be updated to work with the current back-end.
each app consists of:
- front-end (js,html,css) files.
- back-end php files to communication with Mysql database
- There is a dbconfig.ini file that has the authentication parameters in it, because of security purposes, I emptied the authentication details, when migrating to new servers either put them in by hand or copy them from project external hard drive.
- bitcoin python "payto.py" file. This will take care of wallet transactions.
- Make sure to put in all the details of each wallet as show in the example inside this file.
- There is a shell script repeatFetch.sh, which will run the payto.py code indefinitely.
So you need to update the section below inside the payto.py with list of all wallets.
walletsList = {"wallet_name_1":["password1","address1"],
"wallet_name_2":["password2","address2"],
"rest of the wallets" : ["passwordX","AddressX"]}
userWallets = {"userId":"walletName",
"userId":"walletName"}
payto script deals with transactions. This script will look at geocoin mysql database and based on the active transactions in there it will make bitcoin transactions using electrum python script. I used "watch" command to run the python code every 10 seconds, however It may be a better idea to run this every 20 or XX seconds as electrum network speed tents to fluctuate.
In case you want to move this application to a new server, these are the steps you need to follow:
- Server requirements:
- PHP and MySQL installed
- Electrum installed
- Have user rights to be able to copy files into server
- Rights run shell scrips
- admin rights on MySQL to create database, table and procedures.
- All wallets need to be restored by either using the electrum GUI or terminal.
- If you don't have the geocoin database, run the following scripts in the same order as below in your mysql query interface:
- Geocoin database & table creation script
- Wallets table data
- From Serverside Folder upload all php files including the dbconfig to the public_html or www folder of your new server.
- Make sure you update the dbconfig.ini to have correct authentication information.
- Depending on which project you decide to migrate to a new server:
- Copy all the files and folder of one of the three into your new server
- Run the python payto.py file on the new server
electrum restore --wallet ~/.electrum/wallets/negativeWallet_3 "Replace this with the seed for the wallet you are restoring" and then you need to provide a password for it. Doesn't have to be the same as before.
- Open electrum GUI
- Either press Ctrl + N or go to "File" => new/restore
- Choose a name for the wallet you want to restore
- Choose restore wallet or import keys like the image below
- Type in or copy and paste the seed for the wallet you are restoring.
- Next and done...
###6. Running the payto.py ####example of a command for running the python payto file:
watch -n 10 python payto.py
-n XX means, run this command every XX seconds. so for 20 seconds it will be watch -n 20 python payto.py
Make sure to run this from the folder the script is located at, or make sure to include the file path in the command above.
Here is the database EER Diagram
Please note in the current version of the software the foreign keys are not in place. This won't affect the application, but as a good practice, next developer may want to add them.
And scripts for restoring the databese on a new server: