Filemaker Node Login Error

Swat_1 · July 13, 2023, 7:14pm

Hey, I am trying to integrate with the Filemaker node, and having some problems.

I am having a hard time getting the filmmaker node to connect to our local filmmaker pro server. We have enabled the API, and are using proper credentials, but we continue to receive a login error.

The error message we are getting is ERROR: Login fail

NodeOperationError: Login fail
    at Object.execute (/Applications/n8n.app/Contents/Resources/app/node_modules/n8n-nodes-base/nodes/FileMaker/FileMaker.node.ts:703:10)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at Workflow.runNode (/Applications/n8n.app/Contents/Resources/app/node_modules/n8n-workflow/src/Workflow.ts:1270:19)
    at /Applications/n8n.app/Contents/Resources/app/node_modules/n8n-core/src/WorkflowExecute.ts:938:29

Please share your workflow

I am just testing the node individually, so I can learn how they work before I compile our entire system.

MacOS 12.6.1
N8N Desktop Version 1.10.0
*I will be switching to N8N server for the real system, this is just testing.

~SWAT

Jon · July 14, 2023, 8:51am

Hey @Swat_1,

Welcome to the community

This is the second report of this one now, Which version of Filemaker are you using?

Swat_1 · July 17, 2023, 11:55am

Our local FileMaker Pro Server is running 19.5.2, and this is a Mac mini running 10.15.7.

Jon · July 17, 2023, 12:53pm

Hey @Swat_1,

Perfect I will set up a test environment set up to see if I can trigger the same error. I am about to merge in it a PR that should produce better error messages for Filemaker so it could be that the change for that shows something as well.

Swat_1 · July 17, 2023, 1:12pm

Okay, thank you, and I hope you find the solution!

Swat_1 · July 21, 2023, 1:11pm

Hey @Jon,
I hope you have had a chance to start any testing, I have still not been able to get the Filemaker Node to work. Is their a different between the desktop and server nodes?

Jon · July 24, 2023, 10:43am

Hey @Swat_1,

I have had a few days off but I have not yet had a chance to set it up, I know there is one other user with issues when it comes to logging in but there are also a few users who are able to log in without issue.

Can you update to 0.236.3 which should provide better error messages and let me know if the error changes.

Swat_1 · July 24, 2023, 1:53pm

Hey @Jon,
I updated, and now I am getting

NodeOperationError: self-signed certificate in certificate chain
    at Object.execute (/Users/swat/.npm/_npx/a8a7eec953f1f314/node_modules/n8n-nodes-base/nodes/FileMaker/FileMaker.node.ts:705:10)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Workflow.runNode (/Users/swat/.npm/_npx/a8a7eec953f1f314/node_modules/n8n-workflow/src/Workflow.ts:1249:19)
    at /Users/swat/.npm/_npx/a8a7eec953f1f314/node_modules/n8n-core/src/WorkflowExecute.ts:1024:29

I am unsure if their is a way around using a SSL on a lan filmmaker pro server.

Jon · July 24, 2023, 2:06pm

Hey @Swat_1,

That is perfect so at the moment the node doesn’t support self signed certificates for the authentication side of things but now we know what the issue is I can get this fixed.

Swat_1 · July 24, 2023, 8:03pm

Hey @Jon,
Okay, this would be amazing. I have been trying to figure out how to setup a syncing system for our school district for over a year now, and with this node functioning, I will be able to connect to all of my endpoints. Let me know if there is anything else I can do to help, and I appreciate the work you have done so far.

Jon · July 25, 2023, 8:43am

Hey @Swat_1,

Are you using Docker now? I can get a test image built that you can try to see if that works.

Swat_1 · July 25, 2023, 2:30pm

Hey @Jon,
I am just running n8n on my MacBook with npn. I can try to setup docker if you would like me to. If so, how would be the best way to go about that?

Jon · July 26, 2023, 4:50pm

Hey @Swat_1,

It is a bit trickier, I will implement the change anyway and in theory it should just work.

Swat_1 · July 26, 2023, 6:51pm

Hey @Jon,
That would be great! Just let me know when it is ready to test🤞

Swat_1 · August 3, 2023, 2:46pm

Hey @Jon,
I am now running n8n via docker, this will be where it is running in production. I do not know if this makes it easier to build that test image, we can go either route, but if a docker image is easier, then we can do that.

Jon · August 4, 2023, 7:34am

Hey @Swat_1,

Perfect, I will see if I can get this done today.

Jon · August 4, 2023, 9:36am

Hey @Swat_1,

Assuming you are on at least 1.0 can you change your docker image to use n8nio/n8n:PR-6851-forum-filemaker-ignore-certs this is a special version that has some changes to allow self signed certificates to be used for the Filemaker node. If this works for you then we can get it merged and make it generally available.

Swat_1 · August 4, 2023, 12:07pm

Hey, @Jon,
Thank you for getting this image up, and the Filemaker authentication works as long as I keep the setting “Ignore SSL Issues” turned off. My tabes are loading and everything is working except I am not receiving any output data. I have “Always Output Data” turned on, and I am still not getting anything. I do not know if I am doing something wrong, I probably am, but n8n also says that the node is being executed successfully.

{
“meta”: {
“instanceId”: “a7450affccf2c242f6d3a73d63b89bcf02fd0f2a3b5ab67e4d3cbfcd4fd4bc43”
},
“nodes”: [
{
“parameters”: {
“action”: “find”,
“layout”: “Student Detail”,
“responseLayout”: “Student Detail”,
“queries”: {
“query”: [
{
“fields”: {
“field”: [
{
“name”: “Last_Name”,
“value”: “Geo”
}
]
},
“omit”: true
}
]
}
},
“id”: “0411e2ee-0c01-44d6-b61c-a3a678c30c08”,
“name”: “FileMaker”,
“type”: “n8n-nodes-base.filemaker”,
“typeVersion”: 1,
“position”: [
740,
300
],
“alwaysOutputData”: true,
“executeOnce”: false,
“retryOnFail”: false,
“credentials”: {
“fileMaker”: {
“id”: “Y5LKQVrLhSXW1FXZ”,
“name”: “FileMaker account”
}
}
}
],
“connections”: {}
}

Thank you for all of your work, and I will continue to mess with the node and see if I can get it working.

Jon · August 4, 2023, 1:42pm

Hey @Swat_1,

It should be ok with Ignore SSL Issues set to enabled, Out of interest is there any extra log output?

Swat_1 · August 4, 2023, 3:22pm

Hey @Jon,
When Ignore SSL Issues is enabled I get the same error as before (ERROR: self-signed certificate in certificate chain).

This is the output with always output data on and ignore ssl issues off.

I do not know of any other way to view a log than it showing up after I execute the node, their probably is another way, so let me know how to find it, and I will send it to you.