Oi labai laukiam, ačiū.

Išsisprendžiau.

Programoje Sąskaitų plane neatidaro Pavyzdinio sąskaitų plano, Kompleksiniuose dokumentuose neatsidaro Ilgalaikio turto sąrašas (paspaudus "Pildyti" nieko neįvyksta, sąrašas neatsidaro).
Duomenų bazės struktūros klaidos lange išmeta pranešimą "Klaida. Stulpelis ParentID(191' nerastas."

Padėkite, prašau, išspręsti problemą. Ačiū.

Ačiū jolitukasbag, Niemand jums atsakė, kad MySql nereikia , tai vis gi kuri MySql versija yra tinkama? Nes su 8 versija, visai kita vartotojų nustatymo sintaksė, todėl neleidžia sukurti naujų vartotojų, o su seniausia internete rasta versija 5.6.45 meta klaidą, kai kuriama nauja įmonė (anksteniame klausime esu prisegusi).

Puiku, gal galite pasakyti kokia MySql versija pas jus instaliuota?

O apskritai ar yra kas naudoja serverinę Apskaita5 su keletu įmonių, keletu vartotojų, kuriems nustatytos tam tikros teisėmis dirbti su tam tikra įmone.

Sveiki, kokia Apskaita5 reikalinga MySql versija? Dabar susintaliavus MySQL versiją 5.6.45, Apskaita5, kuriant naują įmone išmeta klaidą. Ar čia esmė visai ne MySql versijoje?

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>

Išjungėme lyg ir (žemiau), bet ta pati klaida...

Taip, naudojuosi AccMigration.exe, bet išmeta klaidos pranešimą: prisegu failą.

Ar yra galimybė iš neservesinės Apskaita5 duomenų bazę įsikelti į "serverinę" Apskaita5?

Sveiki, reikia pagalbos. Susikūriau "serverinę" Apskaita5, tačiau prisijungus (jungiuosi kaip administratorius "root") neleidžia sukurti naujos duomenų bazės (naujos įmonės), meta pranešimą:

KRITINĖ KLAIDA - NEBAIGTA KURTI DUOMENŲ BAZĖ. Klaida kilo bandant sukurti procedūrą 'CROUND'. Iki klaidos atsiradimo buvo sukurtos šios duomenų bazės lentelės: advancereports, apyskaitos, asmenys, bankoperations, bz, bzdata, cashaccounts, companyaccounts, companyforms, companyrates, companyregionaldata, d_avansai, d_avansai_d, d_kitos, darbuotojai_d, du_ziniarastis, du_ziniarastis_d, financialstatementsstructure, imone, invoicesmade, invoicesreceived, kalkuliac, kalkuliac_d, kio, kpo, longtermassetcustomgroups, offsetitems, paslaugos, persons_group, persons_group_assignments, prekes_gr, regionalcontents, regionalprices, saskaitupl, serijos, sfd, sfg, tipines_data, tipines_op, turtas, turtas_op, worktimeclasss, specialworktimeitems, worktimesheets, dayworktimes, worktimeitems, warehouses, goods, goodsaccounts, goodscomplexoperations, goodsoperations, goodsvaluationmethods, consignmentdiscards, consignments, accumulativecosts, accumulativecostsitems, holidaypayreserves, holidaypayreserveitems, vatdeclarationentrys, vatdeclarationschemas, payoutnaturalpersonwithouttaxes, proformainvoicemadeitems, proformainvoicesmade, customvatoperations, sharesoperations, sharesclasses, sharesoperationdetails.Iki klaidos atsiradimo nebuvo sukurta nė viena procedūra šioje duomenų bazėje.
SQL serverio klaidos pranešimas yra:


Klaida vykdant SQL komandą: [CREATE FUNCTION apskaita01.CROUND(d DOUBLE, r INT) RETURNS double
BEGIN DECLARE s BIGINT; SET s=FLOOR(d*POW(10,r)); IF (s+0.5>d*POW(10,r)) THEN RETURN s/POW(10,r); END IF; RETURN (s+1)/POW(10,r); END=FLOOR(d*POW(10,r)); IF (s+0.5>d*POW(10,r)) THEN RETURN s/POW(10,r); END IF; RETURN (s+1)/POW(10,r); END], Params:
Klaidos turinys: 'This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)'.
Klaidą sukėlė ši SQL komanda:
CREATE FUNCTION apskaita01.CROUND(d DOUBLE, r INT) RETURNS double
BEGIN DECLARE s BIGINT; SET s=FLOOR(d*POW(10,r)); IF (s+0.5>d*POW(10,r)) THEN RETURN s/POW(10,r); END IF; RETURN (s+1)/POW(10,r); END

SIŪLYTINA ŠIO PRANEŠIMO TEKSTĄ PATEIKTI SISTEMOS ADMINISTRATORIUI.