Hi Joao,
> Reading your email it's not clear to me if you used the old VOMS DB
> directly into new VOMS or if you followed the DB migration step
> presented in that guide:
>
>
> http://italiangrid.github.io/voms/documentation/sysadmin-guide/3.0.0/#Upgrade
> db upgrade Upgrading the VOMS database
Yes, I did follow the instructions. For dumping/importing I've used
these commands:
mysqldump -uroot -p<MYSQL_ROOT_PASSWORD> --all-databases
--flush-privileges > voms_database_dump.sql
mysql -uroot -p<PASSWORD> < voms_database_dump.sql
and this was my last configuration:
voms-configure install --vo hungrid --hostname grid11.kfki.hu
--dbname VOMS_HunGrid --dbauser root --dbapwd *** --dbusername voadmin
--dbpassword *** --core-port 15000 --mail-from [log in to unmask]
--smtp-host localhost
Thank you.
Cheers,
Andras
> Did you updOn 11/21/2013 09:06 AM, Andras Hazi wrote:
>> Hi,
>>
>> Since the upgrade of the VOMS server we're experiencing some issues
>> with the EMI 3 system (we're using SLC 6).
>> I tried the upgrade (from EMI 2 to EMI 3), and
>> I also tried the clean install, but the new VOMS still isn't working
>> properly.
>> I followed the instructions from
>>
>> http://italiangrid.github.io/voms/documentation/sysadmin-guide/3.0.0/,
>> and imported the original database after install.
>> Furthermore VOMS services started successfully:
>>
>> [root@grid11 ~]# service voms-admin status
>> VOMS admin container: [ OK ]
>> VO (hungrid): [ UP ]
>>
>> But I still have these errors (
>> /var/log/voms-admin/voms-admin-hungrid.log):
>>
>> 2013-11-07 09:02:12.093Z - INFO [VOMSConfiguration] - Setting
>> CONF_DIR
>> from context: //etc/voms-admin
>> 2013-11-07 09:02:12.103Z - INFO [VOMSService] - VOMS-Admin starting
>> for
>> VO: hungrid
>> 2013-11-07 09:02:14.265Z - INFO [VOMSExecutorService] - Scheduling
>> task
>> UpdateCATask with period: 3600 seconds
>> 2013-11-07 09:02:14.267Z - INFO [VOMSExecutorService] - Scheduling
>> task
>> TaskStatusUpdater with period: 30 seconds
>> 2013-11-07 09:02:14.267Z - INFO [VOMSExecutorService] - Scheduling
>> task
>> ExpiredRequestsPurgerTask with period: 300 seconds
>> 2013-11-07 09:02:14.268Z - INFO [VOMSExecutorService] - Scheduling
>> task
>> UserStatsTask with period: 3600 seconds
>> 2013-11-07 09:02:15.542Z - INFO [DefaultMembershipCheckBehaviour] -
>> Expired users will be suspended after a grace period of 7 days.
>> 2013-11-07 09:02:15.559Z - INFO [VOMSExecutorService] - Scheduling
>> task
>> MembershipCheckerTask with period: 600 seconds
>> 2013-11-07 09:02:15.559Z - INFO [VOMSService] - VOMS-Admin started
>> succesfully.
>> 2013-11-07 09:02:24.483Z - INFO [VOMSCADAO] - Adding
>> [log in to unmask] to trusted
>> CA
>> database.
>> 2013-11-07 09:02:24.572Z - INFO [VOMSCADAO] - Adding
>> [log in to unmask] to trusted CA
>> database.
>> 2013-11-07 09:02:24.699Z - INFO [VOMSCADAO] - Adding
>> [log in to unmask]
>> to
>> trusted CA database.
>> 2013-11-07 09:02:25.260Z - ERROR [JDBCExceptionReporter] - Unknown
>> column 'request8_.approver_ca' in 'field list'
>> 2013-11-07 09:02:25.260Z - ERROR [DatabaseTransactionTaskWrapper] -
>> An
>> unexpected exception was caught while executing task
>> TaskStatusUpdater
>> 2013-11-07 09:02:25.264Z - ERROR [DatabaseTransactionTaskWrapper] -
>> could not execute query
>> org.hibernate.exception.SQLGrammarException: could not execute query
>> at
>>
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at
>>
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at org.hibernate.loader.Loader.doList(Loader.java:2216)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at org.hibernate.loader.Loader.list(Loader.java:2099)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at
>>
>> org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>>
>> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at
>>
>> org.glite.security.voms.admin.persistence.dao.hibernate.GenericHibernateDAO.findByCriteria(GenericHibernateDAO.java:133)
>> ~[classes/:na]
>> at
>>
>> org.glite.security.voms.admin.persistence.dao.hibernate.TaskDAOHibernate.getActiveTasks(TaskDAOHibernate.java:125)
>> ~[classes/:na]
>> at
>>
>> org.glite.security.voms.admin.core.tasks.TaskStatusUpdater.run(TaskStatusUpdater.java:39)
>> ~[classes/:na]
>> at
>>
>> org.glite.security.voms.admin.core.tasks.DatabaseTransactionTaskWrapper.run(DatabaseTransactionTaskWrapper.java:50)
>> ~[classes/:na]
>> at
>>
>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>> [na:1.7.0_19]
>> at
>>
>> java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
>> [na:1.7.0_19]
>> at
>> java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
>> [na:1.7.0_19]
>> at
>>
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
>> [na:1.7.0_19]
>> at
>>
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
>> [na:1.7.0_19]
>> at
>>
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>> [na:1.7.0_19]
>> at
>>
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>> [na:1.7.0_19]
>> at java.lang.Thread.run(Thread.java:722) [na:1.7.0_19]
>> Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
>> Unknown
>> column 'request8_.approver_ca' in 'field list'
>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
>> ~[mysql-connector-java-5.0.7.jar:na]
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
>> ~[mysql-connector-java-5.0.7.jar:na]
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
>> ~[mysql-connector-java-5.0.7.jar:na]
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
>> ~[mysql-connector-java-5.0.7.jar:na]
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
>> ~[mysql-connector-java-5.0.7.jar:na]
>> at
>>
>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
>> ~[mysql-connector-java-5.0.7.jar:na]
>> at
>>
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
>> ~[mysql-connector-java-5.0.7.jar:na]
>> at
>>
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
>> ~[c3p0-0.9.1.jar:0.9.1]
>> at
>>
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>>
>> at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at
>>
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> at org.hibernate.loader.Loader.doList(Loader.java:2213)
>> ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
>> ... 17 common frames omitted
>>
>>
>> Any help would be appreciated.
>>
>> Cheers,
>>
>> Andras
>>
|