[server-admins] mvnForums / tomcat

[Manfred Bergmann]

Hmm, got some "no permission" errors while trying to alter some tables:
--------
SQL> ALTER TABLE mvnforumMessageFolder ADD FolderStatus INTEGER  
DEFAULT 0 NOT NULL;
Statement failed, SQLCODE = -607
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-no permission for control access to TABLE MVNFORUMMESSAGEFOLDER
---------

Seems like user mvnForums doesn't have the rights to alter tables?
It is also necessary to alter/create triggers and execute procedures.
Can this be granted to mvnForums user?


Manfred


Am 31.07.2009 um 09:15 schrieb Troy A. Griffitts:

> Thanks Manfred,
>
> I have no idea when people are using the forums most!  I'd say  
> they'll be fine without service for an hour or so.  Feel free to do  
> the work when's best for you.
>
> 	-Troy.
>
>
>
> Manfred Bergmann wrote:
>> I have read now through some documentation of how to update the  
>> forum.
>> The database has to get updated to bring it up-to-date for the new  
>> forum version and some other merges, mostly properties -> xml files.
>> I've planed to do this on Monday when I'm back from a weekend trip.
>> That means the forum will be offline for maybe an hour if all goes  
>> well.
>> Do you know when (what time) the least users are online?
>> Manfred
>> Am 29.07.2009 um 08:35 schrieb Troy A. Griffitts:
>>>>> That said, I would love to see the forums updated to the latest  
>>>>> release, and even updated regularly, by anyone who would like to  
>>>>> take this on.
>>>> I would like to do this.
>>>> For backups and that kind of things I would need admin rights for  
>>>> the forum.
>>>> Not sure if a hot upgrade is possible but I also might need  
>>>> rights to stop, restart the forum application context.
>>>
>>> Manfred,
>>>
>>> I've added these commands to suders for you:
>>>
>>> mbergmann     ALL=/etc/rc.d/init.d/tomcat, /usr/bin/killall java
>>>
>>> and I've put you in the groups: tomcat, forums
>>>
>>> Have a look in ~forums
>>>
>>> Also have done a backup tonight, which includes all of our  
>>> databases at /opt/firebird/data
>>>
>>> Let me know if you need anything else.  Thanks for owning this.  I  
>>> stress out being a bottleneck and am so excited when people like  
>>> you step up to take responsibility for these things.  THANK YOU!!!
>>>
>>>    -Troy.
>>>
>>>
>>>
>>>> Manfred
>>>> _______________________________________________
>>>> server-admins mailing list
>>>> server-admins at crosswire.org
>>>> http://www.crosswire.org/mailman/listinfo/server-admins
>>>
>>>
>>> _______________________________________________
>>> server-admins mailing list
>>> server-admins at crosswire.org
>>> http://www.crosswire.org/mailman/listinfo/server-admins
>> _______________________________________________
>> server-admins mailing list
>> server-admins at crosswire.org
>> http://www.crosswire.org/mailman/listinfo/server-admins
>
>
> _______________________________________________
> server-admins mailing list
> server-admins at crosswire.org
> http://www.crosswire.org/mailman/listinfo/server-admins