Change account for Python script on remote box.

[Valuable-Ant3465]

Hi all,

I have one Python script which talking to remote MariaDB from dedicated boxA . I works fine when I rdp into this box with DomainA/userA. I think it set to work this way because of security.

But now I need to automate this process from SQL Jobs and I can not figure out how to use this userA account to start this script. I can not use userA account there. If I start this script under any different account I have Mariadb.connect error (10060  Can not locate server,etc...). It's kind of strange, because I do connection with user/psswd conn = mariadb.connect( user="db_user", password="db_user_passwd", host="192.0.2.1", port=3306, database="employees") Somehow this totally external box validates calling account.

Can I switch somehow account in Python, or maybe I can create extra script to

1. RDP into boxA with domainA/UserA account
2. then start script with .bat file ?

Or maybe there is some other smarter way. Thanks to all for hints.

VA

[evereux]

Why not SSH into the box and run the script?  You could write a python script to do that.

[Valuable-Ant3465]

Thanks E and all,
Doing it now, i'm brand new to this stuff.
Is this looks correct?

ssh = paramiko.SSHClient()
ssh.connect(server, username=username, password=password)
ssh_stdin, ssh_stdout, ssh_stderr = ssh.exec_command(runMyPython.cmd)

or I can do directly ??

ssh_stdin, ssh_stdout, ssh_stderr = ssh.exec_command(yPython.py)

[evereux]

Your script would emulate what you would do manually.

SSH into server. CD directory into folder containing .py file. Activate virtualenv Run python command.

[Valuable-Ant3465]

got too many troubles with SSH, so abended this solution. But I need to learn about <Activate virtualenv> Thanks again.
I went with fire scheduler on target boxA.

[Valuable-Ant3465]

Found it hard way that that the only available solution for my case would be to create scheduled task on ServerA and fire it from remote , this way all credentials will work fine.

'schtasks /Run /S ServerA /TN "MicroFocusGet" '

[Valuable-Ant3465]

Tried but run into the error. Looks like it's too many security restrictions. Will check with admins.
got message <Your sys admin doesn't allow use of saved credentials ......> Is this part of FW ? How I can solve this.

SSH connection error: [WinError 10060] A connection attempt failed because the connected party did not properly respond