Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Lite 7
 AfterLogic Forum : AfterLogic WebMail Lite 7
Subject Topic: unable to login as a user in afterlogic Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
kimmi
Newbie
Newbie
Avatar

Joined: 18 October 2011
Location: New Zealand
Online Status: Offline
Posts: 23
Posted: 29 November 2011 at 3:43pm | IP Logged Quote kimmi
hi,when i tried to do my first login as a user i am getting error- Internal server error please contact your system admin; while during installation everything is connected and in hmail server logs it shows user logged in and then suddenly logged out.i tried with different users as well but no luck -i re installed it but still same problem. please help

EDIT- here is the log of mail server-


TCPConnection - Posting AcceptEx on 127.0.0.1:110"
"POP3D"     500     88     "2011-11-28 21:11:27.906"     "127.0.0.1"     "SENT: +OK hello"
"POP3D"     500     88     "2011-11-28 21:11:27.906"     "127.0.0.1"     "RECEIVED: CAPA"
"POP3D"     500     88     "2011-11-28 21:11:27.906"     "127.0.0.1"     "SENT: -ERR Invalid command in current state."
"POP3D"     7712     88     "2011-11-28 21:11:27.937"     "127.0.0.1"     "RECEIVED: AUTH"
"POP3D"     7712     88     "2011-11-28 21:11:27.937"     "127.0.0.1"     "SENT: -ERR Invalid command in current state."
"POP3D"     6796     88     "2011-11-28 21:11:27.968"     "127.0.0.1"     "RECEIVED: USER kimmi@kimmi.local"
"POP3D"     6796     88     "2011-11-28 21:11:27.968"     "127.0.0.1"     "SENT: +OK Send your password"
"POP3D"     6796     88     "2011-11-28 21:11:27.968"     "127.0.0.1"     "RECEIVED: PASS ***"
"POP3D"     6796     88     "2011-11-28 21:11:27.984"     "127.0.0.1"     "SENT: +OK Mailbox locked and ready"
"POP3D"     6796     88     "2011-11-28 21:11:27.984"     "127.0.0.1"     "RECEIVED: STAT"
"POP3D"     6796     88     "2011-11-28 21:11:27.984"     "127.0.0.1"     "SENT: +OK 11 6184"
"POP3D"     6620     88     "2011-11-28 21:11:27.984"     "127.0.0.1"     "RECEIVED: UIDL"
"POP3D"     6620     88     "2011-11-28 21:11:27.984"     "127.0.0.1"     "SENT: +OK 11 messages (6184 octets)[nl]1 1[nl]2 2[nl]3 3[nl]4 4[nl]5 5[nl]6 6[nl]7 7[nl]8 8[nl]9 9[nl]10 10[nl]11 11[nl]."
"POP3D"     7680     88     "2011-11-28 21:11:27.984"     "127.0.0.1"     "RECEIVED: QUIT"




and webmail's log is here-

