Not Able To Send Mail
9 posts
• Page 1 of 1
Not Able To Send Mail
by sachin » Thu Dec 22, 2016 9:06 am
I am added my account(gmail) as create account.Account was added successfully.But when I send mail to specific user it's give me following error
- Attachments
-
- Images Are Disable
- MailError.png (16.18 KiB) Viewed 731 times
- sachin
- Posts: 8
- Joined: Sat Nov 05, 2016 6:23 am
Re: Not Able To Send Mail
by Maxim » Thu Dec 22, 2016 12:27 pm
Hello Sachin!
Send us (support@onlyoffice.com with link to that topic in subject or body) please logs if you have docker version on /app/onlyoffice/CommunityServer/logs/ or /var/log/onlyoffice/ in Linux version.
Send us (support@onlyoffice.com with link to that topic in subject or body) please logs if you have docker version on /app/onlyoffice/CommunityServer/logs/ or /var/log/onlyoffice/ in Linux version.
- Maxim
- Posts: 912
- Joined: Tue Oct 11, 2016 2:34 pm
Re: Not Able To Send Mail
by sachin » Fri Dec 23, 2016 7:13 am
I am using Windows 8.1,My SQL 5.7.14,Microsoft Windows Server 2012,Microsoft .NET Framework 4.5,IIS 8,Visual Studio 2012
I also attached Log File Here .Please Find Attachment.
I also attached Log File Here .Please Find Attachment.
- Code: Select all
2016-12-23 12:19:32,465 ERROR [9] ASC.Web - Page is not avaliable by url http://localhost/tariffs.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:19:32,731 ERROR [5] ASC.Web - Page is not avaliable by url http://localhost/wizard.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:19:32,903 ERROR [15] ASC.Web - Page is not avaliable by url http://localhost/products/crm/tasks.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:19:32,623 ERROR [16] ASC.Web - Page is not avaliable by url http://localhost/products/projects/projecttemplates.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:21:21,625 ERROR [9] ASC.Web - Page is not avaliable by url http://localhost/products/files/default.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:21:21,786 ERROR [15] ASC.Web - Page is not avaliable by url http://localhost/products/projects/contacts.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:21:21,625 ERROR [16] ASC.Web - Page is not avaliable by url http://localhost/products/projects/reports.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:21:22,101 ERROR [5] ASC.Web - Page is not avaliable by url http://localhost/auth.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:23:05,983 ERROR [9] ASC.Web - Page is not avaliable by url http://localhost/products/crm/cases.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:23:06,315 ERROR [15] ASC.Web - Page is not avaliable by url http://localhost/products/projects/default.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
2016-12-23 12:23:06,428 ERROR [16] ASC.Web - Page is not avaliable by url http://localhost/products/projects/tasks.aspx?warmup=true
System.Net.WebException: The operation has timed out
at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)
at System.Net.WebClient.DownloadData(Uri address)
at System.Net.WebClient.DownloadData(String address)
at ASC.Web.Studio.Core.WarmUp.MakeRequest(String requestUrl) in d:\ZITIMA\sachin\Projects\OnlyOffice\CommunityServer-master\web\studio\ASC.Web.Studio\Core\WarmUp.cs:line 322
- sachin
- Posts: 8
- Joined: Sat Nov 05, 2016 6:23 am
Re: Not Able To Send Mail
by sachin » Fri Dec 23, 2016 9:48 am
Hello,
Maxim
Here I Attached Web.api.log File Code.Please Find It.
Maxim
Here I Attached Web.api.log File Code.Please Find It.
- Code: Select all
2016-11-07 11:34:49,732 ERROR [16] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=642542 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:37:44,533 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/mail/accounts.json?__=369845 - Server error
System.Exception: <span class="attempt_header">POP3 response:</span><br/>Authentication failed.
<span class="attempt_header">SMTP response:</span><br/>Authentication failed.
at ASC.Api.Mail.MailApi.CreateAccount(String name, String email, String account, String password, Int32 port, String server, String smtp_account, String smtp_password, Int32 smtp_port, String smtp_server, Boolean smtp_auth, Boolean imap, Boolean restrict, EncryptionType incoming_encryption_type, EncryptionType outcoming_encryption_type, SaslMechanism auth_type_in, SaslMechanism auth_type_smtp)
2016-11-07 11:42:00,671 ERROR [18] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=79418 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:48:53,861 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=958826 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:51:39,134 ERROR [16] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=411568 - Server error
System.Exception: #1:<br><span class="attempt_header">IMAP response:</span><br/>Invalid credentials (Failure)<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>#2:<br><span class="attempt_header">POP3 response:</span><br/>Authentication failed.<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:54:04,787 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=295605 - Server error
System.Exception: #1:<br><span class="attempt_header">IMAP response:</span><br/>Invalid credentials (Failure)<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>#2:<br><span class="attempt_header">POP3 response:</span><br/>Authentication failed.<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 11:59:58,841 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=653506 - Server error
System.Exception: #1:<br><span class="attempt_header">IMAP response:</span><br/>Invalid credentials (Failure)<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>#2:<br><span class="attempt_header">POP3 response:</span><br/>Authentication failed.<br><span class="attempt_header">SMTP response:</span><br/>Authentication failed.<br>
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-07 12:38:14,886 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/people.json?__=108768 - Server error
System.Exception: Member with this email is already registered
at ASC.Web.Studio.Core.Users.UserManagerWrapper.AddUser(UserInfo userInfo, String password, Boolean afterInvite, Boolean notify, Boolean isVisitor, Boolean fromInviteLink, Boolean makeUniqueName)
at ASC.Api.Employee.EmployeeApi.AddMember(Boolean isVisitor, String email, String firstname, String lastname, Guid[] department, String title, String location, String sex, ApiDateTime birthday, ApiDateTime worksfrom, String comment, IEnumerable`1 contacts, String files)
2016-11-08 15:20:49,658 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=167349 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:20:56,340 ERROR [21] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=144593 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:01,478 ERROR [21] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=143658 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:05,926 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=623934 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:10,390 ERROR [10] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=941972 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:15,956 ERROR [8] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=275735 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:19,986 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=116578 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:24,343 ERROR [8] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=423388 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:28,524 ERROR [25] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=981794 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-08 15:21:32,514 ERROR [8] ASC.Api - method error: http://localhost/api/2.0/project/1/task.json?__=831564 - Server error
MySql.Data.MySqlClient.MySqlException (0x80004005): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.core_subscriptionmethod.tenant' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql)
at ASC.Core.Data.DbSubscriptionService.GetSubscriptionMethods(Int32 tenant, String sourceId, String actionId, String recipientId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubsciptionsStore(Int32 tenant, String sourceId, String actionId)
at ASC.Core.Caching.CachedSubscriptionService.GetSubscription(Int32 tenant, String sourceId, String actionId, String recipientId, String objectId)
at ASC.Core.SubscriptionManager.IsUnsubscribe(String sourceID, String recipientID, String actionID, String objectID)
at ASC.Core.Notify.DirectSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Notify.Model.TopSubscriptionProvider.IsUnsubscribe(IDirectRecipient recipient, INotifyAction action, String objectID)
at ASC.Projects.Engine.ProjectEntityEngine.IsUnsubscribed(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.ProjectEntityEngine.Subscribe(ProjectEntity entity, Guid recipientID)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible, Boolean isImport)
at ASC.Projects.Engine.TaskEngine.SaveOrUpdate(Task task, IEnumerable`1 attachedFileIds, Boolean notifyResponsible)
at ASC.Api.Projects.ProjectApi.AddProjectTask(Int32 projectid, String description, ApiDateTime deadline, TaskPriority priority, String title, Int32 milestoneid, IEnumerable`1 responsibles, Boolean notify, ApiDateTime startDate)
2016-11-09 15:01:04,195 WARN [5] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:04,281 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=426970 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:06,116 WARN [9] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:06,116 ERROR [9] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=426970&__=426970 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:06,158 WARN [9] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:06,158 ERROR [9] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=426970&__=426970&__=426970 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:38,196 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:38,196 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=779628 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:38,317 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:38,317 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=779628&__=779628 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:38,353 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:38,353 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=779628&__=779628&__=779628 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:44,893 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:44,893 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/case/filter.json?startIndex=0&count=25&sortBy=title&sortOrder=ascending&__=860260 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:44,981 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:44,981 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/case/filter.json?startIndex=0&count=25&sortBy=title&sortOrder=ascending&__=860260&__=860260 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:45,045 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:45,045 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/case/filter.json?startIndex=0&count=25&sortBy=title&sortOrder=ascending&__=860260&__=860260&__=860260 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:52,411 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:52,411 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=442471 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:52,515 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:52,515 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=442471&__=442471 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-09 15:01:52,731 WARN [19] ASC.Api - Product crm denied for user Administrator
2016-11-09 15:01:52,732 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/crm/invoice/filter.json?startIndex=0&count=25&sortBy=number&sortOrder=descending&__=442471&__=442471&__=442471 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-11-11 11:44:08,667 ERROR [17] ASC.Api - method error: http://localhost/api/2.0/files/4.json?__=810978 - Server error
System.InvalidOperationException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.d.folder_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ---> MySql.Data.MySqlClient.MySqlException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.d.folder_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, String sql, Object[] parameters)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command)
at ASC.Common.Data.DataExtensions.ExecuteList(IDbCommand command, ISqlInstruction sql, ISqlDialect dialect)
at ASC.Common.Data.DbManager.ExecuteList(ISqlInstruction sql)
at ASC.Files.Core.Data.FolderDao.GetFolder(Object folderId)
at ASC.Files.Thirdparty.ProviderDao.ProviderFolderDao.GetFolder(Object folderId)
at ASC.Web.Files.Services.WCFService.FileStorageServiceController.GetFolderItems(String parentId, Int32 from, Int32 count, FilterType filter, OrderBy orderBy, String ssubject, String searchText)
--- End of inner exception stack trace ---
at ASC.Web.Files.Services.WCFService.FileStorageServiceController.GetFolderItems(String parentId, Int32 from, Int32 count, FilterType filter, OrderBy orderBy, String ssubject, String searchText)
at ASC.Api.Documents.DocumentsApi.ToFolderContentWrapper(Object folderId, Guid userIdOrGroupId, FilterType filterType)
at ASC.Api.Documents.DocumentsApi.GetFolder(String folderId, Guid userIdOrGroupId, FilterType filterType)
2016-11-11 11:48:31,601 ERROR [10] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=85873 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-11-11 12:52:36,637 ERROR [10] ASC.Api - method error: http://localhost/api/2.0/people.json?__=68209 - Server error
System.Exception: Member with this email is already registered
at ASC.Web.Studio.Core.Users.UserManagerWrapper.AddUser(UserInfo userInfo, String password, Boolean afterInvite, Boolean notify, Boolean isVisitor, Boolean fromInviteLink, Boolean makeUniqueName)
at ASC.Api.Employee.EmployeeApi.AddMember(Boolean isVisitor, String email, String firstname, String lastname, Guid[] department, String title, String location, String sex, ApiDateTime birthday, ApiDateTime worksfrom, String comment, IEnumerable`1 contacts, String files)
2016-12-22 10:59:11,584 ERROR [14] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=601779 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:00:42,751 ERROR [14] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=820329 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:00:54,619 ERROR [14] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=521085 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:00:57,356 ERROR [26] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=257108 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:00:59,585 ERROR [26] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=772516 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:01:01,636 ERROR [26] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=598017 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:03:00,839 ERROR [29] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=924703 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 11:06:16,289 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=45959 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 12:01:41,747 ERROR [26] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=862518 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 12:46:57,941 ERROR [9] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=391272 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 13:02:36,935 ERROR [20] ASC.Api - method error: http://localhost/api/2.0/mail/accounts/simple.json?__=331058 - Server error
System.Exception: Unknown mail provider settings.
at ASC.Api.Mail.MailApi.CreateAccountSimple(String email, String password)
2016-12-22 13:06:21,356 ERROR [5] ASC.Api - method error: http://localhost/api/2.0/mail/accounts.json?__=711716 - Server error
System.Exception: <span class="attempt_header">SMTP response:</span><br/>Authentication failed.
at ASC.Api.Mail.MailApi.CreateAccount(String name, String email, String account, String password, Int32 port, String server, String smtp_account, String smtp_password, Int32 smtp_port, String smtp_server, Boolean smtp_auth, Boolean imap, Boolean restrict, EncryptionType incoming_encryption_type, EncryptionType outcoming_encryption_type, SaslMechanism auth_type_in, SaslMechanism auth_type_smtp)
2016-12-22 13:25:51,285 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/mail/folders.json?__=71764 - Server error
System.TimeoutException: Timeout in IO operation
at MySql.Data.MySqlClient.TimedStream.StopTimer()
at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read)
at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at ASC.Common.Data.DbManager.OpenConnection()
at ASC.Common.Data.DbManager.get_Command()
at ASC.Common.Data.DbManager.ExecuteNonQuery(ISqlInstruction sql)
at ASC.Mail.Aggregator.MailBoxManager.UpdateUserActivity(Int32 tenant, String user, Boolean userOnline)
at ASC.Api.Mail.MailApi.GetFolders()
2016-12-22 14:53:55,075 WARN [51] ASC.Api - Product mail denied for user Administrator
2016-12-22 14:53:55,137 ERROR [51] ASC.Api - method error: http://localhost/api/2.0/mail/folders.json?__=292335 - Server error
System.Web.HttpException (0x80004005): Forbidden
2016-12-22 15:37:51,899 WARN [49] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:37:52,946 WARN [5] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:38:10,349 WARN [43] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:38:48,346 WARN [43] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:39:11,600 WARN [42] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:39:38,092 WARN [51] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:40:08,718 WARN [46] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:40:38,259 WARN [45] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:41:08,007 WARN [41] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:41:37,913 WARN [15] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:42:07,805 WARN [42] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:42:37,865 WARN [19] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:43:07,783 WARN [44] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:43:38,503 WARN [5] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:44:07,686 WARN [15] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:44:08,108 WARN [41] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:44:08,265 WARN [19] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:44:42,970 WARN [5] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:45:08,626 WARN [15] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:45:40,549 WARN [5] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:46:07,964 WARN [39] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:46:38,090 WARN [51] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
2016-12-22 15:47:07,958 WARN [45] ASC.Api - ASC cookie auth failed with cookie=r6sg7EakkDKQgkzirxiKyUiA/irPCQ1n7eK/IUz3FrGuk9RwCPLcVnANf6f6ewFfCStAZ7brgE1PtEnVTI3Jn3mVybAzIYHqsLXzV6+5/eB+Hj8ov38V3cpJA+Elg41x
- sachin
- Posts: 8
- Joined: Sat Nov 05, 2016 6:23 am
Re: Not Able To Send Mail
by Maxim » Fri Dec 23, 2016 11:55 am
Hello!
1 There are no settings for mail provider
2 "2016-12-22 13:25:51,285 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/mail/folders.json?__=71764 - Server error
System.TimeoutException: Timeout in IO operation" Problems with Database.
3 What are you trying to do? It's very interesting for me ))))))
1 There are no settings for mail provider
2 "2016-12-22 13:25:51,285 ERROR [19] ASC.Api - method error: http://localhost/api/2.0/mail/folders.json?__=71764 - Server error
System.TimeoutException: Timeout in IO operation" Problems with Database.
3 What are you trying to do? It's very interesting for me ))))))
- Maxim
- Posts: 912
- Joined: Tue Oct 11, 2016 2:34 pm
Re: Not Able To Send Mail
by sachin » Fri Dec 23, 2016 1:43 pm
Hello,
Maxim
1) All Other Functionality Like Add Project,Add People,Calendar Are Working Fine.So I Think My Database Working Properly ..
2) I All Ready Set Smtp Setting For Mail Services And I also Test It (Using Send Test Mail). It's Working Fine ...
Please Can You Tall Me What is Problem With Mail Services?
Maxim
1) All Other Functionality Like Add Project,Add People,Calendar Are Working Fine.So I Think My Database Working Properly ..
2) I All Ready Set Smtp Setting For Mail Services And I also Test It (Using Send Test Mail). It's Working Fine ...
Please Can You Tall Me What is Problem With Mail Services?
- sachin
- Posts: 8
- Joined: Sat Nov 05, 2016 6:23 am
Re: Not Able To Send Mail
by Maxim » Wed Dec 28, 2016 9:48 am
Hello!
I saw your post.....do you still have problems with mail server?
I saw your post.....do you still have problems with mail server?
- Maxim
- Posts: 912
- Joined: Tue Oct 11, 2016 2:34 pm
Re: Not Able To Send Mail
by sachin » Fri Dec 30, 2016 10:29 am
Thaks,For Replay Maxim
Yes,I Have Still Problem With Mail Server.I Checked Console In Browser When I Was Click On Send Button In Mailbox .Here I attached Screenshot Please Find It.
Yes,I Have Still Problem With Mail Server.I Checked Console In Browser When I Was Click On Send Button In Mailbox .Here I attached Screenshot Please Find It.
- Attachments
-
- Error_Image.png (104.09 KiB) Viewed 635 times
- sachin
- Posts: 8
- Joined: Sat Nov 05, 2016 6:23 am
9 posts
• Page 1 of 1
Who is online
Users browsing this forum: Exabot [Bot] and 1 guest