[Dolibarr-bugtrack] [bug #29598] Underscore not allowed in database name

[anonymous]

URL:
  <http://savannah.nongnu.org/bugs/?29598>

                 Summary: Underscore not allowed in database name
                 Project: Dolibarr
            Submitted by: None
            Submitted on: dim 18 avr 2010 14:06:56 UTC
                Severity: 3 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 2.8.0
        Operating System: GNU/Linux

    _______________________________________________________

Details:

Bonjour,

Linux
Apache 2.2
PHP 5.2.12 (CGI)
MySQL 5.1.31

Underscores are allowed for MySql database names. Underscores are also used
to define wildcard permissions. This is heavily used feature. 
For example if user john have CREATE permissions on databases "johnsites_%"
(% is the wildcard character), CREATE permissions are valid on databases
johnsites_www and johnsites_dolibarr.

Thus not allowing underscores in database names breaks this MySql feature. I
don't know if underscore is allowed for Postgres database names.

The fix is quite simple :

remove the "_" in htdocs/install/fileconf.php, line 390
if (databasename.match(/[-;_.]/)) { return false; }

I have changed it, the install worked as expected.
Thanks for the great piece of software !




    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?29598>

_______________________________________________
  Message posté via/par Savannah
  http://savannah.nongnu.org/