Dotpet Package of Motion (Webcam Video Surveillance)

Stuff that has yet to be sorted into a category.
Message
Author
SimonW
Posts: 60
Joined: Wed 28 Mar 2007, 23:15
Location: UK

#16 Post by SimonW »

One thing I have been wondering about Simon. I know Motion can be compiled to work with mysql. However, Puppy Linux 2.17.1 seems to come with sqlite3 (version 3.3.5). Do you know if that could be usefully used with Motion at all? Would maybe save having to install mysql, for example, in order to get database functionality of some sort.
Apologies. but I haven't looked at this thread for some time. I've set email notifications now! I used Grafpup for my system, as it provides a password to protect the system from interference.

To answer your question I know nothing of SQL or SQL lite, sorry.

I think the most difficult part of a system such as this is the GUI. Everyone has their own requirements and wishlist!
I have a set of shell scripts which do what I want, but there's no GUI to that as such, just log files. I did some extension of the Motion Statistics Page (see the Motion wiki) which does "what I want".

Igo AtM
Posts: 25
Joined: Thu 16 Nov 2006, 14:36
Location: UK

Working SQLiteDBMS for Testing

#17 Post by Igo AtM »

I have a working version of SQLiteDBMS running on puppy 2.16 It is very much in a Beta state as I have had to hack the program quite considerably to get it functioning as well or poorly as it is. I'm really putting it up in the hope I get some feed back on its reliability functional failings and also given that I am engaged in ongoing updates especially to the Client browser (most of the back-end is now stable I hope) Any feature requests the puppy public may have.
It is safe to run no hangs and no mem leeks as far as I can tell. It is also no problem with db corruption so usable but the interface is lacking. Given other appropriate db and puppy discussions I felt it may help. It also serves as a good method of checking motionMon db data out ( or litemon ) hence it's appearance here. to run it just up load the pet it should auto install OK. I have tried it on a range of machines and it seems sound. there is no menu item (it is beta and a daemon ) so after install from your favorite terminal just type
sqlitedbms notes (more blerb)
sqlitedbms start restart or stop or status for a very basic output of what it is doing
to get connected in the default install after entering user name and password it is just a case of pointing your browser at <your puppy localhost>:6543 or 127.0.0.1:6543 should do it. The client is problematic but I am in the process of re writing it so bare with it for now but I would be interested in user feedback whilst it can still influence the direction the work on the client is going. package md5 is
62143ca54faa5bac02a6c8a559a029e0 sqlitedbms-beta-0.5.2.pet
enjoy
Last edited by Igo AtM on Tue 11 Dec 2007, 06:42, edited 1 time in total.

mcewanw
Posts: 3169
Joined: Thu 16 Aug 2007, 10:48
Contact:

Re: Working SQLiteDBMS for Testing

#18 Post by mcewanw »

Igo AtM wrote:I have a working version of SQLiteDBMS running on puppy 2.16 It is very much in a Beta state as I have had to hack the program quite considerably to get it functioning as well or poorly as it is. I'm really putting it up in the hope I get some feed back on its reliability functional failings
I'm really looking forwards to trying this out sometime in the near future. Unfortunately, I can't do that just now (and maybe not for a couple of weeks yet) because I'm flat out on a program/programming system I'm currently writing. That should be released as a beta some time next week, though I expect there to be some bugs needing ironed out, like alone the long list of developments I already have planned...

I am hoping that what I'm creating might also be useful in conjunction with Motion in some incarnation or other. I'm particularly delighted that you are working on an implementation of Motion that utilises sqlite (not that I know anything about sqlite myself, other than that I hope and expect it to be "lite"!). Anyway, don't despair if you are not getting much feedback, and please keep up the good work. Your efforts are not being forgotten by this corner.

User avatar
BarryK
Puppy Master
Posts: 9392
Joined: Mon 09 May 2005, 09:23
Location: Perth, Western Australia
Contact:

#19 Post by BarryK »

lgo AtM, this is good news, I greatly appreciate that you are getting involved in getting SQLiteDBMS to run on Puppy. I've made an announcment on my blog, www.puppylinux.com/blog
[url]https://bkhome.org/news/[/url]

zygo
Posts: 243
Joined: Sat 08 Apr 2006, 20:15
Location: UK

#20 Post by zygo »

Using testdb.db3 in puppy 3.01 with Opera 9.23

HTML version:

select * from Contacts
returns, apparently, 4 records as one line of text

javascript version:

Clicked on query and a box came up. After clicking first line in text area I was able to enter the above query. However, clicking execute, gave no results.

brucehohl
Posts: 58
Joined: Thu 07 Jun 2007, 11:47
Location: Ohio

#21 Post by brucehohl »

