Zentyal Forum, Linux Small Business Server

Zentyal Server => Email and Groupware => Topic started by: gofast321 on December 23, 2016, 04:10:49 pm

Title: Mail Log Blank
Post by: gofast321 on December 23, 2016, 04:10:49 pm
Running 5.0.1 development

Is anyone else having an issue with the mail log?  I have been sending and receiving mail but the mail log never populates. I can see the records in /var/log/mail.log but the report in Zentyal never populates.


Chad
Title: Re: Mail Log Blank
Post by: half_life on December 26, 2016, 03:37:19 am
Would you :
open a command line and become root
Code: [Select]
sudo suWe are going to go poking around in mysql looking for information.

Code: [Select]
mysql -e 'select * from mail_message' zentyal

Copy and paste any response including errors if any.   Post them here.   The command simply looks to see if the table that receives that data is populating.
Title: Re: Mail Log Blank
Post by: gofast321 on December 27, 2016, 05:44:12 am
Thanks for the help. Select statement came back blank...

root@wis1:/home/gofast321# mysql -e 'select * from mail_message' zentyal
root@wis1:/home/gofast321#

Title: Re: Mail Log Blank
Post by: half_life on December 27, 2016, 07:15:11 pm
The fact that the table exists means that the init scripts ran for mail.  Chances are a cold restart will clear this issue up.  Have you restarted the system since noticing the isssue?
Title: Re: Mail Log Blank
Post by: gofast321 on December 28, 2016, 09:44:39 pm
Yeah, I have restarted a few times but no success.
Title: Re: Mail Log Blank
Post by: half_life on December 29, 2016, 05:01:49 am
Is this a vm or a physical machine?  I am thinking that disabling and then re-enabling the mail module should do the trick.  If not then doing the same to the log module would be the next things I try.  If this is a vm I would start with either a backup or a snapshot (depending on the technology employed).
Title: Re: Mail Log Blank
Post by: half_life on December 29, 2016, 05:03:29 am
One more question,  are errors showing up in /var/log/zentyal/zentyal.log ?  Maybe there is a clue there.
Title: Re: Mail Log Blank
Post by: gofast321 on December 29, 2016, 10:08:43 pm
Those are all good thoughts.  I have tried disabling and re-enabling both the mail module and the logs module but neither worked. I have noticed that none of the logs are actually working.  I reviewed the zentyal.log and there are no errors.

I think if no one else has bumped into this issue the only solution left is a reinstall.
Title: Re: Mail Log Blank
Post by: half_life on December 30, 2016, 08:52:03 am
You say that no logs are working?   Is the zentyal mysql password correct? Look in
Code: [Select]
/var/lib/zentyal/conf/zentyal-mysql.passwd
Run 
Code: [Select]
mysql -u zentyal -pWhen it prompts you provide the password from the file above.  Database access is a common thread between all of the zentyal logging.
Title: Re: Mail Log Blank
Post by: gofast321 on December 31, 2016, 03:12:18 pm
The mysql password is correct. It lets me in. However, I did check the tables in the  "zentyal" database and they are all empty.

Is there a process that populates the tables in the DB from the log files?


Thanks.
Title: Re: Mail Log Blank
Post by: half_life on December 31, 2016, 05:14:37 pm
   I believe what you are looking for is zentyal.loggerd.service.   
Title: Re: Mail Log Blank
Post by: J. A. Calvo on January 05, 2017, 05:56:04 pm
We haven't found any way to reproduce this behavior, mail logs are working for us in all our test scenarios. If anyone finds a way to reproduce it, please open a issue in tracker.zentyal.org with all the detailed steps to follow. Thanks!
Title: Re: Mail Log Blank
Post by: half_life on January 07, 2017, 08:41:15 pm
I am assuming that you probably have pulled the trigger on a re-install given your silence on this subject.  Hopefully things  are working now for you.