Yes it refused to save my darn passwords. I have just been so annoyed that I havenāt been bothered with fixing the mail shared account for months. (Which is sort of why i posted about it here now because i need to get it sorted)
Hmm ok odd. I cannot find " stored_options" in my database.
Thoughts?
Ok, been s bit busy so I had first now some time to look into it.
I found the table. Is it āsafeā to just change for example the passwords directly e.g. copy paste ā Save. Or are they hashed or serialized so you need to use some tool to do it?
Also can you add a new e-mail user directly in the Db or do you have to use the SuiteCRM UI and then edit the DB to that that? (Iām guessing the latter, but I have to ask).
Hi.
Did you see my last question? I checked myself of course and I can see that the passwords are not stored āas isā. So they are hashed or something right?
The Base64 encoding is just a compact way of storing JSON in the database, itās not a security thing. Itās how you encode and decode the stored_options
The passwords are different, theyāre arenāt actually stored in the DB, only an MD5 hash of them. Then when the user types the password, itās rehashed and compared to the stored hash.
This how you can set user passwords from database:
// MySQL only, not MSSQL
update users set user_hash = md5('jimsPass') where user_name = 'jim';
Normally I donāt do this, what Iāve done before is start from an already configured user, one I know that works, and copy the hash into a separate row in the database.
The same goes for email accounts, I always start them from the UI, not the DB, but Iāve sometimes copied hashed passwords from an installation where I know the account is ok into another one that Iām having trouble configuring due to UI bugs.
Thank you so much for explaining this.
So the MySQL DB query
Is for changing the password of a user right?
So how does the one run a DB query for changing an email accountās password?
Is it possible you could be kind and share an DB query where you change the email password instead, please?
I have exactly the issue that SuiteCRM doesnāt want/refuses to save the shared e-mail account and also changes in the personal emails setup when you do it from the UI.
It does indeed seem to be quite buggy as you also made a mention about beforeā¦
Sorry I canāt do the SQL for you right now, but itās a matter of going to the correct table, which will either be inbound_email or outbound_email and doing an UPDATE query to set the password field in a similar way as the query above (using the MD5 function).