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

[Tobias Gablunsky]

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/vsiteMySQL.php.orig	2017-05-03 11:51:18.633071583 +0200
+++ /usr/sausalito/ui/chorizo/ci/application/modules/base/mysql/controllers/vsiteMySQL.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