Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Lite
 AfterLogic Forum : AfterLogic WebMail Lite
Subject Topic: Database settings not working Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
cloughit
Newbie
Newbie
Avatar

Joined: 23 September 2022
Location: Australia
Online Status: Offline
Posts: 2
Posted: 29 September 2022 at 12:16am | IP Logged Quote cloughit
Hi,

Name: Afterlogic WebMail Lite PHP
Version: 9.6.0.build16-build-a3

Compatibility test check out fine:

Module: Core

PHP version: OK
Safe Mode is off: OK
PDO MySQL Extension: OK
MySQL Native Driver (mysqlnd): OK
Iconv Extension: OK
Multibyte String Extension: OK
CURL Extension: OK
JSON Extension: OK
XML/DOM Extension: OK
GD Extension: OK
Sockets: OK
SSL (OpenSSL extension): OK
Setting memory limits: OK
Setting script timeout: OK
WebMail data directory: Found
Creating/deleting directories: OK
Creating/deleting files: OK
WebMail Settings File: Found
Read/write settings file: OK / OK

After entering Database settings and saving and then clicking Test Connection receive error:

Please make sure your PHP/MySQL environment meets the minimal system requirements.

Database details are 100% correct. I can create a basic PHP file and connect using the same database settings.

Enabled logging, tried again, here are results of log:

[07:00:57.25][bb924535]
[07:00:57.25][bb924535] ===== API: Core::TestDbConnection
[07:00:57.26][bb924535] Exception: ApiException
[07:00:57.26][bb924535] @Time: 0.0067
[07:00:57.26][bb924535] @TimeApiInit: 0.0983
[07:00:57.26][bb924535] INFO[MEMORY]: Memory peak usage: 12MB
[07:00:57.26][bb924535] INFO[TIME]: Time delta: 1664434857.264
[07:01:04.27][5059a453]
[07:01:04.27][5059a453] ===== API: LogsViewerWebclient::GetUsersWithSeparateLog
[07:01:04.28][5059a453] Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.au_core_users' doesn't exist (SQL: select * from `au_core_users` where `WriteSeparateLog` = 1 and not exists (select * from `au_core_groups` inner join `au_core_group_user` on `au_core_groups`.`Id` = `au_core_group_user`.`GroupId` where `au_core_users`.`Id` = `au_core_group_user`.`UserId`) order by `PublicId` asc)
[07:01:04.28][5059a453] @Time: 0.0087
[07:01:04.28][5059a453] @TimeApiInit: 0.0934
[07:01:04.28][5059a453] INFO[MEMORY]: Memory peak usage: 12MB
[07:01:04.28][5059a453] INFO[TIME]: Time delta: 1664434864.2819
[07:01:04.33][4e35f7ac]
[07:01:04.33][4e35f7ac] ===== API: LogsViewerWebclient::GetLogFilesData
[07:01:04.33][4e35f7ac] @Time: 0.0031
[07:01:04.33][4e35f7ac] @TimeApiInit: 0.0946
[07:01:04.33][4e35f7ac] INFO[MEMORY]: Memory peak usage: 12MB
[07:01:04.33][4e35f7ac] INFO[TIME]: Time delta: 1664434864.333
[07:01:06.13][5cf852c0]
[07:01:06.13][5cf852c0] ===== API: LogsViewerWebclient::GetLogFile

The log doesn't show any errors around connection that stand out. It does show that it is trying to perform a query and the tables don't exist, which at this point is correct. So moving on I click Create/Update Tables. New log:

