Users added to many DBs and can't remove

Trel

Well-Known Member
Apr 9, 2003
116
0
166
I'm using

MySQL version 4.0.13
cPanel Build 7.1.6-EDGE 42
Theme cPanel X v2.1


In my mysql section

Many of my databases have more than one user in it and also I can't remove certain users from it.

cPanel.net Support Ticket Number:
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
also, I deleted one of the users completely and remade him, and he was still in the list of users in that database

cPanel.net Support Ticket Number:
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
it's stranger.

I deleted them from their own DB
aka deleted trel_agp from DB trel_agp.

That removed them from all DBs

then I re-added them to their own DB and that put them back in all DBs

cPanel.net Support Ticket Number:
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
OK I found the actuall problem in this

If I have database
A
B
C
D

Then I have users
1
2
3
4

and I add them to the databases like

A
-1
B
-2
C
-3
D
-4

What it shows up like is

A
-1
B
-1
-2
C
-1
-2
-3
D
-1
-2
-3
-4

and so on

So basically it is showing the user in the database its in and in every database below it making the last database listed have users from every database in it.

I'm going to check to see if it's just the display or if it is actually adding them to it.

cPanel.net Support Ticket Number:
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
ok.

I checked.

It's only displaying them that way.
The users aren't actually added to all the databases.

cPanel.net Support Ticket Number:
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
can anyone else confirm this?

cPanel.net Support Ticket Number:
 

ahzeff

Registered
May 22, 2003
4
0
151
i have the same problem. not only this.
in the myPhpadmin, i always get Page not found
when I try to do any changes to the tables.

Btw, I am on
WHM 7.1.0 cPanel 7.1.8-R45
RedHat 7.3

cPanel.net Support Ticket Number:
 
Last edited:

Trel

Well-Known Member
Apr 9, 2003
116
0
166
Originally posted by ahzeff
i have the same problem. not only this.
in the myPhpadmin, i always get Page not found
when I try to do any changes to the tables.

Btw, I am on
WHM 7.1.0 cPanel 7.1.8-R45
RedHat 7.3

cPanel.net Support Ticket Number:
what skin do you use though

cPanel.net Support Ticket Number:
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
can anyone else confirm this?

cPanel.net Support Ticket Number:
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
anyone

also is there going to be a fix for this?
if I heard correctly, the x skins is able to auto update
so it wouldn't be too hard to fix right?

cPanel.net Support Ticket Number:
 

NeutralGold

Well-Known Member
Jun 5, 2002
231
0
316
Originally posted by bdraco
Its a namespace problem with the new caching subs. Its fixed in EDGE 75.

cPanel.net Support Ticket Number:
Roger, Just confirming the same problem, I didn't see this thread earlier when I posted..

cPanel.net Support Ticket Number:
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
well there's no way I can get my host to upgrade, they have a problem with edge versions and it was a stretch getting the edge version I have now.

cPanel.net Support Ticket Number:
 

FWC

Well-Known Member
May 13, 2002
354
0
316
Ontario, Canada
Originally posted by Trel
well there's no way I can get my host to upgrade, they have a problem with edge versions and it was a stretch getting the edge version I have now.

cPanel.net Support Ticket Number:
This fix is in the current Release version.
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
they said that the xskin wasn't available for the current release version

cPanel.net Support Ticket Number:
 

FWC

Well-Known Member
May 13, 2002
354
0
316
Ontario, Canada
Originally posted by Trel
they said that the xskin wasn't available for the current release version

cPanel.net Support Ticket Number:
Xskin is built in to Cpanel now. It's there automatically.
 

Trel

Well-Known Member
Apr 9, 2003
116
0
166
well they downgraded to edge 25 or something, and it works now

cPanel.net Support Ticket Number: