Remove zadmin_ prefix from database

[vuks89]

I have installed Sentora to my Ubuntu 14.04 VPS and it seems to work fine.
Just one thing so far that I find annoying is that I can't seem to find a way to remove/change default prefix to database name.

[Rick]

Hello,

https://github.com/sentora/sentora-core/...er.ext.php
This is where the databases are created, so also where the name is given to the database.

I will try to remove the prefix for you. Remember, when I remove it in the controller, it won't disappear in the page you see. The page is rendered based on another file.

In the file /modules/mysql_databases/code/controller.ext.php, you need to edit line 101.
Original:

Code:

$db = $zdbh->mysqlRealEscapeString($currentuser['username'] . "_" . $databasename);

Replacement:

Code:

$db = $zdbh->mysqlRealEscapeString($databasename);

To delete the prefix in the form, you need to edit this:
File: modules/mysql_databases/module.zpm. Line 72:
Original:

Code:

<td nowrap="nowrap"><@ CurrentUserName @>_<input name="inDatabase" type="text" id="inDatabase" size="30" /></td>

Replacement:

Code:

<td nowrap="nowrap"><input name="inDatabase" type="text" id="inDatabase" size="30" /></td>

I am not responsible for every kind of disadvantages caused. You are trying this on your own risk. I haven't tested this code!

[apinto]

vuks89 I advise you to think clearly about removing "zadmin_" from the db.
The sentora devs are trying to ADD zadmin_ to FTP accounts and to MySQL usernames (thank you Rick ), and they are doing it for a good reason.

Rick I do not believe you should spend your valuable time doing this as it is a clear step back from what we already have. Although I do value your efforts

Anyways, think about all the issues it can cause.

[vuks89]

Hi again.

Not to be mistaken, I don't have any problem with having prefix to database name and/or FTP account, but I'd like to be able to define it for myself.
If it posses the security threat to not have it, doesn't it make just as much as threat to have one that everybody knows about?

[TGates]

It is defined by the account user name... if username is freddy12, then the db, ftp, etc. will be freddy12_
This is so that the admin can tell which databases, ftps, etc. belong to what user at a glance and helps keep everything organized.

[Rick]

@[Rick] I do not believe you should spend your valuable time doing this as it is a clear step back from what we already have. Although I do value your efforts

My time isn't that valuable. My year of school is almost finished, so I actually can't screw it up anymore. I just want to help him. If this is really what fits his needs, he should use Sentora this way.

[TGates]

@[Rick] I do not believe you should spend your valuable time doing this as it is a clear step back from what we already have. Although I do value your efforts

My time isn't that valuable. My year of school is almost finished, so I actually can't screw it up anymore. I just want to help him. If this is really what fits his needs, he should use Sentora this way.

Well, this will break future updates of Sentora for him. So it is not suggested to do this. He will have to remember to make these changes whenever an update is released

[Rick]

@[Rick] I do not believe you should spend your valuable time doing this as it is a clear step back from what we already have. Although I do value your efforts

My time isn't that valuable. My year of school is almost finished, so I actually can't screw it up anymore. I just want to help him. If this is really what fits his needs, he should use Sentora this way.

Well, this will break future updates of Sentora for him. So it is not suggested to do this. He will have to remember to make these changes whenever an update is released

Yes, but if this is really what he wants, who am I to say no to him? He is responsible for the consequences of his own choices...

[thejohnson486]

If any one know how I can use this? I need 2 special ftp accounts that do not have a prefix.... any help would be awesome

[Me.B]

You need to hack the DB and change manually the use name in MySQL table.

BUT this is not adviced or support. Even cpanel have a prefix for all users.

M B