1 Topic by Rashef

  • Rashef
  • Rashef
  • Member
  • Offline
  • From: London
  • Registered: 2009-05-22
  • Posts: 93

Topic: iRedMail upgrade: so what?

I'm a bit confused about iRedMail upgrade to 0.5...
I update/upgrade my CentOS 5.3 with regularity. Does iRedMail upgrades come through your repository?
I have this doubt as I got:

$ sudo postconf -n mail_version
mail_version = 0.4-stable

After a search into the forum I arrived here: http://code.google.com/p/iredmail/wiki/Upgrade_040_050
Should I modify those files by hand as described?
Since I use iRedMail with MySQL and RoundCube I suppose I can jump this http://code.google.com/p/iredmail/wiki/ … nd_special and all LDAP related fixes from http://code.google.com/p/iredmail/wiki/ … p;_Notify.

Thanks in advance... I know it seems I'm asking for a dummy guide, but I cannot allow myself to stop my mailserver since it serves a holding company... :-)

----

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,121

Re: iRedMail upgrade: so what?

You can skip all steps which marked as 'LDAP backend only', and i already upgrade customer's mail server (MySQL backend) with this upgrade tutorial.

And you can increase the mail_version after upgrade.

PS: upgrade tutorial is not so clear, but it will be improved when next release is available:
http://www.iredmail.org/upgrade_050_051.html

Suggestions, contributions are always welcome. smile

3 Reply by Rashef

  • Rashef
  • Rashef
  • Member
  • Offline
  • From: London
  • Registered: 2009-05-22
  • Posts: 93

Re: iRedMail upgrade: so what?

I know I'm not lucky... but what the hell is happening???
I followed the step from http://code.google.com/p/iredmail/wiki/Upgrade_040_050 for mysql backend.
Now users are not able to login anymore.

dovecot: Sep 17 14:18:06 Info: imap-login: Internal login failure (auth failed, 1 attempts): user=<user@domain.it>, method=PLAIN, rip=192.168.0.21, lip=192.168.10.60
dovecot: Sep 17 14:18:06 Error: auth-worker(default): sql(user@domain.it,192.168.0.21): User query failed: Table 'vmail.users' doesn't exist

Did I missed something??? Why does it look for users in a table that didn't exist AFAIR (and I did not modified anyway!).

4 Reply by Rashef

  • Rashef
  • Rashef
  • Member
  • Offline
  • From: London
  • Registered: 2009-05-22
  • Posts: 93

Re: iRedMail upgrade: so what?

Thank God I was able to manage those errors...
I simply recovered old dovecot.conf and dovecot-mysql.conf.
After restoring dovecot.conf users were able to log in.

I read the warning ("Make sure you have upgrade OpenLDAP and MySQL with steps listed above."). I do really followed the previous steps for MySQL backend... I cannot understand... :-S

5 Reply by ZhangHuangbin

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

Re: iRedMail upgrade: so what?

Table vmail.users doesn't exist...

Virtual users are stored in vmail.mailbox table. Did you change dovecot-mysql.conf?

6 Reply by Rashef

  • Rashef
  • Rashef
  • Member
  • Offline
  • From: London
  • Registered: 2009-05-22
  • Posts: 93

Re: iRedMail upgrade: so what?

ZhangHuangbin wrote:

Table vmail.users doesn't exist...

Virtual users are stored in vmail.mailbox table.

Yes I know. I cannot understand why it's looking for user there... roll

7 Reply by Rashef (edited by Rashef 2009-09-17 21:55:54)

  • Rashef
  • Rashef
  • Member
  • Offline
  • From: London
  • Registered: 2009-05-22
  • Posts: 93

Re: iRedMail upgrade: so what?

Ok, I don't know if I understood the guide. Into dovecot-mysql.conf I should change the last line:

user_query = SELECT "/home/vmail" AS home,     "/home/vmail/sieve/%Ld/%Ln/" AS sieve_dir,     CONCAT('*:bytes=', quota*1048576) AS quota_rule,     maildir FROM mailbox     WHERE username='%u'     AND active='1'     AND enable%Ls='1'     AND expired >= NOW()

into

user_query = SELECT CONCAT(storagebasedirectory, '/', maildir) AS home,     "/home/vmail/sieve/%Ld/%Ln/" AS sieve_dir,     CONCAT('*:bytes=', quota*1048576) AS quota_rule,     maildir FROM mailbox     WHERE username='%u'     AND active='1'     AND enable%Ls='1'     AND expired >= NOW()

is it right?

EDIT: Yes, now all seems to correctly work! The problem was probably related to a typo... :-)