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: install v8

Author

Message

<< Prev Topic | Next Topic >>

esetman
Senior Member

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

Posted: 11 April 2018 at 4:42am \| IP Logged

Hello,
how do I install version 8?
I downloaded the package https://afterlogic.org/download/webmail-lite-php-8.zip
there is no directory here: adminpanel and install
For version 7, these directories were.

Igor
AfterLogic Support

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

Posted: 11 April 2018 at 4:49am \| IP Logged

That's not a WebMail Pro package, what you need is https://afterlogic.com/download/webmail-pro-php.zip

In v8, there's no separate login page for AdminPanel, main page is used. By default, login is superadmin, password is empty. While the product doesn't offer installer anymore, you can run compatibility test to check whether system requirements are met - just add ?install to WebMail URL.

The following pages may be helpful:

--
Regards,
Igor, Afterlogic Support

esetman
Senior Member

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

Posted: 11 April 2018 at 11:21am \| IP Logged

Thank you. I'm still asking. Can v7 and v8 run simultaneously on server? for testing?
The new version also uses the mysql database? Version 8 uses the same database like v7?

Regards,
Michal

schwim
Valued Community Member

Joined: 21 November 2017
Location: United States
Online Status: Offline
Posts: 49

Posted: 11 April 2018 at 7:31pm \| IP Logged

I've run both versions on the same server and domain. Just use a different database for each. There is a migration script you can run to import v7 into v8 once you're done testing.

esetman
Senior Member

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

Posted: 11 April 2018 at 11:25pm \| IP Logged

I created a new test database: AFTERLOGIC_DBv8
I started the script: dev/migrate.php
An error is displayed:

Delete tables before moving
Move tables from p7 DB to p8 DB
-----------------------------------------------
Error during migration process. For more detail see log-file

in debug logging:
[06:22:00.33][96922767] [POST(4)][ip:xx.xx.xx.xx] /webmail-new/?/Api/
[06:22:00.33][96922767] POST > [Module, Method, TenantName, Parameters]
[06:22:00.33][96922767]
[06:22:00.33][96922767] API: LogsViewerWebclient::GetLog

Is there any other log file?

esetman
Senior Member

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

Posted: 11 April 2018 at 11:46pm \| IP Logged

In file migration-log-2018-04-12.txt

[06:45:00.50][36cf8602] Delete tables from P8 DB: DROP TABLE IF EXISTS `au_adav_addressbookchanges`,
                        `au_adav_addressbooks`,
                        `au_adav_cache`,
                        `au_adav_calendarchanges`,
                        `au_adav_calendarobjects`,
                        `au_adav_calendars`,
                        `au_adav_calendarshares`,
                        `au_adav_calendarsubscriptions`,
                        `au_adav_cards`,
                        `au_adav_groupmembers`,
                        `au_adav_locks`,
                        `au_adav_principals`,
                        `au_adav_propertystorage`,
                        `au_adav_reminders`,
                        `au_adav_schedulingobjects`^M
[06:45:00.50][36cf8602] Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_addressbooks' already exists^M
[06:45:00.50][36cf8602] Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'addressbooks' already exists^

esetman
Senior Member

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

Posted: 12 April 2018 at 12:18am \| IP Logged

if I delete table adav_addressbooks and addressbooks
DROP TABLE adav_addressbooks;
DROP TABLE addressbooks;

I run the script: dev/migrate.php
other errors will show in log:
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_addressbooks' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'cache' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_cache' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'calendarobjects' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_addressbooks' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_calendarobjects' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'calendars' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_addressbooks' already exists

That's all over again.
But I had a new database created. This should not happen?

esetman
Senior Member

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

Posted: 12 April 2018 at 12:38am \| IP Logged

I create new database. I adminpanel put button Create tables.
I run the script: dev/migrate.php
very much errors:

Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_addressbooks' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'addressbooks' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'cache' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_cache' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'calendarobjects' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_calendarobjects' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'calendars' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_calendars' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'calendarshares' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_calendarshares' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'cards' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_cards' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'groupmembers' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_groupmembers' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'locks' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_locks' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'principals' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_principals' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'reminders' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'adav_reminders' already exists
Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'calendars' already exists

All I removed everything manually
DROP TABLE adav_addressbooks;
DROP TABLE addressbooks;
DROP TABLE cache;
DROP TABLE adav_cache;
DROP TABLE calendarobjects;
DROP TABLE adav_calendarobjects;
DROP TABLE adav_calendars;
DROP TABLE calendarshares;
DROP TABLE adav_calendarshares;
DROP TABLE cards;
DROP TABLE adav_cards;
DROP TABLE groupmembers;
DROP TABLE adav_groupmembers;
DROP TABLE locks;
DROP TABLE adav_locks;
DROP TABLE principals;
DROP TABLE adav_principals;
DROP TABLE reminders;
DROP TABLE adav_reminders;
DROP TABLE calendars;

