[server-admins] Forum upgrade
Manfred Bergmann
manfred.bergmann at me.com
Sun Apr 24 06:13:43 MST 2011
Great.
I've updated the forum.
There is still a css bug. The new forums css seems to be a bit different. I'll sort this out a little later.
I will also make a minor adjustment to the registration page to forbid entering the same string for last name and first name.
Most of the spam registrations have this.
Thanks,
Manfred
Am 24.04.2011 um 06:24 schrieb Troy A. Griffitts:
> 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
>
>
> _______________________________________________
> 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