How to update password in remote website ?

hello

I have 2 website:

Website A: CB installed with several addon such Auto-Action.
Website B: Simple site without CB

Some specific users of website A will have also an account on website B and I would like use same login/password for access in both site. I setup website B for disallow Edit Profil (such email and password) and my goal is to update the password in website B IF users update their password in website A.

For do that, I suppose is required to code a little script and place the file somewhere in website B. Then use in website A, Auto-Action with a Post request (with trigger Afteruserupdate) who will transmit updated password to the script and let the script update the password. So the Post Url will look probably like this:

www.websiteB.com/update_password.php?userid= [user_id]&password=[password]

This is right ? It is possible to perform this task in this way or this is subject to some limitation ?

thank

Use a Query action in CB Auto Actions on the after registration, after profile update, and after login triggers. Those are the only times the password will be cleartext and can be pushed to your second site as cleartext. You'd set your query action to External and specify everything you need to connect to your external sites database. This way you're pushing the password straight to the database.

If you already have an endpoint though to do this via HTTP call then you can use the Request action to send a POST to your URL.

I tested you suggestion but I got an error500 and this disallow me to create the action. This is due to mod_security of CB server so I just asked Beat to add an exception.

Meanwhile could you tell me:

1) What I'm supposed to set in "Host" field of external DB ? I suppose if the remote site is hosted in the same server, I need to set "localhost" ??? And if is hosted in another server, I must set what ??? server IP or Url such www.remote.com ??


2) The following query is right for do what I want ?



thank

1) What I'm supposed to set in "Host" field of external DB ? I suppose if the remote site is hosted in the same server, I need to set "localhost" ??? And if is hosted in another server, I must set what ??? server IP or Url such www.remote.com ??

If the database is on a completely different host then you put the URL or IP Address to your site. If it's on the same server, but different database set it to localhost or the IP Address. If it's on the same server and same database then use Internal.

2) The following query is right for do what I want ?

No, you need to query _users. CB does not store password and email in _comprofiler.

Beat added an exception in the server for allow me to use a query Action. So I have set the action using now this query:

Action is well fired but unfortunately I cannot login in remote Joomla using the new password.

My external DB credential seem to be correct because the Test Connection display 2 green message telling:

Connected to the External database server successfully.
Connected to the External database successfully.

The password seem to be well updated because if I set a password (from remote site Backend) such "hello123" and I update my profile (from my main site where the action is fired), then I cannot login using "hello123" in remote site. So a modification is well performed but not with the new password...

You told me in a previous post, the password is sent in cleartext only when using some specific trigger such onafteruserupdate and this is the trigger I use.

I tried also using this query:

but this don't change nothing...

Any clue?

If you're pushing the data to an external Joomla install then you need to push the encrypted password. Joomla does not work with plaintext passwords. Each Joomla install has a unique secret aswell, which is used to match passwords. Both of your installs would need the same secret in configurationn.php I believe for it to work properly otherwise you'll need to encode the password your self with your other sites secret.