Issue #SCB2466 0-UNDECIDED

Activity report on

  *Enhancement SCB2466 - Introduce new property to allow for more flexible MySQL setup*
 
  Scarab Link: http://www.solitone.org/scarab/issues/id/SCB2466
  Module: Scarab


  Activity generated by  Torsten Reuth ([email protected])  at 12/10/2007 16:57

  *Reasons for the changes*
  - Initial entry


  ** Issue created **

-------------------------------------------------------------------------------
  *Personnel changes*
  - User "treuth" assigned as "Observer"
  - User "hyper32" assigned as "Assigned to"

-------------------------------------------------------------------------------
  *Attribute changes*
  - "Database" set to "MySQL"
  - "Priority" set to "0-UNDECIDED"
  - "Status" set to "Unconfirmed"
  - "Target milestone" set to "UNDECIDED"
  - "Summary" set to "Introduce new property to allow for more flexible MySQL setup"
  - "Short description" set to:
    "The idea is to have a property 'scarab.database.allow_from_host' to overcome the 'same host' problem in the scarab setup.

During database creation the 'scarab.database.host' property is used for both initial connection to the database and as an entry in the 'db' table of the MySQL database. There is an implicit issue here if the database is not on the same host as the application.

Assume you have a db-host 'db.company.lan' and an application host 'app.company.lan'. You have to enter 'db.company.lan' as your database host during setup, but if Scarab is run from 'app.company.lan' the database user will fail to connect due to MySQL access restrictions. (Because the user at this point is resolved as '[email protected]')

Suggestion is to introduce a new build time property 'scarab.database.allow_from_host' that in the above scenario would hold 'app.company.lan'. The last line in the 'create-db.sql' should then read

grant all on @DB_NAME@.* to '@DATABASE_USERNAME@'@'@DATABASE_ALLOW_FROM_HOST@' identified by '@DATABASE_PASSWORD@';

However the new variable must default to 'scarab.database.host' so that the script behaviour remains consistent."

-------------------------------------------------------------------------------