Regarding SQLiteDBMS:

During shutdown Puppy 2.17.1 did not save the files in /var/sqlitedbms/. Should this have happened? The other sqlitedbms files were saved.

zygo: Regarding the Opera HTML display error try SeaMonkey. I also had a problem with the java client but lost my install (above) before I could confirm the problem.

Igo AtM: Perhaps you could start a thread dedicated to SQLiteDBMS with your next release.

I really like the idea of SQLiteDBMS: using sqlite3 over a web interface. I have played around with a bash script front end for sqlite3 but a web interface is a better approach for many reasons. I look forward to future releases.

Igo AtM
Posts: 25
Joined: Thu 16 Nov 2006, 14:36
Location: UK

#22 Post by Igo AtM »

Hi brucehohl
Thanks for your response it is for the issues you have raised that SQLiteDBMS was put out in the first place so appreciated
During shutdown Puppy 2.17.1 did not save the files in /var/sqlitedbms/. Should this have happened? The other sqlitedbms files were saved.
I normally run a development version of puppy from a low spec laptop in order that pet's generated should be backward compatible but as a hard drive install it of course preserves var on reboot the other test machines I use I run from a usb and I never save as this ensures I do not taint the test with left over libs from other packages. I am not sure but thinking about you lost data it is likely var is not one of the locations that puppy preserves none install dir's when exiting So I may need to find another home for the data the safest and most obvious is root/my-documents/sqlitedbms. Out of interest did it preserve the var/log/sqlitedbms dir ?
Anyway I shall setup a test usb for just this situation and later tonight upgrade the pet to switch the server root to /root/my-documents

As far as the issue with Opera zygo one of the main problems with the original version of SQLiteDBMS was that the client interfaces were made to service IE6 they do not even do that very well. I'm in the process of rewriting the entire client both HTML and javascript which should take about a week before the first versions appear. The pet I put up was only tested on seamonkey as the included browser on puppy but I guarantee the version I am writing is WC3 complaint. As far as the data returned in the HTML browser it is raw XML with no native style sheet so at best it will return a unformatted text document. Again this will be upgraded very soon.

I have already some fixes for issues relating to the javascript version not refreshing data correctly mainly these are filtering through to the existing client as I develop the new version. I don't see the sense in delaying the release of the new one to spend time trying to repair the existing client as it's code base is not so good. I will feed these into the pet as quickly as I can so check back or tag the thread if you want the new versions

thanks for you feed back

brucehohl
Posts: 58
Joined: Thu 07 Jun 2007, 11:47
Location: Ohio

#23 Post by brucehohl »

Igo AtM: /var/log/sqlitedbms also was not preserved. The files in /etc/sqlitedbms and /root/my-applications/sqlitedbms were preserved. I look forward to exploring your next release.

Igo AtM
Posts: 25
Joined: Thu 16 Nov 2006, 14:36
Location: UK

Issues with directory persistence

#24 Post by Igo AtM »

Thanks Barry for raising the profile on this by the way. I just hope I can deal with the immediacy of the demand. It has already served a very useful purpose by highlighting the dir/program persistence issue (which also effects motionMon by the way ) I am in the habit of logging to the standard Linux log locations as with program generated web data which I like to locate in a standard safe if possible sandbox location.
I can understand very well why it would be removed on a Puppy installation. I once had to deal with a program which went ballistic and generated 4 gigs of log garbage in a 24hr period. So what would be the preferred choice for this data on Puppy?
For now I shall move the data dir to /root/my-documents/sqlitedbms but the logs ? SQLiteDBMS drops out on boot up if the log dir has been zapped And I'm not overly keen on placing logs which aren't needed until there are needed. In a random application selected hide away. So what would be the recommended location?
One advantage of this is it has made me rethink an application Puppy type install As such I shall add options to tie down log reporting rotation and g-zipping to the configuration options.
Next release probably around Tuesday assuming I can get the free time

Igo AtM
Posts: 25
Joined: Thu 16 Nov 2006, 14:36
Location: UK

Puppy SQLiteDBMS 5.1.2

#25 Post by Igo AtM »

I have updated SQLiteDBMS to a version that saves to /root/my-documents This should resolve the issue with data persistence across reboots. I have started to use a little bit of version tracking so now we have 5.1.2 all updates will have the 5.1.xx with xx representing the latest version until I post the client I am working on at which point we will become 5.2.xx and when stable 6.xx.xx (this so puppy people know what to expect from updates ). There are a number of small code fixes to this version that may make the current client more responsive. The issues with the failure of the client to refresh data ie screens not uploading are cache clearing and should resolve themselves when the new client comes on line.
For people following this thread reference motionMon I'm sort of holding until SQLiteDBMS is functioning with its new client but it is not forgotten. I may move the majority of info re motionMon to the wiki where I have been given some space.

