Archive for Downsizer For an ethical approach to consumption
|
sally_in_wales
|
Are php databases meant to be unintelligible?I'm trying to reset an admin password for the control panel of my oscommerce shop. It was originally installed by my webhost support people, and normally I keep a careful note of passwords but for some reason this one is remembered by my computer but I haven't the foggiest idea what it is (nor does the helpdesk, I have asked them). I'm terrified that if the computer 'forgets' the saved password I'll have no way into the shop to process orders.
So, have been onto the oscommerce support forums and have been given instructions on which bit of the database to find and fiddle with to reset it- except I don't seem to have that bit of database at all  I'm supposed to be altering a table called name administrators, but it just doesnt exist. grr, The chaps on the forum are telling me I must be looking in the wrong database, but I only have one phpmyadmin on my control panel, and it has two databases in it, no idea what one of them is but the other one is definately the one the shop info lives in.
|
jema
|
Re: Are php databases meant to be unintelligible? | sally_in_wales wrote: | I'm trying to reset an admin password for the control panel of my oscommerce shop. It was originally installed by my webhost support people, and normally I keep a careful note of passwords but for some reason this one is remembered by my computer but I haven't the foggiest idea what it is (nor does the helpdesk, I have asked them). I'm terrified that if the computer 'forgets' the saved password I'll have no way into the shop to process orders.
So, have been onto the oscommerce support forums and have been given instructions on which bit of the database to find and fiddle with to reset it- except I don't seem to have that bit of database at all I'm supposed to be altering a table called name administrators, but it just doesnt exist. grr, The chaps on the forum are telling me I must be looking in the wrong database, but I only have one phpmyadmin on my control panel, and it has two databases in it, no idea what one of them is but the other one is definately the one the shop info lives in.
|
the table name may well have a prefix that makes it a bit different.eg. my_administrators or something.
|
JB
|
When I've played with PHP databases on other peoples platforms in the past there tends to be a prefix that is common to all "your" tables just as an artifact to create unique namespaces, i.e. it might be there but hidden as JB_administrators while your real tables are in JB_alienartifacts. Equally it might be that you have access to all the JB_* tables but the administrators table is outside of that space and so hidden to you.
|
lettucewoman
|
....now they are taking over another thread..... 
|
sally_in_wales
|
eureka! It turns out that the database does not actually exist for the version of teh shop that I'm running  That would explain why I was utterly unable to find it.
Have finally discovered that the password is nothing more painful than a protected folder, and whilst I havent managed to trace the original password, I have managed to set a second user access with a password I know, so I do at lest have a way in.
Phew. What a round about way to get there in the end
|
|