[server-admins] Forum upgrade

[Manfred Bergmann]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20110219/bad3315c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: compose-unknown-contact.jpg
Type: image/jpeg
Size: 1421 bytes
Desc: not available
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20110219/bad3315c/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postbox-contact.jpg
Type: image/jpeg
Size: 1333 bytes
Desc: not available
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20110219/bad3315c/attachment-0001.jpg>