search

sirtoobii / vaultwarden_ldap_sync

Autmatically keep ldap in sync with your Vaultwarden installation
GNU General Public License v3.0
10 stars 7 forks source link

Error: no such column: invite_email #5

Closed AzatGo closed 8 months ago

AzatGo commented 8 months ago

hi аirst of all, I wanted to say thank you for LDAP connector. I am getting an error, maybe you could help me out? Database used sqlite ERROR [sync.py] Something went wrong. Error: no such column: invite_email

sirtoobii commented 8 months ago

There is most likely something wrong with you sqlite database file, specifically, the init_db() has not been called or something when wrong during the creation of the initial schema (check for other error message during startup). Are you using the dockerized version? If yes, it might help to delete the /data/ldap_sync.sqlite file.

AzatGo commented 8 months ago

Yes, I run in the docker. Removal /data/ldap_sync.sqlite helped.

SMTP is configured correctly and test messages are being sent. However, the invites from the LDAP connector are not coming through.

2024-03-04:11:25:46 DEBUG [connectionpool.py] Starting new HTTPS connection (1): ****:443 2024-03-04:11:25:46 DEBUG [connectionpool.py] https://****:443 "GET /admin/users HTTP/1.1" 200 3324 2024-03-04:11:25:46 DEBUG [sync.py] Found 0 vanished user(s) 2024-03-04:11:25:46 DEBUG [sync.py] Found 0 deleted user(s) 2024-03-04:11:25:46 DEBUG [sync.py] Found 0 disabled user(s) 2024-03-04:11:25:46 DEBUG [sync.py] Found 0 enabled user(s) 2024-03-04:11:25:46 DEBUG [sync.py] Found 0 user(s) with changed emails 2024-03-04:11:25:46 DEBUG [VaultwardenConnector.py] Cookie store found, loading 2024-03-04:11:25:46 DEBUG [connectionpool.py] https://****:443 "GET /admin/users HTTP/1.1" 200 3324 2024-03-04:11:25:46 DEBUG [sync.py] Found 4 user(s) to invite 2024-03-04:11:25:46 DEBUG [sync.py] Found 0 user(s) to disable 2024-03-04:11:25:46 INFO [sync.py] Invite user ***@gmail.com 2024-03-04:11:25:46 INFO [sync.py] Invite user ***@gmail.com 2024-03-04:11:25:46 INFO [sync.py] Invite user ***@gmail.com 2024-03-04:11:25:46 INFO [sync.py] Invite user ***@gmail.com

sirtoobii commented 8 months ago

Could it be that DRYRUN mode is still active?

AzatGo commented 8 months ago

I'm sorry for answering so late. Thank you for your advice DRYRUN. It was very helpful!