I can not log as admin or user

Started by vivid, July 28, 2008, 05:33:59 PM

Previous topic - Next topic

vivid

Hi,

After I made upgrade I couldn't login as admin or normail user
also I can not see my child forum

plz see here

http://www.albahala.org/smf/index.php

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

ccbtimewiz

Whoa, that's some error there. o.o;

Can you tell us exactly how you upgraded? Did you try using the repair_settings.php?

Could you tell us what version of MySQL you're using? What language is your forum set to? What's the error you get when trying to login?

vivid

yes, I used repair_setting.php
bcz my friend try to upgrade my smf
he uploaded the whole 3.1 beta instead of large upgrade

phpMyAdmin - 2.10.1


same language of 3.1 english

no error in login

but I couldn't login as admin or as user

I tried more than 3 admin password

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

ccbtimewiz

Do you have any backups of your SMF 1.1.5 install? Because this looks like serious table corruption...

vivid

unfortunately not
because my friend made all this confusing



تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

Simon Brown

Note: Backup First

Go to the database user table and define a new password using the sha1 function. As I said, at least backup the old value first.

ccbtimewiz

Quote from: Simon Brown on July 28, 2008, 10:33:47 PM
Note: Backup First

Go to the database user table and define a new password using the sha1 function. As I said, at least backup the old value first.

That's to say if that table still functions correctly.

Vivid, does your smf_members table still function? When you browse it, can you see members?

vivid

I have more than 3200 member
I can see some of my member in the index
but my topics, child forum, are disappeared

my forum is fo productive
I have my attachments folder contain more than 30 gb

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

vivid


تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

metallica48423

this doesn't look good.  have you ran the find and repair errors link in admin > forum maintenance?  how about clearing the file cache (same location)?

as a note, anytime you do something that will change the database its a good idea to back up.  Did you happen to click the button in the upgrader that said to backup the tables with backup_?

whats your error logs say?

And if you view the database via phpmyadmin? (What is phpMyAdmin?)
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

vivid

I can not login to my cpanel
my friend who made this upgrade he did not made backup

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

Deprecated

Quote from: vivid on July 31, 2008, 09:08:35 AM
I can not login to my cpanel

Why can't you login to your cpanel?

As far as the admin password, did you try the lost password link?

vivid

#12
I have 3 acounts as admin
all not works

I tried forget my pass
but I didn't receive email

also I can not login as member

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

Deprecated

Quote from: vivid on July 31, 2008, 09:25:08 AM
I have 3 acounts as admin
all not works

Okay, I understand all that. Can you get access to your web host's cpanel? I mean outside SMF, directly to your hosting account?

Can you get into your SQL database, direct access outside SMF?

vivid


تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

metallica48423

if you can't access your site's cPanel, then you should contact your host to get back in.  You *need* to get into phpMyAdmin.

Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Deprecated

Quote from: vivid on July 31, 2008, 10:30:42 AM
I tried all that

You're going to have to explain yourself better if you expect to get any meaningful help.

Either you can get into your hosting account cpanel or you can't. If you can't, telephone them and have them change your password to something else. Then you should be able to get into your cpanel. If you still can't get into it, call your hosting technical support and get help from them.

vivid


تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

Deprecated

Quote from: vivid on August 02, 2008, 11:07:30 AM
I am still waiting 4 help

You have a long wait ahead of you. Unless you answer questions directed at you, nobody is going to be able to help you.

Question: Can you get into your hosting service cpanel?

If not, why don't you call them and arrange for your password to be reset?

If yes, can you get into your database for example using phpMySQL or whatever your host provides for database access?

And why don't you use the "lost password" feature to recover your password? If your admin account email address is wrong, you could fix that using phpMySQL, so that's why we all want to know if you can get into your cpanel.

So either answer the questions or accept the fact that you're never going to get into your forum. If you are having problems with English then perhaps you might seek help in one of SMF's language boards.

ccbtimewiz

Quote from: vivid on August 02, 2008, 11:07:30 AM
I am still waiting 4 help

If you still have the backup of your site, you need to restore it using phpmyadmin.

vivid

I have no backup

any tool there can fix databases?

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

Deprecated

Unless somebody better than I can help you out, and there are plenty of those people on this site, I think you're screwed.

You have now probably learned the lesson to backup your site, and you should do it frequently. I like to explain it this way:

There are two kinds of data: data you have backed up, and data you will lose forever some day.

I hope I'm wrong about your data being permanently borked. If so you are just going to have to start over, all your posts gone and all your members having to join new.

My advice for you is that you should get somebody in your forum administration that has a better understanding of how to operate the technical side of the forum.

metallica48423

Theres nothing further we can do to investigate if you cannot gain access to your hosting control panel to manage your mysql database.  As I said, you need to contact your host to gain said access so that the database can be checked into.
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Deprecated

Yeah, Metallica. I told him he needs cpanel access and you told him he needs cpanel access.

I think we are facing two issues here, that the OP appears to be technically challenged, and he also appears to be language challenged. I think we're facing an unsolvable problem unless one of those changes.

Actually it appears that his db is totally hosed and I doubt even with full technical and language competence that his problem can be fixed. He's probably facing a full reinstall and starting over from a scratch. Thus my lament about lost data, a good enough idea to occupy my signature line for a while. :)

metallica48423

True enough, though I largely prefer to avoid classing members (yes, i am aware that makes me either inexperienced or saintlike in the big picture of support :P) by their technical or communicative abilities.  I find it best not to judge i guess.  I try to work with everyone.

I like to check first though to be sure.  I have had circumstances arise before where database oddities are just a technical misunderstanding.  That said.. yeah, it doesn't sound too pretty
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Deprecated

I certainly meant no slight to the OP, just was stating my opinion of why the solution of this problem is not progressing.

Actually, those who know the least benefit the most from the SMF site, particularly those whose technical skills are at a beginner level. They would have no hope at all of solving their problems without access to somebody with technical skills, and SMF is undeniably the mothership of SMF knowledge. :)

As far as the language, well that's just a different theme installed on the basic 1.0 human, right? :) I believe I made comment earlier that the OP might ask in one of SMF's language boards although I believe their main purpose is to localize SMF for their language. Perhaps the OP might find somebody who speaks his own language who might guide him through the process.

I agree that the case isn't 100% unlikely to be fixable as I too have seen a hopeless situation turn into a good save, but without better information on the actual state of the OP's database it appears unlikely to be resolved.

I'm going to assume at this point that unless we can convince the OP to get access to his cpanel it's probably a lost cause.

vivid

I can access there. I should change my password there also
but still my child forums my topic all cracked. the frontpage seem half-blank

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

vivid

I change my password in phpmyadmin
but still I can not acess. all my members also can not access.

Password security has recently been upgraded. Please enter your password again.

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

Deprecated

You can't just change your forum password using phpMyAdmin because the passwords are encrypted. If you put a plain text password in your database it will decrypt to something meaningless.

Verify that your account email address is correct, and then use the forum's "Forgot your password?" feature. You should be able to login to your forum that way.

Let us know if this works.

vivid

Quote from: Deprecated on August 04, 2008, 08:13:31 AM
You can't just change your forum password using phpMyAdmin because the passwords are encrypted. If you put a plain text password in your database it will decrypt to something meaningless.

Verify that your account email address is correct, and then use the forum's "Forgot your password?" feature. You should be able to login to your forum that way.

Let us know if this works.

already tried it
but useless

I did al plossible things

the most dengrous thing is that my topics child forums
seem gone with wind

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

Deprecated

Okay, it is possible to take a plain text password and encode it, then put that in your database for admin password. My understanding is that SMF passwords are encoded using the PHP function sha1(). In theory some code could be written that would turn a plain text password into SMF's sha1 encoded format. Unfortunately I'm not skilled enough to write it, but perhaps one of the SMF code experts might help you.

