Tax.lt narys Computantis

Tax.lt narys nuo
2019-10-28
Computantis
forume parašė 5 žinučių

Computantis naujausios žinutės:

2019-11-05 10:04 Programinė įranga » Nemokama apskaitos programa » #1418135
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==
2019-10-28 21:39 Programinė įranga » Nemokama apskaitos programa » #1418002

Niemand rašė:



Computantis rašė:


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ą:



Išjunkite binary logging serveryje.



Išjungėme lyg ir (žemiau), bet ta pati klaida...
2019-10-28 13:16 Programinė įranga » Nemokama apskaitos programa » #1417990

Niemand rašė:



Computantis rašė:


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



Yra, tam specialus įrankis yra, ten pat, kur programa instaliuota. Vartotojo vadove aprašytas naudojimas.


Taip, naudojuosi AccMigration.exe, bet išmeta klaidos pranešimą: prisegu failą.
2019-10-28 13:02 Programinė įranga » Nemokama apskaitos programa » #1417986
Ar yra galimybė iš neservesinės Apskaita5 duomenų bazę įsikelti į "serverinę" Apskaita5?
2019-10-28 12:19 Programinė įranga » Nemokama apskaitos programa » #1417979
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.



Diskusijos

Kas prisijungęs?

Tu esi neprisijungęs vartotojas
Prisijungti arba registruotis

Atmintinė

Atmintinė buhalteriui
Delspinigiai už ne laiku sumokėtus mokesčius ir baudas 2017 m. IV ketv. 0.03 proc
Palūkanos už naudojimąsi mokestine paskola 2017 m. I ketv. 0.01 proc
Valstybinio socialinio draudimo bazinė pensija
nuo 2018-01-01
152.92 EUR
Draudžiamosios pajamos
nuo 2018-01-01
476 EUR
Minimalus valandinis atlygis ir minimali mėnesinė alga (MMA)
nuo 2018-01-01
2,45 EUR ir 400 EUR