Sorted one problem and now created another
Thank you for your response, as ever, Igor,
We host domain.com. User
xxx@domain.com has an email address
xxx@domain.com
After looking at your link Igor, and I knew this anyway, I have a "Customer" set up - Joe Bloggs. The customer's contact email address is
xxx@domain.com. So using the suggestion in that link, I went to the Customers > Joe Bloggs > Edit Contact Info and changed their contact email address to
yyy@domain.com.
Now I was able to go to domain.com > Users >
xxx@domain.com and change their password which is what we wanted to do in the first place.
Now on Customers > Joe Bloggs > Edit Contact Info, I want to put their email address back to
xxx@domain.com, but I amg getting
User with such e-mail address already exists in the system.
I have run the command and got
[root@plesk3 ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select id, login, email, contactName from smb_users where email='xxx@domain.com';"
+-----+----------------------------+----------------------------+----------------------------+
| id | login | email | contactName |
+-----+----------------------------+----------------------------+----------------------------+
| 629 |
xxx@domain.com |
xxx@domain.com |
xxx@domain.com |
+-----+----------------------------+----------------------------+----------------------------+
[root@plesk3 ~]#
and that must be the user/email address that we have on the system.
But I want nothing complicated here. The user/email address exists on domain.com. Originally, we were able to set Joe Bloggs up as a Customer with
xxx@domain.com as the email address. Why should that prevent us from changing the password for
xxx@domain.com?? And now having changed the password, why can I not put
xxx@domain.com back as the email address for the customer? Not rocket science!!
Note domain.com does not belong to Joe Bloggs but to a different Customer on Plesk.
I checked a totally different domain where the Customer's contact details are the same. What would happen if like the last one, I wanted to change the password for
yyy@domain-2.com? The same? Change email address for ID 312. Then change the password for
yyy@domain-2.com, but then as above we would not be able to put the email address for ID 312 back to
yyy@domain-2.com
[root@plesk3 ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select id, login, email, contactName from smb_users where email='yyy@domain-2.com';"
+-----+--------------------------------+--------------------------------+--------------------------------+
| id | login | email | contactName |
+-----+--------------------------------+--------------------------------+--------------------------------+
| 312 | ABC123 |
yyy@domain-2.com | Bill Smith |
| 371 |
yyy@domain-2.com |
yyy@domain-2.com |
yyy@domain-2.com |
+-----+--------------------------------+--------------------------------+--------------------------------+
[root@plesk3 ~]#