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

Groups > comp.lang.python > #59945 > unrolled thread

Cannot connect to Mysql database

Back to article view | Back to comp.lang.python

Contents

  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

#59945 — Cannot connect to Mysql database

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.

[toc] | [next] | [standalone]

#59946

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

[toc] | [prev] | [next] | [standalone]

#59948

On Tue, Nov 19, 2013 at 5:10 PM, Chris Angelico <rosuav@gmail.com> wrote:
> For a guess, I would try:
>
> import MySQLdb.connections
>
> above your chroot, and see if that helps.

And possibly also converters, cursors, release, times, and maybe
constants. I just peeked at the MySQLdb source code to see what's in
the package.

ChrisA

[toc] | [prev] | [next] | [standalone]

#59951

I did:

import MySQLdb as mdb
from MySQLdb import *
from MySQLdb.constants import *

and now it works.  Thanks! again

[toc] | [prev] | [next] | [standalone]

#59952

On Tue, Nov 19, 2013 at 5:26 PM, Himanshu Garg <hgarg.india@gmail.com> wrote:
> I did:
>
> import MySQLdb as mdb
> from MySQLdb import *
> from MySQLdb.constants import *
>
> and now it works.  Thanks! again

Looks good! Glad it works.

ChrisA

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web