[07:09:39.54][93436361] @Time: 0.0036
[07:09:39.54][93436361] @TimeApiInit: 0.0901
[07:09:39.54][93436361] INFO[MEMORY]: Memory peak usage: 12MB
[07:09:39.54][93436361] INFO[TIME]: Time delta: 1664435379.5456
[07:09:41.45][c8f968ed]
[07:09:41.45][c8f968ed] ===== API: LogsViewerWebclient::GetLogFilesData
[07:09:41.45][c8f968ed] @Time: 0.0031
[07:09:41.45][c8f968ed] @TimeApiInit: 0.0818
[07:09:41.45][c8f968ed] INFO[MEMORY]: Memory peak usage: 12MB
[07:09:41.45][c8f968ed] INFO[TIME]: Time delta: 1664435381.4527
[07:09:46.58][5d748c2c]
[07:09:46.58][5d748c2c] ===== API: LogsViewerWebclient::GetLogFilesData
[07:09:46.58][5d748c2c] @Time: 0.0032
[07:09:46.58][5d748c2c] @TimeApiInit: 0.0799
[07:09:46.58][5d748c2c] INFO[MEMORY]: Memory peak usage: 12MB
[07:09:46.58][5d748c2c] INFO[TIME]: Time delta: 1664435386.5855
[07:09:49.60][0e02c473]
[07:09:49.60][0e02c473] ===== API: Core::CreateTables
[07:09:49.61][0e02c473] Exception: ApiException
[07:09:49.61][0e02c473] Exception: ApiException
[07:09:49.61][0e02c473] @Time: 0.0053
[07:09:49.61][0e02c473] @TimeApiInit: 0.0952
[07:09:49.61][0e02c473] INFO[MEMORY]: Memory peak usage: 12MB
[07:09:49.61][0e02c473] INFO[TIME]: Time delta: 1664435389.6124
[07:09:56.20][c5fff282]
[07:09:56.20][c5fff282] ===== API: LogsViewerWebclient::GetUsersWithSeparateLog
[07:09:56.21][c5fff282] Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.au_core_users' doesn't exist (SQL: select * from `au_core_users` where `WriteSeparateLog` = 1 and not exists (select * from `au_core_groups` inner join `au_core_group_user` on `au_core_groups`.`Id` = `au_core_group_user`.`GroupId` where `au_core_users`.`Id` = `au_core_group_user`.`UserId`) order by `PublicId` asc)
[07:09:56.21][c5fff282] @Time: 0.0078
[07:09:56.21][c5fff282] @TimeApiInit: 0.0934
[07:09:56.21][c5fff282] INFO[MEMORY]: Memory peak usage: 12MB
[07:09:56.21][c5fff282] INFO[TIME]: Time delta: 1664435396.2131
[07:09:56.24][19c6fdbb]
[07:09:56.24][19c6fdbb] ===== API: LogsViewerWebclient::GetLogFilesData
[07:09:56.25][19c6fdbb] @Time: 0.0037
[07:09:56.25][19c6fdbb] @TimeApiInit: 0.0847
[07:09:56.25][19c6fdbb] INFO[MEMORY]: Memory peak usage: 12MB
[07:09:56.25][19c6fdbb] INFO[TIME]: Time delta: 1664435396.2511
[07:10:01.31][07a10757]
[07:10:01.31][07a10757] ===== API: LogsViewerWebclient::GetLogFile

Above was using an existing database (database_name substituted for actual for security) but have also tried with a brand new database and user with same results.

Have tried with Host = 127.0.0.1 and Host = localhost

Can't seem to get past this step in configuration. Hoping someone can please shed some light or offer suggestions. Thank you.
Back to Top View cloughit's Profile Search for other posts by cloughit
 
cloughit
Newbie
Newbie
Avatar

Joined: 23 September 2022
Location: Australia
Online Status: Offline
Posts: 2
Posted: 29 September 2022 at 12:24am | IP Logged Quote cloughit
Nevermind, as usual, just needed to create a forum post so i could figure it out 5 seconds later. FML...
Back to Top View cloughit's Profile Search for other posts by cloughit
 
Sco2004
Newbie
Newbie


Joined: 12 March 2025
Online Status: Offline
Posts: 10
Posted: 12 March 2025 at 12:48pm | IP Logged Quote Sco2004
cloughit wrote:
Nevermind, as usual, just needed to create a forum post so i could figure it out 5 seconds later. FML...


Hi! How did you solve it finally?)) I have exactly same issue.
Back to Top View Sco2004's Profile Search for other posts by Sco2004
 
MichaelJack
Newbie
Newbie
Avatar

Joined: 22 September 2025
Location: Aruba
Online Status: Offline
Posts: 2
Posted: 22 September 2025 at 4:44am | IP Logged Quote MichaelJack
Sco2004 wrote:
cloughit wrote:
Nevermind, as usual, just needed to create a forum post so i could figure it out 5 seconds later. FML...


Hi! How did you solve it finally?)) I have exactly same issue.


Give DB user full privileges (CREATE, ALTER, DROP).

Use InnoDB as storage engine.

Disable strict SQL modes if enabled.

If installer fails, import schema .sql file manually.

Enable "debug": true in config.json for detailed logs.
Back to Top View MichaelJack's Profile Search for other posts by MichaelJack Visit MichaelJack's Homepage
 
harveybenjamin
Newbie
Newbie
Avatar

Joined: 26 October 2025
Online Status: Offline
Posts: 1
Posted: 26 October 2025 at 9:46pm | IP Logged Quote harveybenjamin
Hi there,

That error usually means the installation process can’t create the required database tables — even though your connection credentials are valid. In Afterlogic WebMail Lite PHP, this often happens when:

The MySQL user doesn’t have full CREATE TABLE or ALTER permissions.

The database prefix (like au_) conflicts with an existing setup.

PHP’s open_basedir or permission settings restrict the app from executing SQL schema files.

Try these steps:

Verify that your MySQL user has all privileges (CREATE, ALTER, DROP, INDEX).

In data/settings/config.json, double-check the "DbPrefix" setting — you can try leaving it empty.

Manually create the tables by running the SQL script from /data/sql/mysql.initial.sql in your database.

Then re-run the setup wizard or clear cache before testing again.

Once that’s sorted, you should see the tables like au_core_users appear automatically.

By the way, if you’re into testing your reflexes after debugging sessions, you might like mr flip — a fun arcade game where you guide a tiny character jumping between platforms with perfect timing. It’s simple but dangerously addictive — a nice way to reset your brain after hours of staring at log files!
Back to Top View harveybenjamin's Profile Search for other posts by harveybenjamin
 

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