AWS Lambda python library function error

Question

I'm trying to connect to AWS RDS using AWS Lambda. I installed PyMySQL to the directory and built the package with the code below and the libraries

import sys
import pymysql

def lambda_handler(event, context):
    string=""
    try:
            connection = pymysql.connect(host='',
                                            user='',
                                            password='',
                                            db='',
                                            charset='',
                                            cursorclass=pymysql.cursors.DictCursor)
            cur = connection.cursor(pymysql.cursors.DictCursor)
            cur.execute("select * from table")
            for row in cur:
                    print(row['col'])
                    string+=row['col']
    except Exception as e:
            print("MySQL error: %s" % (e.args[0]))

    return string

print(lambda_handler("",""))

In my machine, the code above works, but in AWS, it displays

MySQL error: module 'pymysql' has no attribute 'connect'

I checked that pymysql is only available in the directory that has the code, so I don't know why I'm not able to use the connect method. Both Python versions are the same.

EDIT:

Traceback (most recent call last):
  File "/var/task/lambda.py", line 7, in lambda_handler
    connection = pymysql.connect(host='',
AttributeError: module 'pymysql' has no attribute 'connect'

:( I was hoping it might have shed a bit more light on the issue but I don't take anything from that — roganjosh
– roganjosh, Commented Jan 31, 2018 at 20:47
@roganjosh Yeah, when you asked me that I had a "OF COURSE" moment, but got disappointed as well... — Patrícia Villela
– Patrícia Villela, Commented Jan 31, 2018 at 20:49
What do you get from print(dir(pymysql))? My suspicion is that you have named another script pymysql.py somewhere that's on the PATH. Do you recognise anything in dir that is of your creation? — roganjosh
– roganjosh, Commented Jan 31, 2018 at 20:51

weegolo · Accepted Answer · 2018-04-16 08:28:14Z

1

Try zip -r package.zip *

I suspect you are zipping only the top level of the pymysql module, not the contents of its subdirectories

The AWS documentation for uploading to lambda is pretty poor.

answered Apr 16, 2018 at 8:28

weegolo

3963 silver badges15 bronze badges

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

1 Comment

Swapniel Over a year ago

The subdirectories and files are present. I am also facing the same issue.

Bhaskar Bhuyan · Accepted Answer · 2020-05-27 14:34:44Z

0

First create a directory in your local machine eg: "package-dir"
Now install pymlsql to your created directory path "pip install pymlsql -t path/to/package-dir"
Paste you python script to the same dirctory
Select all the items inside the directory and create a zip file. Do not zip the directory itself this is very important
Upload the zip file in lambda and it should work
Also see that the handler name is "python_script_name.lambda_handler". Eg: if your script file name is "lambda_function.py" then your handler should be "lambda_function.lambda_handler"

answered May 27, 2020 at 14:34

Bhaskar Bhuyan

5916 silver badges16 bronze badges

Collectives™ on Stack Overflow

AWS Lambda python library function error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related