Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Lite 7
 AfterLogic Forum : AfterLogic WebMail Lite 7
Subject Topic: Webmail not working with PostgreSQL Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
aseering
Newbie
Newbie
Avatar

Joined: 11 January 2015
Location: United States
Online Status: Offline
Posts: 2
Posted: 11 January 2015 at 7:22pm | IP Logged Quote aseering
Hi all,
    I'm trying to set up AfterLogic Webmail Lite. I would prefer to use PostgreSQL; I already use it for other things. I just tried downloading and installing it; the installer works fine, and I can log into the administrative interface; but when I log into the regular webmail interface, I get directed to a blank page. (The body of the HTML document consists of exactly one character, a newline.)

    No useful errors that I can immediately see. The debug log reads as follows:

Quote:

[03:07:05.44][9a44eaed] DB(PDO/postgresql) : start connect to afterlogic@localhost
[03:07:05.44][9a44eaed] DB : PDO(pgsql:dbname=afterlogic_db;host=localhost)
[03:07:05.50][9a44eaed] DB : connected to afterlogic@localhost
[03:07:05.50][9a44eaed] DB[1] > SELECT id_acct FROM awm_accounts WHERE def_acct = 1 AND id_user = 1
[03:07:05.51][9a44eaed] DB[2] > SELECT "id_acct", "id_user", "id_domain", "id_tenant", "deleted", "def_acct", "mailing_list", "quota", "email", "friendly_nm", "mail_protoco
l", "mail_inc_host", "mail_inc_port", "mail_inc_login", "mail_inc_pass", "mail_inc_ssl", "mail_out_host", "mail_out_port", "mail_out_login", "mail_out_pass", "mail_out_auth
", "mail_out_ssl", "hide_in_gab", "signature", "signature_type", "signature_opt", "custom_fields" FROM awm_accounts WHERE "id_acct" = 1
[03:07:05.53][9a44eaed] DB[3] > SELECT "id_user", "id_subscription", "id_helpdesk_user", "msgs_per_page", "contacts_per_page", "auto_checkmail_interval", "created_time", "l
ast_login", "last_login_now", "logins_count", "def_skin", "def_lang", "def_editor", "save_mail", "layout", "incoming_charset", "def_timezone", "def_time_fmt", "def_date_fmt
", "client_timezone", "question_1", "question_2", "answer_1", "answer_2", "sip_enable", "sip_impi", "sip_password", "twilio_number", "twilio_enable", "twilio_default_number
", "use_threads", "save_replied_messages_to_current_folder", "desktop_notifications", "allow_change_input_direction", "allow_helpdesk_notifications", "enable_open_pgp", "al
low_autosave_in_drafts", "autosign_outgoing_emails", "capa", "custom_fields", "files_enable" FROM awm_settings WHERE "id_user" = 1
[03:07:05.55][9a44eaed] DB[4] > SELECT id_acct FROM awm_accounts WHERE def_acct = 1 AND id_user = 1
[03:07:05.56][9a44eaed] DB[5] > SELECT "id_acct", "id_user", "id_domain", "id_tenant", "deleted", "def_acct"
, "mailing_list", "quota", "email", "friendly_nm", "mail_protocol", "mail_inc_host", "mail_inc_port", "mail_inc_login", "mail_inc_pass", "mail_inc_ssl", "mail_out_host", "mail_out_port", "mail_out_login", "mail_out_pass", "mail_out_auth", "mail_out_ssl", "hide_in_gab", "signature", "signature_type", "signature_opt", "custom_fields" FROM awm_accounts WHERE "id_acct" = 1
[03:07:05.58][9a44eaed] DB[6] > SELECT "id_user", "id_subscription", "id_helpdesk_user", "msgs_per_page", "contacts_per_page", "auto_checkmail_interval", "created_time", "last_login", "last_login_now", "logins_count", "def_skin", "def_lang", "def_editor", "save_mail", "layout", "incoming_charset", "def_timezone", "def_time_fmt", "def_date_fmt", "client_timezone", "question_1", "question_2", "answer_1", "answer_2", "sip_enable", "sip_impi", "sip_password", "twilio_number", "twilio_enable", "twilio_default_number", "use_threads", "save_replied_messages_to_current_folder", "desktop_notifications", "allow_change_input_direction", "allow_helpdesk_notifications", "enable_open_pgp", "allow_autosave_in_drafts", "autosign_outgoing_emails", "capa", "custom_fields", "files_enable" FROM awm_settings WHERE "id_user" = 1
[03:07:05.62][9a44eaed] DB[7] > SELECT id_acct, email, def_acct, friendly_nm, signature, signature_opt, signature_type FROM awm_accounts WHERE id_user = 1
[03:07:05.62][9a44eaed] DB[8] > SELECT "id_acct", "id_user", "id_domain", "id_tenant", "deleted", "def_acct", "mailing_list", "quota", "email", "friendly_nm", "mail_protocol", "mail_inc_host", "mail_inc_port", "mail_inc_login", "mail_inc_pass", "mail_inc_ssl", "mail_out_host", "mail_out_port", "mail_out_login", "mail_out_pass", "mail_out_auth", "mail_out_ssl", "hide_in_gab", "signature", "signature_type", "signature_opt", "custom_fields" FROM awm_accounts WHERE "id_acct" = 1
[03:07:05.65][9a44eaed] DB[9] > SELECT "id_user", "id_subscription", "id_helpdesk_user", "msgs_per_page", "contacts_per_page", "auto_checkmail_interval", "created_time", "last_login", "last_login_now", "logins_count", "def_skin", "def_lang", "def_editor", "save_mail", "layout", "incoming_charset", "def_timezone", "def_time_fmt", "def_date_fmt", "client_timezone", "question_1", "question_2", "answer_1", "answer_2", "sip_enable", "sip_impi", "sip_password", "twilio_number", "twilio_enable", "twilio_default_number", "use_threads", "save_replied_messages_to_current_folder", "desktop_notifications", "allow_change_input_direction", "allow_helpdesk_notifications", "enable_open_pgp", "allow_autosave_in_drafts", "autosign_outgoing_emails", "capa", "custom_fields", "files_enable" FROM awm_settings WHERE "id_user" = 1
[03:07:05.67][9a44eaed] DB : disconnect from afterlogic@localhost


    If I run that last query manually, it returns a row. No error message or similar.

    If I switch to MySQL, the webmail interface works nicely.

    This is PostgreSQL 9.3 under Linux, if that matters.

    I'd be happy to either try different settings or poke around the code. But I'm not sure where to start. Any suggestions?

Thanks,
Adam

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


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 12 January 2015 at 3:20am | IP Logged Quote Igor
Indeed, the log file doesn't seem to contain any errors so we can't really say what's going wrong there. We recommend to check webserver / PHP logs and see if there are any errors recorded there.

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

Joined: 11 January 2015
Location: United States
Online Status: Offline
Posts: 2
Posted: 12 January 2015 at 7:07am | IP Logged Quote aseering
Oddly, no, there are not any errors recorded there.

Well, there's one. In the Apache access log:

Quote:

(my IP address) - - [12/Jan/2015:09:52:21 -0500] "GET / HTTP/1.1" 500 705 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:29.0) Gecko/20100101 Firefox/29.0"


The error.log for this vhost doesn't get any new log messages. I use php5-fpm; I set the following:

Quote:

log_errors = On
log_level = debug
error_log = /path/to/valid/logfile
display_errors = On
display_startup_errors = On


Still nothing.

I even wrote a simple invalid PHP script; that immediately generated an error. But this page does not; it just stays blank.

It almost feels like some bit of code somewhere is deliberately trying to return a blank 500 page?... Or I've missed some obvious bit of recommended PHP debugging; it's not a language I've used frequently.

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


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 12 January 2015 at 7:28am | IP Logged Quote Igor
I don't think I have any ideas at the moment. I could try reproducing the problem, with different server configurations, as I don't think we've encountered that issue before. PostgreSQL support is still experimental, and we're certainly interested in fixing any issues found there.

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


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 13 January 2015 at 4:57am | IP Logged Quote Igor
Just wanted to let you know that I was able to reproduce the problem on a test install. We'll investigate this, will let you know once there are news. Note that due to holidays and vacations season, this might take a while.

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


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 12 March 2015 at 6:02am | IP Logged Quote Igor
It seems one of AfterLogic WebMail users has found a fix for this problem before our developers did that!

The fix is as follows:

In libraries/afterlogic/common/managers/social/storages/db/storage.php file, replace CApiSocailCommandCreatorPostgreSQL with CApiSocialCommandCreatorPostgreSQL.

After correcting that typo, PostgreSQL support actually works as expected.

Great job on noticing that one, Felix Maurer, thank you!



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

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