[BlueOnyx:24350] easy-migrate.pl and MYSQL_Vsite.pass(alphanum_plus)

[Tomohiro Hosaka]

Hello.

I used /usr/sausalito/sbin/easy-migrate.pl to update from 5208R to 5209R.

I encountered an error.

[ERROR] Failed to update settings of Vsite NameSpace 'MYSQL_Vsite' of Vsite FQDN

After deep analysis, we found that the cause of the error was:

% diff -u old-bq/usr/sausalito/schemas/base/mysql/MYSQL_Vsite.schema
new-bq/usr/sausalito/schemas/base/mysql/MYSQL_Vsite.schema
--- old-bq/usr/sausalito/schemas/base/mysql/MYSQL_Vsite.schema
2014-10-15 09:31:02.000000000 +0900
+++ new-bq/usr/sausalito/schemas/base/mysql/MYSQL_Vsite.schema
2017-09-06 08:05:04.000000000 +0900
@@ -21,7 +26,7 @@
     />

     <property
-        name="pass" type="password" default=""
+        name="pass" type="alphanum_plus" default=""
         writeacl="ruleCapable(adminUser)"
     />

% svn log svn/all/BlueOnyx/ui/base-mysql.mod/glue/schemas/MYSQL_Vsite.schema
------------------------------------------------------------------------
r1705 | mstauber | 2014-10-15 00:30:44 +0900 (水, 15 10月 2014) | 3 lines

2.2.0-0BX04
- Modified glue/schemas/MYSQL_Vsite.schema to allow minus in mysql
  usernames and database names.
------------------------------------------------------------------------

# ack -A5 "alphanum_plus " /usr/sausalito/schemas/basetypes.schema
<!-- alphanum_plus is alphanumeric data plus a "safe" subset of punctuation -->
<typedef
        name="alphanum_plus"
        type="re"
        data="^[A-Za-z0-9\\._-]+$"
/>

I found that the password for the problematic MYSQL_Vsite contained'%'.

This is a report only.

Thanks,