[server-admins] Forum upgrade

[Troy A. Griffitts]

I've given you all rights to all the system tables in the mvnforum db as
well now.  Let me know.

(I'm sure you figured out by now, but if not, I should have told you
that firebird stuff is now install to /usr/lib64/firebird; our databases
are still in the same location)


On 02/19/2011 03:28 PM, Manfred Bergmann wrote:
> Hmm.
> The login which I think is used is in
> /opt/tomcat_site4/webapps/forums/WEB-INF/classes/mvncore.xml
> I wasn't aware of the login in context.xml and I think I used
> "mvnforums" user when I updated the forum database last time (2009?).
> 
> I don't really understand what's happening, I'm still getting the same
> error:
> Statement failed, SQLCODE = -607
> unsuccessful metadata update
> -STORE RDB$RELATION_FIELDS failed
> -no permission for control access to TABLE MVNFORUMMEMBERGROUP
> 
> mvnforums user has all necessary grants so it can't be that. But I don't
> know what the problem is and if it's a permission problem.
> 
> 
> 
> Manfred
>> ------------------------------------------------------------------------
>>
>> 	Troy A. Griffitts <mailto:scribe at crosswire.org>
>> 19. Februar 2011 06:40
>>
>>
>> OK, we're now using the firebird packages from F14. This involved an
>> upgrade from 2.1.1 to 2.1.3. I am using our same security db so
>> password and db access should all be the same.
>>
>> Manfred, my apologies for not getting back with you sooner on this one.
>> I looked into it tonight and found a few strange things:
>>
>> /opt/tomcat_site4/webapps/forums/META-INF/context.xml is showing the
>> news login id and password. Are these not used by mvn forums? I was
>> going to look at your permissions and couldn't remember the login and
>> password for the mvnforum user, but this context.xml file didn't reveal
>> what I expected.
>>
>> It looks like you might need some other permissions. I just did a
>> series of:
>>
>> GRANT ALL ON TABLE <each table> TO MVNFORUMS;
>>
>> in your database. Let me know if this helps or if you still have troubles.
>>
>> Troy
>>
>>
>>
>>
>>
>> _______________________________________________
>> server-admins mailing list
>> server-admins at crosswire.org
>> http://www.crosswire.org/mailman/listinfo/server-admins
>> ------------------------------------------------------------------------
>>
>> 	Manfred Bergmann <mailto:manfred.bergmann at me.com>
>> 13. Februar 2011 18:09
>>
>>
>> Yep. Got into the data folder and could open the database using isql.
>>
>> But I was unable to apply the necessary database updates, see below:
>> ------------------
>> [mbergmann at www ]$ /opt/firebird/bin/isql -u mvnforums -p
>> <NotTheRealPassword> /opt/firebird/data/mvnforums.gdb
>> Database:  /opt/firebird/data/mvnforums.gdb, User: mvnforums
>> SQL> show table;
>>        MVNFORUMATTACHMENT                    
>> MVNFORUMCATEGORY              
>>        MVNFORUMFAVORITETHREAD                
>> MVNFORUMFORUM                 
>>        MVNFORUMGROUPFORUM                    
>> MVNFORUMGROUPPERMISSION       
>>        MVNFORUMGROUPS                        
>> MVNFORUMMEMBER                
>>        MVNFORUMMEMBERFORUM                   
>> MVNFORUMMEMBERGROUP           
>>        MVNFORUMMEMBERPERMISSION              
>> MVNFORUMMESSAGE               
>>        MVNFORUMMESSAGEFOLDER                 
>> MVNFORUMMESSAGESTATISTICS     
>>        MVNFORUMPMATTACHMENT                  
>> MVNFORUMPMATTACHMESSAGE       
>>        MVNFORUMPOST                          
>> MVNFORUMRANK                  
>>        MVNFORUMTHREAD                        
>> MVNFORUMWATCH                 
>>
>> SQL> ALTER TABLE MVNFORUMMEMBERGROUP ADD ExpiteDate TIMESTAMP NOT NULL;
>> Statement failed, SQLCODE = -607
>> unsuccessful metadata update
>> -STORE RDB$RELATION_FIELDS failed
>> -no permission for control access to TABLE MVNFORUMMEMBERGROUP
>> ------------------
>>
>> Actually a pretty simple ALTER statement.
>> Anyone experience with Firebird who can tell me what this error
>> message means?
>>
>> User mvnforums has the following grants:
>> SQL> show grant;
>> GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON
>> MVNFORUMMEMBERGROUP TO USER MVNFORUMS
>>
>> It seems that FireBird wants to update some system tables
>> (RDB$RELATION_FIELDS) which seems to fail:
>> SQL> show index RDB$RELATION_FIELDS;
>> RDB$INDEX_15 UNIQUE INDEX ON RDB$RELATION_FIELDS(RDB$FIELD_NAME,
>> RDB$RELATION_NAME)
>> RDB$INDEX_3 INDEX ON RDB$RELATION_FIELDS(RDB$FIELD_SOURCE)
>> RDB$INDEX_4 INDEX ON RDB$RELATION_FIELDS(RDB$RELATION_NAME)
>>
>>
>>
>>
>>
>> Manfred
>>
>> _______________________________________________
>> server-admins mailing list
>> server-admins at crosswire.org
>> http://www.crosswire.org/mailman/listinfo/server-admins
>> ------------------------------------------------------------------------
>>
>> 	Troy A. Griffitts <mailto:scribe at crosswire.org>
>> 13. Februar 2011 15:10
>>
>>
>> Should be good now. Let me know.
>> -- 
>> Sent from my Android phone with K-9 Mail. Please excuse my brevity.
>>
>> _______________________________________________
>> 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