Hey SMF coding experts! Is there any utility already written to turn a plain text password into the SMF sha1 encoded password? Or is anybody interested in writing one?

I don't know if we'll ever get vivid's forum back without it.

metallica48423

#31
Its pretty simple.

take the username, turn it all lowercase.  prepend it to the password.  Hash it with sha1.

for example

User: Metallica48423
Pass: smfpwnsj00 (and no -- this is not my password -- don't bother trying it :P)

unhashed: metallica48423smfpwnsj00
hashed: 551e74401705a0067eac85cf90d37f1f7d4c04e9

You can do it in phpmyadmin.  Go into the members table and find the row for the member.  Click on the edit button.  In the password field, enter the unhashed value.  In the left dropdown, select sha1.  Save.  It'll hash the password

Alternatively, you CAN also hash just the password in md5 -- but you'll have to enter it twice so SMF can rehash it.  But MD5 is not as secure, so it will not allow you to fully login until it is properly entered and rehashed
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Deprecated

#32
Wow, that's brilliant Metallica! :) I was reading the code and now this makes more sense:

sha1(strtolower($user_settings['member_name']) . un_htmlspecialchars($_POST['passwrd']))

Vivid, let us know if you understand what Metallica said in his post above. Can you do it?

If you don't understand it, tell us what your admin account name is and we can encode the password for you and post it here. (Don't post your password. We'll pick a temporary one.) You should then change it immediately after logging in, or otherwise anybody reading this thread would be able to login to your account.


ETA: Yeah, I tried it on my test account and it worked perfectly.

vivid

nothing new
same problem

can somebody from smf help me
I am ready to sign as charter member

plz my forum is so productive

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

ccbtimewiz

Quote from: vivid on August 05, 2008, 06:30:49 AM
nothing new
same problem

can somebody from smf help me
I am ready to sign as charter member

plz my forum is so productive

Well if you don't have cpanel access, what exactly are we able to do?

Deprecated

Quote from: vivid on August 05, 2008, 06:30:49 AM
nothing new
same problem

Were you able to change your admin password using phpMyAdmin as described above?

metallica48423

sir, we can unfortunately not help you if you cannot answer the questions for the information we need to know in order to be able to figure out the problem, its cause, or a solution.

I do not say this to be rude in the least bit and such is not my intent but without the proper information there is nothing that we can do.  The same would be true with a charter membership -- we simply do not have access to anyone's boards or hosts without being provided with such information by the owner of the board/hosting account.

If you'd like any of us to check on your database then you need to provide the means for us to gain access to it, preferably by private message.
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

vivid


تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

vivid

Quote from: Deprecated on August 05, 2008, 08:26:24 AM
Quote from: vivid on August 05, 2008, 06:30:49 AM
nothing new
same problem

Were you able to change your admin password using phpMyAdmin as described above?

yes, I followed all your instructions

تجميل <a href="http://www.arbsb.com" rel="dofollow">طرائف</a>
<a href="http://www.arbsb.com">مجلة الغرائب عرب سبيس </a>

Deprecated

Good luck and I hope Metallica fixes your problem.

He is your last, best chance. :)

metallica48423

#40
You said prior that your board has 3200 members.  I see only 413 in the database your forum is connecting to -- however there is another database that has around that number of members.

The forum is connecting to a database within vivid20_vivid15
But the database with that number of members is vivid20_vivid002 -- which has a database vivid20_sudanese (the database containing 3,166 members)

Can you go more in depth with what happened beofre and around this happening?

The vivid2_vivid15 database seems to be severely corrupted.   I did a sql query that replaced all the board names (all but one was null) so that I could go into the boards, but then discovered the same problem had come to both a large quantity of the topics and nearly all the posts. 

I'm really stumped -- but why is there two databases?
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Advertisement: