Does anybody know how this is supposed to work?
I'd like to check out a new clean database for testing with the components I've managed to build from source, but so far I can't find any good documentation on sqlCVS.
http://freshmeat.net/projects/sqlcvs/http://plutohome.com/wiki/index.php/Pluto_Home_Softwarehttp://plutohome.com/wiki/index.php/SqlCVShttp://plutohome.com/wiki/index.php/SqlCVS_User%27s_manualhttp://plutohome.com/wiki/index.php/Naming_of_Foreign_Keys%2C_Indirect_Keys%2C_External_Keyshttp://plutohome.com/wiki/index.php/What_do_the_psc_fields_do%3Fhttp://plutohome.com/wiki/index.php/What_do_the_psc_tables_do%3Fhttp://plutohome.com/wiki/index.php/SqlCVS_Programmer%27s_Guide# /usr/pluto/bin/sqlCVS --help
Copyright (C) 2004 Pluto, Inc., a Florida Corporation
www.plutohome.com
Phone: +1 (877) 758-8648
This program is distributed according to the terms
of the Pluto Public License, available at:
http://plutohome.com/index.php?section=public_license
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
or FITNESS FOR A PARTICULAR PURPOSE. See the Pluto Public License for more details.
-------
Unknown option: --help
sqlCVS, v.<=version=>
Usage: sqlCVS [-h MySql hostname] [-u MySql username]
[-p MySql password] [-D MySql database] [-P mysql port]
[-H sqlCVS hostname] [-R sqlCVS port]
[-r Repository( -ies )] [-v] [-i] [-c comments]
[-t Table( s )] [-U Username[~Password][,...]] [-d username]
[-a] [-e everyone] [-w width]
[-s Skip Verification of fields] [-b batch] [-f] [-n]
-h hostname -- address or DNS of database host,
default is `dcerouter`
-u username -- username for database connection
-p password -- password for database connection,
default is `` ( empty )
-D database -- database name. default is pluto_main
-P port -- port for database connection,
default is 3306
-r output path -- Where to put the output files.
Default is ../[database name]
-t input path -- Where to find the template files.
Default is . then ../sqlCVS
-b batch -- the batch number you want to approve
-U user~pass -- the user(s) who are logged in and will be committing rows
-d username -- the owner of any unclaimed new records
Default is the first user checking in records
-v verify -- Verifies the integrity of the database first (foreign keys)
-s Table:Field -- Comma delimted list of Fields to ignore when doing a verify
-i verify id -- Verifies that all records have unique psc_id
-a allow -- Allows checking in a row with a foreign key
to a modified row in another table that is not
being checked in
-e everyone -- Checkin all records from every user
-n no prompts -- Don't ever prompt, just exit if necessary
-c comments -- Optional comments to be included with a checkin
-w screen width-- This value will 'stick' because it's stored in the config
-S restrictions-- Include the listed restrictions.
If one restriction, other than 0,
is specified with the -v option, rather than auto-deleting, it will
update orphaned rows to be in the same restriction
-f filename -- Save the output of this command to a file, usually so
another program like a website can show the contents
normally used with -n
-O PK -N PK -- For use with change_key command
-A anonymous -- Support authorization witn anonymous~anonymous
username and password - all records are commited w/o quarantine
-C attempts count -- Maximal attempts to connect server if it's busy, default is unlimited
-T processor timeout -- Timeout for server-side processor (seconds, default is 15 min)
And from looking at some of the scripts included in the source tarball I gather there are "commands" like: import, checkin, change_key, update-psc as well, but what they actually do remains a mystery to me. I'm guessing (hoping) that one of these scripts is probably used post-install to get a fresh copy of the pluto database.
Aparently sqlCVS does not accept another local username then "root" so I have simply removed the root password on the local mysql database, now running without parameters gives me the folowing menu:
# /usr/pluto/bin/sqlCVS
Copyright (C) 2004 Pluto, Inc., a Florida Corporation
www.plutohome.com
Phone: +1 (877) 758-8648
This program is distributed according to the terms
of the Pluto Public License, available at:
http://plutohome.com/index.php?section=public_license
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
or FITNESS FOR A PARTICULAR PURPOSE. See the Pluto Public License for more details.
-------
Database host:localhost user:root pass: name:pluto_main port:3306
Users:
Use sqlCVS -? for command line options.
What would you like to do?
In the future you can also make your selections on the command line using the command shown in parenthesis.
------Server-side functions------
1. Create a new sqlCVS repository from an existing database ( create )
2. Edit an existing repository ( edit )
3. Start listening for incoming connections from clients ( listen )
4. Permanently roll-back checkins ( rollback )
5. Create a 'dump' file with the tables in the current repository ( dump )
6. List all the tables and what repositories they are in ( list-tables )
7. List all the repositories and what tables they have ( list-repositories )
8. History on all tables ( history-all )
9. History on no tables ( history-none )
10. List unauthorized batches ( batches )
11. List contents of batch ( batch-contents )
---The following are not normally used---
20. Reset entire database--sqlCVS clients will be out of sync ( reset-all )
21. Reset the system tables ( reset-sys )
22. Update psc_id's ( update-psc )
23. Update last_psc_batch/id **server only** ( update-last-psc )
------Client-side functions------
A. Import a 'dump' file from a server and make a local, working copy ( import )
B. Check-in changes you've made locally ( checkin )
C. Update my local copy with changes from the server ( update )
D. **disabled** Synchronize my database with the server. Same as checkin+update ( sync )
E. View my local changes ( diff )
F. Approve pending batch ( approve )
G. Reject pending batch ( reject )
H. Revert changes from a mask file ( revert )
I. Changes a primary key and propagates ( change_key )
Z. Change login or users
Q. Quit
I guess at least that clears the commands up a bit. But now I guess I'm stuck at some file that can't be read:
# /usr/pluto/bin/sqlCVS -D pluto_main -r dce import
Copyright (C) 2004 Pluto, Inc., a Florida Corporation
www.plutohome.com
Phone: +1 (877) 758-8648
This program is distributed according to the terms
of the Pluto Public License, available at:
http://plutohome.com/index.php?section=public_license
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
or FITNESS FOR A PARTICULAR PURPOSE. See the Pluto Public License for more details.
-------
Database host:localhost user:root pass: name:pluto_main port:3306
Users:
01 10/27/07 17:37:17.876 Connect failed Unknown database 'pluto_main' <0xb7b166b0>
Creating database pluto_main
Caught exception: Cannot read file
# /usr/pluto/bin/sqlCVS -D pluto_main -r dce import
Copyright (C) 2004 Pluto, Inc., a Florida Corporation
www.plutohome.com
Phone: +1 (877) 758-8648
This program is distributed according to the terms
of the Pluto Public License, available at:
http://plutohome.com/index.php?section=public_license
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
or FITNESS FOR A PARTICULAR PURPOSE. See the Pluto Public License for more details.
-------
Database host:localhost user:root pass: name:pluto_main port:3306
Users:
Caught exception: Cannot read file
For all I know this could be a configuration file that sqlCVS depends on, but I feel a bit reluctant to try this on a real lmce installation as I'm obviously pretty clueless to what I'm exactly doing here and it wouldn't surprise me at all if I'm doing things horribly wrong...
