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-boun...@mail.blueonyx.it] On Behalf Of > blueonyxu...@gmail.com > Sent: Wednesday, May 03, 2017 12:19 PM > To: 'BlueOnyx General Mailing List' <blueonyx@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-boun...@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-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 _______________________________________________ Blueonyx mailing list Blueonyx@mail.blueonyx.it http://mail.blueonyx.it/mailman/listinfo/blueonyx