Why there is prefix instead of username inside databases ?

[Spacedust]

It makes stuff even more complicated !

[MRatWork]

Click help. Username is cutoff of databasename.

[Spacedust]

Click help. Username is cutoff of databasename.

This makes even more complicated to move customer databases beetween servers.

[MRatWork]

It's for new database. I think it's better compare to 'tester_wp', especially for changeowner.

[Spacedust]

It's for new database. I think it's better compare to 'tester_wp', especially for changeowner.

With usernames we are able to move customer databases manually from /var/lib/mysql. Now we have to move them manually checking each name :/

[MRatWork]

Why move with manually. Why not using change owner?.

[Kloxo-DR]

Hui Mustafa,

Why move with manually. Why not using change owner?.

By changing owner, - until the change from official - kloxo did not enter all details in mysql database in grant tables. I must admit that I do not know if this was modified or eradicated in the later versions of official kloxo. So I do not know about Kloxo-MR.

I would better suggest to have a /script/changeowner and /script/fix-owner.

This would help from the command line as well as kloxomr could use it as well.

Apart from that, I would love to see a feature Admin Home ---> Fix-Home : under Admin. We have many fix scripts. One could have a webpage for that.

[Spacedust]

Sometimes there is a need to move multiple databases between servers. Doing this manually takes too much time. If we really need to move then we just copy entries inside Kloxo database then just move databases by coping it.

Cpanel is using names like u2467192_news, u2467192_games etc. Why not use them ?

Also we've got some install scripts that were using Kloxo to add databases.

The worst thing is that when we look a customers overusing our MySQL server by installing some crappy PHP scripts. 

In the past it was easy we can just see which processes where used and username was there. Now it's gone. We have to check each database and check which customer it belongs too. Too much work and completely pointless change !

Another example - when removing customer, if something happens ex. script freeze, server reboot etc. and it didn't remove client completely we still that customer databases are on disk so we can manually remove them. Now we don't know which databases were belonging to that removed customer so we need to check one by one. Horrible work !

[insanity]

Spacedust if this is a problem for you, the solution is simple. Back kloxo to normal db struct.

Find in: /usr/local/lxlabs/kloxo/httpdocs/driver/pserver/ddatabaselib.php line 63 to 69

Code: [Select]

/*
if (!$parent->isAdmin()) {
$param['nname'] = self::getDbName($parent->nname, $param['nname']);
} else {
$param['nname'] = substr($param['nname'], 0, 15);
}
*/
and change it to:

Code: [Select]

if (!$parent->isAdmin()) {
$param['nname'] = self::getDbName($parent->nname, $param['nname']);
} else {
$param['nname'] = substr($param['nname'], 0, 15);
}

Find line 72:

Code: [Select]

$param['nname'] = random_string_lcase(4) . "_" . $param['nname'];
and change it to:

Code: [Select]

//$param['nname'] = random_string_lcase(4) . "_" . $param['nname'];
then find:

Code: [Select]

// if (!$parent->isAdmin()) {
// $dbprefix = self::fixDbname($parent->nname);
// }

// $vlist['nname'] = array('m', array('pretext' => $dbprefix));
$vlist['nname'] = array('m', array('pretext' => 'prefix_'));
// $vlist['dbtype'] = $class;
and change it to:

Code: [Select]

if (!$parent->isAdmin()) {
$dbprefix = self::fixDbname($parent->nname);
}

$vlist['nname'] = array('m', array('pretext' => $dbprefix));
// $vlist['nname'] = array('m', array('pretext' => 'prefix_'));
// $vlist['dbtype'] = $class;

As i see now kloxo add random generated databases for exampe UHahqd9_dbname ( like cpanel )

[Spacedust]

Spacedust if this is a problem for you, the solution is simple. Back kloxo to normal db struct.

Find in: /usr/local/lxlabs/kloxo/httpdocs/driver/pserver/ddatabaselib.php line 63 to 69

Code: [Select]

/*
if (!$parent->isAdmin()) {
$param['nname'] = self::getDbName($parent->nname, $param['nname']);
} else {
$param['nname'] = substr($param['nname'], 0, 15);
}
*/
and change it to:

Code: [Select]

if (!$parent->isAdmin()) {
$param['nname'] = self::getDbName($parent->nname, $param['nname']);
} else {
$param['nname'] = substr($param['nname'], 0, 15);
}

Find line 72:

Code: [Select]

$param['nname'] = random_string_lcase(4) . "_" . $param['nname'];
and change it to:

Code: [Select]

//$param['nname'] = random_string_lcase(4) . "_" . $param['nname'];
then find:

Code: [Select]

// if (!$parent->isAdmin()) {
// $dbprefix = self::fixDbname($parent->nname);
// }

// $vlist['nname'] = array('m', array('pretext' => $dbprefix));
$vlist['nname'] = array('m', array('pretext' => 'prefix_'));
// $vlist['dbtype'] = $class;
and change it to:

Code: [Select]

if (!$parent->isAdmin()) {
$dbprefix = self::fixDbname($parent->nname);
}

$vlist['nname'] = array('m', array('pretext' => $dbprefix));
// $vlist['nname'] = array('m', array('pretext' => 'prefix_'));
// $vlist['dbtype'] = $class;

As i see now kloxo add random generated databases for exampe UHahqd9_dbname ( like cpanel )

I will leave it as is but that something unusual I think. It might cause some troubles when couting the quota too, but Kloxo should handle this well.

[Spacedust]

I've changed my mind. This is making so big mess on our servers we are unable to identify properly which databases belongs to which customer. Remember all databases have mysql owner !

This might also cause amazing troubles when counting quota for customers !

How to change this in latest upload