[rt-users] Inserting a user with mysql INSERT

Beachey, Kendric Kendric.Beachey at garmin.com
Fri Sep 6 15:55:54 EDT 2013


I need to create an account for a catch-all email address that will be sending requests to our RT from a separate workflow.  No matter which user triggers the action, the email will appear to come from product.suport at company.com.

When I try to use the GUI to create the user, it fails...looking at the log file, it seems to be because it can't find an equivalent user in our company-wide Active Directory.  (This is a useful thing to seed most user details...name, department, phone, etc. for *real* people.)

I don't need all the details for this user, so I decided I'd be OK to have the user created without all the extra goodies, and went right to the mysql command line.

insert into Users set Name='productsupport', EmailAddress='product.support at company.com';

This succeeded fine...I can see the row is in the database.  But when I try to call up the user from the admin GUI, it says it can't find it.  Are there other fields I should fill in?  Are there actually other tables that need rows inserted too?
--
Kendric Beachey


________________________________

CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of the intended recipient(s) and contain information that may be confidential and/or legally privileged. If you have received this email in error, please notify the sender by reply email and delete the message. Any disclosure, copying, distribution or use of this communication (including attachments) by someone other than the intended recipient is prohibited. Thank you.




More information about the rt-users mailing list