Messages

2386

Developers / Re: sqlCVS

« on: November 21, 2007, 10:45:47 pm »

Oh and I almost forgot, when I try to view a batch, I get a bunch of errors:

Code: [Select]

01      11/21/07 21:50:07.016           Query failed (Table 'pluto_main.Version_pschist' doesn't exist): SELECT psc_id,psc_toc,`Version_pschist`.* FROM `Version_pschist` WHERE psc_batch=1839 (1) <0xb78d5a00>
05      11/21/07 21:50:07.016           Resetting mysql connection <0xb78d5a00>
01      11/21/07 21:50:07.017           Query failed (Table 'pluto_main.Version_pschist' doesn't exist): SELECT psc_id,psc_toc,`Version_pschist`.* FROM `Version_pschist` WHERE psc_batch=1839 (1) <0xb78d5a00>
05      11/21/07 21:50:07.018           Resetting mysql connection <0xb78d5a00>
01      11/21/07 21:50:07.018           Query failed (): SELECT psc_id,psc_toc,`Version_pschist`.* FROM `Version_pschist` WHERE psc_batch=1839 retry: (nil) <0xb78d5a00>


it seems that you are missing the table "Version" from the dce repository. Maybe your initial import went wrong?

best regards,
Hari

2387

Developers / Re: sqlCVS

« on: November 21, 2007, 10:41:04 pm »

Anyway, I've been looking around a bit, and I have no clue what batch(es) to approve.  And when I look at: http://62.99.143.187:4000/sqlcvs/?site=batch/view I only see 2 recent IPs, localhost and an internal one.  So I have no idea which one to approve either. 

i did some tests today and managed to checkin changes with a regular user (pluto~pluto). They show up with a negative batch id (not yet approved, sqlCVS calls this "quarantine"). After approving the batch id (works from the gui) with an admin user there is another batch generated (i call this "approval batch" for the moment) and the changes fall out of the tree I commited two dce devices to the database (a dhcp stub "Printserver" and an unfinished "Marantz SR7001 RS232").

How about we approve all the recently added batches?  And then see if anything falls out of the tree again.

Did you commit with your own user? Please try to checkin again with pluto~pluto (regular user) and approve with zaerc~XXXXX (sqlcvs admin).

Oh BTW, logging in on your sqlcvs web interface seems to work (at least that's what it told me).

the session handling is not finished yet. I also have to do some security fixes and implement permissions in the web interface. It's really quick and dirty hack to help me understand sqlCVS better It's in the trunk now.

At the moment i try to implement row history for modifications and deletions and understand how row ownership is assumed to work..
Can you point me to the installer script for the database? I wonder if we have to do other things beside importing with sqlCVS to setup a repository. I saw some mysql syntax errors in the sqlCVS log.. maybe i use the wrong mysql version..

best regards,
Hari

2388

Developers / Re: sqlCVS

« on: November 20, 2007, 11:53:45 pm »

Thanks, I'm so glad at least one of us knows what he's doing.

i hope this is you 

The web gui got some improvements, maybe it helps to get some things sorted for you.. (also look at the wiki page, i did some updates)

best regards,
Hari

2389

Developers / Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!

« on: November 20, 2007, 08:21:42 pm »

i am to lazy to import all my contacts atm but the first impression is good. Went through the sources, very clean. Kudos to Thom! Maybe we can get this in 0710? If i find the time i'll throw some 4000 contacts at it tonight.

best regards,
hari

2390

Developers / Re: Bluetooth Speakers?

« on: November 20, 2007, 04:15:19 pm »

The slimserver should be installed on the core, but I think you can use any MD/PC to run the squeezebox emulator software.

Do you know if a single core can individually address multiple separate BT speaker pairs, each in a separate room, or how I config separate PCs each with a BT dongle to address its own BT speaker  pair (all accessing a single unified LMCE media library)?

this depends if the bluetooth chip on your core can handle multiple connections at a time. I would prefer a dongle on each md, so u get a unique ip in the slimserver device selection box.
But you have to try this out, i don't think anybody is using this combination yet..

What about a USB hub filled with BT dongles, one for each speaker set, on a single core? Do you think bluez and the other BT SW can handle that? If not, do you know what is the specific name of the "multiple device connections" feature that the BT dongle must support, or some models that do support it?

I like the simplicity (and cheapness) of a single PC serving multiple terminals throughout the home.

bluez should run fine with multiple hci devices (tested two at a time some time ago). I think the newer dongles should all support multiple connections. Ask your preferred dealer for model information..

regards,
Hari

2391

Developers / Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!

« on: November 20, 2007, 04:10:15 pm »

I already have an LDAP server running with a directory of contacts in it. Can I use this patch to connect to that existing directory?

not this patch but the modifications are minor: simply exchange the mysql select with some kind of ldap_search and iterate through the result entries.

regards,
hari

2392

Developers / Re: sqlCVS

« on: November 20, 2007, 04:07:00 pm »

Thanks, I'm so glad at least one of us knows what he's doing.   And I'm not in any rush, so you can just take your time.

i wanted to progress faster but without dsl (and my 3g provider is slooooooow) the last five weeks were really painful..
don't want to let you wait, i need helpful souls for testing

best regards,
Hari

2393

Developers / Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!

« on: November 20, 2007, 03:51:04 pm »

we could add a search to the main menu, in addition to the pagination that already happens.. have you tried it yet? It should split entries by 32.

-Thom

i'll try it this evening.. YIPPPE, my DSL is back *ggg*

regards,
hari

2394

Developers / Re: sqlCVS

« on: November 20, 2007, 02:42:39 pm »

I guess I shouldn't have been so lazy to use the web-admin, but I figured it knows better what it's doing then I am... I've removed the "-m" option as well since it's not in the "usage" and I have no idea what it actually does, I suspect it sends some of the output to a logfile or something.  I had to paste all the output into a file and attach it since it was to big to put inside the message...

Looks like it did't go through this time.   Seeing those duplicate key errors, could it be in conflict with my earlier checkin attempt?

yep. im just going through all psc_dce_* tables to trace the batch ids in sqlcvs... please be patient for an hour or two.. i'll approve your first commit (when i find it *g* )

best regards,
Hari

2395

Users / Re: How to do a wireless MD?

« on: November 20, 2007, 02:21:34 pm »

i use a OpenWRT box as wired to wireless bridge (wet mode). Should work with other "gaming adapters", too..
so you don't have to mess with ssids and keys on the MD and can boot straight from the bios with pxe.

but everybody knows: wireless is bad there would be no wires if wireless were a perfect match... a single cat5 run should fit nearly everywhere...

regards,
Hari

2396

Developers / Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!

« on: November 20, 2007, 02:11:29 pm »

I deliberately didn't implement the Search functionality. But if someone wishes to implement it, cool. I wanted to avoid the stupidity of having the search feature be the primary way to use the system, especially from the telephone. This is not an enterprise services directory, and should not be searched as such.

you are absolutely right for a few entries. But my personal addressbook alone has at about 120 contacts. If i dig into this i will do some option switches or put the search function in the services menu...

best regards,
Hari

2397

Developers / Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!

« on: November 20, 2007, 02:01:25 pm »

bump, has anyone tried this besides the guy who wrote it?

-Thom

looked at the code, seems reasonable. What i see messing is some kind of a search functionality. Let's see if i find the time to implement it. I'll test the code these days.
The 7970 has some nice additional features. It plays/sends RTP streams, it should be easy to implement intercom, burglar voice bashing, announcements and so on..

regards,
Hari

2398

Developers / Re: Bluetooth Speakers?

« on: November 20, 2007, 01:58:06 pm »

The slimserver should be installed on the core, but I think you can use any MD/PC to run the squeezebox emulator software.

Do you know if a single core can individually address multiple separate BT speaker pairs, each in a separate room, or how I config separate PCs each with a BT dongle to address its own BT speaker  pair (all accessing a single unified LMCE media library)?

this depends if the bluetooth chip on your core can handle multiple connections at a time. I would prefer a dongle on each md, so u get a unique ip in the slimserver device selection box.
But you have to try this out, i don't think anybody is using this combination yet..

much luck,
hari

2399

Developers / Re: Updating UpdateMedia

« on: November 20, 2007, 01:55:20 pm »

Is it possible to config the maillist to post to the developer forum, maybe  either posted as a daily thread throughout the day or post a daily digest each day?

why don't you use the web archives of mailman?

It's already a bit of a hassle logging into each of the the forums, the wiki and Mantis with separate logins. Convergence is our game; the people this project attracts will be sensitive to arbitrary partitions.

The pluto guys have some kind of a "MasterUsers" Table and are provisioning other systems from it. I'm thinking about a "simple sign on" system with ldap backend. We then could feed the wiki, sqlCVS, mantis and more to come from there.
What i wonder about if we should give every user a unique installation id. Its "1" for now...

but this goes completely off topic..

best regards and happy hacking,
Hari

2400

Developers / Re: ZWave sources

« on: November 20, 2007, 01:47:29 pm »

Hari:
Are you looking into revisions of the ZWave package? Its pretty old and doesn't support the latest revs of the ZWave protocol. It also has some annoying bugs (like dropping ZWave devices if there is a gap and reinstalling them). And still only support for the obsolete and rare Homepro USB_ZWave interface and the even more rare Boca USB-ZWave interface.
The real problem is finding drivers for the other's USB interfaces that work in Linux. If someone can find a Linux driver for the chip in the Intermatic or the Cooper or the Wayne Dalton we can make them work, but up until now no one has a Linux driver that works with those. I can provide details on the chips in them if anyone is interested.

i just stumbled around the sources to get my head free of sqlCVS wanted to see how the old revision is implemented. I thought about getting a ZCU201 with homeseer or the likes and sniff the serial communications after the usb to serial converter..

best regards,
Hari