Reply to thread

Message

<blockquote data-quote="Shazell" data-source="post: 239900" data-attributes="member: 51936">Well I have a feeling that I have the same problem.Often when I start up MP (I have the autostart plugin switch to MyTV on startup) I end up with a screen prompting me to select the tvserver as it cannot be found.I will endeavour to get some logs for this tonight and post a proper report.But if the problem is just that the SQL service has not started then that should be a fairly easy fix. the TV service one is already in and the code is practically the sameTVservice startup delay in /trunk/mediaportal/xbmc/MediaPortal.cs[code]&nbsp; 312&nbsp; &nbsp; &nbsp; &nbsp; if (_waitForTvServer)&nbsp; 313&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 314&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: Wait for TvServer requested. Checking if installed...&quot;);&nbsp; 315&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; System.ServiceProcess.ServiceController ctrl = new System.ServiceProcess.ServiceController(&quot;TVService&quot;);&nbsp; 316&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; try&nbsp; 317&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 318&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; string name = ctrl.ServiceName;&nbsp; 319&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 320&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; catch (Exception)&nbsp; 321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 322&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ctrl = null;&nbsp; 323&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: TvServer not installed, so we can go on.&quot;);&nbsp; 324&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 325&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (ctrl != null)&nbsp; 326&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 327&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: TvServer found. Checking status...&quot;);&nbsp; 328&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (ctrl.Status == System.ServiceProcess.ServiceControllerStatus.StartPending)&nbsp; 329&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 330&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: TvServer is start pending. Waiting until it starts up...&quot;);&nbsp; 331&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (splashScreen != null)&nbsp; 332&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; splashScreen.SetInformation(&quot;Waiting for startup of TvServer...&quot;);&nbsp; 333&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; try&nbsp; 334&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 335&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ctrl.WaitForStatus(System.ServiceProcess.ServiceControllerStatus.Running);&nbsp; 336&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 337&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; catch (Exception) { }&nbsp; 338&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (ctrl.Status == System.ServiceProcess.ServiceControllerStatus.Running)&nbsp; 339&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: Ok. TvServer is started.&quot;);&nbsp; 340&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; else&nbsp; 341&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: Failed. TvServer is in status {0}&quot;, ctrl.Status.ToString());&nbsp; 342&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 343&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: TvServer is in status {0}. So we can go on.&quot;, ctrl.Status.ToString());&nbsp; 344&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ctrl.Close();&nbsp; 345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 346&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }[/code]Now I am not a dev with access, and only really an amateur at this <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />But adding this afterwards should work for MSSQL server[code]&nbsp; 312&nbsp; &nbsp; &nbsp; &nbsp; if (_waitForSQLServer)&nbsp; 313&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 314&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: Wait for SQLServer requested. Checking if installed...&quot;);&nbsp; 315&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; System.ServiceProcess.ServiceController ctrl = new System.ServiceProcess.ServiceController(&quot;MSSQL$SQLEXPRESS&quot;);&nbsp; 316&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; try&nbsp; 317&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 318&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; string name = ctrl.ServiceName;&nbsp; 319&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 320&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; catch (Exception)&nbsp; 321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 322&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ctrl = null;&nbsp; 323&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: SQLServer not installed, so we can go on.&quot;);&nbsp; 324&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 325&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (ctrl != null)&nbsp; 326&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 327&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: SQLServer found. Checking status...&quot;);&nbsp; 328&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (ctrl.Status == System.ServiceProcess.ServiceControllerStatus.StartPending)&nbsp; 329&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 330&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: SQLServer is start pending. Waiting until it starts up...&quot;);&nbsp; 331&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (splashScreen != null)&nbsp; 332&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; splashScreen.SetInformation(&quot;Waiting for startup of SQLServer...&quot;);&nbsp; 333&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; try&nbsp; 334&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; 335&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ctrl.WaitForStatus(System.ServiceProcess.ServiceControllerStatus.Running);&nbsp; 336&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 337&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; catch (Exception) { }&nbsp; 338&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (ctrl.Status == System.ServiceProcess.ServiceControllerStatus.Running)&nbsp; 339&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: Ok. SQLServer is started.&quot;);&nbsp; 340&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; else&nbsp; 341&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: Failed. SQLServer is in status {0}&quot;, ctrl.Status.ToString());&nbsp; 342&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 343&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Log.Info(&quot;Main: SQLServer is in status {0}. So we can go on.&quot;, ctrl.Status.ToString());&nbsp; 344&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ctrl.Close();&nbsp; 345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; 346&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }[/code]These lines need to be added as well[code]&nbsp; 108&nbsp;&nbsp; private static bool _waitForTvServer = false;[I]&nbsp; 109&nbsp;&nbsp; private static bool _waitForSQLServer = false;[/I]&nbsp; 253&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; _waitForTvServer = xmlreader.GetValueAsBool(&quot;general&quot;, &quot;wait for tvserver&quot;, false);&nbsp; [I]&nbsp; 254&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; _waitForSQLServer = xmlreader.GetValueAsBool(&quot;general&quot;, &quot;wait for sqlserver&quot;, false);[/I][/code]As well as the configuration form being updated</blockquote>

