Author Topic: sqlCVS  (Read 6857 times)

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: sqlCVS
« Reply #30 on: November 21, 2007, 11:01:33 pm »
I did both my previous checkins with pluto~pluto.  And I wasn't aware that I needed to do an initial import, I'm doing these things from a fresh LMCE install.

Also I have no idea where the installer script for the database is, if there even is one.  I'm guessing the setup wizard does the final steps.
"Change is inevitable. Progress is optional."
-- Anonymous


hari

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2420
    • View Profile
    • ago control
Re: sqlCVS
« Reply #31 on: November 21, 2007, 11:09:44 pm »
I did both my previous checkins with pluto~pluto.
ok, so i wonder why they don't show up as negative batch id.
Quote
And I wasn't aware that I needed to do an initial import, I'm doing these things from a fresh LMCE install.
i wasn't aware that you checkin from a fresh install. It should need no import (mine didn't). But i wonder where your "Version" table got lost..
Quote
Also I have no idea where the installer script for the database is, if there even is one.  I'm guessing the setup wizard does the final steps.
plutohome .44 did the import after the first boot iirc. I'll see if i find the relevant scripts..
rock your home - http://www.agocontrol.com home automation

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: sqlCVS
« Reply #32 on: November 27, 2007, 01:00:39 am »
We just did another test, and attached is the log from the following command:
/usr/pluto/bin/sqlCVS -r dce -U "pluto~nopass" -H sqlcvs.charonmedia.org checkin 2>&1|tee sqlCVS_checkin-2.log
"Change is inevitable. Progress is optional."
-- Anonymous


hari

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2420
    • View Profile
    • ago control
Re: sqlCVS
« Reply #33 on: December 10, 2007, 11:30:05 pm »
big progress for today:

with the patience and help from Zaerc we sorted out some sqlCVS things
these days. We successfully checked in a complete DCE device template
(GSD) with ruby codes from one installation and pulled that from another.

For now we did the following:

Server side:
* imported the *.sqlcvs files from a 0704 installation on the master repo
* cleaned all *psc* tables and fields with the script
sqlcvs-dumps/scripts/RemovePSCfromDB.sh
* created a fresh repository with sqlcvs-dumps/scripts/CreateRepository.sh
* enabled history with "sqlCVS history-all"
* dumped new *.sqlcvs files with "sqlCVS -r dce,designer,ir,... dump"

Client side:
* dropped ir,designer and dce from the local database of a fresh 0704
installation with the scripts sqlcvs-dumps/scripts/RemoveRepofromDB.sh
(./RemoveRepofromDB.sh ir ; ./RemoveRepofromDB.sh dce ; ...)
That erases all psc information and all data for the tables in that repos
* imported the new *.sqlcvs files (sqlcvs-dumps/0704-new) with "sqlCVS
-r dce,designer,ir import"
* added the D-LinkDCS-5300G on one side and did a checkin with "nopass"
(-a has to be used for dce, FK_Users_Maintainer references Users, that
table is not in the master repo ***)
* approved the batch in the master repo:
http://sqlcvs.charonmedia.org/sqlcvs/?site=batch/detail&repository=dce&batchid=2
* did an update on the other installation
* newly synced device was checked for ruby codes, all there  ;)

so this gives us a newly initialized repo with future history and
synchronized clients. So we can start our own master even if we don't
get the history tables from pluto. We would have to include the new dump
files in a installer build.

I see the number of LMCE devices skyrocketing when we have sqlCVS in
production.

Big thanks (and some promised beers) to Sir Zaerc.
rock your home - http://www.agocontrol.com home automation

bulek

  • Administrator
  • wants to work for LinuxMCE
  • *****
  • Posts: 884
  • Living with LMCE
    • View Profile
Re: sqlCVS
« Reply #34 on: December 11, 2007, 12:10:23 am »
Hi,

thanks for efforts, great work.... Let us know, when it will be safe to enter valid contributions....

Regards,

Bulek.
Thanks in advance,

regards,

Bulek.

darrenmason

  • Addicted
  • *
  • Posts: 529
    • View Profile
Re: sqlCVS
« Reply #35 on: December 11, 2007, 04:23:27 am »
Great effort guys, hopefully with some time off over christmas and january I can assist with some more testing and setup.
I believe what you are doing is a very important piece of work.

Regards
Darren

ddamron

  • Alumni
  • wants to work for LinuxMCE
  • *
  • Posts: 962
    • View Profile
    • My LinuxMCE User Page
Re: sqlCVS
« Reply #36 on: December 15, 2007, 10:13:23 am »
Hari, Maybe I should post my Insteon Drivers...??
EZBridge works well, a few more enhancements and it'll be ready for RC2.
PLM is in progress...

Both are GSD/Ruby based.
The only intuitive interface is the nipple.  After that it's all learned.
My other computer is your windows box.
I'm out of my mind.  Back in 5 minutes.
Q:  What's Red and smells like blue paint?

A:  Red Paint.

hari

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2420
    • View Profile
    • ago control
Re: sqlCVS
« Reply #37 on: December 15, 2007, 10:40:57 am »
Hari, Maybe I should post my Insteon Drivers...??
great idea, but you would have to reimport at least dce and ir (don't know if your devicetemplate affects further repositories/tables) from the new dumps on a fresh installation and add your device there.
You can see the steps in my last post.
Until we get the complete history dumps from pluto we are not able to keep the psc_id's in our repo. We had to reinitialize. The 0704 lmce clients are now out of sync. So only clients doing the reimport of the new dump files will be able to update.

best regards,
Hari

rock your home - http://www.agocontrol.com home automation

hari

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2420
    • View Profile
    • ago control
Re: sqlCVS
« Reply #38 on: December 15, 2007, 06:41:09 pm »
Hi devs,

there is an installer to synchronize a fresh 0704 installation with the testing repository:
http://sqlcvs.charonmedia.org/ReinitSqlCVS.sh

It fetches the new dumps and a helper script, then drops all local tables from ir, designer and dce. After importing them it does a sqlCVS update to fetch latest changes.

There are three changes for now:
Screen sizes for Nokia770/N800
D-Link DCS-5300G IP Cam
Logitech sphere webcam

Soon to come:
Insteon support

best regards,
Hari
rock your home - http://www.agocontrol.com home automation

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: sqlCVS
« Reply #39 on: December 15, 2007, 08:41:40 pm »
And just in case, before you start you might want to do this as the root user:
Code: [Select]
mysqldump --skip-extended-insert pluto_main >pluto_main_$PK_Installation-`date '+%Y%m%d:%H%M%S'`.sql which will give you a nice backup of your main database with the installation-number and a timestamp in the filename (you can become the root user with "sudo su -").
"Change is inevitable. Progress is optional."
-- Anonymous