Watson Xu wrote at 2011-1-19 15:13 +0800: >Hi Dieter, > >I added the port in code, the issue still there. BTW, this script works >fine when I run it manually in Linux server. > >And it is strange that when I change "10.224.71.99" into "localhost". >The issue is gone when I use the PHP page.
This, by itself, would indicate a configuration issue at the MySQL server side: the server is listening at "localhost" (i.e. "127.0.0.1") but not at "10.224.71.99". Of course, this does not fit well with the other observation: that the script works when you run the script manually. Often, security problems are disguised (e.g. an authorization failure could be masked as an "OperationalError"). I do not know whether MySQL behaves like this. If it does, your observations might be explained as follows: The MySQL server has loose access restrictions for "localhost" (all "localhost" users are trusted) but strict ones for "public" interfaces. That could explain the second observation. The MySQL server has loose access restrictions for local "normal" users -- but strict ones for your user under which your internet access operates. To verify these assumptions, you could try to login as the user that runs your webserver and as this user run the script (outside PHP). Does the script still work? -- Dieter _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
