Storing an encrypted password to mysql in python

Question

import sys
import hashlib
import getpass
from passlib.hash import sha256_crypt
import MySQLdb, random, os


def SQLAddPass(username, password):
    SQL = 'insert into user values ("%s", "%s")' % (username, password)

    try:
        db = MySQLdb.connect (host='localhost', user='root', db='vedio')
        c = db.cursor()
        c.execute(SQL)
        db.commit()
        c.close()
        db.close()
        raw_input('Record Added - press enter to continue: ')
    except:
        print 'There was a problem adding the record'
        raw_input ('press enter to continue')


def main(argv):


    print '\nUser & Password Storage Program v.01\n'


    username = raw_input('Please Enter a User Name: ')
    password = sha256_crypt.encrypt(getpass.getpass('Please Enter a Password: '))

    try:
        SQLAddPass(username, password)

    except:
        sys.exit('There was a problem saving Record!')

    print '\nPassword safely stored in ' + sys.argv[1] + '\n'      

if __name__ == "__main__":
    main(sys.argv[1:])

My problem is that the script works but with the following error **

(C:\Users\Elsie\Desktop\example.py:14: Warning: Data truncated for column 'passwo rd' at row 1 c.execute(SQL) Record Added - press enter to continue:

**

Password safely stored in database. What am i doing wrong any ideas or changes to the code are welcome)

You have funny exception strategy. You are handling one exception two times. Don't. — matiit
– matiit, Commented Feb 20, 2013 at 9:10

Daniel Magnusson · Accepted Answer · 2013-02-20 09:10:49Z

1

Data truncated for column 'passwo rd' at row 1

Mean your table has a password column with a length of for example 10 and you are inserting a record of let's say 20. The record you inserted will be truncated. And passwords will be broken.

Increase length of column in the table

answered Feb 20, 2013 at 9:10

Daniel Magnusson

9,7042 gold badges40 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Julian Hille · Accepted Answer · 2013-02-20 09:08:30Z

0

Possible that your 'password' field is too short. You need a varchar(64). What is your length of your password field?

answered Feb 20, 2013 at 9:08

Julian Hille

6695 silver badges11 bronze badges

2 Comments

Herb21 Over a year ago

Julian i had used 15 but have increased as per suggestion and it works like a charm

Herb21 Over a year ago

@daniel thanks it worked can you please help with code to read and verify the stored password so far i have come up with this pass_try x = 3 username = raw_input('Please Enter User Name: ') while pass_try < x: password = sha256_crypt.verify(getpass.getpass("Enter password: ", hash)) if password != password: pass_try += 1print 'Incorrect Password, ' + str(x-pass_try) + ' more attemts left\n' else: pass_try = x+1 if pass_try == x and password != password: sys.exit('Incorrect Password, terminating... \n')

Collectives™ on Stack Overflow

Storing an encrypted password to mysql in python

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related