I have successfully linked mail-cow to next cloud. Now I can login (via mail-cow) as new next cloud user.
However I am having issues with using existing next-cloud users with mail-cow authentication.
Instructions copy and paster below:
- Run the following queries in your Nextcloud database (if you set up Nextcloud using mailcow’s script, you can run
source mailcow.conf && docker-compose exec mysql-mailcow mysql -u$DBUSER -p$DBPASS $DBNAME):
-bash: syntax error near unexpected token `)'
So I run
source mailcow.conf && docker-compose exec mysql-mailcow mysql -u$DBUSER -p$DBPASS $DBNAME ;
MariaDB [mailcow]> INSERT INTO nc_sociallogin_connect (uid, identifier) SELECT DISTINCT uid, CONCAT(“Mailcow-”, uid) FROM nc_users;
ERROR 1146 (42S02): Table ‘mailcow.nc_sociallogin_connect’ doesn’t exist
Any idea how to fix this.
Thanks in advance.