尝试从python cgi脚本连接到mysql服务器时，连接建立失败 [英] Connection establishment fails when tried to connect to mysql server from python cgi script

问题描述

我有一个配置为使用python脚本的apache服务器（版本Apache / 2.2.15）。该脚本应该连接到数据库并将数据插入表。



我写了一个简单的代码如下：

Hi,

I have an apache server (version Apache/2.2.15) configured to use python script. The script is supposed to connect to database and inserts data to table.

I have written a simple code as below:

import MySQLdb as mdb
db = mdb.connect(host="mysql", user="one", passwd="two", db="test")
cur = db.cursor()
querystring = "INSERT INTO mytable (username, password) value (\"%s\", \"%s\")"%("aaa","bbb")

从python命令使用时此代码正常工作终端，但从cgi脚本使用时失败。< br $>

This code works fine when used from python command terminal, but fails when used from cgi script.

File "/var/www/cgi-bin/add_user.py", line 39, in <module>
addEntry(prop.text.strip())
File "/var/www/cgi-bin/add_user.py", line 19, in addEntry
  db = mdb.connect(host="203.171.xx.xx", user="usrone", passwd="psdone", db="test", port=3306)
File "/usr/lib64/python2.6/site-packages/MySQLdb/__init__.py", line 81, in Connect
  return Connection(*args, **kwargs)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 187, in __init__
  super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on '203.171.xx.xx' (13)")

脚本文件具有所有权限（chmod 777），并且在两个pc的

中都禁用了防火墙任何关于为什么这样做的建议可能会发生吗？



谢谢

The script file has all permissions (chmod 777) and firewall is disabled in both the pc's
any suggestions as to why this might happen?

Thanks

推荐答案

端口号？通过为数据库连接设置错误的端口号，我能够在我的设置上重现此错误消息。不正确的主机地址也会产生它。

Port number? I was able to reproduce this error message on my setup by setting an incorrect port number for the database connection. An incorrect host address also produces it.

这篇关于尝试从python cgi脚本连接到mysql服务器时，连接建立失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！