Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - hari

Pages: 1 ... 159 160 [161] 162 163
Developers / Re: sqlCVS
« on: November 20, 2007, 08:46:53 am »
I've just checked in that webcam sphere thingy:
don't see the batch id. can you try again without the grep and cut:
Code: [Select]
sudo -u root /usr/pluto/bin/sqlCVS -R 3999 -H -h localhost -a -n -r dce -t Broadcast,CannedEvents,CannedEvents_CriteriaParmList,Command,CommandCategory,CommandParameter,Command_CommandParameter,Command_Pipe,ConfigType,ConfigType_File,ConfigType_Setting,ConfigType_Token,ConnectorType,CriteriaList,CriteriaList_CriteriaParmList,CriteriaParmList,DeviceCategory,DeviceCategory_DeviceData,DeviceCategory_Event,DeviceCommandGroup,DeviceCommandGroup_Command,DeviceCommandGroup_DeviceCommandGroup_Parent,DeviceData,DeviceTemplate,DeviceTemplate_AV,DeviceTemplate_DesignObj,DeviceTemplate_DeviceCategory_ControlledVia,DeviceTemplate_DeviceCategory_ControlledVia_Pipe,DeviceTemplate_DeviceCommandGroup,DeviceTemplate_DeviceData,DeviceTemplate_DeviceTemplate_ControlledVia,DeviceTemplate_DeviceTemplate_ControlledVia_Pipe,DeviceTemplate_DeviceTemplate_Related,DeviceTemplate_DSPMode,DeviceTemplate_Event,DeviceTemplate_InfraredGroup,DeviceTemplate_Input,DeviceTemplate_MediaType,DeviceTemplate_MediaType_DesignObj,DeviceTemplate_Output,DeviceTemplate_PageSetup,DHCPDevice,DHCPDevice_DeviceData,Event,EventCategory,EventParameter,Event_EventParameter,HouseMode,Licensing,MediaType,MediaType_Broadcast,Package,Package_Compat,Package_Directory,Package_Directory_File,Package_Package,Package_Source,Package_Source_Compat,Package_Users,Package_Version,PhoneLineType,QuickStartCategory,QuickStartTemplate,RepositorySource,RepositorySource_URL,RoomType,StartupScript,System,Version -d "pluto" -U "pluto~pluto" -D pluto_main -e -m /tmp/tmp_sqlcvs_file_4410 checkin
this should spit out the batch id for "submission".
And I'll send you an MD5 hash in PM next. 
When this batch is approved I can restore my database from a backup to what it was before I changed it, and try to check the changes out again. 
i'll approve as soon as i figure out the id ;)

best regards,

Developers / Re: sqlCVS
« on: November 20, 2007, 01:26:41 am »
Hi Zaerc,

Any luck with the batches yet?  If you can approve this one I could restore the database backup I made earlier and update it from the master.  Eventhough you obviously have a way better understanding of what we're doing here, is there anything I can do to assist you with figuring out how these batches work?  Meanwhile I'll have a look over the sqlCVS documentation again as well.

I'm thinking if we just keep shaking the tree something useful will probably fall out sooner or later. ;) 

there fell something out:

with the batch id one can show the database changes:
sqlcvs:/# sqlCVS -h "" -u "root" -p "" -D "pluto_main" -P "3306" -r "dce" -t "" -U "hari~XXXXXX" batch-contents
Batch: 1828 Repository: dce IP: Date: 2007-11-07 06:41:04

Table: Command
NEW- PK_Command:920 Description:Add Insteon Device to Group Define:(NULL) FK_CommandCategory:26 AVCommand:0 Comments:(NULL) Log:1 psc_id:901 psc_user:2 psc_frozen:0 psc_restrict:(NULL)
NEW- PK_Command:921 Description:TurnOnSprinklerValve Define:(NULL) FK_CommandCategory:36 AVCommand:0 Comments:(NULL) Log:1 psc_id:902 psc_user:2 psc_frozen:0 psc_restrict:(NULL)
NEW- PK_Command:922 Description:TurnOffSprinklerValve Define:(NULL) FK_CommandCategory:36 AVCommand:0 Comments:(NULL) Log:1 psc_id:903 psc_user:2 psc_frozen:0 psc_restrict:(NULL)

so i think we are far enough to be able to run kinda developement repository. We can export sqlcvs files anytime to keep svn branches in sync. Feel free to add devices. Send me a md4 pw via mail or pm, i'll create a user zaerc with admin perms.

best regards,

Developers / Re: ZWave sources
« on: November 18, 2007, 10:23:57 pm »
thank you guys, i was misleaded to, its missing the ZWave source..

happy hackin

Developers / ZWave sources
« on: November 18, 2007, 04:51:29 pm »
Hi all,

i can't find the ZWave sources in the trunk (neither LMCE nor pluto). Has anybody seen them?

best regards,

Developers / Re: Bluetooth Speakers?
« on: November 18, 2007, 04:49:13 pm »
you can drive your speakers with alsa and bluez. The slimserver provides an audio stream via :9000/stream.mp3.

best regards,

Users / Re: cisco 7941G
« on: November 17, 2007, 11:57:46 pm »
they are not pnp but work fine with asterisk (sccp and sip images).

best regards,

Users / Re: SIP Cisco 7970?
« on: November 15, 2007, 09:34:55 pm »
Do you think you could update the LMCE wiki 7970 entry by merging the instructions to use LMCE's tftp server and DHCP?
this has to be integrated in a sane way. There is a (disabled) option for the protocol (SIP/SCCP) on the web gui already when adding a 7970. I also have to figure out where lmce sets up the asterisk extensions. "chan_sccp" configures the lines on the phone itself (takes options from sccp.conf). For SIP we have to add a peer to sip.conf and create a SEP<MAC>.cnf.xml with the corresponding line.
I will get into this next week (no sense to set up till my dsl is back). Step by step instructions will follow. Until then you can put my post in the wiki as a stub.

