[server-admins] Forum upgrade

[Troy A. Griffitts]

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




On 02/13/2011 05:09 PM, Manfred Bergmann wrote:
> 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
> 
>> ------------------------------------------------------------------------
>>
>> 	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