Topic: Adding Password

[ronaldson40]

Hi

I have a situation like this. When a user changes his password, I want to store the password in also in a table in mysql. Users change the password using the browser i.e http://server/user-password. So I wanted to insert a script which would update the password in the mysql table also when the user clicks on change password button.

Regards

[shell]

I don't know of any way to achieve this, but imagine that it would involve heavy customisation of the inbuilt sme events, and as the passwords are securely stored would not only prove to be a difficult task but probably  not advised.

Perhaps you can achieve what you want through a different method - for example you maybe able to authenticate against the existing smeserver database.  If your query to the forum gave more of an indication of why you need the passwords in a separate database you may get more responses outlining viable alternatives.

Just a suggestion, as I note your request has not been replied to yet.

Cheers, Shell

[ronaldson40]

Hi

I have a program that uses a local mysql db to authenticate users into that program. I wanted to use Windows authentication initially but since LDAP does not support the password lookup like AD, I went for this option. Secondly I make all SME users passwords reset every 30 days.

So I thought that my local mysl db could have all the usernames of the SME users and the passwords could be obtained when the user first changes the password through the browser. This is my motivation.

Regards

[mmccarn]

It might be easier to go the other way - write your own program to let users change the password in mysql, then write a script that uses the 'password-modify' event to change the SME password to match.

LDAP does support passwords, it just isn't configured to do it on SME.  There are some New Feature Requests on this in bugzilla.