Laba diena, susikūriau vartotojus, nustačiau jiems teises, tačiau jungiantis kaip vartotojui išmeta klaidos pranešimą:
Klaida. Nepavyko prisijungti prie duomenų bazės: Authentication to host 'localhost' for user 'rasyte' using method 'mysql_native_password' failed with message: Access denied for user 'rasyte'@'localhost' (using password: YES)
Ką darau blogai? Kur ieškoti klaidos?
Klaida detaliau:
Programos versija: Nenurodyta
Windows versija: Microsoft Windows NT 6.2.9200.0
.NET versija: 2.0.50727.8810
Klaidos duomenys:
Klaidos tipas: Csla.DataPortalException
Klaidos tekstas:
DataPortal.Fetch failed (System.Exception: Klaida. Nepavyko prisijungti prie duomenų bazės: Authentication to host 'localhost' for user 'zivile' using method 'mysql_native_password' failed with message: Access denied for user 'zivile'@'localhost' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException: Authentication to host 'localhost' for user 'zivile' using method 'mysql_native_password' failed with message: Access denied for user 'zivile'@'localhost' (using password: YES) ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'zivile'@'localhost' (using password: YES)
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadPacket()
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
at AccDataAccessLayer.Security.AccIdentity.TryAuthenticateWithIdentity(AccIdentity& nIdentity)
at AccDataAccessLayer.Security.AccIdentity.DataPortal_Fetch(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Fetch
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
at AccDataAccessLayer.Security.AccIdentity.TryAuthenticateWithIdentity(AccIdentity& nIdentity)
at AccDataAccessLayer.Security.AccIdentity.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)
at Csla.DataPortal.Fetch(Type objectType, Object criteria)
at Csla.DataPortal.Fetch[T](Object criteria)
at AccDataAccessLayer.Security.AccIdentity.GetIdentity(String cUsername, String cPassword, String cSQLServer, String cSQLPort, SqlServerType cSqlServerType, String cDatabaseNamingConvention, Boolean cUseSSL, String cSslCertificateFileName, String cSslCertificatePassword, Boolean cSslCertificateInstalled, Boolean cCannotSetGrants, ICacheManager cCacheManager, String cSqlConnectionCharSet)
at AccDataAccessLayer.Security.AccPrincipal.Login(LocalUser cLocalUser, String cPassword, ICacheManager cCacheManager)
at ApskaitaWUI.F_Login.LoginButton_Click(Object sender, EventArgs e)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tipas: Csla.Server.CallMethodException
Klaidos tekstas:
DataPortal_Fetch method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
at AccDataAccessLayer.Security.AccIdentity.TryAuthenticateWithIdentity(AccIdentity& nIdentity)
at AccDataAccessLayer.Security.AccIdentity.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tipas: System.Exception
Klaidos tekstas:
Klaida. Nepavyko prisijungti prie duomenų bazės: Authentication to host 'localhost' for user 'zivile' using method 'mysql_native_password' failed with message: Access denied for user 'zivile'@'localhost' (using password: YES)
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
TryLogin
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
at AccDataAccessLayer.Security.AccIdentity.TryAuthenticateWithIdentity(AccIdentity& nIdentity)
at AccDataAccessLayer.Security.AccIdentity.DataPortal_Fetch(Criteria criteria)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tipas: MySql.Data.MySqlClient.MySqlException
Klaidos tekstas:
Authentication to host 'localhost' for user 'zivile' using method 'mysql_native_password' failed with message: Access denied for user 'zivile'@'localhost' (using password: YES)
Klaidos šaltinis(Ex.Source):
MySql.Data
Klaidos metodas (Ex.TargetSite):
AuthenticationFailed
Klaidos stekas:
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at AccDataAccessLayer.SqlServerSpecificMethods.MySqlCommandManager.TryLogin(AccIdentity CurrentIdentity, List`1& cRoles)
----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tipas: MySql.Data.MySqlClient.MySqlException
Klaidos tekstas:
Access denied for user 'zivile'@'localhost' (using password: YES)
Klaidos šaltinis(Ex.Source):
MySql.Data
Klaidos metodas (Ex.TargetSite):
ReadPacket
Klaidos stekas:
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadPacket()
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
Objekto tipas: AccDataAccessLayer.Security.LocalUser
Objekto būsena:
AAEAAAD/////AQAAAAAAAAAMAgAAAElBY2NEYXRhQWNjZXNzTGF5ZXIsIFZlcnNpb249MS4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj1udWxsDAMAAABHQ3NsYSwgVmVyc2lvbj0yLjEuNC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPTkzYmU1ZmRjMDkzZTRjMzAMBAAAAElTeXN0ZW0sIFZlcnNpb249Mi4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj1iNzdhNWM1NjE5MzRlMDg5BQEAAAAlQWNjRGF0YUFjY2Vzc0xheWVyLlNlY3VyaXR5LkxvY2FsVXNlchkAAAAEX0dJRAVfTmFtZRVfQ29ubmVjdGlvblRlY2hub2xvZ3kVX0FwcGxpY2F0aW9uU2VydmVyVVJMDl9TcWxTZXJ2ZXJUeXBlEV9TcWxTZXJ2ZXJBZGRyZXNzDl9TcWxTZXJ2ZXJQb3J0GV9EYXRhYmFzZU5hbWluZ0NvbnZlbnRpb24HX1VzZVNTTBNfU3NsQ2VydGlmaWNhdGVGaWxlGF9Tc2xDZXJ0aWZpY2F0ZUluc3RhbGxlZBdfU3NsQ2VydGlmaWNhdGVQYXNzd29yZBBfQ2Fubm90U2V0R3JhbnRzFV9TcWxDb25uZWN0aW9uQ2hhclNldClCdXNpbmVzc0Jhc2VgMSttU2VyaWFsaXphYmxlU2F2ZWRIYW5kbGVycxNCdXNpbmVzc0Jhc2UrbUlzTmV3F0J1c2luZXNzQmFzZSttSXNEZWxldGVkFUJ1c2luZXNzQmFzZSttSXNEaXJ0eRlCdXNpbmVzc0Jhc2UrbUJpbmRpbmdFZGl0HEJ1c2luZXNzQmFzZSttTmV2ZXJDb21taXR0ZWQVQnVzaW5lc3NCYXNlK21Jc0NoaWxkHEJ1c2luZXNzQmFzZSttRWRpdExldmVsQWRkZWQdQnVzaW5lc3NCYXNlK21WYWxpZGF0aW9uUnVsZXMYVW5kb2FibGVCYXNlK21TdGF0ZVN0YWNrIkJpbmRhYmxlQmFzZSttU2VyaWFsaXphYmxlSGFuZGxlcnMDAQQBBAEBAQABAAEAAQMAAAAAAAAABAQEC1N5c3RlbS5HdWlkMUFjY0RhdGFBY2Nlc3NMYXllci5EYXRhQWNjZXNzVHlwZXMrQ29ubmVjdGlvblR5cGUCAAAAMEFjY0RhdGFBY2Nlc3NMYXllci5EYXRhQWNjZXNzVHlwZXMrU3FsU2VydmVyVHlwZQIAAAABAQF6U3lzdGVtLkV2ZW50SGFuZGxlcmAxW1tDc2xhLkNvcmUuU2F2ZWRFdmVudEFyZ3MsIENzbGEsIFZlcnNpb249Mi4xLjQuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj05M2JlNWZkYzA5M2U0YzMwXV0BAQEBAQEIH0NzbGEuVmFsaWRhdGlvbi5WYWxpZGF0aW9uUnVsZXMDAAAAgAFTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYy5TdGFja2AxW1tTeXN0ZW0uQnl0ZVtdLCBtc2NvcmxpYiwgVmVyc2lvbj0yLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODldXQQAAAAxU3lzdGVtLkNvbXBvbmVudE1vZGVsLlByb3BlcnR5Q2hhbmdlZEV2ZW50SGFuZGxlcgQAAAACAAAABPv///8LU3lzdGVtLkd1aWQLAAAAAl9hAl9iAl9jAl9kAl9lAl9mAl9nAl9oAl9pAl9qAl9rAAAAAAAAAAAAAAAIBwcCAgICAgICAsa8BrtIoEZFsmTghKzInCkGBgAAAAZ6aXZpbGUF+f///zFBY2NEYXRhQWNjZXNzTGF5ZXIuRGF0YUFjY2Vzc1R5cGVzK0Nvbm5lY3Rpb25UeXBlAQAAAAd2YWx1ZV9fAAgCAAAAAAAAAAYIAAAAAAX3////MEFjY0RhdGFBY2Nlc3NMYXllci5EYXRhQWNjZXNzVHlwZXMrU3FsU2VydmVyVHlwZQEAAAAHdmFsdWVfXwAIAgAAAAAAAAAGCgAAAAlsb2NhbGhvc3QGCwAAAAQzMzA2BgwAAAAIYXBza2FpdGEACQgAAAAACQgAAAAABg4AAAAGY3AxMjU3CgAAAAABAQAAAAAJDwAAAAkQAAAACgUPAAAAH0NzbGEuVmFsaWRhdGlvbi5WYWxpZGF0aW9uUnVsZXMCAAAADG1Ccm9rZW5SdWxlcxdtUHJvY2Vzc1Rocm91Z2hQcmlvcml0eQQAJUNzbGEuVmFsaWRhdGlvbi5Ccm9rZW5SdWxlc0NvbGxlY3Rpb24DAAAACAMAAAAJEQAAAAAAAAAFEAAAAIABU3lzdGVtLkNvbGxlY3Rpb25zLkdlbmVyaWMuU3RhY2tgMVtbU3lzdGVtLkJ5dGVbXSwgbXNjb3JsaWIsIFZlcnNpb249Mi4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj1iNzdhNWM1NjE5MzRlMDg5XV0DAAAABl9hcnJheQVfc2l6ZQhfdmVyc2lvbgMAAA9TeXN0ZW0uQnl0ZVtdW10ICAQAAAAJEgAAAAAAAAAAAAAABREAAAAlQ3NsYS5WYWxpZGF0aW9uLkJyb2tlblJ1bGVzQ29sbGVjdGlvbg0AAAALbUVycm9yQ291bnQNbVdhcm5pbmdDb3VudAptSW5mb0NvdW50IVJlYWRPbmx5QmluZGluZ0xpc3RgMSttSXNSZWFkT25seStFeHRlbmRlZEJpbmRpbmdMaXN0YDErbVNlcmlhbGl6YWJsZUhhbmRsZXJzF0JpbmRpbmdMaXN0YDErYWRkTmV3UG9zJEJpbmRpbmdMaXN0YDErcmFpc2VMaXN0Q2hhbmdlZEV2ZW50cyRCaW5kaW5nTGlzdGAxK3JhaXNlSXRlbUNoYW5nZWRFdmVudHMWQmluZGluZ0xpc3RgMSthbGxvd05ldxdCaW5kaW5nTGlzdGAxK2FsbG93RWRpdBlCaW5kaW5nTGlzdGAxK2FsbG93UmVtb3ZlHUJpbmRpbmdMaXN0YDErdXNlclNldEFsbG93TmV3EkNvbGxlY3Rpb25gMStpdGVtcwAAAAADAAAAAAAAAAMICAgBgQFTeXN0ZW0uRXZlbnRIYW5kbGVyYDFbW0NzbGEuQ29yZS5SZW1vdmluZ0l0ZW1FdmVudEFyZ3MsIENzbGEsIFZlcnNpb249Mi4xLjQuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj05M2JlNWZkYzA5M2U0YzMwXV0IAQEBAQEBiAFTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYy5MaXN0YDFbW0NzbGEuVmFsaWRhdGlvbi5Ccm9rZW5SdWxlLCBDc2xhLCBWZXJzaW9uPTIuMS40LjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49OTNiZTVmZGMwOTNlNGMzMF1dAwAAAAAAAAAAAAAAAAAAAAEK/////wEAAAAAAQkTAAAABxIAAAABAQAAAAAAAAAHAgQTAAAAiAFTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYy5MaXN0YDFbW0NzbGEuVmFsaWRhdGlvbi5Ccm9rZW5SdWxlLCBDc2xhLCBWZXJzaW9uPTIuMS40LjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49OTNiZTVmZGMwOTNlNGMzMF1dAwAAAAZfaXRlbXMFX3NpemUIX3ZlcnNpb24EAAAcQ3NsYS5WYWxpZGF0aW9uLkJyb2tlblJ1bGVbXQMAAAAICAkUAAAAAAAAAAAAAAAHFAAAAAABAAAAAAAAAAQaQ3NsYS5WYWxpZGF0aW9uLkJyb2tlblJ1bGUDAAAACw==<\Base64>