[BlueOnyx:20999] Re: limited length of database names

[Tobias Gablunsky]

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-bounces at mail.blueonyx.it] On Behalf Of
> Tobias Gablunsky
> Sent: Wednesday, May 03, 2017 12:04 PM
> To: BlueOnyx General Mailing List <blueonyx at 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-bounces at mail.blueonyx.it] On Behalf Of
> > Tobias Gablunsky
> > Sent: Wednesday, May 03, 2017 10:13 AM
> > To: BlueOnyx General Mailing List <blueonyx at 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 at mail.blueonyx.it
> > http://mail.blueonyx.it/mailman/listinfo/blueonyx
> 
> 
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx