| Author |
|
cloughit
Newbie
Joined: 23 September 2022
Location: Australia
Online Status: Offline
Posts: 2
|
| Posted: 29 September 2022 at 12:16am | IP Logged
|
|
|
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 |
|
| |
cloughit
Newbie
Joined: 23 September 2022
Location: Australia
Online Status: Offline
Posts: 2
|
| Posted: 29 September 2022 at 12:24am | IP Logged
|
|
|
Nevermind, as usual, just needed to create a forum post so i could figure it out 5 seconds later. FML...
|
| 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: Database settings not working
Privacy policy |
Refund policy