MAILBEE POP3 SMTP WEBMAIL IMAP4 POP IMAP EMAIL COMPONENT VB ASP ACTIVEX COM VBA OCX NET .NET C# VB.NET ASP.NET DOWNLOAD QUEUE SSL SECURITY CENSOR ACCESS PARSER C++ DLL CONTROL LIBRARY MIME INTERFACE

AfterLogic WebMail Pro

AfterLogic Forum : AfterLogic WebMail Pro

Topic: The error without description occured

Author

Message

<< Prev Topic | Next Topic >>

kekeati
Newbie
Newbie

Joined: 10 March 2010
Online Status: Offline
Posts: 3

Posted: 10 March 2010 at 12:51pm \| IP Logged

I installed WebMail Lite 4.8.13 for php and MySQL. Installation and configuration seemed to go fine. Test connection to database succeeds and database tables have been created.

When any user attempts to login, no matter the Login Settings chosen in the admin interface, they get "The error without description occured".

The debug log shows the information entered on the login screen is in the CDATA but these values don't seem to be used in the sql queries. Further, the users aren't added to the tables on initial login.

What am I missing?

Ken

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6089

Posted: 11 March 2010 at 3:16am \| IP Logged

Could you show us the part of the log file which refers to login failure? You can send us the log file privately via HelpDesk if you like.

--
Regards,
Igor, AfterLogic Support

kekeati
Newbie
Newbie

Joined: 10 March 2010
Online Status: Offline
Posts: 3

Posted: 11 March 2010 at 5:18am \| IP Logged

I'm not sure how easy this will be to read, but here is an entry from the log file with our private information xxx'd out.

[11/03/2010][08:09:43.708] INFORMATION:
   > [POST(1)] /afterlogic/processing.php
   > ver.4.8.13 [SERVER-IP:xxx.xxx.xxx.xxx][USER-IP:xxx.xxx.xxx.xxx]
   > PHP-5.2.1, Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.7d DAV/2 PHP/5.2.1
[08:09:43.709] <<<[client_xml]<<<
<?_xml version="1.0" encoding="utf-8"?><webmail><param name="action" value="login" /><param name="request" value="" /><param name="email"><![CDATA[]]></param><param name="mail_inc_login"><![CDATA

]></param><param name="mail_inc_pass"><![CDATA

]></param><param name="mail_inc_host"><![CDATA[xxx.xxx.xxx.xxx]]></param><param name="mail_inc_port" value="993"/><param name="mail_protocol" value="1"/><param name="mail_out_host"><![CDATA[xxx.xxx.xxx.xxx]]></param><param name="mail_out_port" value="25"/><param name="mail_out_auth" value="0"/><param name="sign_me" value="0"/><param name="language"><![CDATA[]]></param><param name="advanced_login" value="0"/></webmail>
[08:09:43.767] :: connection time -> 0.0019221305847168
[08:09:43.769] Do: CProcessingSwitch->DoLogin
[08:09:43.791] MySQL Query: SELECT id_acct, id_user, mail_inc_pass, def_acct
                           FROM awm_accounts
                           WHERE email = '' AND mailing_list = 0 AND mail_inc_login = '' AND def_acct = 1
[08:09:43.799] MySQL Query: SELECT id_acct, acct.id_user as id_user, def_acct, deleted, email, mail_protocol,
                                 mail_inc_host, mail_inc_login, mail_inc_pass, mail_inc_port, mail_out_host,
                                 mail_out_login, mail_out_pass, mail_out_port, mail_out_auth, friendly_nm,
                                 use_friendly_nm, def_order,     getmail_at_login, mail_mode, mails_on_server_days,
                                 signature_type, signature_opt, delimiter,
                                 msgs_per_page, white_listing, x_spam, last_login, logins_count,     def_skin,
                                 def_lang, def_charset_inc, def_charset_out, def_timezone, def_date_fmt,
                                 hide_folders, mailbox_limit, mailbox_size, id_domain, mailing_list,
                                 allow_change_settings, allow_dhtml_editor, allow_direct_mode, hide_contacts, db_charset,
                                 horiz_resizer, vert_resizer, mark, reply, contacts_per_page, view_mode, imap_quota
                           FROM awm_accounts AS acct
                           INNER JOIN awm_settings AS sett ON acct.id_user = sett.id_user
                           WHERE id_acct = 1 AND mailing_list = 0
