1 Topic by thedoctor.gz

  • thedoctor.gz
  • Member
  • Offline
  • From: Italy
  • Registered: 2014-09-22
  • Posts: 6

Topic: Change default language of new users in iredadmin

Hi all,
I've read this topic http://www.iredmail.org/forum/topic8826 … admin.html but I don't know which is the correct database and the SQL column "mailbox.language".

Thanks in advance for your help.

----

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

Re: Change default language of new users in iredadmin

In iRedMail-0.9.3 and recent iRedMail releases, to set per-domain default language, you should use SQL command:

UPDATE domain SET settings=CONCAT(settings, 'default_language=en_US;') WHERE domain='your_domain.com';

For per-user default language, you should use:

UPDATE mailbox SET language='en_US' WHERE username='user@your_domain.com';

3 Reply by thedoctor.gz

  • thedoctor.gz
  • Member
  • Offline
  • From: Italy
  • Registered: 2014-09-22
  • Posts: 6

Re: Change default language of new users in iredadmin

ZhangHuangbin wrote:

For per-user default language, you should use:

UPDATE mailbox SET language='en_US' WHERE username='user@your_domain.com';

Thanks for your reply.

In this way, each time I create a new user in iredadmin panel, I find my preferred language?

4 Reply by ZhangHuangbin

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

Re: Change default language of new users in iredadmin

How about give it a try first? smile

iRedAdmin open source edition doesn't have this feature, but iRedAdmin-Pro does.

5 Reply by thedoctor.gz

  • thedoctor.gz
  • Member
  • Offline
  • From: Italy
  • Registered: 2014-09-22
  • Posts: 6

Re: Change default language of new users in iredadmin

I've never used SQL command, I have Webmin to manage my server, but tomorrow I'll try and I'll give you feedback.

Thank You.

6 Reply by thedoctor.gz

  • thedoctor.gz
  • Member
  • Offline
  • From: Italy
  • Registered: 2014-09-22
  • Posts: 6

Re: Change default language of new users in iredadmin

ZhangHuangbin wrote:

For per-user default language, you should use:

UPDATE mailbox SET language='en_US' WHERE username='user@your_domain.com';

In which database I have to execute the SQL command? I don't find mailbox table sad

7 Reply by ZhangHuangbin

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

Re: Change default language of new users in iredadmin

That's why we ask you to show us basic info of your iRedMail server:

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- Related log if you're reporting an issue:
====

If you're running OpenLDAP backend, then you should use LDAP attribute 'preferredLanguage' in user object instead.

8 Reply by thedoctor.gz

  • thedoctor.gz
  • Member
  • Offline
  • From: Italy
  • Registered: 2014-09-22
  • Posts: 6

Re: Change default language of new users in iredadmin

==== Required information ====
- iRedMail version: 0.8.7
- Linux/BSD distribution name and version: Ubuntu Server 14.04
- Store mail accounts in which backend: LDAP
- Web server: Apache
- Manage mail accounts with iRedAdmin-Pro? iRedAdmin 0.3.3
- Related log if you're reporting an issue:
====

In iRedMailAdmin panel > Add > User and I fill the fields

Mail Address
New password
Confirm new password
Mailbox Quota

and click Add

In the next step I only change Preferred Language from "English (US)" to "Italiano" and click on Save Changes.

Is it possible to set "Italiano" as default language on that menu?

Thanks

9 Reply by ZhangHuangbin

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

Re: Change default language of new users in iredadmin

*) With iRedAdmin-Pro, you can set per-domain language, then each time you create new user, the preferred language will be selected automatically.

*) Without iRedAdmin-Pro, you have to modify iRedAdmin source code, file "templates/default/ldap/user/create.html".

10 Reply by thedoctor.gz

  • thedoctor.gz
  • Member
  • Offline
  • From: Italy
  • Registered: 2014-09-22
  • Posts: 6

Re: Change default language of new users in iredadmin

ZhangHuangbin wrote:

*) Without iRedAdmin-Pro, you have to modify iRedAdmin source code, file "templates/default/ldap/user/create.html".

I have changed the string in the file "templates/default/ldap/user/profile.html" and it works!

Thank you for the support!