XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / No Admin Installation
Register
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 `_users` WHERE uname=''


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

Query #2 (add user to admin group)
INSERT INTO `_groups_users_link` (uid, groupid) VALUES(<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. http://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.
« 1 (2)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

224 user(s) are online (54 user(s) are browsing Support Forums)

Members: 0

Guests: 224

more...

Donat-O-Meter

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

Latest GitHub Commits