0

While running the fogbugz diagnostics.php on my Fogbugz 6 installation I get the following:

STEP 3 Testing Search Registration

Search does not appear to be working. FogBugz encountered the following error while trying to query the search service.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ApplicationException: Unable to connect to any of the specified MySQL hosts. ---> 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] --- End of inner exception stack trace --- at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x00000] --- End of inner exception stack trace --- at FogUtil.Search.Index.get_IndexSize () [0x00000] at (wrapper managed-to-native) System.Object:__icall_wrapper_mono_remoting_wrapper (intptr,intptr) at (wrapper remoting-invoke) FogUtil.Search.Index:get_IndexSize () at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[]) at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] --- End of inner exception stack trace --- at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] at System.Reflection.MonoProperty.GetValue (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] index, System.Globalization.CultureInfo culture) [0x00000] at System.Reflection.PropertyInfo.GetValue (System.Object obj, System.Object[] index) [0x00000] at SearchTool.UnixServer.ReadAndExecuteCommand (SearchTool.State state) [0x00000]

How do I get past this?

flag

2 Answers

1

The error is "Unable to connect to any of the specified MySQL hosts". If you search online for this there are a myriad of reasons why this can happen but the top two are 1) permissions and 2) your mysql server is down or there are firewall issues. My guess is you are dealing with #1.

link|flag
0

It looks like Mono is not able to reach your MySQL host. Is upgrading to 7 an option?

link|flag
We can't afford 7. This happened after we moved fogbugz servers. Should we re-install mono? – Manu Jan 7 2010 at 20:52

Your Answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.