Hello,

how can i make my _config always choose the right db connection?

To often i copy something from local to production without changing the db settings and then my site it down.

How can i solve this easily in the _config?

// Local
global $databaseConfig;
$databaseConfig = array(
"type" => "MySQLDatabase",
"server" => "localhost",
"username" => "xxx",
"password" => "xxx",
"database" => "xxx",
);

// Production
global $databaseConfig;
$databaseConfig = array(
"type" => "MySQLDatabase",
"server" => "localhost",
"username" => "xxx",
"password" => "xxx",
"database" => "xxx",
);

if server is localhost, 127.0.0.1 {
use local db settings

else id server is domainname, ip {
use production db settings

How do i convert that so a language Silverstripe understands? :)

Hey yea there are a few ways to do this, have a look at this http://ssbits.com/using-import-in-your-config-php-for-live-site-database-details/

Prefect just what i was looking for!!!

I take back my precious reply...

I doesn't work "anymore"

I get the following message...

[Warning] mysql_connect() [function.mysql-connect]: Access denied for user 'Liveusername'@'localhost' (using password: YES)
GET /4-Productie/xxx.nl/

Line 35 in C:\wampserver\www\4-Productie\xxx.nl\sapphire\core\model\MySQLDatabase.php

_config.php

<?php

....
@include '_liveConfig.php';

?>

_liveConfig.php

<?php

// Production
global $databaseConfig;
$databaseConfig = array(
	"type" => "MySQLDatabase",
	"server" => "localhost", 
	"username" => "livename", 
	"password" => "livepassword", 
	"database" => "livedbname",
); 

Director::isLive('http://www.xxx.nl');
if(Director::isLive()) Debug::send_errors_to("richard.duinmayer@gmail.com");

?>

Does anyone know another way to solve this?

Maybe try an environment file to store your settings - http://doc.silverstripe.com/doku.php?id=environment-management