16:31:12.03] [INFO] Assembly version: 6.0.2.220.
[16:31:12.03] [INFO] Will resolve host "localhost".
[16:31:12.04] [INFO] Host "localhost" resolved to IP address(es) 127.0.0.1.
[16:31:12.04] [INFO] Will connect to host "localhost" on port 110.
[16:31:12.06] [INFO] Socket connected to IP address 127.0.0.1 on port 110.
[16:31:12.09] [RECV] +OK hello\r\n
[16:31:12.09] [INFO] Connected to mail service at host "localhost" on port 110 and ready.
[16:31:12.12] [INFO] Get the list of POP3 capabilities via CAPA command.
[16:31:12.14] [SEND] CAPA\r\n
[16:31:12.14] [RECV] -ERR Invalid command in current state.\r\n
[16:31:12.18] [INFO] Warning: The server does not support CAPA command. POP3 pipelining will not be available. The server responded: -ERR Invalid command in current state..
[16:31:12.20] [INFO] Get the list of advertized SASL authentication methods via AUTH command.
[16:31:12.20] [SEND] AUTH\r\n
[16:31:12.20] [RECV] -ERR Invalid command in current state.\r\n
[16:31:12.23] [INFO] Warning: The server does not support AUTH command. SASL authentication will not be available. The server responded: -ERR Invalid command in current state..
[16:31:12.23] [INFO] Will login as "user@kimmi.local".
[16:31:12.25] [INFO] Will try regular USER/PASS authentication.
[16:31:12.25] [SEND] USER user@kimmi.local\r\n
[16:31:12.25] [RECV] +OK Send your password\r\n
[16:31:12.25] [SEND] PASS ********\r\n
[16:31:15.25] [RECV] +OK Mailbox locked and ready\r\n
[16:31:15.25] [INFO] Logged in as "user@kimmi.local".
[16:31:15.26] [INFO] Download inbox statistics.
[16:31:15.26] [SEND] STAT\r\n
[16:31:15.26] [RECV] +OK 0 0\r\n
[16:31:15.26] [INFO] Download the list of Unique-IDs of all messages in inbox.
[16:31:15.26] [SEND] UIDL\r\n
[16:31:15.26] [RECV] +OK 0 messages (0 octets)\r\n.\r\n
[16:31:15.28] [SEND] QUIT\r\n
[16:31:15.29] [RECV] +OK POP3 server saying goodbye...\r\n
[16:31:15.29] [INFO] Will disconnect from host "localhost".
[16:31:15.29] [INFO] Disconnected from host "localhost".



please reply


Back to Top View kimmi's Profile Search for other posts by kimmi
 
Alex
AfterLogic Support
AfterLogic Support
Avatar

Joined: 19 November 2003
Online Status: Offline
Posts: 2206
Posted: 30 November 2011 at 6:01am | IP Logged Quote Alex
You may uncomment debug logging in web.config and examine the more detailed log file which is produced in debug mode. It may help you find the problem.

Regards,
Alex
Back to Top View Alex's Profile Search for other posts by Alex
 
kimmi
Newbie
Newbie
Avatar

Joined: 18 October 2011
Location: New Zealand
Online Status: Offline
Posts: 23
Posted: 30 November 2011 at 2:25pm | IP Logged Quote kimmi
Thanks Alex for reply
I could not find any debugg logging in web.config i just find a debugg= false line and i tried with set it to true but still there. and i also tried reinstalling it and also with trial version of afterlogic pro as well .same problem and mail server is working good with roundcube i can send and recieve mails properly so problem is with afterlogic only. please suggest me what to do,any help will be appreciated,


Thanks
kimmi
Back to Top View kimmi's Profile Search for other posts by kimmi
 
Alex
AfterLogic Support
AfterLogic Support
Avatar

Joined: 19 November 2003
Online Status: Offline
Posts: 2206
Posted: 01 December 2011 at 2:49am | IP Logged Quote Alex
Uncomment this:
<!--add name="MyListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="C:\temp\webmail6.log"/-->

so, it'll look like:
<add name="MyListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="C:\temp\webmail6.log"/>

Make sure the app has permission to write to the specified location, or modify the path to the writable destination.

regards,
Alex
Back to Top View Alex's Profile Search for other posts by Alex
 
kimmi
Newbie
Newbie
Avatar

Joined: 18 October 2011
Location: New Zealand
Online Status: Offline
Posts: 23
Posted: 11 December 2011 at 4:08pm | IP Logged Quote kimmi
hi Alex,

this is the fresh log of afterlogic webmail lite asp.net version after uncommenting the line you told me.

