Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Lite 7

 AfterLogic Forum : AfterLogic WebMail Lite 7
Subject Topic: MySql Database isn’t being updated Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
silentpond
Newbie
Newbie


Joined: 16 March 2013
Online Status: Offline
Posts: 36
Posted: 19 October 2015 at 1:04am | IP Logged Quote silentpond

I'm using AfterLogic Lite 7.0.2 (PHP) version and not willing to go for an updated version.

Any change in account details from cPanel isn't effecting the MySql database. I'm unable to login to email accounts for the same reason.

Is there any file missing there in the package that is causing the trouble? it's a lengthy process for me to check the files one by one.

Thanks,
Back to Top View silentpond's Profile Search for other posts by silentpond
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 19 October 2015 at 4:03am | IP Logged Quote Igor

Not sure if I understand the problem. What's the exact error you're getting when attempting to log into your email account? And what's recorded in the logs on that?

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
silentpond
Newbie
Newbie


Joined: 16 March 2013
Online Status: Offline
Posts: 36
Posted: 19 October 2015 at 4:39am | IP Logged Quote silentpond

When I attempt to login with correct username and password, I get the following message:

WARNING/LOGIN_PASS_INCORRECT

In admin panel, when debug logging is enabled and Verbosity is selected to "error" mode I view the following message "Log file can't be read"

It seems that the webmail is unable to manipulate data from MySql database in any ways. Any update or change in account setting (ie, new account creation, password change and account deletion, etc.) in cPanel's "Email Account" option doesn't effect or update AfterLogic's database.

Thanks,
Back to Top View silentpond's Profile Search for other posts by silentpond
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 19 October 2015 at 4:42am | IP Logged Quote Igor

Quote:
When I attempt to login I get the following message:

WARNING/LOGIN_PASS_INCORRECT


Be sure to delete all the files and subdirectories under data/cache/ directory, that might help.

Quote:
In admin panel, when debug logging is enabled and Verbosity is selected to "error" mode I view the following message "Log file can't be read"


That's usually caused by insufficient write permissions over the data directory, make sure it's set recursively writable for web server.

Please keep in mind that upgrading is done at your own risk, setting up a blank installation is strongly recommended.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
silentpond
Newbie
Newbie


Joined: 16 March 2013
Online Status: Offline
Posts: 36
Posted: 19 October 2015 at 5:05am | IP Logged Quote silentpond

I cleared all files in data/cache/.

Still I get the message

WARNING/LOGIN_PASS_INCORRECT

during any attempt to login with correct username and password.

Although the permission of data directory is set to 0755 error log displays the message "Log file can't be read"

I realize that at this moment the webmail application on apache server has no interaction with it's MySql database.

Thanks,
Back to Top View silentpond's Profile Search for other posts by silentpond
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 19 October 2015 at 7:44am | IP Logged Quote Igor

0755 permissions might be not enough, try setting 0777 and see if that helps. Also, make sure you set the permissions recursively.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
silentpond
Newbie
Newbie


Joined: 16 March 2013
Online Status: Offline
Posts: 36
Posted: 20 October 2015 at 4:19am | IP Logged Quote silentpond

When I test database connection from admin panel I receive the message "Connected Successfully"

I chmod the the directory "data" recursively without any luck. Still there isn't any interaction between the webmail application and the database.

In fact the problem started suddenly after I updated the version number without any other change.

What could be the other possible reasons of such inactivity?

Thanks,
Back to Top View silentpond's Profile Search for other posts by silentpond
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 20 October 2015 at 4:24am | IP Logged Quote Igor

I really don't think this is related to the database. Prior to checking account data on the database level, authentication on IMAP is performed - and most likely, that's where the problem is, and that's why we need the logs.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
silentpond
Newbie
Newbie


Joined: 16 March 2013
Online Status: Offline
Posts: 36
Posted: 20 October 2015 at 4:35am | IP Logged Quote silentpond

After every login attempt, in debug mode the log returns the following message which isn't related to email account login:

[11:30:10.62] [POST(5)] /adminpanel/index.php?submit
[11:30:10.62] POST > [form_id, ch_EnableDebugLogging, selVerbosity, ch_EnableUserActivityLogging, submit_btn]
[11:30:10.62]
[11:30:10.62] Location: index.php

[11:30:11.73] /adminpanel/index.php
[11:30:11.73]
[11:30:11.73] call CWebMailModule->PopulateData->ServicesLogging()

[11:30:21.10] /adminpanel/index.php?pop&type=log&action=view
[11:30:21.10]
[11:30:21.10] call CWebMailModule->StandardPopAction->Services()

In "error", "warning" and "specified user" modes the log returns:

Log file can't be read

Thanks,

Back to Top View silentpond's Profile Search for other posts by silentpond
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 20 October 2015 at 4:41am | IP Logged Quote Igor

No clue really, seems like something is wrong on webserver level, client side of the application doesn't seem to perform any server-level operation at all. Checking web server logs might help.

I would recommend to set up a blank copy of the latest WebMail release on the same server, next to the existing install, using a separate database, and see if that one works. It should allow for determining whether there's a problem with WebMail application itself or with the upgraded install.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
silentpond
Newbie
Newbie


Joined: 16 March 2013
Online Status: Offline
Posts: 36
Posted: 20 October 2015 at 5:50am | IP Logged Quote silentpond

I realize that but during installation After Logic's common setting page displays that everything is up and running though PDO, pdo_sqlite, pdo_mysql and suhosin are unable to initialize on my server (Now I see that in error_log) and this is what keeps me away from checking the application server's error log.

Anyway, I pointed out the following error there related to webmail application

PHP Fatal error: Maximum execution time of 30 seconds exceeded in /home/user/public_html/webmail/libraries/MailSo/Base/LinkFinder.php on line 176

I'm checking these with my host.

Thanks,

Back to Top View silentpond's Profile Search for other posts by silentpond
 
silentpond
Newbie
Newbie


Joined: 16 March 2013
Online Status: Offline
Posts: 36
Posted: 21 October 2015 at 11:19am | IP Logged Quote silentpond

After resolving server issues I deleted all the database tables and import fresh set of tables to MySql database. That solves the problem.

During installation AfterLogic's common setting page doesn't display any error because, though PDO, pdo_sqlite, pdo_mysql and suhosin were installed on my server those had conflicting modules with the PHP module.

Thanks,
Back to Top View silentpond's Profile Search for other posts by silentpond
 

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