Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By comptechie84 on
Ok, I am having some issues here...
I like the drupal system, so I would like to keep it up and going, but I am having some trouble getting the site back up with all of the data that was in there...
The site is http://www.submitcontent.com
First of all... you have to go to http://www.submitcontent.com/index.php because the index.html page that is in there is for when the site is down...
Second... For some reason (probably my fault) the index.php page broke and I had to reload it from a backup. I don't think that is my issue though.
The problem is that this site is meant to hold many categories for articles and when you hover over an article category it gives you a link like http://www.submitarticles.com/article/affiliates
I am assuming because this link has no file extention and the folder "article" never existed that this is some sort of article management within Drupal itself having to do with the mysql database... according to the site owner it is something to the tune of "taxonomy" does this ring a bell to anyone?
Oh, and I am also unable to access the administration section of the site... the link is:
http://www.submitcontent.com/admin, but there is no admin folder...
Can anyone give me some pointers on getting this site back up... This needs to be done like... yesterday.
I guess the first thing I need to know is where to go and check which database username and password is being used by the Drupal system for mysql.
Thank you,
Joshua Foulk
Comments
Sorry, that link is
Sorry, that link is http://www.submitcontent.com/article/affiliates
but it's broken anyways
Oh, my.....
thrown into the fire from the saucepan, are you?
You have a LOT of reading to do.
It sounds like you are trying to work on a system where you don't even know the login username/password of the adminstrator. That isn't going to be an easy system to administer, is it?
Do you have direct access to the MySQL tables? If so, you can find the master login name and password in one of the .ini files. Once there, you can go into the User table and look at the names and passwords for existing users there. That might get you where you are going. You will need to reverse the MD5 coding for the passwords, if that is where you intend to get them from. I'm not entirely sure how to do that, so maybe somebody else can help if that is what you need.
Once you log in to the site, you will find, hopefully, that the addresses you are referencing are what are known as "alias"'s. That is, the user can define a friendly address and the system associates a given piece of information or page with that friendly address. For example, you might find that http://www.submitarticles.com/article/affiliates is really pointing to http://www.submitarticles.com/node/18.
You can edit those friendly addresses from the individual item or, all at once, from Administer->url aliases.
Hope that gives you enough to get the site going.
BTW, you might want to eliminate that Joomla and Mambo stuff in the footer.
Md5 not reversible
MD5 is a one way hashfunction, as such it's nearly impossible to recover a strong password.
To see what the username of the administrative account is execute the query on the drupal database:
(if you use phpmyadmins SQL tab, you may need to omit the final semi-colon)
Then reset the password of user 1 to one you know:
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.
Okay...
No, I am not the original administrator, but I am attempting to restore this data as it is several months worth of work for the owner...
How do I restore the URL Aliasing??? I can't even get into onto the admin page...
http://www.submitcontent.com/admin
returns page not found...
Thanks,
Joshua Foulk
?q=admin
Try the unclean URL ?q=admin.
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.
You need to log in
You need to log in as administrator (that would be User ID=1). Look up the page for instructions as to how to modify the username and password in the MySQL database so that you can do that.
ok... here goes
Here is what we have come up with so far...
I can access the administration page, but I have to put the ?q=admin/whatever in every time i want to change something, or go and do it directly in the database (disabling modules for instance)...
I disabled the clean urls and it is still giving me http://www.submitcontent.com/admin for the administration link on the main site page... how can I change it so that the entire site uses the ?q=whatever (admin or node or whatever) and forgets about using any type of aliasing for the moment (just to be able to access the articles temporarily)
I think my next step would be to reindex the aliases maybe???
Should I remove all of the url aliases from the database (after backing up and backing up again)???
Thanks for your help,
Joshua Foulk
I think it depends
It depends on how the links in question were built. If they were built automatically, then removing the urlAlias capability should, technically, restore those links to their raw state. However, if they were built manually (happens all the time), then removing the aliasing capability will render them broken, subject to manually changing each and every one.
I don't think I'd do that, if I were you, if there was an alternative.
If you can get to Administer->url aliases (admin/path in my system), I would see whether they are correct for a select few before attempting to eliminate them.
Let's assume that the node you want to confirm is found in the urlalias table listing as node/36. Manually navigate to node/36 (see above for q notation if you need it), edit the node and see what the "URL path settings" are. They should match the alias.
I don't know how to re-index the aliases. Maybe just going to the admin page for aliases and looking at one or two of them and then saving will do the trick.
Let us know how you get on.