<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hmm.<br>
The login which I think is used is in
/opt/tomcat_site4/webapps/forums/WEB-INF/classes/mvncore.xml<br>
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?).<br>
<br>
I don't really understand what's happening, I'm still getting the
same error:<br>
Statement failed, SQLCODE = -607<br>
unsuccessful metadata update<br>
-STORE RDB$RELATION_FIELDS failed<br>
-no permission for control access to TABLE MVNFORUMMEMBERGROUP<br>
<br>
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.<br>
<br>
<br>
<br>
Manfred<br>
<blockquote style="border: 0px none;"
cite="mid:4D5F57D1.7030708@crosswire.org" type="cite">
<div style="margin-left: 40px;">
<hr style="border-width: 1px 0pt 0pt; border-style: dotted none
none; border-color: rgb(181, 181, 181) -moz-use-text-color
-moz-use-text-color; height: 1px; margin: 0pt;"
class="__pbConvHr"><br>
</div>
<table style="padding-top: 5px;" class="__pbConvTable">
<tbody>
<tr>
<td valign="top"><img
src="cid:part1.09040601.01080309@me.com"
photoaddress="scribe@crosswire.org" photoname="Troy A.
Griffitts" name="compose-unknown-contact.jpg"
height="29px" width="29px"></td>
<td style="padding-left: 5px;" valign="top"><a
moz-do-not-send="true"
href="mailto:scribe@crosswire.org" style="color: rgb(0,
136, 204) ! important; text-decoration: none !
important;">Troy A. Griffitts</a><br>
<font color="#888888">19. Februar 2011 06:40</font></td>
</tr>
</tbody>
</table>
<div style="color: rgb(136, 136, 136); margin-left: 40px;"
__pbrmquotes="true" class="__pbConvBody"><br>
<div>OK, we're now using the firebird packages from F14. This
involved an<br>
upgrade from 2.1.1 to 2.1.3. I am using our same security db
so<br>
password and db access should all be the same.<br>
<br>
Manfred, my apologies for not getting back with you sooner on
this one.<br>
I looked into it tonight and found a few strange things:<br>
<br>
/opt/tomcat_site4/webapps/forums/META-INF/context.xml is
showing the<br>
news login id and password. Are these not used by mvn forums?
I was<br>
going to look at your permissions and couldn't remember the
login and<br>
password for the mvnforum user, but this context.xml file
didn't reveal<br>
what I expected.<br>
<br>
It looks like you might need some other permissions. I just
did a<br>
series of:<br>
<br>
GRANT ALL ON TABLE <each table> TO MVNFORUMS;<br>
<br>
in your database. Let me know if this helps or if you still
have troubles.<br>
<br>
Troy<br>
<br>
<br>
<br>
</div>
<div><!----><br>
<br>
_______________________________________________<br>
server-admins mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:server-admins@crosswire.org">server-admins@crosswire.org</a><br>
<a class="moz-txt-link-freetext" href="http://www.crosswire.org/mailman/listinfo/server-admins">http://www.crosswire.org/mailman/listinfo/server-admins</a><br>
</div>
<hr style="border-width: 1px 0pt 0pt; border-style: dotted none
none; border-color: rgb(181, 181, 181) -moz-use-text-color
-moz-use-text-color; height: 1px; margin: 15px 0pt 0pt;"
class="__pbConvHr"><br>
</div>
<table style="padding-top: 5px;" class="__pbConvTable">
<tbody>
<tr>
<td valign="top"><img
src="cid:part2.00090500.03070500@me.com"
photoaddress="manfred.bergmann@me.com"
photoname="Manfred Bergmann" name="postbox-contact.jpg"
height="29px" width="29px"></td>
<td style="padding-left: 5px;" valign="top"><a
moz-do-not-send="true"
href="mailto:manfred.bergmann@me.com" style="color:
rgb(0, 136, 204) ! important; text-decoration: none !
important;">Manfred Bergmann</a><br>
<font color="#888888">13. Februar 2011 18:09</font></td>
</tr>
</tbody>
</table>
<div style="color: rgb(136, 136, 136); margin-left: 40px;"
__pbrmquotes="true" class="__pbConvBody"><br>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
Yep. Got into the data folder and could open the database using
isql.<br>
<br>
But I was unable to apply the necessary database updates, see
below:<br>
------------------<br>
[mbergmann@www ]$ /opt/firebird/bin/isql -u mvnforums -p
<NotTheRealPassword> /opt/firebird/data/mvnforums.gdb<br>
Database: /opt/firebird/data/mvnforums.gdb, User: mvnforums<br>
SQL> show table;<br>
MVNFORUMATTACHMENT
MVNFORUMCATEGORY <br>
MVNFORUMFAVORITETHREAD
MVNFORUMFORUM <br>
MVNFORUMGROUPFORUM
MVNFORUMGROUPPERMISSION <br>
MVNFORUMGROUPS
MVNFORUMMEMBER <br>
MVNFORUMMEMBERFORUM
MVNFORUMMEMBERGROUP <br>
MVNFORUMMEMBERPERMISSION
MVNFORUMMESSAGE <br>
MVNFORUMMESSAGEFOLDER
MVNFORUMMESSAGESTATISTICS <br>
MVNFORUMPMATTACHMENT
MVNFORUMPMATTACHMESSAGE <br>
MVNFORUMPOST
MVNFORUMRANK <br>
MVNFORUMTHREAD
MVNFORUMWATCH <br>
<br>
SQL> ALTER TABLE MVNFORUMMEMBERGROUP ADD ExpiteDate TIMESTAMP
NOT NULL;<br>
Statement failed, SQLCODE = -607<br>
unsuccessful metadata update<br>
-STORE RDB$RELATION_FIELDS failed<br>
-no permission for control access to TABLE MVNFORUMMEMBERGROUP<br>
------------------<br>
<br>
Actually a pretty simple ALTER statement.<br>
Anyone experience with Firebird who can tell me what this error
message means?<br>
<br>
User mvnforums has the following grants:<br>
SQL> show grant;<br>
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON
MVNFORUMMEMBERGROUP TO USER MVNFORUMS<br>
<br>
It seems that FireBird wants to update some system tables
(RDB$RELATION_FIELDS) which seems to fail:<br>
SQL> show index RDB$RELATION_FIELDS;<br>
RDB$INDEX_15 UNIQUE INDEX ON RDB$RELATION_FIELDS(RDB$FIELD_NAME,
RDB$RELATION_NAME) <br>
RDB$INDEX_3 INDEX ON RDB$RELATION_FIELDS(RDB$FIELD_SOURCE) <br>
RDB$INDEX_4 INDEX ON RDB$RELATION_FIELDS(RDB$RELATION_NAME) <br>
<br>
<br>
<br>
<br>
<br>
Manfred<br>
<br>
<div>_______________________________________________<br>
server-admins mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:server-admins@crosswire.org">server-admins@crosswire.org</a><br>
<a class="moz-txt-link-freetext" href="http://www.crosswire.org/mailman/listinfo/server-admins">http://www.crosswire.org/mailman/listinfo/server-admins</a><br>
</div>
<hr style="border-width: 1px 0pt 0pt; border-style: dotted none
none; border-color: rgb(181, 181, 181) -moz-use-text-color
-moz-use-text-color; height: 1px; margin: 15px 0pt 0pt;"
class="__pbConvHr"><br>
</div>
<table style="padding-top: 5px;" class="__pbConvTable">
<tbody>
<tr>
<td valign="top"><img
src="cid:part1.09040601.01080309@me.com"
photoaddress="scribe@crosswire.org" photoname="Troy A.
Griffitts" name="compose-unknown-contact.jpg"
height="29px" width="29px"></td>
<td style="padding-left: 5px;" valign="top"><a
moz-do-not-send="true"
href="mailto:scribe@crosswire.org" style="color: rgb(0,
136, 204) ! important; text-decoration: none !
important;">Troy A. Griffitts</a><br>
<font color="#888888">13. Februar 2011 15:10</font></td>
</tr>
</tbody>
</table>
<div style="color: rgb(136, 136, 136); margin-left: 40px;"
__pbrmquotes="true" class="__pbConvBody"><br>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title></title>
Should be good now. Let me know.<br>
-- <br>
Sent from my Android phone with K-9 Mail. Please excuse my
brevity.<br>
<br>
<div>_______________________________________________<br>
server-admins mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:server-admins@crosswire.org">server-admins@crosswire.org</a><br>
<a class="moz-txt-link-freetext" href="http://www.crosswire.org/mailman/listinfo/server-admins">http://www.crosswire.org/mailman/listinfo/server-admins</a><br>
</div>
</div>
</blockquote>
</body>
</html>