746068 - unable to locate the API to request site settings

Status: RESOLVED FIXED

(developer.mozilla.org Graveyard :: Wiki pages, defect)

Description

[Swarnava Sengupta (:Swarnava)]

go to https://developer-stage9.mozilla.org/en-US/
click on "Firefox for Dev" links or alternatively you can go here https://developer-stage9.mozilla.org/en/Firefox_for_developers
an error returned

"Site settings could not be loaded

We were unable to locate the API to request site settings. Please see below for debugging information. If this is a new install, try refreshing - the API is simply taking its time loading up!

HTTP Response Status Code: 500

The API says: wiki 'developer-stage9.mozilla.org' has failed to initialize or did not start up properly: Initialization exception: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Exception of type 'System.Exception' was thrown. at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0 --- End of inner exception stack trace --- at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in :0 at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in :0 at MySql.Data.MySqlClient.MySqlPool..ctor (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in :0 at MySql.Data.MySqlClient.MySqlPoolManager.GetPool (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in :0 at MySql.Data.MySqlClient.MySqlConnection.Open (Boolean allowPooled) [0x00000] in :0
"

Comment 1

[Jake Maul [:jakem]]

I have confirmed that I am able to connect to the DB specified in LocalSettings.php by hand, from the devmostage01 and 02. However, using tcpdump I discovered that this is not, in fact, the IP that it's connecting to!

The file specifies:

                'db-server' => '10.22.70.63',


tcpdump shows:

11:43:00.415080 IP 10.22.81.36.33158 > 10.2.70.130.mysql: S 4268086822:4268086822(0) win 5840 <mss 1460,sackOK,timestamp 513270425 0,nop,wscale 7>



I'm grepping through the whole system now, looking for 10.2.70.130. If anyone knows a good place to look right off the bat, please comment. I'm really hoping it's not storing DB connection info *in* the database or something.

Comment 2

[Jake Maul [:jakem]]

This is fixed!

There is an additional XML config file in /etc/dekiwiki, managed by puppet, that is the *primary* source of DB connection info. The settings in LocalSettings.php and in the DB (yes, there are DB connection settings within the DB, pointing to itself) are legacy, according to MindTouch.