1 Topic by agroshong

  • agroshong
  • Member
  • Offline
  • Registered: 2016-03-25
  • Posts: 36

Topic: Adding an SQL User errors

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

I am trying to add a user to Mysql through phpmyadmin and am getting the following error's

1 row inserted.
Warning: #1364 Field 'ssl_cipher' doesn't have a default value
Warning: #1364 Field 'x509_issuer' doesn't have a default value
Warning: #1364 Field 'x509_subject' doesn't have a default value

Can anyone assist me with the proper settings for these fields

----

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

Re: Adding an SQL User errors

*) Why not simply create mail user with iRedAdmin?
*) If you prefer to do it with raw SQL, please take a look at file iRedMail-0.9.4/tools/create_mail_user_SQL.sh, and this tutorial: http://www.iredmail.org/docs/sql.bulk.c … users.html

3 Reply by agroshong

  • agroshong
  • Member
  • Offline
  • Registered: 2016-03-25
  • Posts: 36

Re: Adding an SQL User errors

ZhangHuangbin wrote:

*) Why not simply create mail user with iRedAdmin?
*) If you prefer to do it with raw SQL, please take a look at file iRedMail-0.9.4/tools/create_mail_user_SQL.sh, and this tutorial: http://www.iredmail.org/docs/sql.bulk.c … users.html

I am not talking about adding a mail user. I am trying to add a secondary sql admin that is not root. I have not found a spot in iredadmin for adding a user to the master database.

4 Reply by ZhangHuangbin

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

Re: Adding an SQL User errors

Maybe you want this tutorial?
http://www.mysqltutorial.org/mysql-create-user.aspx

5 Reply by agroshong

  • agroshong
  • Member
  • Offline
  • Registered: 2016-03-25
  • Posts: 36

Re: Adding an SQL User errors

I have been able to create the SQL user from the start, but when I do I get the errors mentioned in my first post about no default values for the field. I am just looking for the proper setting to put into these fields. They look to revolve around SSL. This is not a huge deal as I can login with the root account, but would prefer a different account for general database maintenance.