IBM / Db2

Db2 Universal Container deployment
Apache License 2.0
9 stars 34 forks source link

unable to authenticate user #16

Open youngnicholas opened 4 years ago

youngnicholas commented 4 years ago

SQL1639N The database server was unable to perform authentication because security-related database manager files on the server do not have the required operating system permissions. SQLSTATE=08001

After trying to solve this using: https://www.ibm.com/support/pages/database-connection-fails-authentication-error-sql1639n . I can't set the ownership of those files root, it sets the owner the "nobody" and not root.

northfig commented 4 years ago

See issue reported by @northfig for root cause

adesilva74 commented 4 years ago

Assuming you are using NFS, likely the root cause as issue #22 (refer to my comment for details in there)

youngnicholas commented 4 years ago

Assuming you are using NFS, likely the root cause as issue #22 (refer to my comment for details in there)

Am not using NFS. Using ibmc-file-bronze . The readme doesn't state that you must use NFS

northfig commented 4 years ago

Am not using NFS. Using ibmc-file-bronze . The readme doesn't state that you must use NFS

@NickYoung-01 IBM Cloud implements ibmc-file-bronze as NFS in the background. That is why it fails, and as we cannot influence the export-options to allow root access, it would seem that we need to configure our own NFS server where we can influence these settings :-(

irinadel commented 4 years ago

@northfig @NickYoung-01 you can influence the export settings on the file storage in IBM cloud. start up this deamonset - https://github.com/IBM-Cloud/kube-samples/tree/master/daemonset-sample