[server-admins] Firebird Server pegging

Thu Nov 21 07:36:29 MST 2013

Looking forward to your explanation.

I've played with myBB briefly. From an admins perspective here is what I found:
Depends upon LAMP (where P is php) which is what wikipedia uses and is common to most linux installations. So dependencies are satisfied w/o additional packages, installation or setup.
Small download.
Install is merely unzipping and changing permissions.
Setup consists of three parts:
Create a mysql database and user with appropriate grants for that database.
Simple http entry.
Run install via webpage.

Total time 10 minutes.

It satisfies a particular admin goal that I have: admin simplicity not requiring any special skills.

-- DM

On Nov 21, 2013, at 8:57 AM, Troy A. Griffitts <scribe at crosswire.org> wrote:

> Presentation in a few hours, no time to respond in detail.
> 
> I'd lke the opportunity to convince you of the benefit of the big picture of having a collaborative online community building new datasets and managing their own projects with a set of expanding specialized tools for these projects.
> 
> In the meantime, check out the liferay forum link I sent:
> http://www.liferay.com/community/forums
> 
> It supports all of what you list and I would suggest is better supported than myBB forum.  Liferay is an enterprise portal solution with an opensource edition.  It is used by Barclays, Sesame Street, Toyota, Cisco, T-Mobile and other large companies. It is the primary portal installation offered by Redhat OpenShift:
> https://www.openshift.com/developers/java
> Ubuntu JuJu:
> https://jujucharms.com/
> 
> and others.
> 
> I believe it is a good choice for all the reasons you list and more.  Gotta run for now.
> 
> Troy
> 
> 
> 
> 
> On 11/21/2013 02:40 PM, Chris Little wrote:
>> This seems like a really bad idea. The reason for choosing mvnForum was that it was built on JSP & Firebird. That wasn't a particularly good reasons to choose it as a forum solution, and now we have poorly supported forum software.
>> 
>> Troy, it sounds like you're proposing we choose another solution on the basis of its underlying technology rather than its actual functional merits. I really can't see any value to searching for forum software that can function as a portlet. And if we switch to another poorly supported, unpopular forum solution, we're going to be in exactly the same situation within a few years as we're in now.
>> 
>> Our requirements are fairly limited:
>> free, open, mature, & maintained software
>> support for threads & quoting
>> support for spam blocking, better CAPTCHAs, & good user management
>> 
>> MyBB seems to fit that bill well enough. And picking a popular solution like myBB is probably more important than all of these since we can benefit from plugins, regular updates, etc.
>> 
>> 
>> FWIW I don't think we should worry about migrating the existing forum content over. We can leave registrations disabled (which tentatively appears to have eliminated the server pegging issue--jira is the current top CPU consumer, with fbserver not visible when I run top). When we have new forums up, we can disable logins to mvnForum. And in a year or so, I wouldn't object to our nuking mvnForum from the server altogether.
>> 
>> Also FWIW, I don't particularly see a need to consult with sword-devel. We already had a bit of discussion of forum software, and now I consider it to be an issue for server admins--the people who will actually install & support the forum software.
>> 
>> --Chris
>> 
>> 
>> On 11/20/2013 7:51 PM, Troy A. Griffitts wrote:
>>> I'd prefer not to take the conversation to sword-devel. Now that I am
>>> done with my project for the INTF, my hope is to utilize the frameworks
>>> I've built for projects at CrossWire. This includes running a liferay
>>> installation which is a fully compliant JSR-168 and 286 portlet
>>> container as well as an OpenSocial container. I'm sure we could find a
>>> forum portlet or use the one that ships with liferay. You can see it
>>> their forums in action on their own site if you'd like to evaluate:
>>> 
>>> http://www.liferay.com/community/forums
>>> 
>>> 
>>> DM Smith <dmsmith at crosswire.org> wrote:
>>> 
>>> 
>>>    On Nov 20, 2013, at 8:02 PM, Chris Little <chrislit at crosswire.org> wrote:
>>> 
>>>        On 11/20/2013 11:07 AM, DM Smith wrote:
>>> 
>>>            Do you want me to stop the fb server?
>>> 
>>>            What are the web apps that use it? (besides news and forums)
>>> 
>>>            News can't possibly be creating the problem. For all
>>>            practical purposes,
>>>            it is read-only.
>>> 
>>>            Can we make the forums read-only and put up a banner that it
>>>            is locked down?
>>> 
>>>            -- DM
>>> 
>>> 
>>>        I disabled new registrations on the servers, which I predict
>>>        will prevent the pegging problem.
>>> 
>>>        I couldn't find a sensible way to switch off registrations
>>>        through the admin panel, so I went after the addmember.jsp file
>>>        itself and moved it to
>>> /home/forums/servers/main/webapps/forums/mvnplugin/mvnforum/user/addmember.bak
>>> 
>>>        --Chris
>>> 
>>> 
>>>    I've been looking for a replacement. Should we take the discussion to sword-devel?
>>> 
>>>    I think the key features that people have mentioned are:
>>>      Something that is actively maintained.
>>>      Something that does threading and quoting.
>>>      Something w/ decent spam and user management support.
>>>      Must work on RHEL 6. Good if it is part of the distribution.
>>>      Open source
>>> 
>>>    The most popular db for forums is mysql. Very few work w/ firebird.
>>> 
>>>    I'm willing to be an active admin for the software and database, but not the forum.
>>> 
>>>    If we can come up w/ something to try, I can install it this weekend. Maybe sooner.
>>> 
>>>    How about we try "myBB"?
>>> 
>>>    Seehttp://myBB.com/features
>>> 
>>> 
>>>    If we want to import current rather than start over empty:
>>> 
>>>    vBulletin can import from mvnForum. It's the only one I could find that handles mvnForum.
>>> 
>>>    myBB can import from vBulletin.
>>> 
>>>    -- DM
>>> 
>>> ------------------------------------------------------------------------
>>> 
>>>    server-admins mailing list
>>>    server-admins at crosswire.org
>>>    http://www.crosswire.org/mailman/listinfo/server-admins
>>> 
>>> 
>>> -- 
>>> Sent from my Android device 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4145 bytes
Desc: not available
URL: <http://www.crosswire.org/pipermail/server-admins/attachments/20131121/13315912/attachment.p7s>