1
council
How do I fix this Problem?
  • 2005/2/10 19:15

  • council

  • Not too shy to talk

  • Posts: 184

  • Since: 2004/12/18


I haven't been able to log in since yesterday. I've posted this problem but it is not being answered. I need to get into my XOOPS site.

I've read the faq, tried the fixes, but still can't log on.

I've done searches and have not found any solution.

Also, no one can register on my site.

Surely, someone has a clue to what's going on?

windows xp unix server. Week old installation of xoops

Isnt there a way of forcing my way into administration?

dumped sesseons table, have no firewall, cleaned-out cookies, nothing works.

rick

2
rcjohnson
Re: How do I fix this Problem?
  • 2005/2/10 19:19

  • rcjohnson

  • Not too shy to talk

  • Posts: 187

  • Since: 2004/7/23


what happens when you go to your site installation /user.php

you shoudl be able to log in from there.

3
council
Re: How do I fix this Problem?
  • 2005/2/10 19:34

  • council

  • Not too shy to talk

  • Posts: 184

  • Since: 2004/12/18


Quote:

rcjohnson wrote:
what happens when you go to your site installation /user.php

you shoudl be able to log in from there.


"INCORRECT LOG IN"

Which is the message I've been getting all day.

Also ran the browser check, and everything passed:

Feature Description Test result
Cookies Cookies can be set and read. (via HTTP headers) PASS
Referrer-H The URL of the referring page can be read. (host name) PASS
Referrer-HS The URL of the referring page can be read. (host name + script name) PASS
Referrer-HSQ The URL of the referring page can be read. (host name + script name + query string) PASS
Javascript Javascript within a web page can be executed. PASS
Javascript read cookie Cookies can be read using Javascript. PASS
Javascript set cookie Cookies can be set using Javascript. PASS
Clock The server and client clocks agree within 15 minutes. (uses Javascript) PASS


Ric

4
rcjohnson
Re: How do I fix this Problem?
  • 2005/2/10 20:01

  • rcjohnson

  • Not too shy to talk

  • Posts: 187

  • Since: 2004/7/23


Can you click the link for lost password?

if that stil does not work, try to reinstall xoops, just use the same database and you shoudln't loose anything.

5
council
Re: How do I fix this Problem?
  • 2005/2/10 21:11

  • council

  • Not too shy to talk

  • Posts: 184

  • Since: 2004/12/18


Quote:

rcjohnson wrote:
Can you click the link for lost password?

if that stil does not work, try to reinstall xoops, just use the same database and you shoudln't loose anything.



Sure, but can I install 1.3 over 1.2 without harming the database?

ric

6
highlander
Re: How do I fix this Problem?
  • 2005/2/10 21:30

  • highlander

  • Not too shy to talk

  • Posts: 151

  • Since: 2004/12/5


Hi Council,

If you still have phpMyAdmin acces try the following :

The password is stored in xoops_user field :pass.

It is in MD5. the following lets you create your own md5 password.

<?php
echo md5(password_of_your_choice);
?>


Save this snippit in a *.php file and call it from a browser. You will get the md5 code to put into the database for your username. (xoops_user table)

You should now be able to log in with your username + password_of_your_choice

If this doesnt work your xoops_groups_users_link table might be the problem.
add a new row :
linkid = next unused number
groupid = id of the group you want to be added to (1 = webmasters in my case) (look up in xoops_groups)
uid = userid (look up in the xoops_user table)

This should get you into your site !!!

Greetings Highlander

ps. this post assumes you have XOOPS as your table prefix; change it if needed.

7
tripmon
Re: How do I fix this Problem?
  • 2005/2/10 22:18

  • tripmon

  • Module Developer

  • Posts: 462

  • Since: 2004/2/28


Council, do you claim to be using XOOPS 1.2?

Quote:
Sure, but can I install 1.3 over 1.2 without harming the database?


the info by highlander above will work, but I think the crack you are puffing may counteract the md5 hash.


8
council
Re: How do I fix this Problem?
  • 2005/2/10 22:43

  • council

  • Not too shy to talk

  • Posts: 184

  • Since: 2004/12/18


Quote:

highlander wrote:
Hi Council,

If you still have phpMyAdmin acces try the following :

The password is stored in xoops_user field :pass.

It is in MD5. the following lets you create your own md5 password.

<?php
echo md5(password_of_your_choice);
?>


Save this snippit in a *.php file and call it from a browser. You will get the md5 code to put into the database for your username. (xoops_user table)

You should now be able to log in with your username + password_of_your_choice

If this doesnt work your xoops_groups_users_link table might be the problem.
add a new row :
linkid = next unused number
groupid = id of the group you want to be added to (1 = webmasters in my case) (look up in xoops_groups)
uid = userid (look up in the xoops_user table)

This should get you into your site !!!

Greetings Highlander

ps. this post assumes you have XOOPS as your table prefix; change it if needed.



Followed the first solution, it didn't work.

With the second solution I couldn't locate "groupid" in the new row. Installed the new row anyway, with no results.

Ok, what about reinstalling Xoops? Can I install 1.3 over 1.2 without losing data?

Ric

9
tripmon
Re: How do I fix this Problem?
  • 2005/2/10 22:54

  • tripmon

  • Module Developer

  • Posts: 462

  • Since: 2004/2/28


Jumping Jesus on a Pogo Stick Man!

What is this 1.2 / 1.3 mumbo jumbo?

Install 2.0.9.2 RIGHT OVER THE TOP.

10
council
Re: How do I fix this Problem?
  • 2005/2/11 0:17

  • council

  • Not too shy to talk

  • Posts: 184

  • Since: 2004/12/18


Quote:

rcjohnson wrote:
Can you click the link for lost password?

if that stil does not work, try to reinstall xoops, just use the same database and you shoudln't loose anything.


When you say use the same database, how do I do that?

Won't a new install report back the database already exists and stop installing?

Ric

Login

Who's Online

182 user(s) are online (120 user(s) are browsing Support Forums)


Members: 0


Guests: 182


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits