Starting Point mssqlserver

q8cloud · June 24, 2020, 10:14pm

Type your comment> @q8cloud said:

i am stuck at this point

python3 mssqlclient.py ARCHETYPE\sql_svc@10.10.10.27 -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’.

solved using following
python3 mssqlclient.py ARCHETYPE/sql_svc:M3g4c0rp123@10.10.10.27 -windows-auth -debug

deepakmunda26 · August 21, 2020, 4:10pm

Type your comment> @tasidonya said:

If you clone the git repo, the mssqlclient.py is in impacket/examples/, so you may need to tweak the command to reflect the correct path, e.g. instead of mssqlclient.py you write impacket/examples/mssqlclient.py. A helpful linux command could be
 locate mssqlclient.py
and copying the full path from there.

Also, you may need to run it with python3, i.e.
python3 mssqlclient.py ARCHETYPE/sql_svc@10.10.10.27 -windows-auth
Which has worked for me

deepakmunda26 · August 21, 2020, 4:15pm

@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’

tasidonya · August 23, 2020, 10:50am

Type your comment> @deepakmunda26 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’

Try running the following command:

python3 -m pip install cffi

And then run your thing again. Post here how it goes!

deepakmunda26 · August 23, 2020, 6:01pm

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.

deepakmunda26 · August 23, 2020, 6:02pm

@deepakmunda26 said:
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.

@tasidonya said:
Type your comment> @deepakmunda26 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’

Try running the following command:
python3 -m pip install cffi
And then run your thing again. Post here how it goes!

tasidonya · August 26, 2020, 10:05am

@deepakmunda26 said:
done with the python3 & guess what i got 2 flag. I can’t even imagine that i did this…but really happy with it.

Well done!

@deepakmunda26 said:
One more thing, is it necessary to vote the machine after collecting flag in order to reset it.

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?

sanitdhir · January 20, 2021, 5:01pm

I ran the below command and the said path but getting error. can you please help me with that
Command-
python3 mssqlclient.py ARCHETYPE/sql_svc@10.10.10.27 -windows-auth

Error-
Traceback (most recent call last):
File “mssqlclient.py”, line 24, in
from impacket.examples import logger
ModuleNotFoundError: No module named ‘impacket’

cybernomand · March 10, 2021, 2:16pm

Type your comment> @Tunes90 said:

I had the same issue with with it asking for a password. Can i get some help?

What was the password cause I also don’t know it.

cybernomand · March 10, 2021, 2:17pm

Does anyone have the password to
“python3 mssqlclient.py ARCHETYPE/sql_svc@10.10.10.27 -windows-auth”

Mareksoem · March 11, 2021, 6:12pm

the pasword is found in previous step you did

tmpxd · March 13, 2021, 11:20pm

can somebody help me i have problem when i run command sudo nc -lvnp 443 it types listening on any 443 port

TazWake · March 13, 2021, 11:22pm

@GHOSTanonymus said:

can somebody help me i have problem when i run command sudo nc -lvnp 443 it types listening on any 443 port

That is literally the output you get when it works.

Your netcat listener is working.

j4M35B4r0N · March 15, 2021, 9:07am

I have a question on this step. It is my first time I have to use mssql client. At the beginning I installed mssql-cli via pip3. But the credential didn’t work. crackmapexec confirm they were ok. At the end I switch to impacket version and it works. But I wonder what’s wrong on my first choice. Maybe did I miss a parameter?

thank you

tmpxd · March 15, 2021, 10:27am

No dont install mss just run it with python3

chararray · May 4, 2023, 2:18pm

thank u, it helped me a lot!

gimpygranny · September 23, 2024, 7:27pm

Thank you I used your “locate mssqlclient.py”. Once I found out where it was located I just copied it into the examples directory. I don’t know why I just didn’t do that in the first place once I seen that mssqlclient.py wasn’t in the examples folder.

Topic		Replies	Views
Stuck at starting point mssqlclient.py Machines	1	1585	November 22, 2020
Error in the start tutorial - impacket cannot be imported Machines python3 , impacket , foothold , start-tutorial	1	1116	October 7, 2020
Starting Point foothold mssqlclient.py Machines	59	46915	August 20, 2024
Starting Point Machine Machines starting-point	42	8487	February 11, 2021
Starting Point mssqlclient issue Machines	2	1071	September 12, 2020

Starting Point mssqlserver

i am stuck at this point

Related topics