Hi again,
as a second reply to my own message: the last patch is working but solving only
a part of the problem. It is covering only the creation of new additional
databases. For being able to create primary databases with names longer than 16
characters there is another change needed:
---
/usr/sausalito/ui/chorizo/extensions/modifyWeb.Vsite/15_MYSQL_Vsite.php.orig
2017-05-03 16:25:26.517303822 +0200
+++ /usr/sausalito/ui/chorizo/extensions/modifyWeb.Vsite/15_MYSQL_Vsite.php
2017-05-03 16:23:43.165098084 +0200
@@ -88,7 +88,7 @@
$enable->addFormField($solmysqlPass,
$factory->getLabel('solmysqlPass'));
$solmysqlDB = $factory->getTextField('solmysql_DB',
$featureMYSQL_Vsite['DB'], 'r');
- $solmysqlDB->setMaxLength("16");
+ $solmysqlDB->setMaxLength("32");
$solmysqlDB->setOptional(false);
$solmysqlDB->setPreserveData(false);
$enable->addFormField($solmysqlDB,
$factory->getLabel('solmysqlDB'));
@@ -200,7 +200,7 @@
$enable->addFormField($solmysqlPass,
$factory->getLabel('solmysqlPass'));
$solmysqlDB = $factory->getTextField('solmysql_DB',
$my_dbname, $prot);
- $solmysqlDB->setMaxLength("16");
+ $solmysqlDB->setMaxLength("32");
$solmysqlDB->setOptional(FALSE);
$solmysqlDB->setPreserveData(false);
$enable->addFormField($solmysqlDB,
$factory->getLabel('solmysqlDB'));
Again, I would like Michael to confirm the innocuousness of this change.
Thanks,
Tobias
> -----Original Message-----
> From: Blueonyx [mailto:blueonyx-boun...@mail.blueonyx.it] On Behalf Of
> Tobias Gablunsky
> Sent: Wednesday, May 03, 2017 12:04 PM
> To: BlueOnyx General Mailing List <blueonyx@mail.blueonyx.it>
> Subject: [BlueOnyx:20994] Re: limited length of database names
>
> Hi there,
>
> we just tried to fix this by ourselves and changed the limiting value of
> the gui from 16 to 32 characters. Well, this worked immediately.
>
> This is the patch:
>
>
> ---
> /usr/sausalito/ui/chorizo/ci/application/modules/base/mysql/controllers/vs
> iteMySQL.php.orig 2017-05-03 11:51:18.633071583 +0200
> +++
> /usr/sausalito/ui/chorizo/ci/application/modules/base/mysql/controllers/vs
> iteMySQL.php 2017-05-03 11:51:21.893014043 +0200
> @@ -448,7 +448,7 @@
> if ($get_form_data['addDB'] == "true") {
> if ($num_dbs < $vsite_MySQL['maxDBs']) {
> $ndbField = $factory->getTextField("new_db_name", '',
> 'rw');
> - $ndbField->setMaxLength("16");
> + $ndbField->setMaxLength("32");
> $block->addFormField(
> $ndbField,
> $factory->getLabel("new_db_name"),
>
>
> Michael, can you please confirm that this change is without negative
> impact to the rest of the system?
>
> Thanks and regards,
>
> Tobias
>
>
> > -----Original Message-----
> > From: Blueonyx [mailto:blueonyx-boun...@mail.blueonyx.it] On Behalf Of
> > Tobias Gablunsky
> > Sent: Wednesday, May 03, 2017 10:13 AM
> > To: BlueOnyx General Mailing List <blueonyx@mail.blueonyx.it>
> > Subject: [BlueOnyx:20993] limited length of database names
> >
> > Hi all,
> >
> > we have a customer that is moving from a self deployed and managed
> server
> > to one with BO on it, 5209R exactly.
> >
> > Now we have to move existing databases and are having the problem that
> we
> > cannot install databases as they are: BO does not let us create
> databeses
> > which names exceed 16 characters.
> >
> > Is there a way to avoid this limitation? Use a handler script per
> command
> > line maybe? Or do I really have to tell my customer that he is forced to
> > rename all of his databases and change the configuration of all of its
> > applications?
> >
> > HELP, please!
> >
> > Thanks,
> > Tobias
> >
> >
> > _______________________________________________
> > Blueonyx mailing list
> > Blueonyx@mail.blueonyx.it
> > http://mail.blueonyx.it/mailman/listinfo/blueonyx
>
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx@mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx
_______________________________________________
Blueonyx mailing list
Blueonyx@mail.blueonyx.it
http://mail.blueonyx.it/mailman/listinfo/blueonyx
