| Author |
|
kekeati
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
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| 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
|
| Back to Top |
|
| |
kekeati
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">< ]></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>
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| 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
|
| Back to Top |
|
| |
kekeati
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)
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| 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
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: The error without description occured
Privacy policy |
Refund policy