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

[blueonyxuser at gmail.com]

I just looked at MySQL and it says a maximum of 64 characters but MariaDB
says to stop at 18 characters......

Tony

> -----Original Message-----
> From: Blueonyx [mailto:blueonyx-bounces at mail.blueonyx.it] On Behalf Of
Tobias
> Gablunsky
> Sent: Wednesday, May 03, 2017 8:04 PM
> To: BlueOnyx General Mailing List
> 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/vsit
eMySQL.
> php.orig	2017-05-03 11:51:18.633071583 +0200
> +++
>
/usr/sausalito/ui/chorizo/ci/application/modules/base/mysql/controllers/vsit
eMySQL.
> 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