[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: anonymous
Subject: [Dolibarr-bugtrack] [bug #29598] Underscore not allowed in database name
Date: Sun, 18 Apr 2010 14:06:57 +0000
User-agent: Mozilla/5.0 (X11; U; Linux x86_64; fr; rv: Gecko/20100415 Ubuntu/10.04 (lucid) Firefox/3.6.3


                 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




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:


  Message posté via/par Savannah

reply via email to

[Prev in Thread] Current Thread [Next in Thread]