Author Topic: Mail Log Blank  (Read 1006 times)

gofast321

  • Zen Apprentice
  • *
  • Posts: 33
  • Karma: +4/-0
    • View Profile
Mail Log Blank
« 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

half_life

  • Bug Hunter
  • Zen Hero
  • *****
  • Posts: 862
  • Karma: +58/-0
    • View Profile
Re: Mail Log Blank
« Reply #1 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.

gofast321

  • Zen Apprentice
  • *
  • Posts: 33
  • Karma: +4/-0
    • View Profile
Re: Mail Log Blank
« Reply #2 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#


half_life

  • Bug Hunter
  • Zen Hero
  • *****
  • Posts: 862
  • Karma: +58/-0
    • View Profile
Re: Mail Log Blank
« Reply #3 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?

gofast321

  • Zen Apprentice
  • *
  • Posts: 33
  • Karma: +4/-0
    • View Profile
Re: Mail Log Blank
« Reply #4 on: December 28, 2016, 09:44:39 pm »
Yeah, I have restarted a few times but no success.

half_life

  • Bug Hunter
  • Zen Hero
  • *****
  • Posts: 862
  • Karma: +58/-0
    • View Profile
Re: Mail Log Blank
« Reply #5 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).

half_life

  • Bug Hunter
  • Zen Hero
  • *****
  • Posts: 862
  • Karma: +58/-0
    • View Profile
Re: Mail Log Blank
« Reply #6 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.

gofast321

  • Zen Apprentice
  • *
  • Posts: 33
  • Karma: +4/-0
    • View Profile
Re: Mail Log Blank
« Reply #7 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.

half_life

  • Bug Hunter
  • Zen Hero
  • *****
  • Posts: 862
  • Karma: +58/-0
    • View Profile
Re: Mail Log Blank
« Reply #8 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.

gofast321

  • Zen Apprentice
  • *
  • Posts: 33
  • Karma: +4/-0
    • View Profile
Re: Mail Log Blank
« Reply #9 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.

half_life

  • Bug Hunter
  • Zen Hero
  • *****
  • Posts: 862
  • Karma: +58/-0
    • View Profile
Re: Mail Log Blank
« Reply #10 on: December 31, 2016, 05:14:37 pm »
   I believe what you are looking for is zentyal.loggerd.service.   

J. A. Calvo

  • Zentyal Staff
  • Zen Hero
  • *****
  • Posts: 1986
  • Karma: +67/-3
    • View Profile
    • http://blogs.zentyal.org/jacalvo
Re: Mail Log Blank
« Reply #11 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!
Zentyal Server Lead Developer

half_life

  • Bug Hunter
  • Zen Hero
  • *****
  • Posts: 862
  • Karma: +58/-0
    • View Profile
Re: Mail Log Blank
« Reply #12 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.