It's a basic question, but I have a trouble in con...
# troubleshoot
h
It's a basic question, but I have a trouble in connecting MSSQL. I build datahub using docker and my recipe. source: type: mssql config: host_port: <IP for connecting MSSQL database> database: <database name> username: <username> password: <password> sink: type: datahub-rest config: server: <datahub-gms ip in docker, ex) 0.0.0.0:9999/api/gms> first of all, I want to see tables list and data schema in database on datahub. How can I see tables list and data schema on datahub page? ex) dbo.Table_Fruit ~ dbo.Table_Animal~~~
h
Hi @hallowed-machine-2603 The recipe looks fine. Are you facing any issue when running the recipe ? Once the ingestion with recipe finishes successfully, you should be able to see table list, etc
h
I see error message below
Copy code
'[2022-06-06 07:25:22,361] WARNING  {urllib3.connectionpool:810} - Retrying (Retry(total=2, connect=None, read=None, redirect=None, '
           "status=None)) after connection broken by 'NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f0021a85c10>: Failed to "
           "establish a new connection: [Errno 111] Connection refused')': /api/gms/config\n"
           '[2022-06-06 07:25:26,362] WARNING  {urllib3.connectionpool:810} - Retrying (Retry(total=1, connect=None, read=None, redirect=None, '
           "status=None)) after connection broken by 'NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f0021a85670>: Failed to "
           "establish a new connection: [Errno 111] Connection refused')': /api/gms/config\n"
           '[2022-06-06 07:25:34,364] WARNING  {urllib3.connectionpool:810} - Retrying (Retry(total=0, connect=None, read=None, redirect=None, '
           "status=None)) after connection broken by 'NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f0021a85640>: Failed to "
           "establish a new connection: [Errno 111] Connection refused')': /api/gms/config\n"
           '[2022-06-06 07:25:34,793] ERROR    {datahub.entrypoints:167} - File '
and in access tokens page [Token based authentication is currently disabled. Contact your DataHub administrator to enable this feature] Could the cause of the message above be in-house network in my company?
h
Can you try setting server config as http://<datahub-gms ip>:<datahub-gms-port, usually 8080> and not use trailing /api/gms ?
b
@hallowed-machine-2603 is this being run via the UI? Please try to remove the path (/api/gms) completely if you are directy connecting to GMS container via Docker!
I am hopeful this is the problem
h
@hundreds-photographer-13496 @big-carpet-38439 I remove the path (/api/gms) completely (vm sever gms ip:gms-port, I changed port 8008). But error message -> Connection refused (/config\n)
@hundreds-photographer-13496 @big-carpet-38439 Ohhhhhhhhhhhhhhh, I resolve that issue. I use the method port forwarding before. But gms port is still 8080. and I removed the path(/api/gms). Thx :) It's all thanks to you Mayuri and John
yay 2
s
@purple-soccer-81736