Academic Certificate Issuing and Global Search using Private Ethereum Blockchain and SQLite

Features

• Issue UniqueID to recipients
• Publish Certificate in Blockchain
• Get all the certificate issued to a particular recipient at on click

Issue UniqueID

• User is requested to enter some details like name, email, password etc
• He/she is given a automatically generated ID which is their UniqueId

Publish Certificate

• The institution will ask the recipient for their UniqueID, without which the certificate cannot be published.
• The institution will have to enter some details and the PDF of the certificate along with the UniqueID and click Publish.
• If the UniqueID is valid, the certificate along with all the details will be published onto the blockchain.

Search using UniqueID

• Enter the valid UniqueID and click Search and all the issued certificates will be listed.

Tools Used

• Truffle
• Ethereum
• NodeJS
• MetaMask
• SQLite
• Flask

Languages Used

• Solidity
• JavaScript
• Python 3

Steps to replicate result

• Clone the directory

foo@bar:~$ git clone git@github.com:sampatghosh/blockchain-academic-certificate-global-verify.git 

• Set up Truffle

foo@bar:~$ npm install -g truffle

• Navigate to the project directory:

foo@bar:~$ cd blockchain-academic-certificate-global-verify

• Compile Contract

foo@bar:~/blockchain-academic-certificate-global-verify$ truffle compile

• Setup private blockchain using geth, create account and generate fake Ether for your account
• Start your node using:

foo@bar:~$ geth --datadir ./blockchain --networkid 2018 --rpc --nodiscover --rpc --rpcport 8545 --rpcaddr 127.0.0.1 --maxpeers=0 --rpccorsdomain "*" --rpcapi "personal,eth,net,web3,debug,miner" --allow-insecure-unlock --password <(echo __password__) --unlock 0 

• Open geth console and start mining:

foo@bar:~$ geth attach http://127.0.0.1:8545
Welcome to the Geth JavaScript console!

instance: Geth/v1.9.14-stable-6d74d1e5/linux-amd64/go1.14.2
coinbase: 0x7c5c723cd38eeb2d2975dc241fa0a54a9f0ff3da
at block: 2931 (Sun Jun 07 2020 14:27:14 GMT+0530 (IST))
datadir: /home/sampatghosh/blockchain
modules: admin:1.0 debug:1.0 eth:1.0 ethash:1.0 miner:1.0 net:1.0 personal:1.0 rpc:1.0 txpool:1.0 web3:1.0
> miner.start() 

• Deploy Contract and note the contract address

foo@bar:~/blockchain-academic-certificate-global-verify$ truffle migrate 

• Write the contract address at line 3 in app.js

var address = "0xA5FB32b226ECC34fF4AA81D0DB1F2eF324378C31";

• Setup MetaMask and import account from blockchain directory

• Run database API

foo@bar:~$ python3 /blockchain-academic-certificate-global-verify/webapp/api/api.py 

• Run Node.js server and click on main.html

foo@bar:~$ http-server blockchain-academic-certificate-global-verify/webapp/ -c-1 

• To Search all the details of all certificates issued to a particular student then go to search.html and enter UniqueID and click Search
• To Create new UniqueID click on uniqueID.html
• To Publish Certificate click on publish.html