[server-admins] Forum upgrade

Troy A. Griffitts scribe at crosswire.org
Sat Apr 23 21:24:37 MST 2011 

Done.

SQL> show table mvnforumMemberGroup;
GROUPID                         INTEGER Not Null
MEMBERID                        INTEGER Not Null
MEMBERNAME                      VARCHAR(30) Not Null
PRIVILEGE                       INTEGER Not Null
CREATIONDATE                    TIMESTAMP Not Null
MODIFIEDDATE                    TIMESTAMP Not Null
EXPIREDATE                      TIMESTAMP Not Null
CONSTRAINT INTEG_106:
  Primary key (GROUPID, MEMBERID)
SQL>


On 04/23/2011 06:50 PM, Manfred Bergmann wrote:
> 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
>
> _______________________________________________
> 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