1 Topic by bongdotcom

  • bongdotcom
  • Member
  • Offline
  • Registered: 2010-02-11
  • Posts: 105

Topic: exceptions.AttributeError at / 'pageSizeLimit' when using 1.4

Hi,

I get an error when I try to upgrade to iredadmin from 1.3 to 1.4.  I tried to upgrade the mod_wgsi but it will crash the system (all SSL failed) so I rollback to mod_wsgi-2.5-2.ired.  I am now get stuck on the current stage, please kindly advise how to perform the upgrade in current stage.  Thanks.

Regards,
James

Post's attachments

error.pdf 655.24 kb, 1 downloads since 2011-02-13 

You don't have the permssions to download the attachments of this post.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,134

Re: exceptions.AttributeError at / 'pageSizeLimit' when using 1.4

Please delete all data from MySQL table "iredadmin.sessions", then re-login. it should fix it.

$ mysql -uroot -p
mysql> USE iredadmin;
mysql> DELETE FROM sessions;

3 Reply by bongdotcom

  • bongdotcom
  • Member
  • Offline
  • Registered: 2010-02-11
  • Posts: 105

Re: exceptions.AttributeError at / 'pageSizeLimit' when using 1.4

Thanks it works.

But I follow the step to apply amavisd.  I receive the below error message.  Do you have any idea about this case?

Feb 13 17:07:51 264644-web2 amavis[25654]: (25654-02) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-OWVrJwXPTdgR-0' for key 1 at (eval 99) line 166, <GEN41> line 11410.

Regards,
James

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,134

Re: exceptions.AttributeError at / 'pageSizeLimit' when using 1.4

Try to increase max_connections setting in MySQL config file (/etc/my.cnf), restart MySQL service and track whether it happen again.

5 Reply by bongdotcom

  • bongdotcom
  • Member
  • Offline
  • Registered: 2010-02-11
  • Posts: 105

Re: exceptions.AttributeError at / 'pageSizeLimit' when using 1.4

My max_connections was set to 1000 already.  Do you think it is possible to increase the max connections?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,134

Re: exceptions.AttributeError at / 'pageSizeLimit' when using 1.4

Yes, try a lager one.

7 Reply by bongdotcom

  • bongdotcom
  • Member
  • Offline
  • Registered: 2010-02-11
  • Posts: 105

Re: exceptions.AttributeError at / 'pageSizeLimit' when using 1.4

Hi Michael,

I am abit worry the server may overload when writting too many message log on the MYSQL.  Is that possible to the antivirus part but not writting all message log to MYSQL?  Please advise.  Thanks.

Regards,
James

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,134

Re: exceptions.AttributeError at / 'pageSizeLimit' when using 1.4

bongdotcom wrote:

Feb 13 17:07:51 264644-web2 amavis[25654]: (25654-02) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-OWVrJwXPTdgR-0' for key 1 at (eval 99) line 166, <GEN41> line 11410.

Solved:
http://www.iredmail.org/forum/topic1677 … issue.html