No reports generating after 9.1.1 upgrade

[brewewa]

Originally Posted by brewewa

OK, I installed Phish Blocker and then generated reports! It worked!! Woo Hoo, thanks dmorris.

Now how do I install Spam Blocker Lite? (I'll post in that forum if I need to).

I went ahead and installed the Lite Package on top of what I had. That gave me Spam Blocker Lite, along with everything else in the Lite Package.

I hope it didn't mess anything up (although I really didn't have much to lose).

[dmorris]

Originally Posted by brewewa

I went ahead and installed the Lite Package on top of what I had. That gave me Spam Blocker Lite, along with everything else in the Lite Package.

I hope it didn't mess anything up (although I really didn't have much to lose).

That will work. If you don't want the other stuff you can just turn them off.
I think you just need to keep one email-processing app in the rack so reports has that one table. This will be fixed in a future version.

[bpenney]

I tried the trick of installing SPAM Blocker Lite but I still have the error:

Jan 9 14:50:55 localhost __main__[27937] CRITICAL: Exception while building report: relation "reports.n_mail_addr_totals" does not exist#012Traceback (most recent call last):#012 File "/usr/share/untangle/bin/reporting-generate-reports.py", line 397, in <module>#012 end_date, report_days)#012 File "/usr/lib/python2.5/reports/engine.py", line 515, in export_static_data#012 result = globals()[methodName](start_date, end_date)#012 File "/usr/lib/python2.5/reports/engine.py", line 560, in __get_emails#012 (start_date, end_date))#012 File "/usr/lib/python2.5/reports/sql_helper.py", line 32, in execute#012 psycopg2.extensions.cursor.execute(self, sql, args)#012ProgrammingError: relation "reports.n_mail_addr_totals" does not exist


I am running 9.1.1.

Any ideas what to try now?

[fmonroy]

Guys, I had to remove reports after upgrade cause it hangs the system when generating reports.

Any plans to optimize reports generation?

[bpenney]

Originally Posted by bpenney

I tried the trick of installing SPAM Blocker Lite but I still have the error:

Jan 9 14:50:55 localhost __main__[27937] CRITICAL: Exception while building report: relation "reports.n_mail_addr_totals" does not exist#012Traceback (most recent call last):#012 File "/usr/share/untangle/bin/reporting-generate-reports.py", line 397, in <module>#012 end_date, report_days)#012 File "/usr/lib/python2.5/reports/engine.py", line 515, in export_static_data#012 result = globals()[methodName](start_date, end_date)#012 File "/usr/lib/python2.5/reports/engine.py", line 560, in __get_emails#012 (start_date, end_date))#012 File "/usr/lib/python2.5/reports/sql_helper.py", line 32, in execute#012 psycopg2.extensions.cursor.execute(self, sql, args)#012ProgrammingError: relation "reports.n_mail_addr_totals" does not exist


I am running 9.1.1.

Any ideas what to try now?

Installing the Phish Blocker fixed the problem.

[Mathiau]

Originally Posted by fmonroy

Guys, I had to remove reports after upgrade cause it hangs the system when generating reports.

Any plans to optimize reports generation?

my system hung like this before for a long time that was because my database was MASSIVVVE with logs, what is your data retention set to?

[fmonroy]

Originally Posted by Mathiau

my system hung like this before for a long time that was because my database was MASSIVVVE with logs, what is your data retention set to?

The defaults. It was performing well before this update. Disk is growing more than it used to.

[bpenney]

I installed a new Untangle server ( Build: 9.1.1~svn20111222r30591release9.1-1lenny), restored my configuration from the backup of my old server, and now I am getting the error about reports.n_mail_addr_totals does not exist problem again. I have installed all the free applications 1 by 1 but that did not fix the problem. I also installed the trial version on the SPAM application but still the same issue.

By doing a simple grep on the code I assume this means there is something missing from the database. Is that correct? Anyway to fix this issue manually?

[raditude]

@bpenny - If you want your post to be reviewed and for the community to try to assist in resolving your issue, I would not post in an old post, about something that does not even seem to be the same issue.

I would start a new thread, with as much information as you can. What version did you restore your backup from..etc.

[sky-knight]

Yes, backups are only good for the version on which they are made. Restoring an old version backup on a current version Untangle is usually a good way to nuke your box.