I run the script: dev/migrate.php
Error during upgrade DB process. Failed migration from a pre-2.0 database to 2.0.

Igor
AfterLogic Support

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

Posted: 12 April 2018 at 1:50am \| IP Logged

Please try an updated script you can download from here. Be sure to delete tables from the database to be used by v8, run Create Tables, and run the script.

--
Regards,
Igor, Afterlogic Support

esetman
Senior Member

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

Posted: 12 April 2018 at 2:03am \| IP Logged

Hi Igor,
I removed database. Created a new.
In webmail I gave: Create tables
Then I run a new migrate.php

log:

[09:02:04.66][1b5f5913] P8 tables list before upgrade: au_adav_addressbookchanges, au_adav_addressbooks, au_adav_cache, au_adav_calendarchanges, au_adav_calendarobjects, au_adav_calendars, au_adav_calendarshares, au_adav_calendarsubscriptions, au_adav_cards, au_adav_groupmembers, au_adav_locks, au_adav_principals, au_adav_propertystorage, au_adav_reminders, au_adav_schedulingobjects, au_adav_users, au_eav_attributes_bool, au_eav_attributes_datetime, au_eav_attributes_double, au_eav_attributes_int, au_eav_attributes_mediumblob, au_eav_attributes_string, au_eav_attributes_text, au_eav_entities, au_min_hashes
[09:02:05.50][1b5f5913] Delete tables from P8 DB: DROP TABLE IF EXISTS `au_adav_addressbookchanges`,
                                 &n bsp;`a u_adav _addressbooks`,
                                 &n bsp;`a u_adav _cache`,
                                 &n bsp;`a u_adav _calendarchanges`,
                                 &n bsp;`a u_adav _calendarobjects`,
                                 &n bsp;`a u_adav _calendars`,
                                 &n bsp;`a u_adav _calendarshares`,
                                 &n bsp;`a u_adav _calendarsubscriptions`,
                                 &n bsp;`a u_adav _cards`,
                                 &n bsp;`a u_adav _groupmembers`,
                                 &n bsp;`a u_adav _locks`,
                                 &n bsp;`a u_adav _principals`,
                                 &n bsp;`a u_adav _propertystorage`,
                                 &n bsp;`a u_adav _reminders`,
                                 &n bsp;`a u_adav _schedulingobjects`
[09:02:14.89][1b5f5913] DAV tables was renamed.
[09:02:15.01][1b5f5913] Error during upgrade DB process. Failed migration from a pre-2.0 database to 2.0.

Igor
AfterLogic Support

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

Posted: 12 April 2018 at 2:59am \| IP Logged

Looks like there's a need to use an alternative migration approach, we've just had it documented at:

https://afterlogic.com/docs/webmail-pro-8/installation/migration-from-v7

Check the section called "Alternative migration approach".

--
Regards,
Igor, Afterlogic Support

esetman
Senior Member

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

Posted: 12 April 2018 at 3:40am \| IP Logged

Upgrade to 2.0 schema completed.
Upgrade to 2.1 schema completed.
Upgrade to 3.0 schema completed.

run: migrate.php?pass=223344&skip_sabredav_migrate

[10:38:02.80][23c2aed9] POST > []
[10:38:02.80][23c2aed9]
[10:38:02.80][23c2aed9] P8 tables list before upgrade: addressbookchanges, addressbooks, au_adav_addressbookchanges, au_adav_addressbooks, au_adav_cache, au_adav_calendarchanges, au_adav_calendarobjects, au_adav_calendars, au_adav_calendarshares, au_adav_calendarsubscriptions, au_adav_cards, au_adav_groupmembers, au_adav_locks, au_adav_principals, au_adav_propertystorage, au_adav_reminders, au_adav_schedulingobjects, au_adav_users, au_eav_attributes_bool, au_eav_attributes_datetime, au_eav_attributes_double, au_eav_attributes_int, au_eav_attributes_mediumblob, au_eav_attributes_string, au_eav_attributes_text, au_eav_entities, au_min_hashes, cache, calendarchanges, calendarobjects, calendars, calendarshares, calendarsubscriptions, cards, groupmembers, locks, principals, propertystorage, propertystorage_old6588, reminders, schedulingobjects
[10:38:02.80][23c2aed9] Error during upgrade DB process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'au_adav_addressbooks' already exists

Igor
AfterLogic Support

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

Posted: 12 April 2018 at 5:49am \| IP Logged

Try to remove these tables in v8 database manually:

Code:

au_adav_addressbookchanges,

au_adav_addressbooks,

au_adav_cache,

au_adav_calendarchanges,

au_adav_calendarobjects,

au_adav_calendars,

au_adav_calendarshares,

au_adav_calendarsubscriptions,

au_adav_cards,

