Hello,
When I try List Collaborators (seatable.io) I get a 500 Internal Server Error.
All other API calls work. Only this one throws an error. Any idea why that could be?
Thanks
Server error → server log?!
[2024-05-21 18:23:57] [ERROR] axios.cjs[837] - get dtable related-users: 9031fe893ff0481eb11ae78e25963eb7 error: AxiosError: getaddrinfo ENOTFOUND data.cocolotravel.comapi
at Function.AxiosError.from (/opt/seatable/seatable-server-4.4.9/dtable-server/node_modules/axios/dist/node/axios.cjs:837:14)
at RedirectableRequest.handleRequestError (/opt/seatable/seatable-server-4.4.9/dtable-server/node_modules/axios/dist/node/axios.cjs:3083:25)
at RedirectableRequest.emit (node:events:525:35)
at ClientRequest.eventHandlers.<computed> (/opt/seatable/seatable-server-4.4.9/dtable-server/node_modules/follow-redirects/index.js:38:24)
at ClientRequest.emit (node:events:513:28)
at TLSSocket.socketErrorListener (node:_http_client:494:9)
at TLSSocket.emit (node:events:513:28)
at emitErrorNT (node:internal/streams/destroy:157:8)
at emitErrorCloseNT (node:internal/streams/destroy:122:3)
at processTicksAndRejections (node:internal/process/task_queues:83:21) {
hostname: 'data.cocolotravel.comapi',
syscall: 'getaddrinfo',
code: 'ENOTFOUND',
errno: -3008,
config: {
transitional: {
silentJSONParsing: true,
forcedJSONParsing: true,
clarifyTimeoutError: false
},
adapter: [ 'xhr', 'http' ],
transformRequest: [ [Function: transformRequest] ],
transformResponse: [ [Function: transformResponse] ],
timeout: 60000,
xsrfCookieName: 'XSRF-TOKEN',
xsrfHeaderName: 'X-XSRF-TOKEN',
maxContentLength: -1,
maxBodyLength: -1,
env: { FormData: [Function], Blob: null },
validateStatus: [Function: validateStatus],
headers: Object [AxiosHeaders] {
Accept: 'application/json, text/plain, */*',
'Content-Type': undefined,
Authorization: 'Token I HIDE THIS',
'User-Agent': 'axios/1.6.2',
'Accept-Encoding': 'gzip, compress, deflate, br'
},
params: { dtable_uuid: '9031fe89-3ff0-481e-b11a-e78e25963eb7' },
method: 'get',
url: 'https://data.cocolotravel.comapi/v2.1/dtable-internal/get-related-users/',
data: undefined
},
request: <ref *1> Writable {
_writableState: WritableState {
objectMode: false,
highWaterMark: 16384,
finalCalled: false,
needDrain: false,
ending: false,
ended: false,
finished: false,
destroyed: false,
decodeStrings: true,
defaultEncoding: 'utf8',
length: 0,
writing: false,
corked: 0,
sync: true,
bufferProcessing: false,
onwrite: [Function: bound onwrite],
writecb: null,
writelen: 0,
afterWriteTickInfo: null,
buffered: [],
bufferedIndex: 0,
allBuffers: true,
allNoop: true,
pendingcb: 0,
constructed: true,
prefinished: false,
errorEmitted: false,
emitClose: true,
autoDestroy: true,
errored: null,
closed: false,
closeEmitted: false,
[Symbol(kOnFinished)]: []
},
_events: [Object: null prototype] {
response: [Function: handleResponse],
error: [Function: handleRequestError],
socket: [Array]
},
_eventsCount: 3,
_maxListeners: undefined,
_options: {
maxRedirects: 21,
maxBodyLength: Infinity,
protocol: 'https:',
path: '/v2.1/dtable-internal/get-related-users/?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7',
method: 'GET',
headers: [Object: null prototype],
agents: [Object],
auth: undefined,
family: undefined,
beforeRedirect: [Function: dispatchBeforeRedirect],
beforeRedirects: [Object],
hostname: 'data.cocolotravel.comapi',
port: '',
agent: undefined,
nativeProtocols: [Object],
pathname: '/v2.1/dtable-internal/get-related-users/',
search: '?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7'
},
_ended: true,
_ending: true,
_redirectCount: 0,
_redirects: [],
_requestBodyLength: 0,
_requestBodyBuffers: [],
_onNativeResponse: [Function (anonymous)],
_currentRequest: ClientRequest {
_events: [Object: null prototype],
_eventsCount: 7,
_maxListeners: undefined,
outputData: [],
outputSize: 0,
writable: true,
destroyed: false,
_last: true,
chunkedEncoding: false,
shouldKeepAlive: false,
maxRequestsOnConnectionReached: false,
_defaultKeepAlive: true,
useChunkedEncodingByDefault: false,
sendDate: false,
_removedConnection: false,
_removedContLen: false,
_removedTE: false,
strictContentLength: false,
_contentLength: 0,
_hasBody: true,
_trailer: '',
finished: true,
_headerSent: true,
_closed: false,
socket: [TLSSocket],
_header: 'GET /v2.1/dtable-internal/get-related-users/?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7 HTTP/1.1\r\n' +
'Accept: application/json, text/plain, */*\r\n' +
'Authorization: Token I HIDE THIS' +
'User-Agent: axios/1.6.2\r\n' +
'Accept-Encoding: gzip, compress, deflate, br\r\n' +
'Host: data.cocolotravel.comapi\r\n' +
'Connection: close\r\n' +
'\r\n',
_keepAliveTimeout: 0,
_onPendingData: [Function: nop],
agent: [Agent],
socketPath: undefined,
method: 'GET',
maxHeaderSize: undefined,
insecureHTTPParser: undefined,
path: '/v2.1/dtable-internal/get-related-users/?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7',
_ended: false,
res: null,
aborted: false,
timeoutCb: null,
upgradeOrConnect: false,
parser: null,
maxHeadersCount: null,
reusedSocket: false,
host: 'data.cocolotravel.comapi',
protocol: 'https:',
_redirectable: [Circular *1],
[Symbol(kCapture)]: false,
[Symbol(kBytesWritten)]: 0,
[Symbol(kEndCalled)]: true,
[Symbol(kNeedDrain)]: false,
[Symbol(corked)]: 0,
[Symbol(kOutHeaders)]: [Object: null prototype],
[Symbol(kUniqueHeaders)]: null
},
_currentUrl: 'https://data.cocolotravel.comapi/v2.1/dtable-internal/get-related-users/?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7',
_timeout: null,
[Symbol(kCapture)]: false
},
cause: Error: getaddrinfo ENOTFOUND data.cocolotravel.comapi
at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:109:26) {
errno: -3008,
code: 'ENOTFOUND',
syscall: 'getaddrinfo',
hostname: 'data.cocolotravel.comapi'
}
}
[2024-05-21 18:25:15] [ERROR] axios.cjs[837] - get dtable related-users: 9031fe893ff0481eb11ae78e25963eb7 error: AxiosError: getaddrinfo ENOTFOUND data.cocolotravel.comapi
at Function.AxiosError.from (/opt/seatable/seatable-server-4.4.9/dtable-server/node_modules/axios/dist/node/axios.cjs:837:14)
at RedirectableRequest.handleRequestError (/opt/seatable/seatable-server-4.4.9/dtable-server/node_modules/axios/dist/node/axios.cjs:3083:25)
at RedirectableRequest.emit (node:events:525:35)
at ClientRequest.eventHandlers.<computed> (/opt/seatable/seatable-server-4.4.9/dtable-server/node_modules/follow-redirects/index.js:38:24)
at ClientRequest.emit (node:events:513:28)
at TLSSocket.socketErrorListener (node:_http_client:494:9)
at TLSSocket.emit (node:events:513:28)
at emitErrorNT (node:internal/streams/destroy:157:8)
at emitErrorCloseNT (node:internal/streams/destroy:122:3)
at processTicksAndRejections (node:internal/process/task_queues:83:21) {
hostname: 'data.cocolotravel.comapi',
syscall: 'getaddrinfo',
code: 'ENOTFOUND',
errno: -3008,
config: {
transitional: {
silentJSONParsing: true,
forcedJSONParsing: true,
clarifyTimeoutError: false
},
adapter: [ 'xhr', 'http' ],
transformRequest: [ [Function: transformRequest] ],
transformResponse: [ [Function: transformResponse] ],
timeout: 60000,
xsrfCookieName: 'XSRF-TOKEN',
xsrfHeaderName: 'X-XSRF-TOKEN',
maxContentLength: -1,
maxBodyLength: -1,
env: { FormData: [Function], Blob: null },
validateStatus: [Function: validateStatus],
headers: Object [AxiosHeaders] {
Accept: 'application/json, text/plain, */*',
'Content-Type': undefined,
Authorization: 'Token I HIDE THIS',
'User-Agent': 'axios/1.6.2',
'Accept-Encoding': 'gzip, compress, deflate, br'
},
params: { dtable_uuid: '9031fe89-3ff0-481e-b11a-e78e25963eb7' },
method: 'get',
url: 'https://data.cocolotravel.comapi/v2.1/dtable-internal/get-related-users/',
data: undefined
},
request: <ref *1> Writable {
_writableState: WritableState {
objectMode: false,
highWaterMark: 16384,
finalCalled: false,
needDrain: false,
ending: false,
ended: false,
finished: false,
destroyed: false,
decodeStrings: true,
defaultEncoding: 'utf8',
length: 0,
writing: false,
corked: 0,
sync: true,
bufferProcessing: false,
onwrite: [Function: bound onwrite],
writecb: null,
writelen: 0,
afterWriteTickInfo: null,
buffered: [],
bufferedIndex: 0,
allBuffers: true,
allNoop: true,
pendingcb: 0,
constructed: true,
prefinished: false,
errorEmitted: false,
emitClose: true,
autoDestroy: true,
errored: null,
closed: false,
closeEmitted: false,
[Symbol(kOnFinished)]: []
},
_events: [Object: null prototype] {
response: [Function: handleResponse],
error: [Function: handleRequestError],
socket: [Array]
},
_eventsCount: 3,
_maxListeners: undefined,
_options: {
maxRedirects: 21,
maxBodyLength: Infinity,
protocol: 'https:',
path: '/v2.1/dtable-internal/get-related-users/?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7',
method: 'GET',
headers: [Object: null prototype],
agents: [Object],
auth: undefined,
family: undefined,
beforeRedirect: [Function: dispatchBeforeRedirect],
beforeRedirects: [Object],
hostname: 'data.cocolotravel.comapi',
port: '',
agent: undefined,
nativeProtocols: [Object],
pathname: '/v2.1/dtable-internal/get-related-users/',
search: '?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7'
},
_ended: true,
_ending: true,
_redirectCount: 0,
_redirects: [],
_requestBodyLength: 0,
_requestBodyBuffers: [],
_onNativeResponse: [Function (anonymous)],
_currentRequest: ClientRequest {
_events: [Object: null prototype],
_eventsCount: 7,
_maxListeners: undefined,
outputData: [],
outputSize: 0,
writable: true,
destroyed: false,
_last: true,
chunkedEncoding: false,
shouldKeepAlive: false,
maxRequestsOnConnectionReached: false,
_defaultKeepAlive: true,
useChunkedEncodingByDefault: false,
sendDate: false,
_removedConnection: false,
_removedContLen: false,
_removedTE: false,
strictContentLength: false,
_contentLength: 0,
_hasBody: true,
_trailer: '',
finished: true,
_headerSent: true,
_closed: false,
socket: [TLSSocket],
_header: 'GET /v2.1/dtable-internal/get-related-users/?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7 HTTP/1.1\r\n' +
'Accept: application/json, text/plain, */*\r\n' +
'Authorization: Token I HIDE THIS' +
'User-Agent: axios/1.6.2\r\n' +
'Accept-Encoding: gzip, compress, deflate, br\r\n' +
'Host: data.cocolotravel.comapi\r\n' +
'Connection: close\r\n' +
'\r\n',
_keepAliveTimeout: 0,
_onPendingData: [Function: nop],
agent: [Agent],
socketPath: undefined,
method: 'GET',
maxHeaderSize: undefined,
insecureHTTPParser: undefined,
path: '/v2.1/dtable-internal/get-related-users/?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7',
_ended: false,
res: null,
aborted: false,
timeoutCb: null,
upgradeOrConnect: false,
parser: null,
maxHeadersCount: null,
reusedSocket: false,
host: 'data.cocolotravel.comapi',
protocol: 'https:',
_redirectable: [Circular *1],
[Symbol(kCapture)]: false,
[Symbol(kBytesWritten)]: 0,
[Symbol(kEndCalled)]: true,
[Symbol(kNeedDrain)]: false,
[Symbol(corked)]: 0,
[Symbol(kOutHeaders)]: [Object: null prototype],
[Symbol(kUniqueHeaders)]: null
},
_currentUrl: 'https://data.cocolotravel.comapi/v2.1/dtable-internal/get-related-users/?dtable_uuid=9031fe89-3ff0-481e-b11a-e78e25963eb7',
_timeout: null,
[Symbol(kCapture)]: false
},
cause: Error: getaddrinfo ENOTFOUND data.cocolotravel.comapi
at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:109:26) {
errno: -3008,
code: 'ENOTFOUND',
syscall: 'getaddrinfo',
hostname: 'data.cocolotravel.comapi'
}
}
@rdb I am noticing that the hostname has “api” appended to it. I wonder if this is supposed to be this way?
Thank you for your help.
Looks like you forgot a trailing slash. I guess it should be data.cocolotravel.com/api. Which API endpoint do you use? The api-gateway endpoint or the legacy endpoint?
@rdb thank you for your help.
That is what I thought to but the call looks good to me as you can see on the screenshot below.
I use the api-gateway endpoint. Could it be something wrong with the configuration ?
I tested the /related-users/ endpoint on https://api.seatable.io with SeaTable Cloud. The result: The expected response (see below).
Did you update to SeaTable 4.4? Have you paid attention to the upgrade notice for SeaTable 4.4?
@rdb I managed to make it work
Of course I respected all the steps in the Extra Upgrade Notices
Extra Upgrade Notices - SeaTable Admin Manual
BUT, somehow by simply omitting the last optional step the call worked
Maybe could it be that the
"dtable_web_service_url": "https://{public server URL}"
should be instead:
"dtable_web_service_url": "https://{public server URL}/"
With the trailing slash?
Glad to hear that the problem has been solved.
@cdb Can you check the hint that Axel gave?
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
