Yes, I cannot I believe it but I did! I have lost the page in my notebook where I recoreded my Localhost admin password. So now I cannot get in to complete the installation and setup with Moodle etc Anyone know how to get around , through or over this little absentminded glitch?!! Your help will be very gratefully received. Thanks
Go into the database and change the password in there. If you can wait a few more hours for me to get home I will give you the database entry for a new password to let you into yours then you can change it once you getit all set up.
robertbruce, when you say you lost your Localhost admin password are you referring to Amember or your hosting account/Cpanel account in general? If you have access to your DB via PHPMyAdmin (or some other way to run SQL) you can run this code to create a user "userid" with a password of "password" to login with. Change the userid to whatever you want and be sure to change the password or delete the account once you are in. Code: INSERT INTO `amember_admins` VALUES(99, 'userid', '$1$4aUJAbgw$fQSzg.mUQR5llanKY5Gto/', '', '', '6fb15774a9ef226322914d43a87a8bb1', 'your@email.com', 1, 'N;');
James & Skippy, Many thanks for responding. I am trying to get into aMember. After unzipping and installing I was able to carry on going in for a couple of days (even went through creating the UAT (test user exercise) but then encountered anothe rissue on one of the other applications (moodle) that needed me to empty my cache. From here on I was not able to get into aMember. Bummer ' cos I want to conclude the config and intergration to Moodle, VBulletin and PostAff. I fired up phpAdmin and did edit the amember_admins entry but I still get bounced. Even tried the fixadmin.php file to no avail. Have read your responses and went in as testuser and created a new admin with a different ID. No luck. I must still try the script So I am now dumbstruck and lack ideas on what to do next. Last resort is a uninstall and re-install but I do not want to do that. James, I'll wait for you and will welcome any other fixes. Mail me at robert@bruce.org.uk with the details. Regards RB UPDATE: Just run the script. Cannot login with 'userid' and 'password' which leads me to think I might have altered the password field attribute in the table.
Just to verify, you are trying to login to the admin console correct and not the end user part of the site as I don't believe admin credentials are cached. be sure you are logging into the right URL: http://yoursite.com/amember/admin <- Your picture matches my PHPAdmin. Userid should be 'userid' and password should be 'password'. Case sensitive (lower case)
Skippy, Yes I am trying the correct login. Can you tell me what the field attribute for the password in Mysql should be? See the attached snapshot of the pass field types. Are they correct? My main concern is the Collation. Is that correct? I'm thinking that the help you guys have been providing me is correct and that I have screwed up one of the field types. Also, when I browse pass in phpMyAdmin, I see FULLTEXT. Is this correct?
I checked what the collation is on my blog and it is also latin1_swedish_ci. So I tried this but it did not work. I am thinking an uninstall and re-install might be the best option. I'll do this as a last resort if Support cannot provide the solution. Have raised a ticket. Meanwhile, thanks a million Skippy! I do appreciate the help.
The Solution Yippeee! The lockout is resolved. How? Read this from our good Support team: Hello. Please set length of pass field in amember_admins table to varchar(128) and then try fixadmin.php tool again. SO there it is - change the field length to 128, save, run fixadmin.php and hey presto! Many thanks to you all. Great support. Great resolution. I'm a happy chappie!
i have my password and have forgotten my admin login in! would all the above work too for the other way around. I have my Admin password but i've forgotten the admin log in? Thanks
gailc, if you have not modified your database from standard, the sql insert statement I have above should do the trick.