|
SageTV Customizations This forums is for discussing and sharing user-created modifications for the SageTV application created by using the SageTV Studio or through the use of external plugins. Use this forum to discuss customizations for SageTV version 6 and earlier, or for the SageTV3 UI. |
|
Thread Tools | Search this Thread | Display Modes |
#821
|
|||
|
|||
Hi Slugger,
For some reason I can no longer log into SJQ. I'm running SageTV7. I upgraded Jetty via the plugins manager and then upgraded SRE (Thanks for the help on that), BMT, and the web interface via the plugin manager. All of them are working fine and I can log into them without issue. I did not change username and password credentials and jetty picked them up just fine. However, I can not log into SJQ, it keeps telling me incorrect password. I then went into the jetty config screen and reentered username and password fields and still I can not log into SJQ. What is the next step to troubleshoot? Thanks, Peter |
#822
|
|||
|
|||
SJQ does not use the Jetty id/pwd, it uses its own. What ever it was before, that's what it is now. If you are using a new database with SJQ then it's the default password, which is sjqadmin.
__________________
Twitter: @ddb_db Server: Intel i5-4570 Quad Core, 16GB RAM, 1 x 128GB OS SSD (Win7 Pro x64 SP1), 1 x 2TB media drive Capture: 2 x Colossus STB Controller: 1 x USB-UIRT Software:Java 1.7.0_71; SageTV 7.1.9 Clients: 1 x HD300, 2 x HD200, 1 x SageClient, 1 x PlaceShifter Plugins: Too many to list now... |
#823
|
||||
|
||||
Quote:
__________________
Server: HP AMD64 dual core running Win7 64bit (MCE disabled) with 4G memory Tuners: 2 PVR-500(disabled), 3 HDHR and 1 HDPVR Clients: 2 HD200 and 1 HD100 TV: 70" and 52" and 42" Media Storage: ReadyNas 8TB Recording media: 300GB + 200GB+ 250 GB Network: Gigabit backbone' Thanks to all the developers who work on SageMC, code, utilities and plug-ins to make SageTV better!!! |
#824
|
|||
|
|||
Quote:
Looks like i somehow lost the database so everything is back to a clean default install. Where is the database file stored? I have a backup from a few days ago of the entire sagetv directory. How would I go about restoring it? |
#825
|
||||
|
||||
I created a sjqc.properties file as in the documentation. I run the .bat and don't know what the window says cuz it flashes sooooo fast and disappears.
But when I go into sjq and under clients, nothing is listed.
__________________
Server: HP AMD64 dual core running Win7 64bit (MCE disabled) with 4G memory Tuners: 2 PVR-500(disabled), 3 HDHR and 1 HDPVR Clients: 2 HD200 and 1 HD100 TV: 70" and 52" and 42" Media Storage: ReadyNas 8TB Recording media: 300GB + 200GB+ 250 GB Network: Gigabit backbone' Thanks to all the developers who work on SageMC, code, utilities and plug-ins to make SageTV better!!! |
#826
|
|||
|
|||
It would be in the root SageTV\ dir and it's called sjq.sqlite. Stop Sage, copy that file back into the same location (C:\Program Files\SageTV\SageTV), restart Sage and SJQ will pick up the db file.
__________________
Twitter: @ddb_db Server: Intel i5-4570 Quad Core, 16GB RAM, 1 x 128GB OS SSD (Win7 Pro x64 SP1), 1 x 2TB media drive Capture: 2 x Colossus STB Controller: 1 x USB-UIRT Software:Java 1.7.0_71; SageTV 7.1.9 Clients: 1 x HD300, 2 x HD200, 1 x SageClient, 1 x PlaceShifter Plugins: Too many to list now... |
#827
|
|||
|
|||
That means the task client is not running. If it's configured properly the window will stay open indefinitely when started via the bat file. There are [MS Windows] options to prevent the command window from closing on program termination. You'll want to set that up to see the errors (I don't remember how off the top of my head, but Google is your friend).
__________________
Twitter: @ddb_db Server: Intel i5-4570 Quad Core, 16GB RAM, 1 x 128GB OS SSD (Win7 Pro x64 SP1), 1 x 2TB media drive Capture: 2 x Colossus STB Controller: 1 x USB-UIRT Software:Java 1.7.0_71; SageTV 7.1.9 Clients: 1 x HD300, 2 x HD200, 1 x SageClient, 1 x PlaceShifter Plugins: Too many to list now... |
#828
|
||||
|
||||
PAUSE (I edited and added pause at the end of the .bat. If you think other people will come across the same problem, please add it.
I get this message. Quote:
Quote:
__________________
Server: HP AMD64 dual core running Win7 64bit (MCE disabled) with 4G memory Tuners: 2 PVR-500(disabled), 3 HDHR and 1 HDPVR Clients: 2 HD200 and 1 HD100 TV: 70" and 52" and 42" Media Storage: ReadyNas 8TB Recording media: 300GB + 200GB+ 250 GB Network: Gigabit backbone' Thanks to all the developers who work on SageMC, code, utilities and plug-ins to make SageTV better!!! Last edited by QueOnda; 05-30-2010 at 11:09 PM. |
#829
|
||||
|
||||
you can go to http://www.java.com/en/download/ and ddownload the latest Java if you need it.
It could also mean that where Java is located is not in your PATH. For debudding, click on START, then RUN, then put in CMD and hit enter That should bring up a DOS window. Cd to the directory that you have the sjqc.bat file, then execute/run it from there. This way the window does not close when the bat file ends. |
#830
|
||||
|
||||
Quote:
Quote:
I have: Quote:
__________________
Server: HP AMD64 dual core running Win7 64bit (MCE disabled) with 4G memory Tuners: 2 PVR-500(disabled), 3 HDHR and 1 HDPVR Clients: 2 HD200 and 1 HD100 TV: 70" and 52" and 42" Media Storage: ReadyNas 8TB Recording media: 300GB + 200GB+ 250 GB Network: Gigabit backbone' Thanks to all the developers who work on SageMC, code, utilities and plug-ins to make SageTV better!!! |
#831
|
|||
|
|||
You do not need the java compiler (javac) to run sjqc (or any Java program). You just need to make sure that java.exe is in your system path.
If you have java 1.6.0_20 installed on your system then you have everything you need to run sjqc. Just make sure java.exe is in your system path then it should be good to go.
__________________
Twitter: @ddb_db Server: Intel i5-4570 Quad Core, 16GB RAM, 1 x 128GB OS SSD (Win7 Pro x64 SP1), 1 x 2TB media drive Capture: 2 x Colossus STB Controller: 1 x USB-UIRT Software:Java 1.7.0_71; SageTV 7.1.9 Clients: 1 x HD300, 2 x HD200, 1 x SageClient, 1 x PlaceShifter Plugins: Too many to list now... |
#832
|
|||
|
|||
This worked great. Thanks.
|
#833
|
||||
|
||||
Quote:
Quote:
and also the ipaddress of my computer I'm running both server and client on the same computer. The sjqc.properties in the in c:\sjqc\
__________________
Server: HP AMD64 dual core running Win7 64bit (MCE disabled) with 4G memory Tuners: 2 PVR-500(disabled), 3 HDHR and 1 HDPVR Clients: 2 HD200 and 1 HD100 TV: 70" and 52" and 42" Media Storage: ReadyNas 8TB Recording media: 300GB + 200GB+ 250 GB Network: Gigabit backbone' Thanks to all the developers who work on SageMC, code, utilities and plug-ins to make SageTV better!!! |
#834
|
|||
|
|||
Make sure the server is running. Can you access the web site? If not, then the SJQ server is not running. If you can, then there may be firewall issues preventing the task client from connecting.
__________________
Twitter: @ddb_db Server: Intel i5-4570 Quad Core, 16GB RAM, 1 x 128GB OS SSD (Win7 Pro x64 SP1), 1 x 2TB media drive Capture: 2 x Colossus STB Controller: 1 x USB-UIRT Software:Java 1.7.0_71; SageTV 7.1.9 Clients: 1 x HD300, 2 x HD200, 1 x SageClient, 1 x PlaceShifter Plugins: Too many to list now... |
#835
|
|||
|
|||
I can no longer login to SJQ... I pull up the SJQ webpage, enter in my password and it just sits there, never loading the interface. I have cleared my browsers cache, switched to IE and chrome, all with the exact same result. I've restarted the SageTV service and the computer and still the same thing happens. No matter what I do, I can't login.
I did check the sjq.log file and it seems to be somewhat working... as the file update time is the current time. When viewing the file i see the following error in the log: Code:
2010-06-01 07:51:36,578 INFO [SystemMessageQueueLoader]: Run completed [3094ms] 2010-06-01 07:51:36,843 INFO [MediaFileQueueLoader]: Run completed [4797ms] 2010-06-01 07:51:36,843 INFO [DataStore]: Thread 'SJQ-VacuumCleaner' is seeking an exclusive DataStore connection! 2010-06-01 07:51:36,843 INFO [DataStore]: Thread 'SJQ-VacuumCleaner' has received an exclusive DataStore connection! [WAIT=0ms] 2010-06-01 07:51:36,859 INFO [DataStore]: Thread 'SJQ-LogCleaner' is seeking an exclusive DataStore connection! 2010-06-01 07:51:36,859 INFO [DataStore]: Thread 'SJQ-LogCleaner' is waiting for an exclusive DataStore connection! [AVAIL=4; MAX=5; WAIT=0ms] 2010-06-01 07:52:06,859 WARN [DataStore]: DataStore pool timeout expired! 'SJQ-VacuumCleaner' did not return connection within 30 seconds! Adding a replacement connection to the pool. 2010-06-01 07:52:10,109 FATAL [DataStore]: SQL error java.sql.SQLException: database is locked at org.sqlite.DB.throwex(DB.java:288) at org.sqlite.NativeDB.prepare(Native Method) at org.sqlite.DB.prepare(DB.java:114) at org.sqlite.Stmt.executeQuery(Stmt.java:89) at com.google.code.sagetvaddons.sjq.server.DataStore.loadDDL(DataStore.java:301) at com.google.code.sagetvaddons.sjq.server.DataStore.<init>(DataStore.java:154) at com.google.code.sagetvaddons.sjq.server.DataStore.<init>(DataStore.java:53) at com.google.code.sagetvaddons.sjq.server.DataStore$1.run(DataStore.java:186) at java.util.TimerThread.mainLoop(Unknown Source) at java.util.TimerThread.run(Unknown Source) 2010-06-01 07:52:36,531 ERROR [DataStore]: SQL error java.sql.SQLException: database or disk is full at org.sqlite.DB.execute(DB.java:275) at org.sqlite.DB.executeUpdate(DB.java:281) at org.sqlite.Stmt.executeUpdate(Stmt.java:103) at com.google.code.sagetvaddons.sjq.server.DataStore.freeDiskSpace(DataStore.java:1118) at com.google.code.sagetvaddons.sjq.server.VacuumCleaner.run(VacuumCleaner.java:31) at java.lang.Thread.run(Unknown Source) 2010-06-01 07:52:36,531 WARN [DataStore]: Thread 'SJQ-VacuumCleaner' attempted to return a timed out connection! Dropping connection. 2010-06-01 07:52:36,531 INFO [DataStore]: Thread 'SJQ-LogCleaner' is waiting for an exclusive DataStore connection! [AVAIL=4; MAX=5; WAIT=59672ms] |
#836
|
|||
|
|||
I did just check the size of my sjq.sqlite file and it's almost 8GB!
|
#837
|
|||
|
|||
Slugger,
I've run into an issue several times in the last couple days. Occasionally, it seems it is taking too long for my client task to report a successful start back to the sjq server, so the server marks the process as failed, but the process (MediaShrink) is actually running. Since SJQ marks the process as failed, it starts a new process and now that client is running 2 MediaShrink processes. here is the text of the failed task: Code:
Mon May 31 06:35:51 CDT 2010: Starting task with priority 5/1/10 Killed because tasks cannot remain in STARTED state for more than 60 seconds! Executing command line: C:/BatchFiles/sjq_mediaShrink.bat "//<server>/<path-to-video>/Fringe-OverTherePart1-804315-0.mpg"
__________________
SageTV v9.1.10.479 on Ubuntu (testing v9.1.10.479 on Debian and Win10) |
#838
|
|||
|
|||
Quote:
However, your SJQ db should never get to 8GB unless you're running tasks that dump very large amounts of data and even then, 8GB of text output is a lot of text. Either way, the issue is the SQLite driver could no longer read/write the db file so once that happens all bets are off. Your best best may be to rename the current db file and restart with a fresh/empty db file. Or check the free space on the drive. However, an 8GB db file is going to perform terribly with some of the cleanup methods used in SJQ. Even if you got SJQ to load and use that 8GB db, you'll likely run into file lock errors from SQLite anyway so I would really suggest saving that db file to somewhere (if necessary) and starting over.
__________________
Twitter: @ddb_db Server: Intel i5-4570 Quad Core, 16GB RAM, 1 x 128GB OS SSD (Win7 Pro x64 SP1), 1 x 2TB media drive Capture: 2 x Colossus STB Controller: 1 x USB-UIRT Software:Java 1.7.0_71; SageTV 7.1.9 Clients: 1 x HD300, 2 x HD200, 1 x SageClient, 1 x PlaceShifter Plugins: Too many to list now... |
#839
|
|||
|
|||
There is about 1.5gb of free space on that particular drive. Is there any way to open the sqlite file to extract the jobs
|
#840
|
|||
|
|||
Quote:
First, have a look at the jetty request log and look for the task client's attempt to signal back that it started the task. Is that failing (i.e. 500 status code)? Second, SJQ is killing the first bat file, but whatever that bat file is starting (mediashrink, I assume) is not properly stopping when the bat file is stopping. OR... the bat file is not actually being killed even though SJQ thinks it did kill it. OR... the bat file is starting mediashrink in the background, which means all bets are off when SJQ tried to kill it - it will only kill the bat file and never any processes spawned from it. Fix issue #1 and you're good to go. Help me figure out what's going on with #2 and we can maybe talk to EP to see why mediashrink isn't playing nice when told to die (if that's the actual case).
__________________
Twitter: @ddb_db Server: Intel i5-4570 Quad Core, 16GB RAM, 1 x 128GB OS SSD (Win7 Pro x64 SP1), 1 x 2TB media drive Capture: 2 x Colossus STB Controller: 1 x USB-UIRT Software:Java 1.7.0_71; SageTV 7.1.9 Clients: 1 x HD300, 2 x HD200, 1 x SageClient, 1 x PlaceShifter Plugins: Too many to list now... |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sage Job Queue (SJQ) new release notifications | Slugger | Customization Announcements | 3 | 12-17-2009 09:59 AM |
Plugin: Sage Job Queue (SJQ) | Slugger | SageTV Customizations | 991 | 12-11-2009 03:52 PM |
Sage Job Queue Completed tasks problem | raffmanlt | SageTV Customizations | 2 | 08-18-2009 07:34 PM |
Comskip Monitor VS Sage Job Queue SJQ | personalt | SageTV Customizations | 6 | 03-02-2009 10:27 AM |
Plugin: SJQ v1.1.0RC1 Available - Testers Needed | Slugger | SageTV Customizations | 35 | 04-21-2008 08:12 AM |