Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Thu 30 Oct 2014, 12:29
All times are UTC - 4
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Unsorted
Dotpet Package of Motion (Webcam Video Surveillance)
Moderators: deshlab, Flash, GuestToo, Ian, JohnMurga, Lobster
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
Page 2 of 2 Posts_count   Goto page: Previous 1, 2
Author Message
SimonW

Joined: 28 Mar 2007
Posts: 60
Location: UK

PostPosted: Tue 04 Dec 2007, 10:03    Post_subject:  

Quote:
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".
Back to top
View user's profile Send_private_message 
Igo AtM

Joined: 16 Nov 2006
Posts: 25
Location: UK

PostPosted: Sat 08 Dec 2007, 11:10    Post_subject:  Working SQLiteDBMS for Testing
Sub_title: pet of sqlitedbms user feed back wanted
 

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
sqlitedbms-beta-0.5.2.pet
Description 
pet

 Download 
Filename  sqlitedbms-beta-0.5.2.pet 
Filesize  243.5 KB 
Downloaded  391 Time(s) 

Edited_time_total
Back to top
View user's profile Send_private_message 
mcewanw

Joined: 16 Aug 2007
Posts: 2348
Location: New Zealand

PostPosted: Sat 08 Dec 2007, 12:28    Post_subject: Re: Working SQLiteDBMS for Testing
Sub_title: pet of sqlitedbms user feed back wanted
 

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.
Back to top
View user's profile Send_private_message Visit_website 
BarryK
Puppy Master


Joined: 09 May 2005
Posts: 7060
Location: Perth, Western Australia

PostPosted: Sat 08 Dec 2007, 21:14    Post_subject:  

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
_________________
http://bkhome.org/news/
Back to top
View user's profile Send_private_message Visit_website 
zygo

Joined: 08 Apr 2006
Posts: 211
Location: UK

PostPosted: Sun 09 Dec 2007, 07:32    Post_subject:  

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.
Back to top
View user's profile Send_private_message 
brucehohl

Joined: 07 Jun 2007
Posts: 58
Location: Ohio

PostPosted: Sun 09 Dec 2007, 09:42    Post_subject:  

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.
Back to top
View user's profile Send_private_message 
Igo AtM

Joined: 16 Nov 2006
Posts: 25
Location: UK

PostPosted: Sun 09 Dec 2007, 16:21    Post_subject:  

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

Quote:
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
Back to top
View user's profile Send_private_message 
brucehohl

Joined: 07 Jun 2007
Posts: 58
Location: Ohio

PostPosted: Sun 09 Dec 2007, 20:15    Post_subject:  

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.
Back to top
View user's profile Send_private_message 
Igo AtM

Joined: 16 Nov 2006
Posts: 25
Location: UK

PostPosted: Mon 10 Dec 2007, 02:03    Post_subject: Issues with directory persistence
Sub_title: Are there defaults for Puppy data and log locations
 

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
Back to top
View user's profile Send_private_message 
Igo AtM

Joined: 16 Nov 2006
Posts: 25
Location: UK

PostPosted: Tue 11 Dec 2007, 03:02    Post_subject: Puppy SQLiteDBMS 5.1.2
Sub_title: Minor bugfix update
 

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.
Back to top
View user's profile Send_private_message 
brucehohl

Joined: 07 Jun 2007
Posts: 58
Location: Ohio

PostPosted: Tue 11 Dec 2007, 21:50    Post_subject:  

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
Back to top
View user's profile Send_private_message 
Igo AtM

Joined: 16 Nov 2006
Posts: 25
Location: UK

PostPosted: Wed 12 Dec 2007, 01:00    Post_subject: Current Client Feedback
Sub_title: Issues with the current HTML and javascript client
 

Again thanks for your feedback brucehohl
re the issues you raised
Quote:
(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.
Quote:
(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.
Quote:
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/viewtopic.php?p=162211#162211
Back to top
View user's profile Send_private_message 
Display_posts:   Sort by:   
Page 2 of 2 Posts_count   Goto page: Previous 1, 2
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Unsorted
Jump to:  

Rules_post_cannot
Rules_reply_cannot
Rules_edit_cannot
Rules_delete_cannot
Rules_vote_cannot
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.1070s ][ Queries: 13 (0.0054s) ][ GZIP on ]