A function for MySQL which verifies Mobile One Time Passwords and remeber them to make them only valid for one time.

1. Create table otp_history like shown in mysql-motp.func.

2. Paste text from mysql-motp.func into your mysql-session

3. You are ready to start.

The function otpverify returns a bool value, so:
1 := True (is valid)
0 := False (wrong)

mysql> select otpverify('1234','624d4f','0123456789abcdef') as result\G
result: 1

mysql> select otpverify('1234','624d4f','0123456789abcdef') as result\G
result: 0

Features

  • motp
  • mysql

Project Activity

See All Activity >

Follow mysql-motp

mysql-motp Web Site

Other Useful Business Software
Level Up Your Cyber Defense with External Threat Management Icon
Level Up Your Cyber Defense with External Threat Management

See every risk before it hits. From exposed data to dark web chatter. All in one unified view.

Move beyond alerts. Gain full visibility, context, and control over your external attack surface to stay ahead of every threat.
Try for Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of mysql-motp!

Additional Project Details

Registered

2014-05-16
Report inappropriate content