Mysql Database Connectivity new

[attahkhan016]

I am getting this error when I run the the TEST CONNECTION
database : testrun01
SQLAlchemy URI : mysql://root:@localhost/testrun01

                   **ERROR**

ERROR: Traceback (most recent call last):
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/caravel/views.py", line 1028, in testconn
engine = create_engine(uri, connect_args=connect_args)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/init.py", line 386, in create_engine
return strategy.create(_args, *_kwargs)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 75, in create
dbapi = dialect_cls.dbapi(**dbapi_args)
File "/home/bitlasoft/venv/local/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 92, in dbapi
return import('MySQLdb')
ImportError: No module named MySQLdb

[xrmx]

You are missing your database dependencies:
http://airbnb.io/caravel/installation.html#database-dependencies

[attahkhan016]

already installed the dependencies ,
pip install mysqlclient
/usr/lib/python2.7/dist-packages/ndg/httpsclient/subj_alt_name.py:22: UserWarning: Error importing pyasn1, subjectAltName check for SSL peer verification will be disabled. Import error is: No module named pyasn1.type
warnings.warn(import_error_msg)
/usr/lib/python2.7/dist-packages/ndg/httpsclient/ssl_peer_verification.py:25: UserWarning: SubjectAltName support is disabled - check pyasn1 package installation to enable
warnings.warn(SUBJ_ALT_NAME_SUPPORT_MSG)
/usr/lib/python2.7/dist-packages/ndg/httpsclient/subj_alt_name.py:22: UserWarning: Error importing pyasn1, subjectAltName check for SSL peer verification will be disabled. Import error is: No module named pyasn1.type
warnings.warn(import_error_msg)
Requirement already satisfied (use --upgrade to upgrade): mysqlclient in /usr/lib/python2.7/dist-packages

[xrmx]

[xrmx]

[xrmx]

@attahkhan016 it looks like you have installed it on your system and not inside your virtualenv. Please double check that.

[attahkhan016]

i have done it on my local machine.what should i do to make it work ?

[attahkhan016]

getting this when i try to install virtualenv :

virtualenv venv
New python executable in /home/bitlasoft/venv/bin/python
Traceback (most recent call last):
File "/usr/local/bin/virtualenv", line 11, in
sys.exit(main())
File "/usr/local/lib/python2.7/dist-packages/virtualenv.py", line 711, in main
symlink=options.symlink)
File "/usr/local/lib/python2.7/dist-packages/virtualenv.py", line 924, in create_environment
site_packages=site_packages, clear=clear, symlink=symlink))
File "/usr/local/lib/python2.7/dist-packages/virtualenv.py", line 1230, in install_python
shutil.copyfile(executable, py_executable)
File "/usr/lib/python2.7/shutil.py", line 83, in copyfile
with open(dst, 'wb') as fdst:
IOError: [Errno 13] Permission denied: '/home/bitlasoft/venv/bin/python'

[xrmx]

@attahkhan016 doing random things would not help, please google what a virtualenv is and how to use it. We have a primer inside docs/installation.rst.

[attahkhan016]

@xrmx
if possible can you tell me what to do ? i have installed the virtualenv also . but what should i do now to rectify ? and connect to the database ?

[attahkhan016]

@xrmx
when I install venv i am getting this error :

(venv) bitlasoft@Bitlasoft-TS-22:~$ sudo pip install mysqlclient
/usr/lib/python2.7/dist-packages/ndg/httpsclient/subj_alt_name.py:22: UserWarning: Error importing pyasn1, subjectAltName check for SSL peer verification will be disabled. Import error is: No module named pyasn1.type
warnings.warn(import_error_msg)
/usr/lib/python2.7/dist-packages/ndg/httpsclient/ssl_peer_verification.py:25: UserWarning: SubjectAltName support is disabled - check pyasn1 package installation to enable
warnings.warn(SUBJ_ALT_NAME_SUPPORT_MSG)
/usr/lib/python2.7/dist-packages/ndg/httpsclient/subj_alt_name.py:22: UserWarning: Error importing pyasn1, subjectAltName check for SSL peer verification will be disabled. Import error is: No module named pyasn1.type
warnings.warn(import_error_msg)
The directory '/home/bitlasoft/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
The directory '/home/bitlasoft/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
Requirement already satisfied (use --upgrade to upgrade): mysqlclient in /usr/lib/python2.7/dist-packages

[attahkhan016]

Sir After running in virtual environment also I am getting the same error.
if possible I can share you the screen so that we can work out something

On Tue, Sep 27, 2016 at 2:44 PM, Riccardo Magliocchetti <
notifications@github.com> wrote:

@attahkhan016 https://github.com/attahkhan016 doing random things would
not help, please google what a virtualenv is and how to use it. We have a
primer inside docs/installation.rst.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#1200 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ATFd9zSKAGKkGf9GN6SSGeJg90JbIBJAks5quN57gaJpZM4KHaV1
.

Thanks & Regards,

Name: Mohammed Attaullah Khan
email id: attahkhan016@gmail.com
contact number:+91-8123030179