16:25:39.56] [INFO] Assembly version: 6.0.2.220.
[16:25:39.56] [INFO] Will resolve host "localhost".
[16:25:44.57] [INFO] Assembly version: 6.0.2.220.
[16:25:44.57] [INFO] Will resolve host "localhost".
[16:35:49.96] [INFO] Assembly version: 6.0.2.220.
[16:35:49.96] [INFO] Will resolve host "localhost".
[16:38:34.59] [INFO] Assembly version: 6.0.2.220.
[16:38:34.59] [INFO] Will resolve host "localhost".
[16:38:39.59] [INFO] Assembly version: 6.0.2.220.
[16:38:39.59] [INFO] Will resolve host "localhost".
[16:52:05.01] [INFO] Assembly version: 6.0.2.220.
[16:52:05.01] [INFO] Will resolve host "localhost".
[16:52:21.20] [INFO] Assembly version: 6.0.2.220.
[16:52:21.20] [INFO] Will resolve host "localhost".
[16:52:31.78] [INFO] Assembly version: 6.0.2.220.
[16:52:31.78] [INFO] Will resolve host "localhost".
[16:57:44.85] [INFO] Assembly version: 6.0.2.220.
[16:57:44.85] [INFO] Will resolve host "localhost".
[16:57:51.23] [INFO] Assembly version: 6.0.2.220.
[16:57:51.23] [INFO] Will resolve host "localhost".
[17:00:11.00] [INFO] Assembly version: 6.0.2.220.
[17:00:11.00] [INFO] Will resolve host "localhost".


this is the only log i am recieving after every try to login i am stil having the same error message every time i try to login.i am surprised because this is working perfectly fine on my local machine but on vps its not letting me login strange please help me its so many days now,roundcube is working fine on same machine with hmail server problem is only with this i really want to use this please help

thanks kimmi
Back to Top View kimmi's Profile Search for other posts by kimmi
 
kimmi
Newbie
Newbie
Avatar

Joined: 18 October 2011
Location: New Zealand
Online Status: Offline
Posts: 23
Posted: 11 December 2011 at 4:40pm | IP Logged Quote kimmi
and again i re installed it with a new database everything fresh, still same error when try to login -Internal server error, please contacr your network admin. here is the fresh log of afterlogic-

