Easymod's password ?

[Mathieu]

Hi,

First of all, excuse me for my english, i'm french .


So, an old administrator installed easymod on our phpbb forum (in order to control MODs):


Our problem is that he did not give us the password before leave us!! I think we can find it in "tables" server (with phpmyadmin for example).
But i don't know where the password is in

Can you say me in what "tables" is the password for easymod please ?


Thanks a lot to those who can help me!
And many excuses for my english .

[Kevin Clark]

Off the top of my head, I think it's in the config table in an entry called EM_password.
However, it will be MD5 hashed and you won't be able to read it. But you can put your own password in instead.

[Mathieu]

Off the top of my head, I think it's in the config table in an entry called EM_password.
However, it will be MD5 hashed and you won't be able to read it. But you can put your own password in instead.

Hi,

In fact, i've only 2 tables with easymod : "phpbb_easymod" and "phpbb_easymod_processed_files"...
What's "MD5" ?

Actually, we're 2 administrators, and none can tape his password in order to enter easymod's page!! (we can't modify MODs !!!!)


An idea ?

[Kevin Clark]

I didn't say it was in the easymod table.
It's in the config table. eg phpbb_config
There are several entries in there prefixed EM_ and I think one is EM_password.

MD5 means you won't see the password as a word. It'll show as a series of letters and numbers as it is 'encrypted'.

[Mathieu]

I didn't say it was in the easymod table.
It's in the config table. eg phpbb_config
There are several entries in there prefixed EM_ and I think one is EM_password.

MD5 means you won't see the password as a word. It'll show as a series of letters and numbers as it is 'encrypted'.

Ok, i understand ! (well... i think ).

How can i "translate" a MD5 in a "normal password" (for exemple 78ddkp7222674o mypassword) ?


Thx

[Kevin Clark]

You can't.

Just put a new password in there.

[Rotsblok]

You can't.

Just put a new password in there.

in a md5 hash i guess

[Kevin Clark]

Don't think it makes much difference (although haven't tried it). As long as the password to EM is different to your main account/db passwords there isn't a lot you could do with it if you knew what it was without knowing the other admin account password.

[Yogi2]

You can't.

Just put a new password in there.

I've run into a similar situation with my board and need to change the EM password. Apparently the only way to do it is to operate on the database tables directly. I'm somewhat familiar with SQL, but don't know the exact code to change one data value, the EM Password in this case. Could you possibly provide that code for me here?

I suppose an alternate solution would be to uninstall easyMOD and start over from scratch. I hesitate to do that because it is on my live board and I don't want to mess it up if I make a mistake.

[Kevin Clark]

Select your database in phpmyadmin.
Click the config table in the left column.
In the main window click the browse tab
Use the > icon to get to the page with the EM_password field on it
Click the pencil icon next to that field
Type in your new password
Click submit.

You can actually also leave the password blank so you don't have to remember it. If you're the only admin then you don't really need one.