In reply to @ccdd:matrix.org

Hi, thanks for the response. Here they are:

INFO io.kamax.mxisd.session.SessionManager - Server 127.0.0.1 is asking to create session for io.kamax.matrix.ThreePid@5aaf1be7 (Attempt #1) - Next link: https://app.element.io/#/register?client_secret=cWOL5UksyarisvOsOPDphcL0yP6deaeda&hs_url=https%3A%2F%2Friot.visix.technology&is_url=https%3A%2F%2Fvector.im&session_id=NyxfOpaCbpJBncnkTKwjBBig
[XNIO-1 task-1] INFO io.kamax.mxisd.session.SessionManager - No existing session for io.kamax.matrix.ThreePid@5aaf1be7
[XNIO-1 task-1] INFO io.kamax.mxisd.session.SessionManager - Generated new session 1603097120854 to validate io.kamax.matrix.ThreePid@5aaf1be7 from server 127.0.0.1
[XNIO-1 task-1] INFO io.kamax.mxisd.session.SessionManager - Stored session 1603097120854
[XNIO-1 task-1] INFO io.kamax.mxisd.session.SessionManager - Session 1603097120854 for io.kamax.matrix.ThreePid@5aaf1be7: sending validation notification
[XNIO-1 task-1] INFO io.kamax.mxisd.threepid.generator.GenericTemplateNotificationGenerator - Generating notification content for 3PID Session validation
[XNIO-1 task-1] INFO io.kamax.mxisd.threepid.connector.email.EmailSmtpConnector - Sending email to my.email@outlook.com via SMTP using smtp.mandrillapp.com:587
[XNIO-1 task-1] INFO io.kamax.mxisd.threepid.connector.email.EmailSmtpConnector - Connecting to smtp.mandrillapp.com:587
[XNIO-1 task-1] INFO io.kamax.mxisd.threepid.connector.email.EmailSmtpConnector - Using SMTP authentication
[XNIO-1 task-1] ERROR io.kamax.mxisd.http.undertow.handler.SaneHandler - Unknown error when handling http://my.matrix.server/_matrix/identity/api/v1/validate/email/requestToken
java.lang.RuntimeException: Unable to send e-mail to my.email@outlook.com
#011at io.kamax.mxisd.threepid.connector.email.EmailSmtpConnector.send(EmailSmtpConnector.java:142)
#011at io.kamax.mxisd.threepid.notification.email.EmailRawNotificationHandler.send(EmailRawNotificationHandler.java:64)
#011at io.kamax.mxisd.threepid.notification.email.EmailRawNotificationHandler.send(EmailRawNotificationHandler.java:31)
#011at io.kamax.mxisd.threepid.notification.GenericNotificationHandler.sendForValidation(GenericNotificationHandler.java:72)
#011at io.kamax.mxisd.notification.NotificationManager.sendForValidation(NotificationManager.java:78)
#011at io.kamax.mxisd.session.SessionManager.create(SessionManager.java:149)
#011at io.kamax.mxisd.http.undertow.handler.identity.share.SessionStartHandler.handleRequest(SessionStartHandler.java:57)
#011at io.kamax.mxisd.http.undertow.handler.SaneHandler.handleRequest(SaneHandler.java:71)
#011at io.kamax.mxisd.http.undertow.handler.SaneHandler.handleRequest(SaneHandler.java:71)
#011at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
#011at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
#011at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
#011at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
#011at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: javax.mail.AuthenticationFailedException: 535 5.7.8 Error: authentication failed: UGFzc3dvcmQ6
#011at com.sun.mail.smtp.SMTPTransport$Authenticator.authenticate(SMTPTransport.java:965)
#011at com.sun.mail.smtp.SMTPTransport.authenticate(SMTPTransport.java:876)
#011at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:780)
#011at javax.mail.Service.connect(Service.java:366)
#011at javax.mail.Service.connect(Service.java:246)
#011at javax.mail.Service.connect(Service.java:267)
#011at io.kamax.mxisd.threepid.connector.email.EmailSmtpConnector.send(EmailSmtpConnector.java:132)
#011... 13 more
[XNIO-1 task-1] INFO io.kamax.mxisd.http.undertow.handler.BasicHttpHandler - Request POST http://my.matrix.server/_matrix/identity/api/v1/validate/email/requestToken - Error M_UNKNOWN: Unable to send e-mail to my.email@outlook.com

Use a recursive lookup mechanism when searching and inviting people by 3PID, allowing to fetch data from:

Own Identity store(s)

just read this and I was wondering where I can read more about this and how exactly it works, anyone know where I can look? (links to code lines will also be very useful! thanks 😊)

Use a recursive lookup mechanism when searching and inviting people by 3PID, allowing to fetch data from:

Own Identity store(s)

just read this and I was wondering where I can read more about this and how exactly it works, anyone know where I can look? (links to code lines will also be very useful! thanks 😊)

Use a recursive lookup mechanism when searching and inviting people by 3PID, allowing to fetch data from:
Own Identity store(s)

just read this and I was wondering where I can read more about this and how exactly it works, anyone know where I can look? (links to code lines will also be very useful! thanks 😊)

I think is here https://github.com/ma1uta/ma1sd/blob/master/docs/stores/synapse.md and https://github.com/ma1uta/ma1sd/blob/master/docs/stores/sql.md. I achieved to make the lookup work. But if I send a room invitation by email, after the user is registered/loged or she adds the 3pid-email, etc, the mail invitation stills pending and it doesn't match with the @matrix_user_id:example.com. I mean, I send the invitation, I can see it in the ma1sd database, the user apply the token (sent by email), I see this activity in the ma1sd journalctl [journalctl -fu ma1sd], the user adds her email, nothing happens.

I know the hard part is to make the match between @matrix_user_id:example.com and the 3pid email. I have tried many configurations. Any clues?
Thank you!

In reply to @roderikferdinand:matrix.org

I think is here https://github.com/ma1uta/ma1sd/blob/master/docs/stores/synapse.md and https://github.com/ma1uta/ma1sd/blob/master/docs/stores/sql.md. I achieved to make the lookup work. But if I send a room invitation by email, after the user is registered/loged or she adds the 3pid-email, etc, the mail invitation stills pending and it doesn't match with the @matrix_user_id:example.com. I mean, I send the invitation, I can see it in the ma1sd database, the user apply the token (sent by email), I see this activity in the ma1sd journalctl [journalctl -fu ma1sd], the user adds her email, nothing happens.

I know the hard part is to make the match between @matrix_user_id:example.com and the 3pid email. I have tried many configurations. Any clues?
Thank you!

In reply to @ma1uta:ru-matrix.org
I will check this, it seems that it is a bug.

In reply to @roderikferdinand:matrix.org

I think is here https://github.com/ma1uta/ma1sd/blob/master/docs/stores/synapse.md and https://github.com/ma1uta/ma1sd/blob/master/docs/stores/sql.md. I achieved to make the lookup work. But if I send a room invitation by email, after the user is registered/loged or she adds the 3pid-email, etc, the mail invitation stills pending and it doesn't match with the @matrix_user_id:example.com. I mean, I send the invitation, I can see it in the ma1sd database, the user apply the token (sent by email), I see this activity in the ma1sd journalctl [journalctl -fu ma1sd], the user adds her email, nothing happens.

I know the hard part is to make the match between @matrix_user_id:example.com and the 3pid email. I have tried many configurations. Any clues?
Thank you!

Your case:

1. invite a new user by email
2. user create a new account
3. user bind email to the account
4. nothing (user should be invited into the invited room)
   Am I right?

So, I see the next flow:

• /_matrix/identity/api/v1/validate/email/requestToken when user try to add email, ma1sd sends the email with confirm link
• /_matrix/identity/api/v1/validate/email/submitToken when user open the confirm link
• /_matrix/identity/api/v1/3pid/getValidated3pid when riot check successful validation
• and thats all, request /_matrix/identity/v2/3pid/bind or /_matrix/identity/v1/3pid/bind missing.

In reply to @ma1uta:ru-matrix.org
Do you use PostgreSQL or SQLite?

In reply to @ma1uta:ru-matrix.org

So, I see the next flow:

• /_matrix/identity/api/v1/validate/email/requestToken when user try to add email, ma1sd sends the email with confirm link
• /_matrix/identity/api/v1/validate/email/submitToken when user open the confirm link
• /_matrix/identity/api/v1/3pid/getValidated3pid when riot check successful validation
• and thats all, request /_matrix/identity/v2/3pid/bind or /_matrix/identity/v1/3pid/bind missing.

Please try this config:

synapseSql:
  identity:
    query: 'select user_id as uid, medium, address from user_threepids where medium = ? and address = ?'

to override the identity config.

For example config will be look like this:

synapseSql:
  enabled: true
  type: postgresql
  connection: //127.0.0.1/synapse?user=synapse&password=synapse_password
  identity:
    enabled: true
    query: 'select user_id as uid, medium, address from user_threepids where medium = ? and address = ?'
  lookup:
    query: 'select user_id as mxid, medium, address from user_threepids'