1 Topic by matz

  • matz
  • Member
  • Offline
  • Registered: 2017-09-15
  • Posts: 3

Topic: Cant create new account

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.6
- Linux/BSD distribution name and version: Debian 8.9
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL (MariaDB)
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? NO
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hello. I cant create new account.
I try to use free admin panel but I get message:

Account already exist.

If i try create by script:

root@mx:~/iRedMail-0.9.7/tools# ./create_mail_user_SQL.sh test@xxxx.pl test1234
INSERT INTO mailbox (username, password, name,
                     storagebasedirectory,storagenode, maildir,
                     quota, domain, active, local_part, created)
             VALUES ('test@xxx.pl', '{SSHA512}pr1X/SNUQi1/SNWusa+bdGhztMp1acuTnpE9Xj+i+L5m7cEvo               VCIBE+4rk/iYOYkFAjir34WTBg87zkNG9Z7boDP7YIlKZOJ', 'test',
                     '/var/vmail','vmail1', 'xxx.pl/t/e/s/test-2017.09.15.11.57.37/',
                     '1024', 'xxx.pl', '1','test', NOW());
INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_forwarding)
                 VALUES ('test@xxx.pl', 'test@xxx.pl','xxx.pl', 'xxx.pl', 1);

How I can debug problem?

----

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

Re: Cant create new account

If you're running iRedMail-0.9.6, there's no "vmail.forwardings" table at all. Please use the script shipped in iRedMail-0.9.6 to create new user.

For iRedAdmin, sounds like a bug. But did you ever create mail accounts with SQL command line tool? Maybe you missed some required SQL records.

3 Reply by matz (edited by matz 2017-09-16 19:54:26)

  • matz
  • Member
  • Offline
  • Registered: 2017-09-15
  • Posts: 3

Re: Cant create new account

Thank You for answer. II try with 0.9.6 version of tool but with no luck:

oot@mx:/home/matz/iRedMail-0.9.6/tools# ./create_mail_user_SQL.sh j.skowron@xxx.pl test
INSERT INTO mailbox (username, password, name,
                     storagebasedirectory,storagenode, maildir,
                     quota, domain, active, local_part, created)
             VALUES ('j.skowron@xxx.pl', '{SSHA512}zhsCppN0kQfvilRKws848R8hNebbrcZgOs4fMW/i7m+cMmxSDq2mlh029+3ipKHaLnXWyxGQZ6SsrnqTrKZKtJxkGY/Rtg0y', 'j.skowron',
                     '/var/vmail','vmail1', 'xxx.pl/j/./s/j.skowron-2017.09.16.13.16.04/',
                     '1024', 'xxx.pl', '1','j.skowron', NOW());
INSERT INTO alias (address, goto, domain, created, active)
           VALUES ('j.skowron@xxx.pl', 'j.skowron@xxx.pl','xxx.pl', NOW(), 1);

P.s. I add alias few weeks ago with sql commands. Maybe this is a problem?

4 Reply by ZhangHuangbin

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

Re: Cant create new account

This command just print the SQL command you should use to create the account, but it does NOT actually run the SQL command.

5 Reply by matz

  • matz
  • Member
  • Offline
  • Registered: 2017-09-15
  • Posts: 3

Re: Cant create new account

Omfg! Its true hmm

Web panel dont work but sql comand works well.
Coffe is yours!

Payment confurmation wink
4X437134K49939603

6 Reply by ZhangHuangbin

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

Re: Cant create new account

Thanks for the coffee. smile