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.

General Questions /

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

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

Lost $databaseConfig in _config.php


Reply


4 Posts   2190 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!