[server-admins] mvnForums / tomcat

[DM Smith]

On 08/03/2009 05:33 PM, Manfred Bergmann wrote:
> OK, the forum is back online.
> The look & feel is not as it was and needs some more work.

When I try to login I get:
	mvnForum <http://crosswire.org/forums/mvnforum/index> »  Error !!!


The error message is:
*/The referer of request is not in trusted domains. Please configure 
mvncore.xml./*

*» *You may go back now and try again <javascript:history.back(1)>
*» *If you believe this is a bug, click here to report this error to 
Website administrator 
<mailto:webmaster at crosswire.org?subject=Report%20bug%20in%20mvnForum>


If you look at /opt/tomcat/logs/catalina.out, you'll find this is 
mentioned in there as well.

-- DM

>
>
> Manfred
>
>
> Am 03.08.2009 um 09:51 schrieb 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20090803/fe133e68/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: nav.gif
Type: image/gif
Size: 224 bytes
Desc: not available
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20090803/fe133e68/attachment.gif>