Hi,
I'm trying to migrate our old unsupported VOMS to the new version. I
have followed the documentation from the VOMS administration guide but I
didn't achieve to have a running VOMS server.
Here is the procedure I followed:
1 - exporting (mysqldump) the old database from voms.begrid.be;
2 - importing my database in my new voms (voms01.begrid.be);
3 - granting required privileges:
mysql> GRANT ALL PRIVILEGES ON betestdb TO betest_admin@localhost
IDENTIFIED BY 'xxxxxxxx';
4 - cleaning database:
mysql> DELETE FROM admins WHERE adminid NOT IN (SELECT adminid FROM
acl);
mysql> SELECT adminid, dn, c.ca FROM admins a JOIN ca c ON a.ca =
c.cid WHERE dn IN (SELECT dn FROM admins GROUP BY dn HAVING COUNT(*) > 1);
deleting IDs return by the SELECT;
5 - copy VOMS configuration from old voms server to new one and
parameters update (stronger password for DB users);
6- trying to migrate the DB
1s time:
[root@voms01 betest]# /opt/glite/sbin/voms-admin-configure
--vo=betest upgrade
voms-admin-configure, version 2.0.18
Upgrading vo betest
Checking database existence...
No voms-admin 1.2.x database found to upgrade!
Error upgrading voms database!
[root@voms01 betest]# /opt/glite/sbin/voms-admin-configure --vo=betestdb
upgrade
2nd time
voms-admin-configure, version 2.0.18
Upgrading vo betestdb
Traceback (most recent call last):
File "/opt/glite/sbin/voms-admin-configure", line 556, in ?
main()
File "/opt/glite/sbin/voms-admin-configure", line 548, in main
do_command()
File "/opt/glite/sbin/voms-admin-configure", line 529, in do_command
do_upgrade()
File "/opt/glite/sbin/voms-admin-configure", line 510, in do_upgrade
action.upgrade_vo() File "/opt/glite/sbin/voms.py", line 184,
in upgrade_vo
self.upgrade_configuration()
File "/opt/glite/sbin/voms.py", line 195, in upgrade_configuration
db_props = vo_database_properties(self.user_options['vo'])
File "/opt/glite/sbin/voms.py", line 74, in vo_database_properties
return PropertyHelper(f)
File "/opt/glite/sbin/voms.py", line 994, in __init__
self._load_properties()
File "/opt/glite/sbin/voms.py", line 997, in _load_properties
f = open(self._filename,"r")
IOError: [Errno 2] No such file or directory:
'/var/glite/etc/voms-admin/betestdb/voms.database.properties'
I also tryied,
[root@voms01 ~]# /opt/glite/sbin/voms-admin-configure --vo=betest upgrade
voms-admin-configure, version 2.0.18
Upgrading vo betest
Traceback (most recent call last):
File "/opt/glite/sbin/voms-admin-configure", line 556, in ?
main()
File "/opt/glite/sbin/voms-admin-configure", line 548, in main
do_command()
File "/opt/glite/sbin/voms-admin-configure", line 529, in do_command
do_upgrade()
File "/opt/glite/sbin/voms-admin-configure", line 510, in do_upgrade
action.upgrade_vo()
File "/opt/glite/sbin/voms.py", line 184, in upgrade_vo
self.upgrade_configuration()
File "/opt/glite/sbin/voms.py", line 196, in upgrade_configuration
self.jdbc_url = db_props['jdbc.URL']
KeyError: 'jdbc.URL'
And voms-db-deploy.py undeploy/deploy... no usefull resultats.
Does anybody know how I could migrate this database to a supported
version of the VOMS server?
My old databsase is at the latest release of VOMS 1.2 version.
Thanks for help!
Kind regards,
David
--
David Durvaux
BEgrid and services
Wetenschapsstraat 4 Rue de la Science
B-1000 Brussel
+32 2 790 33 33
[log in to unmask]
[log in to unmask]
--
David Durvaux
BEgrid and services
Wetenschapsstraat 4 Rue de la Science
B-1000 Brussel
+32 2 790 33 33
[log in to unmask]
[log in to unmask]
|