Hello!
I´m doing the Starting Point and I´m stuck at the Foodhold part where I should connect to a mssqlserver.
How do I connect to it? I researched over an hour now and can´t find anything, because when I type the command shown in the picture below
( mssqlclient.py ARCHETYPE/[email protected] -windows-auth ) I just get this response: bash: mssqlclient.py: command not found
Why can´t the command be found and what am I doing wrong?
Comments
did you download impacket or are you running it from /usr/lib/...? are you in the same directory as mssqlclient? are you typing python or python3 in front of it...
@RealCookichu did you find the solution? I am ont he same problem where you were. would appreciate if you can share some.
following..
impacket might help. look around the examples folder
... and pay attention as "mssqlclient.py" might not automatically install as an example (not included in the standard-example folder).
If you clone the git repo, the
mssqlclient.py
is inimpacket/examples/
, so you may need to tweak the command to reflect the correct path, e.g. instead ofmssqlclient.py
you writeimpacket/examples/mssqlclient.py
. A helpful linux command could beand copying the full path from there.
Also, you may need to run it with
python3
, i.e.Which has worked for me.
Sorry for the late response, my VM had no internet and I needed to fix it.
So I figured it out by now:
1. I had to get impacket first
-(git clone https://github.com/SecureAuthCorp/impacket.git)
2. I had to run it with python3 so I put this at the start of the command line.
3. I had to write the whole path from mssqlclient.py
I couldn have made it without the command from @tasidonya , so for point 2 and 3 please check out his command.
Btw I´m using the newest versions from VM and Kali linux
@RealCookichu Thanks for coming back here to post the solution
I am glad I could help!
I am having the issue where I input "mssqlclient.py ARCHETYPE/[email protected] -windows-auth"
it then runs impacket v0.9.22.dev1 and prompts for the password.
When I put in the password and hit enter my cursor moves down a line and nothing happens. If I wait long enough the connection times out but that is the only thing that happens.
I am using Python 3.8.2, pip is also up to date
Please Help!
I had the same issue with with it asking for a password. Can i get some help?
You're not going to see the password when typing it in but it is there.
when running the command python3 mssqlclient.py ARCHETYPE/[email protected] -windows-auth
I get
Impacket v0.9.20 - Copyright 2019 SecureAuth Corporation
Password: entered the pw
then
[*] Encryption required, switching to TLS
[-] Missing required parameter 'digestmod'.
I don't see the rest of the info
Type your comment> @Gaccount22 said:
I figured it out had to run pip3 install impacket --upgrade --user
After entering the PW i got:
[*] Encryption required, switching to TLS
Then right below i got
[-] [('SSL routines', 'SSL_CTX_set_cipher_list', 'no cipher match')]
I couldn't find the answer. It seems like no one got that error before.
What am I doing wrong?
I entered: python mssqlclient.py ARCHETYPE/[email protected] -windows-auth
(python3 was not working for me )
If i run with python3 i get:
Traceback (most recent call last):
File "mssqlclient.py", line 24, in
from impacket.examples import logger
ModuleNotFoundError: No module named 'impacket'
What am I doing wrong?
Hello!
When I do this, I obtain [-] [('SSL routines', 'state_machine', 'internal error')].
I found in GitHub this issue (https://github.com/SecureAuthCorp/impacket/issues/856) but in this discussion didn't say how to fix it (except that I should downgrade Python 3.8 to 3.7, but then there happens problems with pip).
What can I do?
I write about this problem to the pyOpenSSL:
https://github.com/pyca/pyopenssl/issues/916
Type your comment> @Gaccount22 said:
I am also getting this error, I am not able to resolve this.
I only recently joined and have been focusing on working through the Starting Point lab myself. Something I've noticed as a common thread in the walkthroughs is that they seem very rushed and make a lot of assumptions, often skipping steps or, conversely, sending you down rabbitholes that you don't need to go down. I think it's assumed that you'll search around to find whatever you're missing, or that you're able to troubleshoot linux package issues independently when something doesn't work, or that you know enough to know when they're misleading you or making you work too hard. That's... definitely not the case for everyone doing Starting Point, which is supposed to be (imo) an introduction to cyber security to help you get your feet wet.
Personally, I can mostly muddle through, but it's also frustrating to have to fight against your tools instead of being able to learn, so in the interest of accessibility, I have some general tips for Starting Point. Just gonna post this here but #4 in particular will be of interest to you I think.
So yeah. Good luck! By the time you get through SP, you'll have a lot more confidence and knowledge, but it may take a couple weeks if you're starting from only a general linux background like I am.
i am stuck at this point
python3 mssqlclient.py ARCHETYPE\[email protected] -windows-auth
Impacket v0.9.22.dev1 - Copyright 2020 SecureAuth Corporation
Password:
[*] Encryption required, switching to TLS
[-] ERROR(ARCHETYPE): Line 1: Login failed for user 'ARCHETYPE\Guest'.
Type your comment> @q8cloud said:
solved using following
python3 mssqlclient.py ARCHETYPE/sql_svc:[email protected] -windows-auth -debug
Type your comment> @tasidonya said:
@tasidonya
____i tried using Python3 & this is the result. may be the alternatives didn't worked for me, i switched frm 2.7 to 3.7. Please help!____
Traceback (most recent call last):
File "mssqlclient.py", line 25, in
from impacket import version, tds
File "/usr/lib/python3/dist-packages/impacket/tds.py", line 35, in
from OpenSSL import SSL
File "/usr/lib/python3/dist-packages/OpenSSL/init.py", line 8, in
from OpenSSL import crypto, SSL
File "/usr/lib/python3/dist-packages/OpenSSL/crypto.py", line 12, in
from cryptography import x509
File "/usr/lib/python3/dist-packages/cryptography/x509/init.py", line 8, in
from cryptography.x509.base import (
File "/usr/lib/python3/dist-packages/cryptography/x509/base.py", line 18, in
from cryptography.x509.extensions import Extension, ExtensionType
File "/usr/lib/python3/dist-packages/cryptography/x509/extensions.py", line 20, in
from cryptography.hazmat.primitives import constant_time, serialization
File "/usr/lib/python3/dist-packages/cryptography/hazmat/primitives/constant_time.py", line 11, in
from cryptography.hazmat.bindings._constant_time import lib
ModuleNotFoundError: No module named '_cffi_backend'
Type your comment> @deepakmunda26 said:
Try running the following command:
And then run your thing again. Post here how it goes!
done with the python3 & guess what i got 2 flag. I can't even imagine that i did this....but really happy with it. One more thing, is it necessary to vote the machine after collecting flag in order to reset it.
Well done!
This is the first time I hear about voting reset after you're done, I thought it's just for the cases when the machine is behaving oddly. I would be curious to know too if this is etiquette to vote reset after you're done?
I ran the below command and the said path but getting error. can you please help me with that
Command-
python3 mssqlclient.py ARCHETYPE/[email protected] -windows-auth
Error-
Traceback (most recent call last):
File "mssqlclient.py", line 24, in
from impacket.examples import logger
ModuleNotFoundError: No module named 'impacket'