Hi, 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: 1. 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 MariaDB [mailcow]> Any idea how to fix this. Thanks in advance. Nenad

Configure Nextcloud to use mailcow for authentication

nsavic

Hi,

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
MariaDB [mailcow]>

Any idea how to fix this.
Thanks in advance.
Nenad