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

[Tobias Gablunsky]

Hi Michael,

another small glitch we found, one thing that the web interface permits to do that is no problem for MySQL or MariaDB respectively. In the process of migrating existing servers onto the BO base we had to create a database with a dot in its name ("wordpress4.1") - no way, is what the web interface tells.

A small patch allows us to do it:

--- /usr/sausalito/schemas/base/mysql/MYSQL_Vsite.schema.orig	2017-05-03 17:39:37.240714478 +0200
+++ /usr/sausalito/schemas/base/mysql/MYSQL_Vsite.schema	2017-05-03 17:39:57.485361009 +0200
@@ -291,4 +291,4 @@
 </class>
 
 <typedef name="mysqlusername" type="re" data="^[A-Za-z0-9][-]{0,4}[A-Za-z0-9_%]{1,15}$" /> 
-<typedef name="mysqldatabase" type="re" data="^[A-Za-z0-9][-]{0,8}[A-Za-z0-9_%]{1,63}$" /> 
+<typedef name="mysqldatabase" type="re" data="^[A-Za-z0-9][-]{0,8}[A-Za-z0-9_%.]{1,63}$" />

Again, can you please check that this patch will not introduce any harmful things and eventually include it into the system?

Thank you very much,
Tobias

> -----Original Message-----
> From: Blueonyx [mailto:blueonyx-bounces at mail.blueonyx.it] On Behalf Of
> Michael Stauber
> Sent: Wednesday, May 03, 2017 4:46 PM
> To: BlueOnyx General Mailing List <blueonyx at mail.blueonyx.it>
> Subject: [BlueOnyx:21000] Re: limited length of database names
> 
> Hi Tobias,
> 
> > Again, I would like Michael to confirm the innocuousness of this change.
> 
> Yes, it's all good.
> 
> There are probably 2-3 more places in the UIExtensions where the field
> length needs to be changed (Vsite.Create + Vsite.Defaults), but don't
> worry.
> 
> I'll publish an update which bumps the fieldlength in all the relevant
> places to 32 characters somewhat later today.
> 
> --
> With best regards
> 
> Michael Stauber
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx