11
ackbarr
Re: No Admin Installation

Do you have the ability to execute SQL queries on your MySQL db directly? If so, try the following:

Query #1 (get uid of your user account)
SELECT uid FROM `<table prefix>_usersWHERE uname='<login>'


Write down the uid returned by the above query, normally it will be '1'.

Query #2 (add user to admin group)
INSERT INTO `<table prefix>_groups_users_link` (uidgroupidVALUES(<value from query #1>, 1)


For the above queries to work you'll need to replace the values enclosed in <> with your installation specific values.

12
Cecilia
Re: No Admin Installation
  • 2004/7/19 14:44

  • Cecilia

  • Just popping in

  • Posts: 8

  • Since: 2004/7/19



Query on user table - uid is 1

Query on groups_users_link table - there is 2 entries both with uid 1. Here is the data.

Entry 1: linkid 1, groupid 1, uid 1
Entry 2: linkid 2, groupid 2, uid 1

13
Herko
Re: No Admin Installation
  • 2004/7/19 15:03

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


Are you absolutely sure that you're logging in with the same info you entered during the install? That is the user you have to login with to get to the admin panel. Make sure your password is case-correct... Also, make sure the site is added as a trusted site to your firewall software, as that may block logins too.

Herko

14
Cecilia
Re: No Admin Installation
  • 2004/7/19 15:46

  • Cecilia

  • Just popping in

  • Posts: 8

  • Since: 2004/7/19


Herko and everyone,

Now I feel really st******d! I'm in. I thought I had tried logging in already...anyhow, thank you .

15
philsco
Re: No Admin Installation
  • 2004/7/19 18:28

  • philsco

  • Just popping in

  • Posts: 2

  • Since: 2004/7/19


actually, was following this thread because I have the same problem.
- Was abe to log in as admin
- Deactivated the login module (so it doesn't show on the home page)
- And now /admin.php returns "You don't have the right to access this area" and sends me back to the home page.

Thoughts on what I'm doing wrong?

16
Herko
Re: No Admin Installation
  • 2004/7/19 19:56

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


Phil: you do need to login before you can get into the admin section. Use user.php directly for that (ie. www.yoursite.net/user.php)

Herko

17
philsco
Re: No Admin Installation
  • 2004/7/19 20:04

  • philsco

  • Just popping in

  • Posts: 2

  • Since: 2004/7/19


sweet! works! Thanks.
Guess I thought there were 2 different login processes, one for admin and one for users.
Thx.

Login

Who's Online

199 user(s) are online (140 user(s) are browsing Support Forums)


Members: 0


Guests: 199


more...

Donat-O-Meter

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

Latest GitHub Commits