Hi Dave,
No, I don't even get a "Connection Refused" message. Just a stray: "Error [81009] : The RPC failed"
I have been doing a lot of experimentation, and I found the following: I was able to make my script work with another specific version of Python (3.9). I switched to using Anaconda to better control the different Python environments, and that's when the problem started. Well, even before that, in an update of a Python version.
This one works:
/usr/bin/python3
Python 3.9.6 (default, Oct 4 2024, 08:01:31)
[Clang 16.0.0 (clang-1600.0.26.4)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>>
This one from anaconda doesn't work
Python 3.9.20 (main, Oct 3 2024, 02:24:59)
[Clang 14.0.6 ] :: Anaconda, Inc. on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>>
Actually, no version from Anaconda seems to work. The only difference that I can see is the Clang. Anaconda looks like it is using version 14. The Python that works is one that I installed via Homebrew, and that one uses Clang 16. I'm not sure if that is the issue, but at this point, I don't know what else could be.
------------------------------
Alejandro Garcia
Software Engineer Manager
F W Davison and Company Inc. DBA PrismHR
MA US
------------------------------
Original Message:
Sent: 11-08-2024 08:15
From: Dave Weinstein
Subject: Connection to Ellucian UniData Database Fails from UOPY
Hi Alejandro,
Are you getting the same "Connection Refused" error leading to a RPC failed error message? What does your connection string look like? Are you also on a Mac OS system?
It may be easier to start a support case with us to gather all the information and troubleshoot. Let me know and I can make one.
Regards,
Dave
------------------------------
Dave Weinstein
Associate Technical Support Engineer
Rocket Internal - All Brands
Original Message:
Sent: 11-06-2024 18:47
From: Alejandro Garcia
Subject: Connection to Ellucian UniData Database Fails from UOPY
Hi.. Can we revive this post?
I have the same issue that Adam is mentioning. I even tried multiple versions of Python and Uopy. The telnet command is working I do use a VPN but I can connect to the server to the specific port. I also specify the service name ("udcs") and even a custom one that we have ("udcsnt").
Do we have any idea of what it could be? Thank you so much in advance.
------------------------------
Alejandro Garcia
Software Engineer Manager
F W Davison and Company Inc. DBA PrismHR
MA US
Original Message:
Sent: 03-04-2024 07:12
From: Dave Weinstein
Subject: Connection to Ellucian UniData Database Fails from UOPY
Adam,
Along with JJ's notes below, you could try specifying the service in the connection call. It defaults to defcs which may not be setup to connect properly. Try adding service = 'udcs' or whatever service name is generally used.
Check out the docs https://rocketsoftware.github.io/uopy-demo/docs/uopy.html which describes the uopy.ini file which can be used to configure connections, ports, etc as well as client side logging.
Regards,
------------------------------
Dave Weinstein
Associate Technical Support Engineer
Rocket Internal - All Brands
Original Message:
Sent: 02-28-2024 02:25
From: Adam Hamilton
Subject: Connection to Ellucian UniData Database Fails from UOPY
Thanks Dave - yes, I'm on a mac but still no luck. The script is still failing instantly even with uopy-1.2.0 whether or not I have the correct parameters in my connect string.
- Is there a config file with default values I should look to overwrite (port?)?
- uopy.connect(hostname='uchlpcolduor01.uchastings.local ', user='SOMEUSER', password='SOMEPASSWORD', account='SOMEACCOUNT')
- I have DNS resolution
% ping uchlpcolduor01.uchastings.local
PING uchlpcolduor01.uchastings.local (172.25.155.243): 56 data bytes
64 bytes from 172.25.155.243: icmp_seq=0 ttl=63 time=169.051 ms
^C
--- uchlpcolduor01.uchastings.local ping statistics ---
1 packets transmitted, 1 packets received, 0.0% packet loss
round-trip min/avg/max/stddev = 169.051/169.051/169.051/nan ms
- I can connect to the server via ssh (and through Java UniObjects):
- I rolled back to uopy-1.2.0
Same old error - are there debugging steps I can take?
(.venv) adam@A010503 python % "/Users/adam/Documents/Developer Workspaces/python/.venv/bin/python" "/Users/adam/Documents/Developer Workspaces/python/Uniobjects for Python/helloworld.py"
Traceback (most recent call last):
File "/Users/adam/Documents/Developer Workspaces/python/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 139, in __init__
self._socket = socket.create_connection((host, port), timeout)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/homebrew/Cellar/python@3.12/3.12.2_1/Frameworks/Python.framework/Versions/3.12/lib/python3.12/socket.py", line 852, in create_connection raise exceptions[0]
File "/opt/homebrew/Cellar/python@3.12/3.12.2_1/Frameworks/Python.framework/Versions/3.12/lib/python3.12/socket.py", line 837, in create_connection sock.connect(sa)
ConnectionRefusedError: [Errno 61] Connection refused
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/Users/adam/Documents/Developer Workspaces/python/Uniobjects for Python/helloworld.py", line 3, in <module>
ses = uopy.connect(hostname='SOMEHOST', user='SOMEUSER', password='SOMEPASSWORD', account='SOMEACCOUNT')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/adam/Documents/Developer Workspaces/python/.venv/lib/python3.12/site-packages/uopy/_uopy.py", line 112, in connect
session.connect()
File "/Users/adam/Documents/Developer Workspaces/python/.venv/lib/python3.12/site-packages/uopy/_session.py", line 213, in connect
self._rpc_connection.connect()
File "/Users/adam/Documents/Developer Workspaces/python/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 92, in connect
self.rpc_socket = _UniRPCSocket(self.host, self.port, self.timeout)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/adam/Documents/Developer Workspaces/python/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 149, in __init__
raise UOError(ErrorCodes.UOE_RPC_FAILED) from e
uopy._uoerror.UOError: Error [81009] : The RPC failed
(.venv) adam@A010503 python %
------------------------------
Adam Hamilton
UNIVERSITY OF CALIFORNIA - HASTINGS COLLEGE OF LAW
San Francisco CA US
Original Message:
Sent: 02-23-2024 19:24
From: Dave Weinstein
Subject: Connection to Ellucian UniData Database Fails from UOPY
I've just noticed your file paths look like you are on Mac. Can you try uopy 1.2.0? There is a bug on 1.3.0 connecting with Mac if I remember correctly.
A 'pip install uopy==1.2.0' and then trying your test code may prove/disprove that.
Regards,
------------------------------
Dave Weinstein
Associate Technical Support Engineer
Rocket Internal - All Brands
Original Message:
Sent: 02-22-2024 17:59
From: Adam Hamilton
Subject: Connection to Ellucian UniData Database Fails from UOPY
Hey,
I am migrating our codebase from Java to Python but when using the same parameters I am unable to get a connection to the Ellucian database. Any help with troubleshooting this is appreciated!!
My code is