Posted by mkarliner on March 17, 2008 at 11:38am
I've got a site that was built some time ago, which
we have suddenly lost admin access to.
It's actually used not as a community site, but as
a commercial brochure, so there are only 3 users.
I've had a look at the database, and I have the
authenticated user role, (and I was the first user),
and the authenticated user role has all the necessary
permissions, but I still can't edit any pages or indeed
do anything an anonymous user can't do.
Based in London UK. Please contact me immediately
with a rough quote for fixing this.
UK mobile +44 750 8000 458
Comments
=-=
If you are brave you can try this: Go to your database and browse the 'users' table to make sure that your #1 account is missing (that there is no row with uid=1). If it is really missing, then create it with an SQL query like:
INSERT INTO users (uid, name, pass) VALUES ('1', 'yourname', md5('yourpassword'));
(Use your table name prefix (if any) and your username, password and email.)
When you log in go to user/1 and fill-in any other missing details.
Then get upgraded to Drupal 5.x since 4.7 is no longer supported and get secure.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
No dice
Thanks for the rapid response, but there is a uid=1 user,
*and* he has an entry in the users_roles table for authenticated
user, and the authenticate user role has plenty of permissions.
So I'm still stumped and willing to pay for a fix.
cheers
Mike
No need to pay!
First, back up your existing database.
Then, in the user table, edit the email address for UID1, and make that your email address.
Then, navigate to yoursite.com/?q=user, and do a password recover for uid1 -- the pw will go to your email, and you should be set.
If this doesn't work, then you might have greater issues here.
I hope this helps --
Cheers,
Bill
-------
http://www.funnymonkey.com
Tools for Teachers
-------
http://www.funnymonkey.com
Click. Connect. Learn.
Using Drupal in Education
More info
Wsup
When did this happen, was something installed or modified? Maybe a server crash..
Maybe a Bitter employee? or worse.. a Forgetful Employee (passwords can be forgotten). Something had to have happened for this result to show its Ugly head,
No need for a quote, I will do what I can to help :)
---
When God is with you, who can stand against you?
--
When God is with you, who can stand against you?
Requested Info
Nothing has been installed or modified in the best part of 2 years.
The reason it has got left at 4.7 is that I unfortunately made liberal
use of the Wiki plugin which was orphaned at 4.7, so upgrades would
have been painful. (Also, given there isn't even an obvious login on
the system, and it doesn't naturally attract the bad guys, as its
a specialist film industry site, I deemed it pretty safe)
It's on fasthosts, who did have a major compromise some while ago, but
the events are far apart. I installed it, as I have installed many Drupals over
the years, (although in truth I now do custom Ruby on Rails sites).
I was the first user, I can still log in, but can't do any admin.
I can access MySql and as far
as I can see, I have all the permissions I need, via users_roles and
permission tables, but the site stubbornly says access denied.
I spotted one extra user (making a total of three :) in the users table,
but I changed his password, via mysql and his access is no better than mine
so if he's a hacker he is a lousy one. All, in all a bit of a mystery.
BTW many thanks for the offer of help and to all others responding.
cheers
MIke
Do you see any of the admin
Do you see any of the admin links, like edit, etc? If so, what happens if you click them?
http://www.trailheadinteractive.com
Any chance either PHP or
Any chance either PHP or mySQL was upgraded?
Software Versions
mysql 4.1.22 standard log, so I suspect not been recently upgraded :-) At least on the client end
php 5.1.6 built Sep 2007, so possible, although this problem is less than a week old.
Mike
(Still willing to pay)
I would ask the hosting company when they change to PHP 5
I would ask the hosting company when they change to PHP 5 as I seen to recall that can cause login problems with Drupal 4.7
THAT'S IT! Drupal 4.7 php5
For anyone who has just suffered as I have.
add
$GLOBALS['tempUser'] = $user;
to the end of the index.php in the root of the drupal installation.
Thanks for all responses, this community is great.
?
I am presuming that you mean the bottom of the coded page?
ie:
}
drupal_page_footer();
$GLOBALS['tempUser'] = $user;
I tried this but, no go.
Ralph Manis
Infinitee Designs
http://www.infinitee-designs.com/
http://www.infiniteewebdesign.com/
http://www.rock-band-t-shirts.com/
Export nodes/content and rebuild site
You mentioned that it is a brochure site, so I can safely assume that it doe snot have too many features that need rebuilding. If it is just for the content, what if:
You export the SQL/CSV/XML for the node tables
Setup a new install of 4.7
Import your nodes
Upgrade your site to 5.7x and do any updates to make sure the nodes are not orphaned...
-----
iDonny Productions: Web CMS and UI/UX Design, Development & Web Standards
-----
Donny Nyamweya - USER25.com