brucehohl
Posts: 58
Joined: Thu 07 Jun 2007, 11:47
Location: Ohio

#26 Post by brucehohl »

Igo AtM: I encountered a few problems with the new SQLiteDBMS package under Puppy 2.17.1 as follows:

(1) HTML client:
In the HTML version of the client "select * from contacts;" produces the following using SeaMonkey:

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<response>
<changes>0</changes>
<rowid>0</rowid>
<rows>4</rows>
<time>0.018052</time>

<columns>
<columnname>idx</columnname>
<columnname>Name</columnname>
<columnname>add1</columnname>
<columnname>add2</columnname>
<columnname>add3</columnname>
<columnname>add4</columnname>
<columnname>add5</columnname>
<columnname>addpc</columnname>
<columnname>phone_ll</columnname>
<columnname>phone_m</columnname>
</columns>

<row>
<data>1</data>
<data>plop</data>
<data>101 Numpty lane</data>
<data>Isadump</data>
<data>Plankton Dirigable</data>
<data>Utopia</data>
<data>-</data>
<data>PO Box 134567</data>
<data>0989-0870987</data>
<data>0777-1324321</data>
</row>

etc ...

Note using Opera the result is as follows:

0040.113281 idxNameadd1add2add3add4add5addpcphone_llphone_m 1plop101 Numpty laneIsadumpPlankton DirigableUtopia-PO Box 1345670989-08709870777-1324321 2glop102 Numpty LaneIsadumpPlankton DirigableUtopia-Box 10690455-0022734560778-546778 3goop103 Numpty LaneWaddermezzLahula-hantaUtopia---- 4loop104 Numpty HouseBlazewaterWiken-by-trogYammamoto-444


(2) Java client:
From the java client I am unable to type a query in the "query box" using SeaMonkey or Opera.

When I attempted a remote connection to the java client I was not offered any databases to choose from on the drop down list, thus, could not connect.

(3) HTML client note:
It would be nice to have a drop down list of available databases like on the java client.

Regards, BH

Igo AtM
Posts: 25
Joined: Thu 16 Nov 2006, 14:36
Location: UK

Current Client Feedback

#27 Post by Igo AtM »

Again thanks for your feedback brucehohl
re the issues you raised
(1) HTML client:
In the HTML version of the client "select * from contacts;" produces the following using SeaMonkey:
One of the problems with the existing HTML client is it only returns raw data from the database via the server and directed to the client browsers lower frame.
What you are seeing is the server response to the query just dumped into the lower frame. There is no attempt to format it at all. it is left to the capabilities of the individual browser as to how it will display the data. In a way this makes sens as by definition you are using a basic HTML connection hence the assumption is there is no browser capability for scripting js or css. At the base level the server is responding as if you have connected via a text terminal. However as is shown by the seamonkey output there is xml formating piped to the browser which in the case of opera, the browser has striped the tags and just left the text content. I am of a mind to leave this functionality in the version I am building as it dose offer the lowest level text access to the data. This also then would reflect on the issue of having a drop down database selector in the HTML browser as if it is designed for basic access then there would be no way to process the unique data in the form after log on.
As a remedy to these issues what is in the new version is a halfway house which assumes a none javascript browser that is css capable or code that will degrade to an acceptable form in a none css browser. This version dose parse the returned data (or at least the server sends headers that allows it to be dealt with in the browser DOM ) Also selectors are provided for db selection as well as key word SQL selection. As this is being coded into the new version it dose not seem worthwhile correcting it in the existing version.
(2) Java client:
From the java client I am unable to type a query in the "query box" using SeaMonkey or Opera.
There is a known issue with the js client and the SQL query screen A fix will be on its way either today or early tomorrow.
When I attempted a remote connection to the java client I was not offered any databases to choose from on the drop down list, thus, could not connect.
With the log in screen it will sometimes not refresh data to the client properly as a simple resolution to this if you select cancel and open out the side bar clicking log in from there and you should see the databases (every second time ???). Its a kinda weird issue as when I look at the debug output for the server response to the client there is no difference in data between a good and bad log on. On the bright side it is not an issue in the new version where a correct document type is sent with the page so I am assuming it as an issue with that or just uncleared data buffers in the client js
Again thanks for your feed back. By the way when I post the bugfix version (should be 0.5.1.3 I think ) you should upload it as I have picked up a bug in the server that causes data/page transmissions above 32k to be corrupted that can give unknown/undesirable effects on your browser so it needs replacing.
Have opened a new topic for SQLiteDBMS link below (A new version awaits)
http://www.murga-linux.com/puppy/viewto ... 211#162211

Post Reply