Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

login problems after migrate

  • minsca
  • minsca's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 7 months ago #230321 by minsca
login problems after migrate was created by minsca
Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Survey theme/template:
==================

Hello Community. I very much need your help. I'm moving servers, and have migrated my limesurvey from the old domain to new location. It does read the database, and will in fact give me the two created surveys to participate in. So far, so good. however, I can't get in -- interestingly, not in the new server installation, or even in the old domain (which is actually still the live one. Until I'm ready to re-point the IP addresses, the new location is at my [newdomain]/subdirectory -- though it works. Perhaps importantly I'm in a WP Multiuser environment (though that doesn't explain why I can't log into the old.

I've successfully figured the user name and email address used previously, and get an immediate new, perhaps temporary perhaps not, password. But even if I input it in seconds, it doesn't work. I've downloaded the latest limesurvey, 5.3.24, I believe. I'm on WHM/cPanel, and all the php systems, etc. are up to date.

I had brainstormed that if I could get into the old, I'll then recopy the db to the new, and hope the pw would work. Alas, I can't even get into the old. --I do have access to the mySQL db tables in both locations. 

For my own understanding, which of the id/password combinations are the used ones? The cPanel login? The domain login? The db definition? It seems certainly that it's not a given password on installation, as there is never anything asked for, and at the end of installation goes right to a login screen that I can't succeed in. So I'm guessing the pw is either the domain or db password, though more likely embedded in the database table that I ported over from old. Either way, I can't get in to either.

I do have the online possibility, but it's a very infrequently used survey, and has passed into obscurity, so the online method will not work for me. 

Can anyone offer suggestions, have come up with the same thing perhaps? 

Thanks!
 

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 7 months ago #230327 by tpartner
Replied by tpartner on topic login problems after migrate
The admin password is not related to the server or DB, it is created in LimeSurvey during the installation process.

This may help - www.limesurvey.org/manual/General_FAQ/en...How_do_I_reset_it.3F

Also, Denis has a controller that may work (not sure about 5.x) - gitlab.com/SondagesPro/coreAndTools/ResetPasswordController

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

  • minsca
  • minsca's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 7 months ago #230338 by minsca
Replied by minsca on topic login problems after migrate
Thanks Tony! The manual page was helpful. Yet it's still not working. I'm suspecting the program is broken which is why none of the passwords (including the password reset resends) are not working. But to make sure I'm doing this correctly, I've opened the db and gone to lsurvey[myname]_users and Edited one of my two user names, putting the hashed password into the password block, directly under the user name.

To check, to see if I've done this correctly, I've gone to the xorbin.com/tools/sha256-hash-calculator and put in 'password' coming up with this hash:
5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8

Would it seem I've done everything correctly? Might the program be broken? Actually, the program at this old server is less current than the new one--but still, I can't get in. Also, I tried Denis' controller which did not work either.

If I reinstall new current software (being careful to refer to my db name, table, and user, might I be able to do this without losing the data in the db? Thanks much!!

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 7 months ago #230339 by holch
Replied by holch on topic login problems after migrate
Whatever you do, make a copy of the database for backup.

Or use the copy to create a new database and then install on top of that. But if you don't know the correct login for the super admin, you might still run into trouble.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The following user(s) said Thank You: minsca

Please Log in to join the conversation.

  • minsca
  • minsca's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 7 months ago #230340 by minsca
Replied by minsca on topic login problems after migrate
Thanks all, I'm in. Tony, it was most helpful your page with hash instructions, as that ultimately was critical. But still, it was convoluted. But I'm in--and I've not exported copies of working files.

FWIW, or for those who may stumble across this, this was how I ultimately did it. I had exported a mySQL copy of the db from old server, though I couldn't even log in there--and this was also critical, this exported file. Next I blew out the limeserver folders in cPanel in the new server location. (Now, for those who are cringing, I didn't actually blow it out, but copied it to limeserverBK, 2, 3, and 5 -- yes, I'm conservative.)

Then I made careful note of the old db configurations, name, user, pw, etc. And reloaded current software creating a new "limeserver" folder. Then, clicked on the survey link where it opened up the installation box, and I put all that information -- making, once again, VERY careful notes. Then executed the whole thing.

Interestingly, when this finished and went to the login box, the id/pw that I entered into the installation didn't work. --And this is where the hash came in critical: Of the dozen now stored in my computer, one of them hashed now matched the hash in the original database. So I tried this combination, and was in: old name, and old password, luckily stumbled across. Thanks again Tony, or I likely wouldn't have gotten it.

Then, for your interest, I logged out, and couldn't log in again. Ouch!! Stumbled across that combo again, and was in. --From there, I created two new users and pw combinations, which I've now vetted. Then made a note in my Apple notes for forever posterity, including what worked and how. Three different combinations now work, PLUS, once in the second time, I immediately exported working copies of the two needed surveys. (Now on my computer as additional safety.)

Interestingly, the combination that got me back in, the stumbled across hash password from the old db would NOT get me into the old server limeserver program. In the end, I believe something there was broken, and boy did that set me on a rabbit trail for two days. But all is well now with the new server, and that's where it needs to be. Thanks, both Tony and holch -- and yes, I indeed took your advice seriously and made an inordinate number of backup databases, like or more before it was over. Thanks both, tons!!

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 7 months ago #230346 by tpartner
Replied by tpartner on topic login problems after migrate
Phew! 

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose