cancel
Showing results for 
Search instead for 
Did you mean: 

Rogue Database

Firemage
Newbie
Posts: 2
Registered: 28-11-2007

Rogue Database

I have had a mysql database setup on plusnet for quite a few years now, I logged on again yesterday to find another database with just _pn as its name with a test table in it along side my normal DB, I can access both DB under my username and password.
Anyone else had this "problem" ? Is someone hacking my DB ?
Thanks
Martin
4 REPLIES
Community Gaffer
Community Gaffer
Posts: 17,644
Thanks: 636
Fixes: 162
Registered: 05-04-2007

Re: Rogue Database

Strange, I only have the 1 table in here. Which server are you on? (rumpus or humbug) We are trying to replicate the extra table but no luck so far.
*edit*
We managed to replicate this on rumpus but not humbug, problem is being raised. TBH I don't think it's anything to worry about, but obviously it shouldn't be there.
If this post resolved your issue please click the 'This fixed my problem' button
 Chris Parr
 Plusnet Staff
Firemage
Newbie
Posts: 2
Registered: 28-11-2007

Re: Rogue Database

Hi Chris,
The server i use is rumpus.
Thanks for the response, just wanted to check if something had gone wrong.
Community Gaffer
Community Gaffer
Posts: 13,167
Thanks: 941
Fixes: 78
Registered: 04-04-2007

Re: Rogue Database

FYI This has been raised as problem 48152 for investigation.

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

Community Gaffer
Community Gaffer
Posts: 13,167
Thanks: 941
Fixes: 78
Registered: 04-04-2007

Re: Rogue Database

Quick update.
It seems that there was a problem when a user created their database (ie. activated MySQL via the portal). The script served a blank variable that created a database with the name "_pn" and a username "".
From here -
Quote
In the User column, wildcard characters are not allowed, but you can specify a blank value, which matches any name.

This is why several users could see this rogue database.
We're reckoning on it being safe to remove the database/table/user etc, so change control will be raised to get that done shortly. We'll then look at trying to replicate the problem so we can see what we can tighten up with the creation script.

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