au_adav_groupmembers,

au_adav_locks,

au_adav_principals,

au_adav_propertystorage,

au_adav_reminders,

au_adav_schedulingobjects

After that run migration.php with 'skip_sabredav_migrate' key.

--
Regards,
Igor, Afterlogic Support

esetman
Senior Member

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

Posted: 12 April 2018 at 6:37am \| IP Logged

Now it was all right. Will migrate.php be integrated into the new version?
He noticed that v8 adminpan is missing the option to disable the user from logging in to webmail. Do not you add this feature?

Can you disable (hide) for all users: calendar, files, tasks?
Just forbid someone, maybe not? Globally, could it possibly go?

Igor
AfterLogic Support

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

Posted: 12 April 2018 at 6:57am \| IP Logged

Quote:

Will migrate.php be integrated into the new version?

Yes, sure.

Quote:

He noticed that v8 adminpan is missing the option to disable the user from logging in to webmail. Do not you add this feature?

V8 was a rewrite from scratch, for now we've implemented the most critical features - we'll be adding most of the features from v7 eventually.

Quote:

Can you disable (hide) all users, calendar, files, tasks?
Just forbid someone, maybe not? Globally, could it possibly go?

It cannot be currently done on per-user level, but you can disable certain features globally. In data/settings/modules directory, locate configuration file of the module you need to disable, edit it and set Disabled to true there.

For the majority of the features, there are client and backend modules, and it's recommended to disable both. For Calendar, it's CalendarWebclient.config.json and Calendar.config.json files; configuration files for Contacts and Files are called the same way.

--
Regards,
Igor, Afterlogic Support

esetman
Senior Member

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

Posted: 03 May 2018 at 11:53pm \| IP Logged

Hi Igor,
I testing new build 8.1.13-build-a3.
The standard migration process still fails

[05:58:44.02][d6c623e0] P8 tables list before upgrade: addressbooks, au_adav_users, au_eav_attributes_bool, au_eav_attributes_datetime, au_eav_attributes_double, au_eav_attributes_int, au_eav_attributes_mediumblob, au_eav_attributes_string, au_eav_attributes_text, au_eav_entities, au_min_hashes, cache, calendarobjects, calendars, calendarshares, cards, groupmembers, locks, principals, reminders^M
[05:58:44.05][d6c623e0] Delete tables from P8 DB: DROP TABLE IF EXISTS `au_adav_addressbookchanges`,
                                `au_adav _addressbooks`,
                                `au_adav _cache`,
                                `au_adav _calendarchanges`,
                                `au_adav _calendarobjects`,
                                `au_adav _calendars`,
                                `au_adav _calendarshares`,
                                `au_adav _calendarsubscriptions`,
                                `au_adav _cards`,
                                `au_adav _groupmembers`,
                                `au_adav _locks`,
                                `au_adav _principals`,
                                `au_adav _propertystorage`,
                                `au_adav _reminders`,
                                `au_adav _schedulingobjects`^M
[05:58:44.06][d6c623e0] P8 tables list after delete operation: addressbooks, au_adav_users, au_eav_attributes_bool, au_eav_attributes_datetime, au_eav_attributes_double, au_eav_attributes_int, au_eav_attributes_mediumblob, au_eav_attributes_string, au_eav_attributes_text, au_eav_entities, au_min_hashes, cache, calendarobjects, calendars, calendarshares, cards, groupmembers, locks, principals, reminders^M
[05:58:51.63][d6c623e0] Error during rename tables process. SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'addressbooks' already exists^M

Again, I had to do a manual process: Alternative migration approach
Why does not this process happen automatically?

when do you add all the features and skins in v8 as they were in version 7?

esetman
Senior Member

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

Posted: 04 May 2018 at 12:41am \| IP Logged

I found a bug in the mobile version. If I click on contacts. Contacts are loaded. Then, when you tap a contact, contact the @ icon. A new message is displayed to the user. It's OK. If I click on <- (Back), I'm back to the contact. I will again <- (back). All contacts are displayed. It's OK. Now that I click on the gear and select "Mail", a list of emails should be loaded. It does not work anymore. A new message appears.

Igor
AfterLogic Support

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

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

Quote:

I had to do a manual process: Alternative migration approach
Why does not this process happen automatically?

This is specific to SabreDAV upgrade scripts which are designed to be run from console only. In most cases, it would still work just fine from web browser, but depending on PHP configuration it sometimes fails and needs to be done from console.

Quote:

when do you add all the features and skins in v8 as they were in version 7?

We plan to port all the skins from v7 within this month. As for the features, they will be moved on an on-demand basis, particularly based on results from feature requests at https://afterlogic.uservoice.com/.

Quote:

I found a bug in the mobile version. If I click on contacts.
...
It does not work anymore. A new message appears.

Confirmed and reported it to the developers, thank you.

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