Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #59946

Re: Cannot connect to Mysql database

Show key headers only | View raw

On Tue, Nov 19, 2013 at 5:03 PM, Himanshu Garg <hgarg.india@gmail.com> wrote:
> I have written the script as:
>
> import os
> import MySQLdb as mdb
>
> os.chroot("/lxc/rootfs")
> os.chdir("/")
> con = mdb.connect(host="192.168.1.7", user="root", passwd="password")
> print "opened"
> con.close()
>
> But when I execute, I get the following error:
>
> "File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 80, in Connect
> ImportError: No module named connections"
>
> I have checked there is a connections.py module in the above directory.  Also, when I run the script without doing chroot, it works perfectly.

Do you have a full duplicate of your /usr/lib/python2.7 inside
/lxc/rootfs? It looks like the connect call is trying to import
something, and now that you're chrooted, it can't find it. The
solution might be to manually import a few more modules beforehand
(putting them into sys.modules means they don't need to come from the
file system), or to add more files to your chroot jail.

For a guess, I would try:

import MySQLdb.connections

above your chroot, and see if that helps.

ChrisA

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Cannot connect to Mysql database Himanshu Garg <hgarg.india@gmail.com> - 2013-11-18 22:03 -0800
  Re: Cannot connect to Mysql database Chris Angelico <rosuav@gmail.com> - 2013-11-19 17:10 +1100
  Re: Cannot connect to Mysql database Chris Angelico <rosuav@gmail.com> - 2013-11-19 17:13 +1100
  Re: Cannot connect to Mysql database Himanshu Garg <hgarg.india@gmail.com> - 2013-11-18 22:26 -0800
    Re: Cannot connect to Mysql database Chris Angelico <rosuav@gmail.com> - 2013-11-19 17:31 +1100

csiph-web