A Problem with my Imported Users (automated password reset broken)
Hi Everyone, New to the list here, so, "Hello!" I'm glad to be a part and hope that sometime down the road I too can help out somebody. My little problem arose after I imported users from a Scoop database. Everything went fine and the users are usable, except there is one thing wrong. Under the login area on a Drupal page there is a link that says "Request new password." Normally, when working, the user simply enters their user name or email and the system sends instructions to the email on file. As you probably guess, this function doesn't work for my imported users. The whole process goes through OK, but the email is never received (and I'm guessing never sent either, though I'm not sure). For the sake of efficiency, let me tell you some things I have already done: -Checked the Drupal "users" table to make sure emails for users were set in 'mail' and 'init' fields -Checked all other "users" fields for irregularities -Changed password manually through cms, then reattempted password request Needless to say, this didn't result in any advancement against my problem. If anyone on this list might be able to shed a little light on this, please let me know. it would be greatly appreciated. I'm willing to answer any other questions to the best of my ability if you have them Thanks! Dave B.
Big Brother ha scritto:
Hi Everyone,
New to the list here, so, "Hello!" I'm glad to be a part and hope that sometime down the road I too can help out somebody.
[SNIP] Ok, these are mine stupid questions for 27/03/2008: have you tried to see if email field does not contains some strange character like " " or \n or \t ? What do you use for interface with mysql ? If you use phpmyadmin or similar can you try the mysql console (via web you can not see the strange characters) ? Have you tried to add a user via drupal normal way (this for check that there is not a problem with your php ini file) ? M.
Thanks Michel. I'm going to double check for any bad characters, thanks for the suggestion. Yes, I've added users the normal way and everything works fine, including automated password emails. DB On Wed, Mar 26, 2008 at 7:06 PM, michel <michel@ziobudda.net> wrote:
Big Brother ha scritto: Hi Everyone,
New to the list here, so, "Hello!" I'm glad to be a part and hope that sometime down the road I too can help out somebody.
[SNIP]
Ok, these are mine stupid questions for 27/03/2008: have you tried to see if email field does not contains some strange character like " " or \n or \t ? What do you use for interface with mysql ? If you use phpmyadmin or similar can you try the mysql console (via web you can not see the strange characters) ? Have you tried to add a user via drupal normal way (this for check that there is not a problem with your php ini file) ?
M.
-- [ Drupal support list | http://lists.drupal.org/ ]
Quoting Big Brother <ignorance.is.strength@gmail.com>:
-Checked the Drupal "users" table to make sure emails for users were set in 'mail' and 'init' fields -Checked all other "users" fields for irregularities -Changed password manually through cms, then reattempted password request
Needless to say, this didn't result in any advancement against my problem. If anyone on this list might be able to shed a little light on this, please let me know. it would be greatly appreciated. I'm willing to answer any other questions to the best of my ability if you have them
What modules do you have installed on the new system that might affect the user or the user profile? Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Hi Earnie, Thanks for responding. I just double checked the modules and I don't see any of them causing problems with the users. The only three which *may* do something to users somewhere down the line are: -profile -bloginfo -karma Comments and other things you'd expect for a participatory website are active. Also, an the email field in the database is clean on these accounts. There are no errant characters in there. I thought that could have been it, though. I've been stuck on this for a while. I've looked into all three of them and none have any input for an email or anything to do with one. -DB On Thu, Mar 27, 2008 at 7:12 AM, Earnie Boyd <earnie@users.sourceforge.net> wrote:
Quoting Big Brother <ignorance.is.strength@gmail.com>:
-Checked the Drupal "users" table to make sure emails for users were set in 'mail' and 'init' fields -Checked all other "users" fields for irregularities -Changed password manually through cms, then reattempted password request
Needless to say, this didn't result in any advancement against my problem. If anyone on this list might be able to shed a little light on this, please let me know. it would be greatly appreciated. I'm willing to answer any other questions to the best of my ability if you have them
What modules do you have installed on the new system that might affect the user or the user profile?
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
--
[ Drupal support list | http://lists.drupal.org/ ]
Quoting Big Brother <ignorance.is.strength@gmail.com>:
Also, an the email field in the database is clean on these accounts. There are no errant characters in there. I thought that could have been it, though.
What do the server log files say, if anything? When you say "the email field in the database is clean" you are saying that you used a select statement to select a row where the mail column is equal to a problem string? How about character encodings from old to new system; do you need to transform the string into different encodings? Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
On Fri, Mar 28, 2008 at 8:15 AM, Earnie Boyd <earnie@users.sourceforge.net> wrote:
Quoting Big Brother <ignorance.is.strength@gmail.com>:
Also, an the email field in the database is clean on these accounts. There are no errant characters in there. I thought that could have been it, though.
What do the server log files say, if anything? When you say "the email field in the database is clean" you are saying that you used a select statement to select a row where the mail column is equal to a problem string? How about character encodings from old to new system; do you need to transform the string into different encodings?
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
-- [ Drupal support list | http://lists.drupal.org/ ]
It's possible that the encodings may have been different. I didn't do anything to specify the encoding when I imported the users. How would I check the encodings? -dbb
Quoting Big Brother <ignorance.is.strength@gmail.com>:
It's possible that the encodings may have been different. I didn't do anything to specify the encoding when I imported the users.
How would I check the encodings?
How did you export? What versions of MySql old vs new? What versions of PHP old vs new? Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Ok, I'm fairly sure I did this an unconventional way. Please don't rail if you find I did something very... stupid. Our current software is Scoop. We've already transferred all the stories and comment information without problem. I wrote all the scripts to do this. For the users I simply studied both tables on the DBs and then figured out what I had to transfer and where to put everything. Then I wrote the script based on that. As I said earlier, everything works fine but this. As for versions. Php4 all around. The old Scoop database used to be on a server that was using MySql 3, but has been transferred to a new server which uses MySql 5. Is that enough to affect the encoding somehow in a way I can't or couldn't detect? Thanks.
How did you export? What versions of MySql old vs new? What versions of PHP old vs new?
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
-- [ Drupal support list | http://lists.drupal.org/ ]
Quoting Big Brother <ignorance.is.strength@gmail.com>:
Ok, I'm fairly sure I did this an unconventional way. Please don't rail if you find I did something very... stupid.
Our current software is Scoop. We've already transferred all the stories and comment information without problem.
I wrote all the scripts to do this. For the users I simply studied both tables on the DBs and then figured out what I had to transfer and where to put everything. Then I wrote the script based on that. As I said earlier, everything works fine but this.
As for versions. Php4 all around. The old Scoop database used to be on a server that was using MySql 3, but has been transferred to a new server which uses MySql 5. Is that enough to affect the encoding somehow in a way I can't or couldn't detect?
Ah, MySql-3 and MySql-5 handle the strings differently. Make sure all your string columns are utf8-unicode-ci. Make sure you save the strings as utf8 encoded. You might wish to study or even use the user_save[1] function for your scripts. [1] http://api.drupal.org/api/function/user_save/5 Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Ok thanks! I will definitely be using that user_save function. However, wouldn't this encoding problem be solved if I were to change the email from within the Drupal system it would be set correctly. Yet, I've changed emails in this manner and it still doesn't send it. Or does it remain the same encoding as before? Thanks, regardless I'm going to check up on the utf8-unicode-ci.
Ah, MySql-3 and MySql-5 handle the strings differently. Make sure all your string columns are utf8-unicode-ci. Make sure you save the strings as utf8 encoded. You might wish to study or even use the user_save[1] function for your scripts.
[1] http://api.drupal.org/api/function/user_save/5
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
-- [ Drupal support list | http://lists.drupal.org/ ]
Here's another strange symptom. On the Drupal logs it says that these emails have indeed been sent out. Whether true or now, Drupal thinks that these password recovery emails are being sent. They didn't fail the mail() function (I think that's what handles it, but you get my point). On first thought this led me to believe that something was wrong with my mail servers. But this doesn't make sense as users who were created under a "normal" process can still reset their passwords via email password recovery. I just wanted to throw some more info into the field in case it helps. -DB On Thu, Mar 27, 2008 at 7:12 AM, Earnie Boyd <earnie@users.sourceforge.net> wrote:
Quoting Big Brother <ignorance.is.strength@gmail.com>:
-Checked the Drupal "users" table to make sure emails for users were set in 'mail' and 'init' fields -Checked all other "users" fields for irregularities -Changed password manually through cms, then reattempted password request
Needless to say, this didn't result in any advancement against my problem. If anyone on this list might be able to shed a little light on this, please let me know. it would be greatly appreciated. I'm willing to answer any other questions to the best of my ability if you have them
What modules do you have installed on the new system that might affect the user or the user profile?
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
--
[ Drupal support list | http://lists.drupal.org/ ]
Quoting Big Brother <ignorance.is.strength@gmail.com>:
Here's another strange symptom.
On the Drupal logs it says that these emails have indeed been sent out. Whether true or now, Drupal thinks that these password recovery emails are being sent. They didn't fail the mail() function (I think that's what handles it, but you get my point).
On first thought this led me to believe that something was wrong with my mail servers. But this doesn't make sense as users who were created under a "normal" process can still reset their passwords via email password recovery.
I just wanted to throw some more info into the field in case it helps.
We still need to know:
What modules do you have installed on the new system that might affect the user or the user profile?
Also, how did you import the users? And make sure that the {users}->mail column doesn't contain extra white space (including a \r). Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
On Fri, Mar 28, 2008 at 7:13 AM, Earnie Boyd <earnie@users.sourceforge.net> wrote:
Quoting Big Brother <ignorance.is.strength@gmail.com>:
Here's another strange symptom.
On the Drupal logs it says that these emails have indeed been sent out. Whether true or now, Drupal thinks that these password recovery emails are being sent. They didn't fail the mail() function (I think that's what handles it, but you get my point).
On first thought this led me to believe that something was wrong with my mail servers. But this doesn't make sense as users who were created under a "normal" process can still reset their passwords via email password recovery.
I just wanted to throw some more info into the field in case it helps.
We still need to know:
What modules do you have installed on the new system that might affect the user or the user profile?
Obviously the user module, otherwise: -profile module -bloginfo module -karma module
Also, how did you import the users? And make sure that the {users}->mail column doesn't contain extra white space (including a \r).
I imported the users using my own scripts. Pretty basic. Everything imported fine but this problem showed up. No extra whitespace. I'll check again for a \r.
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
-- [ Drupal support list | http://lists.drupal.org/ ]
participants (3)
-
Big Brother -
Earnie Boyd -
michel