[17:30:54.40] [INFO] Assembly version: 6.0.2.220.
[17:30:54.40] [INFO] Will resolve host "localhost".
[17:30:54.40] [INFO] Host "localhost" resolved to IP address(es) 127.0.0.1.
[17:30:54.40] [INFO] Will connect to host "localhost" on port 110.
[17:30:54.42] [INFO] Socket connected to IP address 127.0.0.1 on port 110.
[17:30:54.46] [RECV] +OK hello\r\n
[17:30:54.46] [INFO] Connected to mail service at host "localhost" on port 110 and ready.
[17:30:54.48] [INFO] Get the list of POP3 capabilities via CAPA command.
[17:30:54.50] [SEND] CAPA\r\n
[17:30:54.50] [RECV] -ERR Invalid command in current state.\r\n
[17:30:54.56] [INFO] Warning: The server does not support CAPA command. POP3 pipelining will not be available. The server responded: -ERR Invalid command in current state..
[17:30:54.56] [INFO] Get the list of advertized SASL authentication methods via AUTH command.
[17:30:54.56] [SEND] AUTH\r\n
[17:30:54.56] [RECV] -ERR Invalid command in current state.\r\n
[17:30:54.59] [INFO] Warning: The server does not support AUTH command. SASL authentication will not be available. The server responded: -ERR Invalid command in current state..
[17:30:54.59] [INFO] Will login as "user@user.local".
[17:30:54.60] [INFO] Will try regular USER/PASS authentication.
[17:30:54.60] [SEND] USER user@user.local\r\n
[17:30:54.60] [RECV] +OK Send your password\r\n
[17:30:54.60] [SEND] PASS ********\r\n
[17:30:54.62] [RECV] +OK Mailbox locked and ready\r\n
[17:30:54.62] [INFO] Logged in as "user@user.local".
[17:30:54.62] [INFO] Download inbox statistics.
[17:30:54.62] [SEND] STAT\r\n
[17:30:54.62] [RECV] +OK 14 8015\r\n
[17:30:54.62] [INFO] Download the list of Unique-IDs of all messages in inbox.
[17:30:54.62] [SEND] UIDL\r\n
[17:30:54.62] [RECV] +OK 14 messages (8015 octets)\r\n1 1\r\n2 2\r\n3 3\r\n4 4\r\n5 5\r\n6 6\r\n7 7\r\n8 8\r\n9 9\r\n10 10\r\n11 11\r\n12 12\r\n13 13\r\n14 14\r\n.\r\n
[17:30:54.65] [SEND] QUIT\r\n
[17:30:54.65] [RECV] +OK POP3 server saying goodbye...\r\n
[17:30:54.65] [INFO] Will disconnect from host "localhost".
[17:30:54.65] [INFO] Disconnected from host "localhost"
Back to Top View kimmi's Profile Search for other posts by kimmi
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 11 December 2011 at 9:35pm | IP Logged Quote Igor
Looks like you are looking at the different log file. WebMail Pro ASP.NET offers two types of logging, one log is about email-related operations (the one you're quoting) while the other log is enabled in web.config, and you can specify any path for the log file there, just make sure that location is writable by web server.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
kimmi
Newbie
Newbie
Avatar

Joined: 18 October 2011
Location: New Zealand
Online Status: Offline
Posts: 23
Posted: 12 December 2011 at 7:03pm | IP Logged Quote kimmi

Hi i found these logs please see




WebMail Version: 5.1.3
[12/12/2011 7:46:16 PM][] - >>>>>>>>>>>>>>>> IN >>>>>>>>>>>>>>>>
[12/12/2011 7:46:16 PM][] - <?xml version="1.0" encoding="utf-8"?><webmail><param name="action" value="login" /><param name="request" value="" /><param name="email"><![CDATA[user@user.local]]></param><param name="mail_inc_login"><![CDATA[]]></param><param name="mail_inc_pass"><![CDATA[******]]></param><param name="mail_inc_host"><![CDATA[localhost]]></param><param name="mail_inc_port" value="110"/><param name="mail_protocol" value="0"/><param name="mail_out_host"><![CDATA[localhost]]></param><param name="mail_out_port" value="25"/><param name="mail_out_auth" value="1"/><param name="sign_me" value="0"/><param name="language"><![CDATA[]]></param><param name="advanced_login" value="0"/></webmail>
[12/12/2011 7:46:16 PM][] - >>>>>>>>>>>>>>>> IN >>>>>>>>>>>>>>>>
[12/12/2011 7:46:17 PM][PrepareCommand] - SET NAMES utf8
[12/12/2011 7:46:17 PM][CreateParameter] - @name='user@local'
[12/12/2011 7:46:17 PM][PrepareCommand] - SELECT * FROM my_awm_domains WHERE name=?
[12/12/2011 7:46:18 PM][PrepareCommand] - SET NAMES utf8
[12/12/2011 7:46:18 PM][PrepareCommand] - SELECT account.id_domain, account.id_acct, account.id_user, account.def_acct,
account.deleted, account.email, account.mail_protocol, account.mail_inc_host, account.mail_inc_login,
account.mail_inc_pass, account.mail_inc_port, account.mail_out_host, account.mail_out_login,
account.mail_out_pass, account.mail_out_port, account.mail_out_auth, account.friendly_nm,
account.use_friendly_nm, account.def_order, account.getmail_at_login, account.mail_mode,
account.mails_on_server_days, account.signature, account.signature_type, account.signature_opt,
account.delimiter, account.mailbox_size, account.mailing_list, account.imap_quota, account.namespace,
domains.mail_protocol AS domain_mail_protocol, domains.mail_inc_host AS domain_mail_inc_host,
domains.mail_inc_port AS domain_mail_inc_port, domains.mail_out_host AS domain_mail_out_host,
domains.mail_out_port AS domain_mail_out_port, domains.mail_out_auth AS domain_mail_out_auth
FROM my_awm_accounts AS account
LEFT JOIN my_awm_domains AS domains ON (account.id_domain = domains.id_domain)
WHERE email LIKE 'user@user.local' AND mailing_list=0
[12/12/2011 7:46:18 PM][POP3 Connect] - 'localhost' - '110'
[12/12/2011 7:46:18 PM][POP3 Connect] - IsConnected - 'False'
[12/12/2011 7:46:19 PM][POP3 Connect] - IsConnected - 'True'
[12/12/2011 7:46:19 PM][POP3 Login] - 'user@user.local' - '******'
[12/12/2011 7:46:19 PM][POP3 Login] - IsLogined - 'False'
[12/12/2011 7:46:19 PM][POP3 Login] - IsLogined - 'True'
[12/12/2011 7:46:20 PM][PrepareCommand] - SET NAMES utf8
[12/12/2011 7:46:20 PM][PrepareCommand] -
SELECT COUNT(my_a_users.id_user) FROM my_a_users
INNER JOIN my_awm_settings ON (my_a_users.id_user = my_awm_settings.id_user)
WHERE deleted = 0
------------------------------------------------------------
[12/12/2011 7:46:20 PM] ERROR!!!
[Message]
Arithmetic operation resulted in an overflow.
[TargetSite]
System.Data.Odbc.TypeMap GetSqlType(Int32)
[Stack Trace]
   at System.Data.Odbc.OdbcDataReader.GetSqlType(Int32 i)
   at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
   at System.Data.Odbc.OdbcCommand.ExecuteScalar()
   at WebMail.DbManager.GetUsersCountNotDel()
[Method]: GetSqlType
[Line, Column]: [0, 0]
------------------------------------------------------------
[12/12/2011 7:46:20 PM] ERROR!!!
[Message]
Internal Server Error. Please, contact your system administrator in order to report the problem.
[TargetSite]
System.Data.Odbc.TypeMap GetSqlType(Int32)
[Stack Trace]
   at System.Data.Odbc.OdbcDataReader.GetSqlType(Int32 i)
   at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
   at System.Data.Odbc.OdbcCommand.ExecuteScalar()
   at WebMail.DbManager.GetUsersCountNotDel()
[Method]: GetUsersCountNotDel
[Line, Column]: [0, 0]
Back to Top View kimmi's Profile Search for other posts by kimmi
 
Superia
Newbie
Newbie


Joined: 12 December 2011
Location: United Kingdom
Online Status: Offline
Posts: 3
Posted: 14 December 2011 at 12:19am | IP Logged Quote Superia
This might be a permissions problem, make sure that the webmail user accounts have write permissions to the webmail folder.
Back to Top View Superia's Profile Search for other posts by Superia
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 14 December 2011 at 1:32pm | IP Logged Quote Igor
Thanks for log, developers will look into it. Will keep you posted.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
kimmi
Newbie
Newbie
Avatar

Joined: 18 October 2011
Location: New Zealand
Online Status: Offline
Posts: 23
Posted: 14 December 2011 at 3:53pm | IP Logged Quote kimmi
Superia wrote:
This might be a permissions problem, make sure that the webmail user accounts have write permissions to the webmail folder.


Hi Superia,

I tried with giving full permisions to webmail user accounts but of no use same error ,

and Igor please give me updates what could be the problem?

thanks
kimmi
Back to Top View kimmi's Profile Search for other posts by kimmi
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 19 December 2011 at 1:53am | IP Logged Quote Igor
Can you please let us know what database engine you're using?

If you try running the following database query directly:

Code:
SELECT COUNT(my_a_users.id_user) FROM my_a_users
INNER JOIN my_awm_settings ON (my_a_users.id_user = my_awm_settings.id_user)
WHERE deleted = 0


what is the result?

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
kimmi
Newbie
Newbie
Avatar

Joined: 18 October 2011
Location: New Zealand
Online Status: Offline
Posts: 23
Posted: 20 December 2011 at 3:15pm | IP Logged Quote kimmi
HI ,

I am using mysql and after running this query on database webmail(afterlogic's database) this is the result -


Show query box

Your SQL query has been executed successfully
SELECT COUNT( my_a_users.id_user )
FROM my_a_users
INNER JOIN my_awm_settings ON ( my_a_users.id_user = my_awm_settings.id_user )
WHERE deleted =0 Profiling [Inline][ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]



+ Options
Partial texts
Full texts
Show binary contents
Show BLOB contents
Show binary contents as HEXHide Browser transformation
COUNT(my_a_users.id_user)
0



Query results operations Print view Print view (with full texts) Export


thanks
kimmi
Back to Top View kimmi's Profile Search for other posts by kimmi
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide