XSQL: Run on a schedule

[macrho]

Is it possible to have the XSQL plugin run on an unattended schedule?
I'd like it to scan all my DB files nightly

[nime5ter]

Yes. There are a variety of ways to do it.

You can create a command that sets an event timer (VC.SetEventTimer) for a particular time every night--name this event whatever you like (e.g. "RunXSQL"). You can use the VC.Loaded event to trigger this command when VC launches.

Then use the RunXSQL event as the trigger to initiate your XSQL.GenerateAll command.

If you leave VC running all the time, you'll want to have your XSql command re-initialize the event timer for 24 hours from now (or 23h 59m 59s from now), so that it knows to repeat the action again tomorrow.

Basically, you'll be doing something similar to this: http://voxcommando.com/forum/index.php?topic=1187.0

But instead of getting VC to talk to you at a certain time every day, you'll be asking it to run the genXML for you.

Or you could use the Google Calendar plugin if that is more convenient for you.

[nime5ter]

For more on these actions:

http://voxcommando.com/mediawiki/index.php?title=Actions#SetEventTimer

http://voxcommando.com/mediawiki/index.php?title=Plugin_XSQL

The above action descriptions can also be found within VoxCommmando in the Action Selection Tree. http://voxcommando.com/mediawiki/index.php?title=Logical_Command_Builder

[macrho]

Is Xsql only available for the local host?
I had set up JSON to point to my remote XBMC box, however I moved to xSQL because I could not read my whole library.

error from JSON is basically a timeout while reading my songs: I have 24,928 tracks

If I look at the log file when I try to send a command to my remote XBMC box, it looks like it's trying to send it to localhost and not the remote box:

10/22/2013 12:58:34 PM   669   Action:  XBMC.Send - execbuiltin(ActivateWindow(weather))
10/22/2013 12:58:35 PM   669   sorry! error connecting to XBMC
 ip: 127.0.0.1
port: 8080
port: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:8080
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress&

[jitterjames]

Is Xsql only available for the local host?
I had set up JSON to point to my remote XBMC box, however I moved to xSQL because I could not read my whole library.

error from JSON is basically a timeout while reading my songs: I have 24,928 tracks

If I look at the log file when I try to send a command to my remote XBMC box, it looks like it's trying to send it to localhost and not the remote box:

10/22/2013 12:58:34 PM   669   Action:  XBMC.Send - execbuiltin(ActivateWindow(weather))
10/22/2013 12:58:35 PM   669   sorry! error connecting to XBMC
 ip: 127.0.0.1
port: 8080
port: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:8080
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress&

XSQL reads the SQL files directly.  The XSQL plugin settings allow you to specify the paths of the files.  So normally it is simplest to use when XBMC is running on the same machine as VC.  It is possible to access remote files if they are shared on the network, you just need to enter the correct network path for the files.  If you are not in a position to share the database files on your netowork, then you will be forced to use either the XJSON method, or XMYSQL.

The log snippet you have posted does not appear to have anything to do with XJSON, XSQL, or GenXML in general.  It is hard to tell from just this small portion of the log, but it looks like an old EDEN action for opening the Weather page.

[jitterjames]

error from JSON is basically a timeout while reading my songs: I have 24,928 tracks

If that is really what is happening, it can probably be easily fixed with an adjustment to the plugin.  Please provide the exact error message.

[macrho]

I haven't set up anything in the EDEN settings under options, they are the defaults - should I change them?

Under plugins and XBMC JSON, I set my IP, Port and Username and the test connection was successful
I saved these settings as well

Under xSQL, I'm pointing to UNC paths for the XBMCBuntu box, e.g.
\\XBMCBUNTU\System\userdata\Database\MyMusic32.db



this is what I'm seeing in my log file (is there better day I can provide)?

Code: [Select]

10/22/2013 1:34:23 PM 456 action repeat set to: 1
10/22/2013 1:34:23 PM 456 Action:  XBMC.Send - execbuiltin&parameter=ActivateWindow(musicplaylist)
10/22/2013 1:34:24 PM 467 sorry! error connecting to XBMC
 ip: 127.0.0.1
port: 8080
port: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:8080
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
   --- End of inner exception stack trace ---
   at System.Net.HttpWebRequest.GetResponse()
   at VoxCommando.XBMCcommander.internalWebRequest(String strCommand)
10/22/2013 1:34:24 PM 468 action repeat set to: 1
10/22/2013 1:34:24 PM 469 Action:  XBMC.Send - SendKey(0xF024)
10/22/2013 1:34:25 PM 473 sorry! error connecting to XBMC
 ip: 127.0.0.1
