1 Topic by intelsec

  • intelsec
  • Member
  • Offline
  • Registered: 2014-05-10
  • Posts: 5

Topic: Deleting User created with create_mail_user_SQL.sh

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

I added my user with create_mail_user_SQL.sh
but i forgot to add a password to the user.

How do i delete the user now?

I tried to access the mysql by forwarding the port to my local network but since my firewall on the server is tight i can't do that.

How do i delete the user over ssh?
also how do you add a new user using create_mail_user_SQL.sh with password?

Thanks and sorry about the Newbie disaster i got myself into lol.

----

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: 30,787

Re: Deleting User created with create_mail_user_SQL.sh

intelsec wrote:

- Web server (Apache or Nginx): NONE

You don't have a web server installed? And no iRedAdmin (open source edition, under /var/www/iredadmin)?

To delete this user, login to mysql server, then delete this user from `vmail.mailbox` and `vmail.alias` tables.

3 Reply by intelsec

  • intelsec
  • Member
  • Offline
  • Registered: 2014-05-10
  • Posts: 5

Re: Deleting User created with create_mail_user_SQL.sh

ZhangHuangbin wrote:
intelsec wrote:

- Web server (Apache or Nginx): NONE

You don't have a web server installed? And no iRedAdmin (open source edition, under /var/www/iredadmin)?

To delete this user, login to mysql server, then delete this user from `vmail.mailbox` and `vmail.alias` tables.

I have trust issues and i don't need another Web server installed my firewall is so tight right now only 3 ports are open 25, 587, 143 and i keep an eye on my logs live.
no pings are allowed too
every process is being watched and monitored and users.

Chinese, Russians, are country Blocked.

Web clients are weak in security i wish iRedmail had a paranoid tool scripts for people who only use the email server for what it is not a complete set.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,787

Re: Deleting User created with create_mail_user_SQL.sh

intelsec wrote:

i wish iRedmail had a paranoid tool scripts for people who only use the email server for what it is not a complete set.

Will give it a try in future release. smile

5 Reply by intelsec

  • intelsec
  • Member
  • Offline
  • Registered: 2014-05-10
  • Posts: 5

Re: Deleting User created with create_mail_user_SQL.sh

ZhangHuangbin wrote:
intelsec wrote:

i wish iRedmail had a paranoid tool scripts for people who only use the email server for what it is not a complete set.

Will give it a try in future release. smile

I just checked the .sh file

# If set to 'NO', password is the same as username.

the username that i created was using its first username as password
My heart just panicked

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,787

Re: Deleting User created with create_mail_user_SQL.sh

Read our tutorial here:
http://www.iredmail.org/docs/sql.bulk.c … users.html