2008-05-23 12:45:10
I upgraded from 1.5.4 to 1.6 (stable). I can log in as teacher?course creator, but I can not log in as administrator. I looked in the atutor mysql5 database and my administrator name and password are there as I thought thet would be, but I get the error "Invalid login/password combination."
I tried installing the defoult themes as someone suggested in another message, but that didn't work.
2008-05-23 14:16:23
Seems like the admin passwords were not encrypted if you can still read them. This changed in 1.6
Check the password field in the admins table to be sure it's type is set to varchar(40). If it's not, change the length to 40.
Then edit the password manually for your admin user, entering the text of the password, then setting the "function" to "sha1", then save the record. (assuming you are using phpMyAdmin)
You may want to check that your database user has alter table permissions. This problem suggest the tables were not altered during upgrade. You'll have problems in the future if the user can't alter tables.
2008-05-27 14:20:31
Thanks, Greg - your advice worked. Not at first, for some reason I had to manually edit the password fiedl three times and the third time I saved the changes, I was able to login as administrator.
Now, once logged on as admin, when I select the course I want to work on and click "Edit," it takes me to Course Properties and an error message says "Course not found." Can you help me fix that so I can edit the course properties? Thanks.
2008-05-27 15:28:00
Have you confirmed that your database user has ALTER table permissions? The best approach would be to get that straightened out, then try the upgrade again.
There is also the manual route, running the queries in the db upgrade scripts for version 1.5.5 and 1.6, found in the install/db/ directory
2008-06-12 10:49:53
I have same problem thx you to solve this problem
but can u list the step by point?
2008-06-13 03:00:06
I am sucessful
2008-06-19 19:22:17
I never did get around myproblems updating, so I decided just to install the new version and then spend 100 hours recreating all the content and the tests.
I though this would solve the problem, but the problems are even worse than before. When I successfully install the new version, it won't accept my logon and password that I set up when I did the install. So I went to PhPMyAdmin and reset the username and password, double checking the varchar(40) and sha1, as suggested, saved the changes, but it still won't accept my login. I was, however, abler to log on as a teacher (but I still need to log on as administrator to make some changes), butwhen I clicked to enter the course, I got an error message screen (attached). Please view the attachment and see if you can spot the problem.
I have deleted and reinstalled ATutor three times, and have even deleted and recreated my atutor database, but not of this helps. I am getting so frustrated because this has been going on for almost 2 weeks.
2008-06-20 08:44:22
Sorry to hear you having so much trouble.
Which theme are you using? What you describe sounds like it is related to an outdated theme.
If you manually change the default theme in the themes table by setting the value for another theme to "2" to make it the default theme, and the current theme to "1", are you able to login. Try setting the ATutor "Default" theme as the system's default.
2008-06-25 12:03:38
No, although I saw that the theme had changed when I brought up the log in screen, I'm still not able to log in as administrator. I also tried resetting the login and password in the admins table, but that didn't work either. I made sure the password was set to varchar(40) and the function to sha1. I left the login at varchar(30), it that ok? SI also set the login to sha1, but that didn't help either. What should the function for login be set to?
2008-06-25 12:32:19
The login should stay plain text, and the password to sha1. Login type is left blank to default to plain text.Let me know if that works.
Work with the ATutor Default theme, and once you can login with it, try with the other themes.
2008-06-26 17:20:14
Greg - Your last suggestion worked, I was finally able to log on as administrator. Too bad I couldn't solve the update problem. I don't mind having to upload all thecourse documents again, but what I really hateis rebuilding 10 quizzes and a 50 question final exam. Plus, I'll probably have to stay with this version forever.
Thanks for your help!
2008-06-27 08:46:20
The trouble you had is unusual. Upgrades should not be a problem. It isn't for most.
In the future you might try creating backups of your courses, then downloading them before you upgrade. You should not need to do this, but at least if something goes wrong with the next upgrade, you'll be able to restore your courses, and tests, from the backups.
2008-06-29 02:54:41
I do have a backup of the course.; I figured out how to make a backup, but I can't figure out how to restore it yet. It backs up as a zip file. Where do I put the zip file to restore it?
2008-06-29 07:37:09
The same place you create a course backup, you restore the backup.
Manage>Backups
See the Handbook for details.
2009-03-02 16:03:44
I am also having this issue where no users including admin can sign in. I've tried all the fixes from this form and http://www.atutor.ca/view/7/13789/2.html one as well. I've tried resetting the password and blanking the password for admin in the database. I've tried different themes. It was working this morning and now I cannot get in.
Things to describe:
Operating system ATutor is installed on - Windows 2003 x64 R2
ATutor version - 1.6.1
Patch #s applied - 1 through 12 I think
ATutor theme name - Atutor 1.5
PHP version - 5
MySQL version - 5
Webserver & version - IIS 6
Copies of error messages - Invalid login/password combination.
Changes to default settings - n/a
Web browser being used - IE7 with minimal security
...and anything else relevant -
2013-04-05 22:46:07
Hi,
I've been having a problem with this error message in the ATutor login page, after I tried logging in as an admin from a fresh install.
=========================================================
The following errors occurred:
Invalid login/password combination.
=========================================================
Remarkably, this 5-year old thread solved my problem. Thanks a lot everyone!:D