[server-admins] Forum upgrade

Manfred Bergmann manfred.bergmann at me.com
Sat Apr 23 10:50:03 MST 2011 

Hi.

Unfortunately still not working.
Could you try this? Maybe it has to do with system permissions.

Procedure is quite easy:
- stop forum application
- make backup of db:
cp -a /opt/firebird/data/mvnforums.gdb mvnforums_1.2.1_bak.gdb 

- connect to db:
/usr/lib64/firebird/bin/isql -u mvnforums -p mvnforums123 /opt/firebird/data/mvnforums.gdb

- apply the following SQL statements:
1. ALTER TABLE mvnforumMemberGroup ADD ExpireDate TIMESTAMP NOT NULL ;
2. UPDATE mvnforumMemberGroup SET ExpireDate = CreationDate ;

When I try this I still get this error on 1.:
---
SQL> ALTER TABLE mvnforumMemberGroup ADD ExpireDate TIMESTAMP NOT NULL ;
Statement failed, SQLCODE = -607
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-no permission for control access to TABLE MVNFORUMMEMBERGROUP
---

In any case you can do a "QUIT;" which will rollback the changes.



Manfred


Am 19.02.2011 um 20:03 schrieb 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
> 
> 
> _______________________________________________
> server-admins mailing list
> server-admins at crosswire.org
> http://www.crosswire.org/mailman/listinfo/server-admins

More information about the server-admins mailing list