Hello Folks,
thank you for the two links, i tried it a few more time and found the particular issue:
https://blog.linuxserver.io/2017/05/10/installing-nextcloud-on-unraid-with-letsencrypt-reverse-proxy/
First for some reason CREATE USER 'chbmb' IDENTIFIED by 'password'; was not working instead i had to write the "BY" case sensitve so the guide is wrong in this part I assume?
And the last part of the problem was my lack of undertanding the nextcloud and letsencrypt config file, now its more clear