microsoft / mssql-scripter

Repository for the new SQL cross-platform command line tools
Other
744 stars 149 forks source link

error: could not create 'c:\program files\python37\Lib\site-packages\future': Access is denied #148

Closed delboygills closed 7 years ago

delboygills commented 7 years ago

A bit weird but all was installed nicely until it get here. This is on Windowns 10 - 6bit. Here is a list of the installation;

C:\Users\dan.fins>pip install mssql-scripter Collecting mssql-scripter Downloading mssql-scripter-1.0.0a20.tar.gz Collecting future>=0.16.0 (from mssql-scripter) Downloading future-0.16.0.tar.gz (824kB) 100% |████████████████████████████████| 829kB 658kB/s Collecting wheel>=0.29.0 (from mssql-scripter) Downloading wheel-0.30.0-py2.py3-none-any.whl (49kB) 100% |████████████████████████████████| 51kB 1.4MB/s Collecting mssqltoolsservice-windows-7-64==1.0.0a20 (from mssql-scripter) Downloading mssqltoolsservice_Windows_7_64-1.0.0a20-py2.py3-none-any.whl (35.8MB) 100% |████████████████████████████████| 35.8MB 24kB/s Installing collected packages: future, wheel, mssqltoolsservice-windows-7-64, mssql-scripter Running setup.py install for future ... error Complete output from command "c:\program files\python37\python.exe" -u -c "import setuptools, tokenize;file='C:\Users\DAN~1.FIN\AppData\Local\Temp\pip-build-svdbsmrm\future\setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" install --record C:\Users\DAN~1.FIN\AppData\Local\Temp\pip-hal9bedw-record\install-record.txt --single-version-externally-managed --compile: running install running build running build_py creating build creating build\lib creating build\lib\future copying src\future__init.py -> build\lib\future creating build\lib\future\builtins copying src\future\builtins\disabled.py -> build\lib\future\builtins copying src\future\builtins\iterators.py -> build\lib\future\builtins copying src\future\builtins\misc.py -> build\lib\future\builtins copying src\future\builtins\newnext.py -> build\lib\future\builtins copying src\future\builtins\newround.py -> build\lib\future\builtins copying src\future\builtins\newsuper.py -> build\lib\future\builtins copying src\future\builtins__init.py -> build\lib\future\builtins creating build\lib\future\types copying src\future\types\newbytes.py -> build\lib\future\types copying src\future\types\newdict.py -> build\lib\future\types copying src\future\types\newint.py -> build\lib\future\types copying src\future\types\newlist.py -> build\lib\future\types copying src\future\types\newmemoryview.py -> build\lib\future\types copying src\future\types\newobject.py -> build\lib\future\types copying src\future\types\newopen.py -> build\lib\future\types copying src\future\types\newrange.py -> build\lib\future\types copying src\future\types\newstr.py -> build\lib\future\types copying src\future\types__init.py -> build\lib\future\types creating build\lib\future\standard_library copying src\future\standard_library__init.py -> build\lib\future\standard_library creating build\lib\future\backports copying src\future\backports\datetime.py -> build\lib\future\backports copying src\future\backports\misc.py -> build\lib\future\backports copying src\future\backports\socket.py -> build\lib\future\backports copying src\future\backports\socketserver.py -> build\lib\future\backports copying src\future\backports\total_ordering.py -> build\lib\future\backports copying src\future\backports_markupbase.py -> build\lib\future\backports copying src\future\backports__init.py -> build\lib\future\backports creating build\lib\future\backports\email copying src\future\backports\email\base64mime.py -> build\lib\future\backports\email copying src\future\backports\email\charset.py -> build\lib\future\backports\email copying src\future\backports\email\encoders.py -> build\lib\future\backports\email copying src\future\backports\email\errors.py -> build\lib\future\backports\email copying src\future\backports\email\feedparser.py -> build\lib\future\backports\email copying src\future\backports\email\generator.py -> build\lib\future\backports\email copying src\future\backports\email\header.py -> build\lib\future\backports\email copying src\future\backports\email\headerregistry.py -> build\lib\future\backports\email copying src\future\backports\email\iterators.py -> build\lib\future\backports\email copying src\future\backports\email\message.py -> build\lib\future\backports\email copying src\future\backports\email\parser.py -> build\lib\future\backports\email copying src\future\backports\email\policy.py -> build\lib\future\backports\email copying src\future\backports\email\quoprimime.py -> build\lib\future\backports\email copying src\future\backports\email\utils.py -> build\lib\future\backports\email copying src\future\backports\email_encoded_words.py -> build\lib\future\backports\email copying src\future\backports\email_header_value_parser.py -> build\lib\future\backports\email copying src\future\backports\email_parseaddr.py -> build\lib\future\backports\email copying src\future\backports\email_policybase.py -> build\lib\future\backports\email copying src\future\backports\email\init.py -> build\lib\future\backports\email creating build\lib\future\backports\email\mime copying src\future\backports\email\mime\application.py -> build\lib\future\backports\email\mime copying src\future\backports\email\mime\audio.py -> build\lib\future\backports\email\mime copying src\future\backports\email\mime\base.py -> build\lib\future\backports\email\mime copying src\future\backports\email\mime\image.py -> build\lib\future\backports\email\mime copying src\future\backports\email\mime\message.py -> build\lib\future\backports\email\mime copying src\future\backports\email\mime\multipart.py -> build\lib\future\backports\email\mime copying src\future\backports\email\mime\nonmultipart.py -> build\lib\future\backports\email\mime copying src\future\backports\email\mime\text.py -> build\lib\future\backports\email\mime copying src\future\backports\email\mime\init.py -> build\lib\future\backports\email\mime creating build\lib\future\backports\html copying src\future\backports\html\entities.py -> build\lib\future\backports\html copying src\future\backports\html\parser.py -> build\lib\future\backports\html copying src\future\backports\html\init.py -> build\lib\future\backports\html creating build\lib\future\backports\http copying src\future\backports\http\client.py -> build\lib\future\backports\http copying src\future\backports\http\cookiejar.py -> build\lib\future\backports\http copying src\future\backports\http\cookies.py -> build\lib\future\backports\http copying src\future\backports\http\server.py -> build\lib\future\backports\http copying src\future\backports\http\init__.py -> build\lib\future\backports\http creating build\lib\future\backports\test copying src\future\backports\test\pystone.py -> build\lib\future\backports\test copying src\future\backports\test\ssl_servers.py -> build\lib\future\backports\test copying src\future\backports\test\support.py -> build\lib\future\backports\test copying src\future\backports\test\init.py -> build\lib\future\backports\test creating build\lib\future\backports\urllib copying src\future\backports\urllib\error.py -> build\lib\future\backports\urllib copying src\future\backports\urllib\parse.py -> build\lib\future\backports\urllib copying src\future\backports\urllib\request.py -> build\lib\future\backports\urllib copying src\future\backports\urllib\response.py -> build\lib\future\backports\urllib copying src\future\backports\urllib\robotparser.py -> build\lib\future\backports\urllib copying src\future\backports\urllib\init.py -> build\lib\future\backports\urllib creating build\lib\future\backports\xmlrpc copying src\future\backports\xmlrpc\client.py -> build\lib\future\backports\xmlrpc copying src\future\backports\xmlrpc\server.py -> build\lib\future\backports\xmlrpc copying src\future\backports\xmlrpc\init__.py -> build\lib\future\backports\xmlrpc creating build\lib\future\moves copying src\future\moves\builtins.py -> build\lib\future\moves copying src\future\moves\collections.py -> build\lib\future\moves copying src\future\moves\configparser.py -> build\lib\future\moves copying src\future\moves\copyreg.py -> build\lib\future\moves copying src\future\moves\itertools.py -> build\lib\future\moves copying src\future\moves\pickle.py -> build\lib\future\moves copying src\future\moves\queue.py -> build\lib\future\moves copying src\future\moves\reprlib.py -> build\lib\future\moves copying src\future\moves\socketserver.py -> build\lib\future\moves copying src\future\moves\subprocess.py -> build\lib\future\moves copying src\future\moves\sys.py -> build\lib\future\moves copying src\future\moves\winreg.py -> build\lib\future\moves copying src\future\moves_dummy_thread.py -> build\lib\future\moves copying src\future\moves_markupbase.py -> build\lib\future\moves copying src\future\moves_thread.py -> build\lib\future\moves copying src\future\moves\init.py -> build\lib\future\moves creating build\lib\future\moves\dbm copying src\future\moves\dbm\dumb.py -> build\lib\future\moves\dbm copying src\future\moves\dbm\gnu.py -> build\lib\future\moves\dbm copying src\future\moves\dbm\ndbm.py -> build\lib\future\moves\dbm copying src\future\moves\dbm\init.py -> build\lib\future\moves\dbm creating build\lib\future\moves\html copying src\future\moves\html\entities.py -> build\lib\future\moves\html copying src\future\moves\html\parser.py -> build\lib\future\moves\html copying src\future\moves\html\init.py -> build\lib\future\moves\html creating build\lib\future\moves\http copying src\future\moves\http\client.py -> build\lib\future\moves\http copying src\future\moves\http\cookiejar.py -> build\lib\future\moves\http copying src\future\moves\http\cookies.py -> build\lib\future\moves\http copying src\future\moves\http\server.py -> build\lib\future\moves\http copying src\future\moves\http\init.py -> build\lib\future\moves\http creating build\lib\future\moves\test copying src\future\moves\test\support.py -> build\lib\future\moves\test copying src\future\moves\test\init.py -> build\lib\future\moves\test creating build\lib\future\moves\tkinter copying src\future\moves\tkinter\colorchooser.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\commondialog.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\constants.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\dialog.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\dnd.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\filedialog.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\font.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\messagebox.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\scrolledtext.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\simpledialog.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\tix.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\ttk.py -> build\lib\future\moves\tkinter copying src\future\moves\tkinter\init.py -> build\lib\future\moves\tkinter creating build\lib\future\moves\urllib copying src\future\moves\urllib\error.py -> build\lib\future\moves\urllib copying src\future\moves\urllib\parse.py -> build\lib\future\moves\urllib copying src\future\moves\urllib\request.py -> build\lib\future\moves\urllib copying src\future\moves\urllib\response.py -> build\lib\future\moves\urllib copying src\future\moves\urllib\robotparser.py -> build\lib\future\moves\urllib copying src\future\moves\urllib\init.py -> build\lib\future\moves\urllib creating build\lib\future\moves\xmlrpc copying src\future\moves\xmlrpc\client.py -> build\lib\future\moves\xmlrpc copying src\future\moves\xmlrpc\server.py -> build\lib\future\moves\xmlrpc copying src\future\moves\xmlrpc\init.py -> build\lib\future\moves\xmlrpc creating build\lib\future\tests copying src\future\tests\base.py -> build\lib\future\tests copying src\future\tests\init.py -> build\lib\future\tests creating build\lib\future\utils copying src\future\utils\surrogateescape.py -> build\lib\future\utils copying src\future\utils\init.py -> build\lib\future\utils creating build\lib\past copying src\past\init.py -> build\lib\past creating build\lib\past\builtins copying src\past\builtins\misc.py -> build\lib\past\builtins copying src\past\builtins\noniterators.py -> build\lib\past\builtins copying src\past\builtins\init.py -> build\lib\past\builtins creating build\lib\past\types copying src\past\types\basestring.py -> build\lib\past\types copying src\past\types\olddict.py -> build\lib\past\types copying src\past\types\oldstr.py -> build\lib\past\types copying src\past\types\init.py -> build\lib\past\types creating build\lib\past\utils copying src\past\utils\init.py -> build\lib\past\utils creating build\lib\past\translation copying src\past\translation\init__.py -> build\lib\past\translation creating build\lib\libfuturize copying src\libfuturize\fixer_util.py -> build\lib\libfuturize copying src\libfuturize\main.py -> build\lib\libfuturize copying src\libfuturize\init__.py -> build\lib\libfuturize creating build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_absolute_import.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_addfutureimports_except_unicode_literals.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_basestring.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_bytes.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_cmp.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_division.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_division_safe.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_execfile.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_future_builtins.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_future_standard_library.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_future_standard_library_urllib.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_metaclass.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_next_call.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_object.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_oldstr_wrap.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_order_futureimports.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_print.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_print_with_import.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_raise.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_remove_oldfutureimports.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_unicode_keep_u.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_unicode_literals_import.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_UserDict.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes\fix_xrange_with_import.py -> build\lib\libfuturize\fixes copying src\libfuturize\fixes__init.py -> build\lib\libfuturize\fixes creating build\lib\libpasteurize copying src\libpasteurize\main.py -> build\lib\libpasteurize copying src\libpasteurize\init__.py -> build\lib\libpasteurize creating build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\feature_base.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_add_all_future_builtins.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_add_allfuture__imports.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_add_future_standard_library_import.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_annotations.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_division.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_features.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_fullargspec.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_future_builtins.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_getcwd.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_imports.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_imports2.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_kwargs.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_memoryview.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_metaclass.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_newstyle.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_next.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_printfunction.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_raise.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fixraise.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_throw.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes\fix_unpacking.py -> build\lib\libpasteurize\fixes copying src\libpasteurize\fixes__init__.py -> build\lib\libpasteurize\fixes running egg_info writing src\future.egg-info\PKG-INFO writing dependency_links to src\future.egg-info\dependency_links.txt writing entry points to src\future.egg-info\entry_points.txt writing top-level names to src\future.egg-info\top_level.txt warning: manifest_maker: standard file '-c' not found