best regards,

Users / Re: SIP Cisco 7970?
« on: November 15, 2007, 09:22:54 pm »
so any injector should work ok. not sure why my prestandard cisco injector didnt.

oh, i hope they work with the old 7905 phones.. i will post my results,


Compatible Products & Services / Re: Need <$100 HTPC case ideas
« on: November 15, 2007, 08:31:10 pm »
look for the Hiper HMC-1S53A. It's available for 60€ in Germany. I think i will use it with the MSI 7??? mATX board (see Wiki). 200 watt ps and raiser card included. Only slim line optical drives supported (adapter included).

best regards,

Users / Re: SIP Cisco 7970?
« on: November 15, 2007, 08:15:06 pm »
Hi all,

i'm running the sip software with asterisk and don't have any problems. The newer ones don't register with asterisk but SIP70.8-0-2SR1S works great.
For the Orbiter be sure to put the right URLs in the "SEP<MAC>.cnf.xml" file (delete the link to SEPDefault7970.cnf.xml and put your desired config in /tftpboot):
It works perfect. The 7970 SIP image supports all xml push features (old 7960 and 40 with sip lack xml push because of limited ram, haven't checked the newer G series).

For upgrade instructions see the wiki.

I'll try to use the Aironet injectors (AIR-PWR-INJ) with the 7905 phones. Hope it won't fry. A friend has a 7970 running on a cisco poe  switch (3800 series). The display is bright enough to be misused as a night light for the whole room. But as teedge77 wrote: you can't select full brightness from the menu.
There are newer single port injectors from the voice line with built in power supply. A good cisco dealer should be able to deliver them at about 50-60€. They support all cisco phones (old ones and new ones with 802.3af).

best regards,

Developers / Re: sqlCVS
« on: November 14, 2007, 08:10:01 pm »
It would be nice if someone could explain what all this means, but I won't be holding my breath.  I'm guessing "Revert" will sync my local DB with the master, and "CheckIn" will upload the "changes" I have (none yet) made locally to the masted DB.  Might not be a bad idea since this is a fresh installation.
go ahead.. as far as i get it this are only some old entries from the package system to be deleted by your batch.
I think I'll try "CheckIn" first, hoping that will give you already a batch to look at hari.  And it might not be a bad idea to have the master synced with a fresh install as a starting point. 
I think we should further investigate the import process. Maybe we are missing to setup additional tables for the master repository (like for history tracking and stuff). I'm still stuck with some other things. I don't see any way to show the batches with the "sqlCVS" utility alone.. at the moment i'm looking through the php scripts in pluto-admin/operations/sqlCVS. There is a batch history table for each repository. It's named "psc_<repository>_bathdr". To show the batch id's from changes in the dce repo i use "select * from psc_dce_bathdr order by date limit 20". I'll try to figure out how to get the exact sql statements from a batch.
When i get this right i'll update the wiki page.

happy hacking,

Developers / Re: Complete rewrite of template for Marantz Audio receivers
« on: November 13, 2007, 08:06:54 pm »
Hi Bulek,

- I wonder if I can contribute template and how to do it to main LMCE database, so others will be also able to use it ? I'm interested in this, cause very shortly, template for LG LCD TVs and Plasmas will follow...

we don't have figured out the complete sqlCVS workflow at the moment. But it would be great if you can commit your changes to the testing sqlCVS repository (, pluto~pluto, see the sqlCVS thread). I have a SR7001 myself and can test your checkin next week (dsl is coming back on monday ;) ).

When we understand how to isolate sqlCVS batches we can collect them in the testing repo for working devices and inject them into the main/release repository when approved.

best regards,

Compatible Products & Services / Re: New ACT Z-Wave Interface
« on: November 12, 2007, 12:42:43 pm »
I understand that support for the ZCU201 is being considered now.
do you now by whom? I asked a german distributor for the DK. It's price is at about 2600€ and they don't want to sponsor. The required documents are not available without the DK.

best regards,

Developers / Re: RS232 controllable TV ?? Olevia 32" LCD
« on: November 08, 2007, 10:42:18 pm »
Maybe you want to look at the template for "Plasma RS232" (AV Equipment). It should give you a basic understanding how a TV device should like. Adding a new template for a rs232 controllable device is easy (see the Marantz page in the wiki). Don't forget to add "Live TV" as embedded device.

best regards,

Developers / Re: LMCE v0710 on PS3?
« on: November 07, 2007, 10:52:03 pm »
I can't say the same for people with Zaerc's attitude, who can't even read the info that could set them straight, but instead find it an opportunity to post redundantly wrong obnoxious insults that only keep back this project.
Im a PS3 owner my self. I like it. Of course it would make a great orbiter. But as Zaerc points out without RSX its a expensive thin client for LinuxMCE with some bells and whistles at the moment.
And then maybe get to work incorporating more of the parallel developments, like spu-medialib and other efforts to make RSX lockout either go away or irrelevant.
Until somebody comes up with a mythtv version utilizing the spu's any questions on a media director ps3 port seem silly at the moment. And please stop offensing on of our mostly involved developers. Whar are your contributions? Did you manage to cross compile some core components like DCE-router as a start? Been into some SPU coding these days?


Pages: 1 ... 159 160 [161] 162 163