Empty Database Password Workaround

edited July 2006 in Vanilla 1.0 Help
While testing vanilla on my local test server, i found that database empty password may cause problems. Thats why i am offering a workaround for this problem; Framework.Class.MySQL.php GetConnection() function: Replace $this->Connection = @mysql_connect($this->Context->Configuration['DATABASE_HOST'], $this->Context->Configuration['DATABASE_USER'], $this->Context->Configuration['DATABASE_PASSWORD']); with if(!isset($this->Context->Configuration['DATABASE_PASSWORD']) || ($this->Context->Configuration['DATABASE_PASSWORD'] == "your_vanilla_database_password")) { $this->Connection = @mysql_connect($this->Context->Configuration['DATABASE_HOST'], $this->Context->Configuration['DATABASE_USER']); } else { $this->Connection = @mysql_connect($this->Context->Configuration['DATABASE_HOST'], $this->Context->Configuration['DATABASE_USER'], $this->Context->Configuration['DATABASE_PASSWORD']); } Also GetFarmConnection() function: Replace $this->FarmConnection = @mysql_connect($this->Context->Configuration['FARM_DATABASE_HOST'], $this->Context->Configuration['FARM_DATABASE_USER'], $this->Context->Configuration['FARM_DATABASE_PASSWORD']); with if(!isset($this->Context->Configuration['FARM_DATABASE_PASSWORD']) || ($this->Context->Configuration['FARM_DATABASE_PASSWORD'] == "your_vanilla_database_password")) { $this->FarmConnection = @mysql_connect($this->Context->Configuration['FARM_DATABASE_HOST'], $this->Context->Configuration['FARM_DATABASE_USER']); } else { $this->FarmConnection = @mysql_connect($this->Context->Configuration['FARM_DATABASE_HOST'], $this->Context->Configuration['FARM_DATABASE_USER'], $this->Context->Configuration['FARM_DATABASE_PASSWORD']); } I think this will solve the empty database password. Any feedback?

Comments

  • Hi tamkun,

    the easiest way to get vanilla work with a blank database password ist to put
    $Configuration['DATABASE_PASSWORD'] = '';

    in the conf/database.php which will overwrite the configuration files in appg/ directory. So you don't need to change Vanillas core files (which may change after an Vanilla update).

    Also, see this discussion.
  • Hi michaelontheroof, Correct but it seems that configuration aren't saved during install. That should be saved during install so the problem will be solved, i think. My workaround is the solution situation where installer works as it is now. Thanks
This discussion has been closed.