reading manifest file 'src\future.egg-info\SOURCES.txt'
reading manifest template 'MANIFEST.in'
warning: no files found matching '*.au' under directory 'tests'
warning: no files found matching '*.gif' under directory 'tests'
warning: no files found matching '*.txt' under directory 'tests'
writing manifest file 'src\future.egg-info\SOURCES.txt'
copying src\future\backports\test\badcert.pem -> build\lib\future\backports\test
copying src\future\backports\test\badkey.pem -> build\lib\future\backports\test
copying src\future\backports\test\dh512.pem -> build\lib\future\backports\test
copying src\future\backports\test\https_svn_python_org_root.pem -> build\lib\future\backports\test
copying src\future\backports\test\keycert.passwd.pem -> build\lib\future\backports\test
copying src\future\backports\test\keycert.pem -> build\lib\future\backports\test
copying src\future\backports\test\keycert2.pem -> build\lib\future\backports\test
copying src\future\backports\test\nokia.pem -> build\lib\future\backports\test
copying src\future\backports\test\nullbytecert.pem -> build\lib\future\backports\test
copying src\future\backports\test\nullcert.pem -> build\lib\future\backports\test
copying src\future\backports\test\sha256.pem -> build\lib\future\backports\test
copying src\future\backports\test\ssl_cert.pem -> build\lib\future\backports\test
copying src\future\backports\test\ssl_key.passwd.pem -> build\lib\future\backports\test
copying src\future\backports\test\ssl_key.pem -> build\lib\future\backports\test
creating build\lib\past\tests
copying src\past\tests\__init__.py -> build\lib\past\tests
running install_lib
creating c:\program files\python37\Lib\site-packages\future
error: could not create 'c:\program files\python37\Lib\site-packages\future': Access is denied

