sqlCVS

[Zaerc]

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.

[hari]

I did both my previous checkins with pluto~pluto.

ok, so i wonder why they don't show up as negative batch id.

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..

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..

[Zaerc]

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

[hari]

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.

[bulek]

Hi,

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

Regards,

Bulek.

[darrenmason]

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]

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.

[hari]

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

[hari]

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

[Zaerc]

And just in case, before you start you might want to do this as the root user:

Code:

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 -").