[QUOTE="Shazell, post: 239900, member: 51936"] Well I have a feeling that I have the same problem. Often when I start up MP (I have the autostart plugin switch to MyTV on startup) I end up with a screen prompting me to select the tvserver as it cannot be found. I will endeavour to get some logs for this tonight and post a proper report. But if the problem is just that the SQL service has not started then that should be a fairly easy fix. the TV service one is already in and the code is practically the same TVservice startup delay in /trunk/mediaportal/xbmc/MediaPortal.cs [code] 312 if (_waitForTvServer) 313 { 314 Log.Info("Main: Wait for TvServer requested. Checking if installed..."); 315 System.ServiceProcess.ServiceController ctrl = new System.ServiceProcess.ServiceController("TVService"); 316 try 317 { 318 string name = ctrl.ServiceName; 319 } 320 catch (Exception) 321 { 322 ctrl = null; 323 Log.Info("Main: TvServer not installed, so we can go on."); 324 } 325 if (ctrl != null) 326 { 327 Log.Info("Main: TvServer found. Checking status..."); 328 if (ctrl.Status == System.ServiceProcess.ServiceControllerStatus.StartPending) 329 { 330 Log.Info("Main: TvServer is start pending. Waiting until it starts up..."); 331 if (splashScreen != null) 332 splashScreen.SetInformation("Waiting for startup of TvServer..."); 333 try 334 { 335 ctrl.WaitForStatus(System.ServiceProcess.ServiceControllerStatus.Running); 336 } 337 catch (Exception) { } 338 if (ctrl.Status == System.ServiceProcess.ServiceControllerStatus.Running) 339 Log.Info("Main: Ok. TvServer is started."); 340 else 341 Log.Info("Main: Failed. TvServer is in status {0}", ctrl.Status.ToString()); 342 } 343 Log.Info("Main: TvServer is in status {0}. So we can go on.", ctrl.Status.ToString()); 344 ctrl.Close(); 345 } 346 } [/code] Now I am not a dev with access, and only really an amateur at this :P But adding this afterwards should work for MSSQL server [code] 312 if (_waitForSQLServer) 313 { 314 Log.Info("Main: Wait for SQLServer requested. Checking if installed..."); 315 System.ServiceProcess.ServiceController ctrl = new System.ServiceProcess.ServiceController("MSSQL$SQLEXPRESS"); 316 try 317 { 318 string name = ctrl.ServiceName; 319 } 320 catch (Exception) 321 { 322 ctrl = null; 323 Log.Info("Main: SQLServer not installed, so we can go on."); 324 } 325 if (ctrl != null) 326 { 327 Log.Info("Main: SQLServer found. Checking status..."); 328 if (ctrl.Status == System.ServiceProcess.ServiceControllerStatus.StartPending) 329 { 330 Log.Info("Main: SQLServer is start pending. Waiting until it starts up..."); 331 if (splashScreen != null) 332 splashScreen.SetInformation("Waiting for startup of SQLServer..."); 333 try 334 { 335 ctrl.WaitForStatus(System.ServiceProcess.ServiceControllerStatus.Running); 336 } 337 catch (Exception) { } 338 if (ctrl.Status == System.ServiceProcess.ServiceControllerStatus.Running) 339 Log.Info("Main: Ok. SQLServer is started."); 340 else 341 Log.Info("Main: Failed. SQLServer is in status {0}", ctrl.Status.ToString()); 342 } 343 Log.Info("Main: SQLServer is in status {0}. So we can go on.", ctrl.Status.ToString()); 344 ctrl.Close(); 345 } 346 } [/code] These lines need to be added as well [code] 108 private static bool _waitForTvServer = false; [I] 109 private static bool _waitForSQLServer = false;[/I] 253 _waitForTvServer = xmlreader.GetValueAsBool("general", "wait for tvserver", false); [I] 254 _waitForSQLServer = xmlreader.GetValueAsBool("general", "wait for sqlserver", false);[/I][/code] As well as the configuration form being updated [/QUOTE]

Verification