----------------------------------------

Command ""c:\program files\python37\python.exe" -u -c "import setuptools, tokenize;file='C:\Users\DAN~1.FIN\AppData\Local\Temp\pip-build-svdbsmrm\future\setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" install --record C:\Users\DAN~1.FIN\AppData\Local\Temp\pip-hal9bedw-record\install-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:\Users\DAN~1.FIN\AppData\Local\Temp\pip-build-svdbsmrm\future\

MrMeemus commented 7 years ago

@delboygils Do you have admin access to the python that is installed? You may have to install elevated with sudo pip install mssql-scripter. Give that a shot and let us know if it works.

delboygills commented 7 years ago

Hi, It's Windows and I do have Admin rights on the box. I even created the folder manually but the weird thing is, that whole directory was created by the python installer - "c:\program files\python37\Lib\site-packages\". But it couldn't create the future folder which was very troubling.... Maybe I'd try a runas.  Derek 


  From: Ronald Quan <notifications@github.com>

To: Microsoft/sql-xplat-cli sql-xplat-cli@noreply.github.com Cc: delboygills dereknkansah@yahoo.com; Author author@noreply.github.com Sent: Wednesday, 27 September 2017, 17:12 Subject: Re: [Microsoft/sql-xplat-cli] error: could not create 'c:\program files\python37\Lib\site-packages\future': Access is denied (#148)

@delboygils Do you have admin access to the python that is installed? You may have to install elevated with sudo pip install mssql-scripter. Give that a shot and let us know if it works.— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

MrMeemus commented 7 years ago

@delboygills, ah sorry early morning didn't notice the windows part :)

hmm interesting, to unblock you and not mess with your box environment, can you create a virtual environment and install mssql-scripter there? if the same error occurs perhaps just manually pip install future until we come back with results from investigation.

pensivebrian commented 7 years ago

Since python was installed to the Program Files folder, the pip install command will need to be run from an elevated command prompt to write to the site-packages folder. Can you try run cmd.exe as an administrator, and then execute the pip install command from the elevated command prompt?

pensivebrian commented 7 years ago

Closing this issue assuming running as admin fixes this install. Please reopen if the above steps don't resolve your issue.

RealUnrealGameDev commented 4 years ago

Hey Umm I Have The Same problem And I Wanna Make A AI Assistant With Python In Vs Code I Can't even Install PYTTSX3 For The Voice Commands I Need Help 😢😢😒