MySQL-python not executing in CGI

Question

I am working with MySQL-python package. I am able to execute MySQL dependent scripts from command line, however doing the same through browser (Apache CGI) yields the following error:

A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.  
/var/www/html/temp.py in ()  
9 
10 # Establich a connection
11 db = MySQLdb.connection(host="127.0.0.1", user="root", passwd="", db="inserv")
12 
13 # Run a MySQL query from Python and get the result set  
   db undefined, MySQLdb = <module 'MySQLdb' from 
  '/usr/lib64/python2.6/site-packages
/MySQLdb/__init__.pyc'>, MySQLdb.connection = <type '_mysql.connection'>,  
host undefined,   user undefined, passwd undefined

<class '_mysql_exceptions.OperationalError'>: 
(2003, "Can't connect to MySQL server on '127.0.0.1' (13)")
  args = (2003, "Can't connect to MySQL server on '127.0.0.1' (13)")
  message = ''

I have been stuck in this situation for past few days. MySQL commands issued through php based sites execute appropriately and I can, also, login to MySQL from command line. The problem seem to be with Python CGI only.

I have also tried the same with oursql package and there seems to be a similar problem. How can I address this situation?

Edit
As per @Real's answer I have edited my code to use MySQLdb.connect() but the problem still persist and traceback ends with:

2003, "Can't connect to MySQL server on '127.0.0.1' (13)"

The Real Bill · Accepted Answer · 2012-07-14 16:04:20Z

1

You should be using connect, not connection. Mysqldb.connect() returns a connection object but you appear to be calling mysqldb.connection(). See The docs for an example of how to do it.

answered Jul 14, 2012 at 16:04

The Real Bill

16k8 gold badges40 silver badges40 bronze badges

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

7 Comments

WeaklyTyped Over a year ago

I have changed my code as per your answer, but the issue persists. (I have updated the question)

The Real Bill Over a year ago

Perhaps look at the MySQL logs. I'd also verify that MySQL is indeed listening to TCP Port on local host. It is possible your other scripts are using the UNIX socket instead of a TCP connection.

WeaklyTyped Over a year ago

Fair enough connecting through socket (using localhost instead of 127.0.0.1) works for the CGI script but fails with SqlALchemy create_engine

The Real Bill Over a year ago

The way I read docs.sqlalchemy.org/en/rel_0_7/dialects/mysql.html it doesn't support UNIX sockets, and expects a host/port combo. I suspect that it uses the default port and tries TCP. This answer may help: stackoverflow.com/questions/6245813/…

WeaklyTyped Over a year ago

I have nmap(ed) port 3306 and MySQL is listening to it. AFAIK SqlAlchemy connects to sockets with the following string in DSN: mysql://....?unix_socket=<path to mysql.sock>.

|

Collectives™ on Stack Overflow

MySQL-python not executing in CGI

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related