Help, i'm locked out
Permalink
i changed the permission on the login page, in sitemap by unchecking 'guest' now i can't log back in.
how can i fix this?
in case you wonder why i did this, it was late and i was reading a post here somewhere about someone who wanted to hide the register page, and it was suggested to go into siteamp and uncheck guest. i thought that would be handy to stop people seeing the login page, thinking that since i was already registerd i would still be able to see it. wrong i know now.
i'm guessing i need to change something in the database but what??? i've got cpanel and phpmyadmin i can get to the 'PagePermissions' in the database but what next??
please guys i really need some help here.
how can i fix this?
in case you wonder why i did this, it was late and i was reading a post here somewhere about someone who wanted to hide the register page, and it was suggested to go into siteamp and uncheck guest. i thought that would be handy to stop people seeing the login page, thinking that since i was already registerd i would still be able to see it. wrong i know now.
i'm guessing i need to change something in the database but what??? i've got cpanel and phpmyadmin i can get to the 'PagePermissions' in the database but what next??
please guys i really need some help here.
panic over i fixed it
I don't know how you fixed it.
But I had an exact same problem before. I didn't bother to share it to everyone... but I now saw you... so I should share my knowledge here.
Please share with us if your solution were different from mine.
----------
If you ever got locked out, follow this instruction.
However, if you don't understand what I am talking about... or don't have an access to MySQL, you maybe dead.
ALSO IF YOU SIMPLY FORGET YOUR PASSWORD, YOU ARE REALLY DEAD.
This instruction is only for the people who unchecked the permission of Login page by mistake from Site map.
You also need the following knowledge and techniques.
1. Need to Access to MyPHPAdmin
2. Need knowledge of basic MySQL
3. If you don't have access to MyPHPAdmin, you need to have SSH access and know the exact commands.
I'll just explain how you can fix it from MyPHPAdmin.
----------
How to Fix using MyPHPAdmin
----------
1. Login to MyPHPAdmin
2. Select your concrete5 database
3. Go to "PagePermissions" Table
4. Check if there is a row with "cID=5 gID=1 cgPermission=r" (see the 1st attached image)
5. If there is no row with that, click "Insert" tab on the top of the page
6. Enter as my 2nd attached image. cID=5, gID=1 uID=0, cgPermission=r, check "Null" on cgStartDate and cgEndDate. And Leave blank to all function.
7. Click "Go"
8. And you should be able to log in.
9. Also you may want to check if there is cID=5, gID=2 uID=0, cgPermission=r row.
10 If not, you may wan to INSERT as my third image.
But I had an exact same problem before. I didn't bother to share it to everyone... but I now saw you... so I should share my knowledge here.
Please share with us if your solution were different from mine.
----------
If you ever got locked out, follow this instruction.
However, if you don't understand what I am talking about... or don't have an access to MySQL, you maybe dead.
ALSO IF YOU SIMPLY FORGET YOUR PASSWORD, YOU ARE REALLY DEAD.
This instruction is only for the people who unchecked the permission of Login page by mistake from Site map.
You also need the following knowledge and techniques.
1. Need to Access to MyPHPAdmin
2. Need knowledge of basic MySQL
3. If you don't have access to MyPHPAdmin, you need to have SSH access and know the exact commands.
I'll just explain how you can fix it from MyPHPAdmin.
----------
How to Fix using MyPHPAdmin
----------
1. Login to MyPHPAdmin
2. Select your concrete5 database
3. Go to "PagePermissions" Table
4. Check if there is a row with "cID=5 gID=1 cgPermission=r" (see the 1st attached image)
5. If there is no row with that, click "Insert" tab on the top of the page
6. Enter as my 2nd attached image. cID=5, gID=1 uID=0, cgPermission=r, check "Null" on cgStartDate and cgEndDate. And Leave blank to all function.
7. Click "Go"
8. And you should be able to log in.
9. Also you may want to check if there is cID=5, gID=2 uID=0, cgPermission=r row.
10 If not, you may wan to INSERT as my third image.
thats exactly how i did it to, the only thing i can add to that was my methodology for the fix, since i dont know much about mysql.
basically i figured that it had to be a database problem. which led me to poking around in phpMyAdmin, none of which made much sense as i'm a total noobies noob.
however i have a working local xampp version of c5.
so i fired that up along with my local phpMyAdmin, then looked for the anything that could be related to page permissions, there are only two entries that stand out and only one of those can you browse.
i hit the browse button and made a note of all the entries.
i then repeated what i had done before, by unchecking the permission box, then i refreshed the phpMyAdmin page. i made a note of the new settings, and concluded whatever was missing from the first note must be the part i need.
I headed over to my hosted version, and did much the same, finding the pagepermissions part hitting browse, then insert and added the data. i refreshed my website and woopdedoo was back in the game.
thanks katz515 for your time and help.
p.s.
i will just add that at times like these its the panic that causes the inertia. once i calmed down and thought logically about the problem, i realised by retracing my steps in a controlled manner i shoud be able to figure out how to undo what i'd done.
basically i figured that it had to be a database problem. which led me to poking around in phpMyAdmin, none of which made much sense as i'm a total noobies noob.
however i have a working local xampp version of c5.
so i fired that up along with my local phpMyAdmin, then looked for the anything that could be related to page permissions, there are only two entries that stand out and only one of those can you browse.
i hit the browse button and made a note of all the entries.
i then repeated what i had done before, by unchecking the permission box, then i refreshed the phpMyAdmin page. i made a note of the new settings, and concluded whatever was missing from the first note must be the part i need.
I headed over to my hosted version, and did much the same, finding the pagepermissions part hitting browse, then insert and added the data. i refreshed my website and woopdedoo was back in the game.
thanks katz515 for your time and help.
p.s.
i will just add that at times like these its the panic that causes the inertia. once i calmed down and thought logically about the problem, i realised by retracing my steps in a controlled manner i shoud be able to figure out how to undo what i'd done.