[08:09:43.809] MySQL Query: SELECT id_acct, signature FROM awm_accounts WHERE id_acct = 1
[08:09:43.810] MySQL Query: SELECT id_column, column_value FROM awm_columns WHERE id_user = 1
[08:09:43.811] MySQL Query: SELECT deleted FROM a_users WHERE id_user = 1
[08:09:43.816] >>>[server_xml]>>>
<?_xml version="1.0" encoding="utf-8"?><webmail><error><![CDATA[]]></error></webmail>

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6089

Posted: 11 March 2010 at 6:20am \| IP Logged

Thank you.

The most interesting thing about this log is:

Code:

WHERE email = '' AND mailing_list = 0 AND mail_inc_login = '' AND def_acct = 1

Is this exactly how it was in the log file, or you've stripped email / username for privacy reasons?

--
Regards,
Igor, AfterLogic Support

kekeati
Newbie
Newbie

Joined: 10 March 2010
Online Status: Offline
Posts: 3

Posted: 11 March 2010 at 8:07am \| IP Logged

No, that's exactly how it occurred. The only information I stripped was replaced with 'xxx'.

It seemed odd to me as well. Maybe I'm not understanding something. Do I need to add users into the database before they can log in or is that done automatically the first time they log in?

I have tried to log in with several different accounts, but in the database if I do a 'select * from awm_accounts' there is only 1 entry (with email=''):

mysql> select * from awm_accounts;
+---------+---------+----------+---------+-------+---------- -----+---------------+----------------+---------------+----- ----------+---------------+----------------+---------------+ ---------------+---------------+-------------+-------------- ---+-----------+------------------+-----------+------------- ---------+-----------+----------------+---------------+----- ------+--------------+-----------+--------------+----------- -+
| id_acct | id_user | def_acct | deleted | email | mail_protocol | mail_inc_host | mail_inc_login | mail_inc_pass | mail_inc_port | mail_out_host | mail_out_login | mail_out_pass | mail_out_port | mail_out_auth | friendly_nm | use_friendly_nm | def_order | getmail_at_login | mail_mode | mails_on_server_days | signature | signature_type | signature_opt | delimiter | mailbox_size | id_domain | mailing_list | imap_quota |
+---------+---------+----------+---------+-------+---------- -----+---------------+----------------+---------------+----- ----------+---------------+----------------+---------------+ ---------------+---------------+-------------+-------------- ---+-----------+------------------+-----------+------------- ---------+-----------+----------------+---------------+----- ------+--------------+-----------+--------------+----------- -+
| 1 | 1 | 1 | 0 | | &nbs p; &nbs p;1 | ; | ; | ; | 993 | ; | ; | ; | ; 25 | ; 0 | ; | 1 | 0 | ; 1 | 1 | ; 7 | | ; 1 | ; 0 | | &nbs p; 0 | 0 | ; 0 | ;0 |
+---------+---------+----------+---------+-------+---------- -----+---------------+----------------+---------------+----- ----------+---------------+----------------+---------------+ ---------------+---------------+-------------+-------------- ---+-----------+------------------+-----------+------------- ---------+-----------+----------------+---------------+----- ------+--------------+-----------+--------------+----------- -+
1 row in set (0.00 sec)

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6089

Posted: 16 March 2010 at 3:44am \| IP Logged

Lite version does not require adding accounts, those should be added on login provided that corresponding IMAP/POP3 account exists.

The only thing we can suggest at the moment is to try installing the Pro version, either 30-days trial or 5 users license would do. In case if the issue persists in the Pro version as well, we'll need you to send AdminPanel access over HelpDesk to let us help you on this.

--
Regards,
Igor, AfterLogic Support

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

Printable version

Forum Jump

.NET Components

ActiveX Components

Web scripts

Solutions

AfterLogic WebMail Pro