Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Lost $databaseConfig in _config.php


Go to End


4 Posts   3484 Views

Avatar
lennert

Community Member, 4 Posts

23 September 2010 at 7:38am

I changed the pw for my MYSQL database user (in retrospect I shouldn't have done that), but when I wanted to edit my database settings in _config.php to my surprise there was no $databaseConfig defined in the file. Have no _environment file so I'm wondering where I can find these settings.

Have inherited this site from someone else so I'm not a Silverstripe expert. Any help would be appreciated.
Using SS 2.3.1

Lennert

Avatar
lennert

Community Member, 4 Posts

23 September 2010 at 7:41am

One thing I should have added:

Tried adding $databaseConfig to _config.php but that didn't help. Still am getting "Website Error There has been an error".

Avatar
lennert

Community Member, 4 Posts

23 September 2010 at 8:32am

Went into dev mode and got the following error:

=======
[Warning] mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
GET /

Line 35 in /nfs/c05/h01/mnt/69388/domains/darlingagency.com/html/sapphire/core/model/MySQLDatabase.php

Source

26 /**
27 * Connect to a MySQL database.
28 * @param array $parameters An map of parameters, which should include:
29 * - server: The server, eg, localhost
30 * - username: The username to log on with
31 * - password: The password to log on with
32 * - database: The database to connect to
33 */
34 public function __construct($parameters) {
35 $this->dbConn = mysql_connect($parameters['server'], $parameters['username'], $parameters['password']);
36 $this->active = mysql_select_db($parameters['database'], $this->dbConn);
37 $this->database = $parameters['database'];
38 if(!$this->dbConn) {
39 $this->databaseError("Couldn't connect to MySQL database");
40 }
41
Trace

mysql_connect(localhost,db69388,xxxxxxx)
Line 35 of MySQLDatabase.php
MySQLDatabase->__construct(Array)
Line 72 of DB.php
DB::connect(Array)
Line 187 of main.php

---
(Changed pw). So it looks as if it's getting the correct info.
Will continue digging.

Avatar
lennert

Community Member, 4 Posts

23 September 2010 at 8:41am

Alright fixed it myself.
First of all I was able to find the correct call to the database.
And secondly by making my $databaseConfig global I was able to override the default values which are hidden somewhere.

Thanks for being an audience!