Enhanced Web Admin

[jsteele]

Yeah, what a surpise :-) Gotta love Microsoft. Seriously, you've gotta' love them 'cause if you don't the will crush you :-)

As old friend of mine used to say about AT&T (back when it was actually "the" phone company ) "once again the elephantine efforts of the Bell system have brought forth a mouse."

[drugstore_cowboy]

If you are trying to access on a share you could have inadvertently locked it with access. I belive Xrecord also uses the database so perhaps that has it locked. I have not had any problems with locking of the DB. I don't use Xrecord so perhaps that is it.

I managed to get a moment or so to play with this tonight and I found out the problem is within the Access database itself. I went into the database and started poking around in the Security options for "User and Group permissions" - turns out that the database permissions are only set for "Admin" the user not for "Admins" the group (or that is how I interperted it). So a simple fix of setting it to the group and adding myself as part of the Admin group within Access and *Boom*... As the Taco Bell commercial says "Good to go".

The compact process always compacts the source Access database file to a new file and therefore that is when the security settings are set.

Thanks for your help UncleJohnsBand

Now if only I can get the Statistics tab working I would be golden !!

[jsteele]

normanr

Just to update you, I reinstalled 93.10 from scratch. The spiking is still there when the web interface connects, but it now seems that it has no effect on the video. Problems seems to have just "gone away" (I hate those :-)

[normanr]

jsteele: has the value of ForceHighPriorityRecordingService maybe changed?

[normanr]

Can you try and get a screenshot of the cpu usage. Do it using 'Process Explorer' from SysInternal, because you can drill down to cpu usage per application. I can't get any great spikes to occur, the worst is about 50%ish.

How many channels do you have information for and for how long? I estimate I have 8 channels x 1 month = 8 channel months of programs. There are 7452 programs in the database.

[jsteele]

Can you try and get a screenshot of the cpu usage. Do it using 'Process Explorer' from SysInternal, because you can drill down to cpu usage per application. I can't get any great spikes to occur, the worst is about 50%ish.

How many channels do you have information for and for how long? I estimate I have 8 channels x 1 month = 8 channel months of programs. There are 7452 programs in the database.

I have about 160 channels defined, about 45 on the cable (twice) and the remainder on the satellite, for 10 days or so. Maybe that could be it

[normanr]

so you have +/- 6 times more data than me, which might explain the 2 or 3 second delay.

It might be interesting to see what a profiler (like nprof) comes up with.

[jsteele]

normanr

Something strange is happening since my last reinstall of 93.10 --- the web interface fails:
------------
Server Error in '/gbpvr' Application.
--------------------------------------------------------------------------------

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

Source Error:


Line 42: {
Line 43: zapConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + databaseFileName );
Line 44: zapConnection.Open();
Line 45: }
Line 46:

-------------------------
Any idea what's happening? I rebooted and there was no other activity happening, just the LiveTV running.

[jsteele]

normanr

Just an update. I disabled the zap database (renamed it) and the web interface works again. The database must be locked by the zaptools interface for some reason when it updates after the EPG.

[normanr]

mmm, odd. I don't see how opening the database can cause an issue like this. Maybe UncleJohnsBand can do some debugging on this one?