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

[Tobias Gablunsky]

Hi Tony,

thanks for your answer, but I cannot confirm this information: I already created databases with names longer than 16 characters with MariaDB. But it is not possible to create them via BO web interface (at least without the patch I sent).

Tobias

> -----Original Message-----
> From: Blueonyx [mailto:blueonyx-bounces at mail.blueonyx.it] On Behalf Of
> blueonyxuser at gmail.com
> Sent: Wednesday, May 03, 2017 12:19 PM
> To: 'BlueOnyx General Mailing List' <blueonyx at mail.blueonyx.it>
> Subject: [BlueOnyx:20995] Re: limited length of database names
> 
> 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/vs
> it
> eMySQL.
> > php.orig	2017-05-03 11:51:18.633071583 +0200
> > +++
> >
> /usr/sausalito/ui/chorizo/ci/application/modules/base/mysql/controllers/vs
> it
> 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
> 
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx