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 Lite 7

AfterLogic Forum : AfterLogic WebMail Lite 7

Topic: upgrade problem 7.4.2 ==> 7.5

Author

Message

<< Prev Topic | Next Topic >>

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 02 May 2015 at 12:42am \| IP Logged

I have a problem. I did upgrade for instructions. It always worked. Now, after you upgrade to version 7.5 I can not log into the mail. With the message "The username or password you entered is incorrect."
not met with anyone? help

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 02 May 2015 at 12:51am \| IP Logged

Try this.

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 03 May 2015 at 10:21pm \| IP Logged

it looks like that already exist

mysql> ALTER TABLE `awm_accounts` ADD `social_email` VARCHAR( 255 ) NOT NULL ;
ERROR 1060 (42S21): Duplicate column name 'social_email'
mysql>
mysql> ALTER TABLE `awm_identities` ADD `def_identity` BOOLEAN NOT NULL DEFAULT FALSE AFTER `id_acct` ;
ERROR 1060 (42S21): Duplicate column name 'def_identity'

Igor
AfterLogic Support

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

Posted: 04 May 2015 at 2:08am \| IP Logged

It's where standard recommendation applies, then: to find out what's causing the problem, you need to enable debug logging in AdminPanel, make sure log verbosity is set to Debug level, reproduce the problem and check what's in the logs - in particular, look into responses coming from mail server.

--
Regards,
Igor, AfterLogic Support

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 2:21am \| IP Logged

Debug log is here: http://xxx.cz/log-2015-05-04.txt

Igor
AfterLogic Support

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

Posted: 04 May 2015 at 2:26am \| IP Logged

Interesting. I'll request an insight from the developers.

Also, I'd recommend to try setting up a blank 7.5 install next to your existing one and see if that one would work.

--
Regards,
Igor, AfterLogic Support

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 2:40am \| IP Logged

with a clean install, the new database AFTERLOGIC_DB2 it is the same.
Please let me know what you find out something that developers

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 04 May 2015 at 2:48am \| IP Logged

Try setting

Code:

'labs.webmail.display-server-error-information' => true,

in file

Code:

data/settings/config.php

This will display error details directly in the web interface.

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 3:09am \| IP Logged

Unfortunately my mistake in the web interface does not appear. It's always the same: "The username or password you entered is incorrect."

updated log here: http://xxx.cz/log-2015-05-04.txt

I tried both IE and firefox

my config.php:
<?php

$aSieveDomains = array('imap.domain1.com', 'imap.domain2.com');

return array(

        'sieve' => false,
        'sieve.autoresponder' => true,
        'sieve.forward' => true,
        'sieve.filters' => true,
        'sieve.config.host' => '',
        'sieve.config.port' => 2000,
        'sieve.config.filters-folder-charset' => 'utf-8', // [utf7-imap, utf-8]
        'sieve.config.domains' => $aSieveDomains,
        'labs.webmail.display-server-error-information' => true,

        'links.importing-contacts' => 'http://www.afterlogic.com/wiki/Importing_contacts_(WebMail_Lite)'

);

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 04 May 2015 at 3:31am \| IP Logged

Your log:

Code:

[10:05:17.01][4bef3d9a] [POST(7)][ip:XX.XX.XX.XX] /webmail-clear/?/Ajax/

[10:05:17.01][4bef3d9a] POST > [Action, Email, IncLogin, IncPassword, SignMe, AccountID, Token]

[10:05:17.01][4bef3d9a]

[10:05:17.01][4bef3d9a] AJAX: Action: SystemLogin

[10:05:17.01][4bef3d9a] exception 'ProjectSeven\Exceptions\ClientException' with message 'ClientException' in /var/www/html/webmail-clear/libraries/ProjectSeven/Actions.php:2610

My log:

Code:

[10:25:01.92][dc9b4946] [POST(5)][ip:XX.XX.XX.XX] /webmail/?/Ajax/

[10:25:01.92][dc9b4946] POST > [Action, Folders, AccountID, InboxUidnext, Token]

[10:25:01.92][dc9b4946]

[10:25:01.92][dc9b4946] AJAX: Action: FoldersGetRelevantInformation

[10:25:01.92][dc9b4946] DB(PDO/mysql) : start connect to al_mail@localhost

[10:25:01.92][dc9b4946] DB : PDO(mysql:dbname=al_mail7_4;host=localhost;charset=utf8)

[10:25:01.92][dc9b4946] DB : connected to al_mail@localhost

Anyone?

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 4:21am \| IP Logged

I'm grateful for any advice

Toletum
Newbie
Newbie

Joined: 04 May 2015
Location: Spain
Online Status: Offline
Posts: 7

Posted: 04 May 2015 at 4:33am \| IP Logged

Hi!

I had the same problem... the login works in version 7.3.0...., but 7.5.0 doesn't work.

In 7.3.0 the user is just the user (user), but 7.5.0 I had to add the domain (user@domain.com).

So, I had to update the table "awm_accounts" the field "email" adding the domain

Regards,
Toletum

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 5:17am \| IP Logged

in "awm_accounts" is "email"
Name: email Type: VARCHAR Length/Values: 255 Default: As defined: mydomain.cz Collation: utf8_general_ci

it has to be this way or differently? I tried mydomain.cz i @ mydomain.cz I still can not sign :(

Toletum
Newbie
Newbie

Joined: 04 May 2015
Location: Spain
Online Status: Offline
Posts: 7

Posted: 04 May 2015 at 5:21am \| IP Logged

esetman wrote:

in 7.3.0 awm_accounts.email had "myuser"
in 7.5.0 awm_accounts.email has "myuser@mydomain.com"

It is the only change which I had to do

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 5:53am \| IP Logged

Either doing it wrong or it did not work

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 04 May 2015 at 6:21am \| IP Logged

Toletum wrote:

in 7.3.0 awm_accounts.email had "myuser"
in 7.5.0 awm_accounts.email has "myuser@mydomain.com"

It is the only change which I had to do

You do not need to alter the records, just set <UseLoginWithoutDomain> to On or Off in data/settings/settings.xml

Toletum
Newbie
Newbie

Joined: 04 May 2015
Location: Spain
Online Status: Offline
Posts: 7

Posted: 04 May 2015 at 6:59am \| IP Logged

webdbase2 wrote:

You do not need to alter the records, just set <UseLoginWithoutDomain> to On or Off in data/settings/settings.xml

Thanks.. but, I did it...

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 8:36am \| IP Logged

I edit file data/settings/settings.xml this: <UseLoginWithoutDomain>On</UseLoginWithoutDomain>

Still inoperative. The username or password you entered is incorrect.

debug log: http://www.xxx.cz/log.txt

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 04 May 2015 at 8:55am \| IP Logged

And what about the <LoginAtDomainValue> value?

I see there is an exeption thrown at line 2610 of libraries/ProjectSeven/Actions.php and the code arround it is

Code:

$sAtDomain = trim($oSettings->GetConf('WebMail/LoginAtDomainValue'));

  if ((\ELoginFormType::Email === (int) $oSettings->GetConf('WebMail/LoginFormType') || \ELoginFormType::Both === (int) $oSettings->GetConf('WebMail/LoginFormType')) && 0 === strlen($sAtDomain) && 0 < strlen($sEmail) && !\MailSo\Base\Validator::EmailString($sEmail))

   {

          throw new \ProjectSeven\Exceptions\ClientException(\ProjectSeven\Notifications::AuthError);

   }

Toletum
Newbie
Newbie

Joined: 04 May 2015
Location: Spain
Online Status: Offline
Posts: 7

Posted: 04 May 2015 at 9:09am \| IP Logged

webdbase2 wrote:

And what about the <LoginAtDomainValue> value?

I did rollback my awm_accounts.email, now, it just has the username

The param <UseLoginWithoutDomain> doesn't work.... I tried Off and On

But, <LoginAtDomainValue>mydomain.com</LoginAtDomainValue> works

Regards,
Toletum

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 04 May 2015 at 9:15am \| IP Logged

Toletum wrote:

The param <UseLoginWithoutDomain> doesn't work.... I tried Off and On

It works quite fine in my environment.

Code:

<LoginAtDomainValue>my.own.domain</LoginAtDomainValue>

<UseLoginWithoutDomain>On</UseLoginWithoutDomain>

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 10:57am \| IP Logged

If I set <UseLoginWithoutDomain>On</UseLoginWithoutDomain>
So I login as: user@mydomain.com
I want login as only: username
how to set it? previously it worked.

If I set <UseLoginWithoutDomain>Off</UseLoginWithoutDomain>
You can not log in as: user@mydomain.com or: username

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 10:57am \| IP Logged

are there any other options for: <LoginFormType>Email</LoginFormType> ?

esetman
Senior Member

Joined: 25 August 2014
Location: Czech Republic
Online Status: Offline
Posts: 158

Posted: 04 May 2015 at 11:38am \| IP Logged

if I login as user@mydomain.com place only username
as before, so the user lacks contacts. other user settings disappeared
awm_accounts the database is creating a "new" user @ mydomain.com

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 04 May 2015 at 12:36pm \| IP Logged

esetman wrote:

are there any other options for: <LoginFormType>Email</LoginFormType> ?

Login
and that's mine.
Maybe you should read http://afterlogic.com/wiki/Configuring_WebMail_via_settings.xml_file_(WebMail_Pro)

Page of 2 Next >>

Printable version

Forum Jump

.NET Components

ActiveX Components

Web scripts

Solutions

AfterLogic WebMail Lite 7