port: 8080
port: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:8080
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
   --- End of inner exception stack trace ---
   at System.Net.HttpWebRequest.GetResponse()
   at VoxCommando.XBMCcommander.internalWebRequest(String strCommand)
10/22/2013 1:34:25 PM 474 action repeat set to: 1
10/22/2013 1:34:25 PM 474 Action:  XBMC.Send - SetPlaylistSong(0)
10/22/2013 1:34:26 PM 479 sorry! error connecting to XBMC
 ip: 127.0.0.1
port: 8080
port: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:8080
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
   --- End of inner exception stack trace ---
   at System.Net.HttpWebRequest.GetResponse()
   at VoxCommando.XBMCcommander.internalWebRequest(String strCommand)
10/22/2013 1:34:26 PM 480 action repeat set to: 1
10/22/2013 1:34:26 PM 480 Action:  XBMC.Send - Action(79)
10/22/2013 1:34:27 PM 489 sorry! error connecting to XBMC
 ip: 127.0.0.1
port: 8080
port: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection


[macrho]

If that is really what is happening, it can probably be easily fixed with an adjustment to the plugin.  Please provide the exact error message.

ERROR: (xbmcSongs.xml) Failed to connect to XMBC:
System.Net.WebException: The Operation has timed out at System.New.HttpWebRequest.GetResponse() at vcPlugins.xJsonHttpCommunicator.PostRequest(String strRequest)

I typed the error as I couldn't see it in my application event viewer

The other pieces are successful [xbmcArtists.xml, etc]

[jitterjames]

this is what I'm seeing in my log file (is there better day I can provide)?

It is best if you attach the entire actual log file to your post, by clicking "Additional Options" and then attaching the file.

[Kalle]

sorry, but do you have a full VC restart after the changes done?

[jitterjames]

I am very confused, but after looking at your log file I am thinking that you did not watch the installation tutorial.

What version of XBMC are you using?

What version of VC are you using?

What configuration did you select when you first ran VoxCommando?

Which commands (if any) currently work?

Did you create or modify any of the XBMC commands in the command tree?

[macrho]

I am very confused, but after looking at your log file I am thinking that you did not watch the installation tutorial.

What version of XBMC are you using?

What version of VC are you using?

What configuration did you select when you first ran VoxCommando?

Which commands (if any) currently work?

Did you create or modify any of the XBMC commands in the command tree?

I actually wound up doing 2 installs of voxCommando. I was going to use it on an HTPC but decided against it and it's running on an older PC in a closet. I do believe I followed the directions but just in case, I'm going to do a fresh install now -- I'm not that far in

I'm running XMBC 12.2 on Ubuntu [xbmcbuntu]
I'm running VC 1.150 [latest downloaded from vox website]
English XBMC 12 Frodo.zip is the configuration

I set up XJSON and XSQL again and attempted to control the XBMC box and some commands are working now.
I attached my log file as it did show an error but not sure it matters

When I start the VoxCommando app, it takes a few minutes to become functional, I gather it's parsing through my library, which is large:

683 movies
14,788 episodes of TV
24,928 music tracks

Anyway to increase the load speed?

[Kalle]

You can take a look on this excellent video http://www.youtube.com/watch?v=O-9QNjEdNhI
this will show you the setup steps for VC and XBMC Frodo.

[macrho]

You can take a look on this excellent video http://www.youtube.com/watch?v=O-9QNjEdNhI
this will show you the setup steps for VC and XBMC Frodo.

It's running great now. I must say with a HUGE library of music, movies and TV -- this is such an easier way to navigate my library.
"Play album the wall" and blamo

[jitterjames]

So everything is working correctly now?  You've mentioned 2 installations, and you've mentioned HTPC, older PC in a closet, and XMBC on Ubuntu, and "the XBMC box".  So I don't really know which is which any more but if it is all working then I guess it does not matter.

How can you speed it up?

When you first do a genXML the rebuild will take a longer time to calculate everything.  After that reloading should be faster, but if it is still slow you can:
- install VC on a faster computer
- remove commands that you don't use, especially ones that reference large lists like the "play song X" commands
- reduce the size of your payloadXML files by removing content from your library.
- change the payloadXML types so that they don't use subset matching, but then you will need to say the exact name of the item, instead of just part of the name.

Your log file looks fine, but you are not issuing any commands or attempting to perform a genXML so I don't know if there is any problem or not.

EDIT: OK great.  I did not see your last post before posting this one!